Excel Training Classes

Get down to business in Word, Excel, PowerPoint, Project, Visio and Access with hands-on expert training. Learn to write formulas, create PivotTables, animate charts and stylize reports, getting more done in less time and really impressing the boss.

Click class titles to see details and dates.

Excel icon Excel for Office 365▼

Microsoft Excel combines powerful spreadsheet, chart and list-management capabilities to form the industry-standard spreadsheet application. You will be learning from patient, experienced trainers on the current version of the software.

Learn Excel for Office 365 in the most efficient and effective way possible; live, hands-on, small-group, instructor-led training delivered over Zoom that you can attend remotely from anywhere. Here are the Excel for Office 365 classes we offer:

Excel Beginning 1: Your First Worksheets▶

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

Excel Beginning 2: Cell Formatting and Charting▶

Three hours, $99
- Formatting Cells
- Using Cell Styles
- Basic Conditional Formatting
- Creating Charts
- Enhancing Charts

Excel Intermediate 1: Simple Formulas▶

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

Excel Intermediate 2: Manage Lists and Tables of Data▶

Three hours, $129
- Writing Queries to Import Data
- Summarizing Data with Subtotals
- Using Data in Tables
- Advanced Filtering
- Database Functions

Excel PivotTables: Data Summarization and Analysis▶

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

Excel Advanced 1: Automating Tasks▶

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

Excel Advanced 2: Advanced Formulas▶

Three hours, $149
- Lookup and Reference Functions
- VLOOKUP, HLOOKUP, XLOOKUP
- INDEX and MATCH functions
- Logical Functions
- IF, AND, OR, IFS, and IFERROR functions
- COUNTIF, SUMIF, COUNTIFS and SUMIFS
- Dynamic Array Formulas
- SEQUENCE function
- SORT and FILTER functions
- UNIQUE function

Excel Tips and Tricks: Essential Time-Saving Techniques▶

Three hours, $149
- Formula Shortcuts
- Managing Multiple Worksheets and Workbooks
- Navigation and Selection Tips
- Data Editing Shortcuts
- Data Validation Tips
- Miscellaneous Shortcuts