Advanced Class
- Creating Megaformulas
- Using a Megaformula
- Tools for Debugging Formulas
- Methods for Debugging Formulas
- Fundamental Macro Concept
- Working in the Visual Basic Editor
- Excel Object Model
- Built-In VBA function
- Controlling Execution
- Using Ranges
- Introductory VBA Function
- Function Procedure
- Testing and Debugging functions
- Creating Add-Ins for Functions
- Simple Functions
- Cell’s Data Type
- Multifunctional Function
- Generating Random Numbers
- Calculating Sales Commission
- Text Manipulation Functions
- Counting Funtions
- Date Functions
- Multisheet Function
- Advanced Function Techniques