Advanced Excel Formulas and VBA User Defined Functions

Master advanced Excel mega-formulas combining multiple functions and learn to create your own VBA user-defined functions

Created by: Grant Gamble
Developer, trainer and author

What Will I Learn?

• Learn to create complex Excel formulas by understanding all of the building blocks that go together to make up mega-formulas.
• Learn how to make your formulas more readable by writing multi-line formulas.
• Gain access to unique formula diagrams which illustrate the structure of the formulas you are creating.
• Hands-on training which allows you to learn by doing, with all of the files used by the instructor made available to you.
• Demystify Excel VBA by learning to write user-defined functions which add insights to your Excel models.
• Expand your VBA skills by learning how to write clear, clean VBA code which you fully understand.

Requirements

• You will need to have experience of using Microsoft Excel and be comfortable with the creation of basic formulas.

Target audience

• Experienced Excel users and data analysts who would like to know more about complex Excel formulas.