Excel Advanced
$225.00
Course Date
Please choose
In stock
Product Details
Upcoming Classes
6/4/2025 - 9:00am to 4:00pm
8/1/2025 - 9:00am to 4:00pm
WE OFFER FLEXIBLE SCHEDULING, SO PLEASE REQUEST AN ALTERNATE CLASS DATE OR TIMEFRAME IF NEEDED!
Course Description
Excel Advanced is intended for proficient users of Excel. Topics covered offer a deeper dive into advanced features including linking worksheets, lookup functions, formula auditing, collaborative and sharing capabilities, data validation, utilizing macros to automate processes, analysis and forecasting tools, and visual tools like Sparklines and 3D Maps.
Prerequisite
Excel Intermediate or equivalent experience
Software Version
Microsoft (Office) 365, 2024, 2021, 2019
Course Highlights
- Linking worksheets and workbooks
- Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Formula Auditing features
- Comments and Notes
- Collaboration and Sharing Capabilites
- Protection features
- Data Validation
- Macro recording and running
- What-If Analysis tools
- Forecast Sheet feature
- Sparkline Charts
- 3D Map creation
- Exporting and Importing (appendix)
- Application settings (appendix)
- Power Pivot (appendix)
Display prices in:
USD
