Microsoft Excel is the most widely used spreadsheeting application in the world today. It has a wide range of features available for every-day office documents and professional spreadsheets with complex calculations and Macros.
Microsoft Excel Basic
Get up to speed quickly by learning about the following topics:
- Excel Environment
- Excel Views
- Entering Data
- Constructing basic Formulas & Functions
- Construct basic Formulas between Worksheets and Workbooks.
- Copy and Paste data and formulas
- Apply formatting
- Page Setup & Printing
Microsoft Excel Intermediate
Improve your Excel skills by learning about the following topics:
- Time savers and shortcuts
- Formulas
- Relative and Absolute references
- Functions
- Commonly used functions
- Date and Time functions
- Logical functions
- Finding and correcting errors
- Custom formats
- Outlining
- Charts
- Data Validation
Microsoft Excel Advanced
Take your Excel skills to the next level by learning about the following advanced topics:
- Using Names
- Using Tables
- Advanced Functions
- IF
- AND / OR
- IS
- VLOOKUP
- Advanced Sorting and Filtering
- PivotTables
- PivotCharts
- Basic Macros
VBA for Microsoft Excel
Make Excel jump through hoops and automate any repetitive tasks by learning about the following topics:
- Record Macros
- Absolute Macros
- Relative Macros
- Using the VBA Editor
- Project Explorer
- Setting Break Points
- Using Bookmarks
- Stepping through Procedures
- Running Macros
- VBA Theory and Terminology
- Creating Procedures
- Using Variables
- Variable Declarations
- Variable Scope
- Arrays
- Using Excel Objects
- Methods, Properties and Events
- Programming Techniques
- Using Message Boxes
- Using IFs
- Using Loops
- Custom user Functions
- Creating Custom Forms
- Event-driven Procedures
- Error Handling