Excel Intermediate
$225.00
Course Date
Please choose
In stock
Product Details
Upcoming Classes
5/21/2025 - 9:00am to 4:00pm
7/15/2025 - 9:00am to 4:00pm
WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE OR TIMEFRAME IF NEEDED!
Course Description
Excel Intermediate will take you even further into the powers of the software. Training topics include using cell names, utilizing some of the most common built-in calculating functions, data list management like sorting and filtering, using the Format as Table feature, calculating within a data list with Subtotal functions and Pivot Tables, creating charts, and more!
Prerequisite
Excel Basics or equivalent experience
Software Version
Microsoft (Office) 365, 2024, 2021, 2019
Course Highlights
- Creating and using cell names
- Built-in calculating Functions - Logical, Math/Trig, Statistical, Date, Text
- Sorting and Filtering data lists
- Database Functions
- Outlining Data
- Generating Subtotals
- Format as Table feature
- Advanced Conditional Formatting
- Charting
- PivotTables and PivotCharts
- Graphics and SmartArt (appendix)
- Array formulas (appendix)
Display prices in:
USD
