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 2016 (PC) Session 1: Create Your First Spreadsheets

Three hours, $119
- Introduction to Excel
- Making Entries
- Performing Simple Calculations like SUM and AVERAGE

Excel 2016 (PC) Session 2: Manage Worksheets and Charts

Three hours, $149
- Managing Cells and Worksheets
- Formatting Worksheet Cells
- Creating Charts
- Printing Worksheets

Excel 2016 (PC) Session 3: Manage Lists and Tables of Data

Three hours, $149
- Working with Data in Tables
- Summarizing with Subtotals
- Summarizing with PivotTables

Excel 2016 (PC) PivotTables: Data Analysis with PivotTables

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

Excel 2016 (PC) Session 4: Make Quick Work of Complex Tasks

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

Excel 2016 (PC) Session 5: Advanced Formulas and Charts

Three hours, $195
- Advanced Charting Capabilities
- Advanced Formulas Including VLOOKUP, IF & DSUM
- Troubleshooting Advanced Formulas

Excel VBA Programming 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 Programming 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 2016 (Mac) Session 1: Create Your First Spreadsheets

Three hours, $119
- Introduction to Excel
- Making and Editing Entries
- Performing Simple Calculations like SUM and AVERAGE

Excel 2016 (Mac) Session 2: Manage Worksheets and Charts

Three hours, $149
- Managing Cells and Worksheets
- Formatting Worksheet Cells
- Creating Charts
- Printing Worksheets

Excel 2016 (Mac) Session 3: Manage Lists and Tables of Data

Three hours, $149
- Working with Data in Tables
- Summarizing with Subtotals
- Summarizing with PivotTables

Excel 2016 (Mac) Session 4: Make Quick Work of Complex Tasks

Three hours, $195
- Group Mode: Working in Multiple Sheets
- Sharing Excel Workbooks
- Performing "What If" Analysis
- Formatting Cells Using Style Sheets
- Recording Macros

Excel 2016 (Mac) Session 5: Advanced Formulas and Charts

Three hours, $195
- Advanced Charting Capabilities
- Advanced Functions Including VLOOKUP, IF, & DSUM
- Troubleshooting Advanced Formulas