The Ultimate Excel Programmer Course

• Automate and Customize data entry forms
• Choose the right Loop for each task
• Master the CELLS and RANGE objects in multiple scenarios
• Create multiple Variable styles to match your need
• Customize your VBA Editor and Understand all the Toolbars and options
• Debug and Troubleshoot code like a boss!
• Record, Modify or Write Macros from scratch
• Make Custom Formulas/Functions on the fly
• Breeze through IF THEN statements and conquer all the Logical Operators
• Batch out inter-active MessageBoxes, InputBoxes and give users CHOICES!
• Generate Basic Reports that can be printed
• Add filters to report menus to narrow the records
• Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons AND so much more. . .
• Trigger code from a number of different methods – from Clicking on a cell – to De-Selecting a worksheet.
• Set up Special Commands when a workbook: Opens or closes, is selected, any cell or certain cells are selected, right before printing, etc. . .
• Manipulate Userforms for data entry, report generation, editing tables/databases – ALL within your control. Restrict the flow of data OR make the Userform(s) responsive, calculating, INTUITIVE.
• Streamline your work and the work of others.
• Put Excel ON AUTOPILOT. . .

Who this course is for:

• This Excel course is for anyone who wants to learn Automation secrets in Excel VBA. It’s for complete newbies and/or students looking for a refresher or Reference tool, to pick and choose relevant lessons for their projects. No prior programming knowledge is needed.
• This course is probably not for you if you’re looking to learn super advanced report authoring, which will be covered in a future course specifically on this topic. We will, however, make sure you know how to make good solid reports from your data and many tricks to make them look good.
• If you’re using Excel for Mac, you will find that this course won’t cover all the various differences in Excel Mac, as this course was filmed using Excel for PC and Excel VBA is a bit limited for Mac users, esp on the design side. Many students end up programming in windows and just using Mac to run the Excel wb or will virtualize Windows within Mac using programs like Parallels or Bootcamp.