Excel for Office 365 Group Training Classes
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.
Our Excel for Office 365 Classes
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 Data in Lists and Tables
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
Make Quick Work of Complex 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