Course Overview
Most Microsoft Office users only know how to set up a basic table or maybe do a few formulas here and there. This course will teach you how to take Excel by the horns and make it do whatever you want, whenever you want. It can go through loads of information and create a printable report for you. You can make custom forms so that you can access, analyze, edit, or add new information quickly to your data tables/worksheets. Excel programming utilizes a simple but effective tool called "VBA" - the hidden programming language that runs quietly in the background while you work. It’s very easy and straight-forward to use, and we'll show you how.
Instructor - Daniel Strong
I've been using Excel since my early teens, and a few years back, I got my first opportunity to program in Excel. When I landed the job, I was asked to re-write my predecessor's coded programs with fancy databases and automated Crystal reports! I found my Excel skills somewhat lacking. I HAD TO LEARN VBA! After finding online resources lacking, I was forced to learn it myself, and quickly realized that if only someone was out there teaching Excel VBA — making everything simple and visual — then anyone could learn it! Here, I'm going to teach you the good stuff — the things that make people hire you: building real programs, advanced reporting, data analysis, dashboards, live data, automation and more.
