Advanced Excel Formulas and VBA User Defined Functions
MP4 | Video: h264, 1280x720 | Audio: AAC, 48000 Hz
Language: English | Size: 1.61 GB | Duration: 8h 34m
What you'll 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 which are unavailable using only Excel's built-in functions.
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.
MP4 | Video: h264, 1280x720 | Audio: AAC, 48000 Hz
Language: English | Size: 1.61 GB | Duration: 8h 34m
What you'll 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 which are unavailable using only Excel's built-in functions.
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.