Table of Content
MS-Excel Basics
- Workbook and Worksheet
- Manipulating Data
- Worksheet Formatting
- Page Properties and Printing
- Excel Formulas
- Sort and Filter
- Charts
Advanced Excel
- Excel Cell Referencing
- Excel Functions
- Excel Formulas
- Working with Ranges
- The VLOOKUP function
- Pivot Table
- Advanced Excel Filter
VBA
- VBA Basics
- Variables, Comments, Constants and Data Types
- Visual Basic Arrays
- VBA Conditional Statements
- VBA Loops
- VBA objects
- Subroutines
- Functions
- Labels and the On Error statement
- VBA and Excel functions
- Excel Objects
- Excel Events
Macros
- Recording a Macro
- Perform the Macro
- Running a Macro
- Change macro security settings
- Copy a macro module to another workbook
- Copying a module from one workbook to another
- Assign a macro to a Form or a Control button
- Macro Virus Protection
Apply for certification