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

 

Scroll to Top