Among some of the many topics that I cover are the following:
- Designing Workbooks
- Entering and Editing Data
- Formatting Worksheets
- Functions
- Charts
- Vlookups, Hlookups
- Database Features
- Printing
- Taming the Ribbon in Excel 2007 / 2010 / 2013
- Macros
- VBA Programming
- Working with Procedures and Functions
- Understanding Objects
- Using Expressions, Variables, and Intrinsic Functions
- Controlling Program Execution
- Working with Forms and Controls
- Working with the PivotTable Object
- Debugging Code
- Handling Errors