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
- Make and Edit Entries
- Manage Cells and Worksheets
- Print Worksheets
Excel Beginning 2
Cell Formatting and Charting
Three hours, $99
- Format Cells
- Apply Cell Styles
- Basic Conditional Formatting
- Create Charts
- Enhance Charts
Excel Intermediate 1
Simple Formulas
Three hours, $129
- Simple Functions
- Arithmetic Formulas
- Math with Dates
- Lookup Functions
- AutoFill Formulas
- Relative vs Absolute Referencing
Excel Intermediate 2
Manage Data in Lists and Tables
Three hours, $129
- Import Data
- Summarize Data with Subtotals
- Use Data in Tables
- Advanced Filtering
- Database Functions
Excel PivotTables
Data Summarization and Analysis
Three hours, $129
- Create PivotTables
- Analyze data using PivotTables
- Work with PivotTable options
- Create PivotCharts
Excel Advanced 1
Make Quick Work of Complex Tasks
Three hours, $149
- Work on Multiple Sheets Simultaneously
- Perform "What If" Analysis
- Conditional Formatting
- Record 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
- Manage Multiple Worksheets and Workbooks
- Navigation and Selection Tips
- Data Editing Shortcuts
- Data Validation Tips
- Miscellaneous Shortcuts