Excel Advanced
+3

Excel Advanced

00018
$225.00
In stock
1
Product Details

Upcoming Classes

5/29/2024 - 9:00am to 4:00pm

8/1/2024 - 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 an in-depth view of advanced spreadsheet capabilities including calculating functions and formulas, data validation, analysis tools, and utilizing macros to automate processes.

Prerequisite

Excel Intermediate or equivalent experience

Software Version

Microsoft (Office) 365, 2021, 2019, 2016

Course Highlights

  • Linking worksheets and workbooks
  • Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
  • Formula Auditing features
  • Comments and Collaboration
  • 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)
Save this product for later
Share by: