Advanced MBA Excel: Lesson 1
Start programming VBA in minutes!

What this introduction covers:

  • Some points to note for the lessons over the next few days
  • Why we are going to ignore a lot of jargon and 'technical speak'!
  • How to access the VBA part of Excel (the code editor)

Lesson 1: Controlling Cells and Ranges

  • Learn using my side by side method which will make it very easy to learn
  • How Excel makes it easier for us to do VBA
  • The two ways to automatically put info into cells
  • How to copy and paste with VBA code

Here's today's Career insight...

The most lucrative career paths involving Excel skills

Note on Accountants and Controllers: While they don't have to learn VBA / Macros to do their job, those who have done so, often do extremely well due to freeing up time on reporting/analysis/budget building to do other value add activities: such relationship building with other departments, looking for more cost saving opportunities and the best accountant/controllers get involved in vendor/contract renegotiation. These are great ways to re-purpose the time saved and build credibility with decision making execs who can open doors for you.