Excel Classes

Click class titles to see dates and details

Microsoft Excel combines powerful spreadsheet, chart and list-management capabilities to form the industry-standard spreadsheet application. Here are the Excel 2016 for Windows classes we offer:

Excel Beginning: Your First Worksheets

Three hours, $119
- Introduction to Excel
- Making and Editing Entries
- Managing Cells and Worksheets
- Printing Worksheets

Excel Formulas: Simple Functions

Three hours, $149
- Using Simple Functions
- Arithmetic Formulas
- Math with Dates
- Copying Formulas
- Relative vs Absolute Referencing

Excel Intermediate: Cell Formatting and Charting

Three hours, $149
- Formatting Cells
- Using Cell Styles
- Creating Charts
- Enhancing Charts

Excel Intermediate: Queries, Subtotals & Tables

Three hours, $149
- Writing Queries to Import Data
- Summarizing Data with Subtotals
- Using Data in Tables

Excel PivotTables: Data Analysis with PivotTables

Three hours, $179
- Creating PivotTables
- Analyzing data using PivotTables
- Working with PivotTable options
- Creating PivotCharts

Excel Advanced: Automating Tasks

Three hours, $195
- Working on Multiple Sheets Simultaneously
- Performing "What If" Analysis
- Conditional Formatting
- Recording Macros

Excel Formulas: Advanced Functions

Three hours, $195
- Advanced Formulas using Functions
- Array Formulas
- Troubleshooting Formulas

Excel VBA Day 1: Write VBA Code in Excel Macros

One day, $449
- VBA Concepts
- Accessing VBA Functionality
- Editing Macros
- Debugging Macros
- Assigning Macros
- Using Variables

Excel VBA Day 2: Add Power and Interactivity to Macros

One day, $449
- Loop Structures
- Code to Move the Cell Pointer and Select Ranges
- User-Interactive Worksheets
- VBA Decision Structures
- Methods to Manipulate Worksheets
- Using Built-in VBA Functions
- Performing Calculations

Microsoft Excel combines powerful spreadsheet, chart and list-management capabilities to form the industry-standard spreadsheet application. Here are the Excel 2016 for Mac classes we offer:

Excel (Mac) Basics: Your First Worksheets

Three hours, $119
- Introduction to Excel
- Making and Editing Entries
- Managing Cells and Worksheets
- Printing Worksheets

Excel (Mac) Intermediate: Cell Formatting and Charts

Three hours, $149
- Formatting Cells
- Using Cell Styles
- Creating Charts
- Enhancing Charts