Microsoft Excel Advanced Training

Issued by University of North Dakota

Users will learn to manage Excel workbooks through proper design, use lesser known features within Excel to analyze data, and troubleshoot common issues in Excel workbooks. Topics include: Setting up 3-D references, Use links and external references , Consolidate data, Worksheet and workbook protection, Apply data validation, Formula evaluation and managing errors and issues, Using data tables, Create scenarios, Use Goal Seek, Forecast trends, Create sparklines and maps, and Embed a document.

Type Learning
Level Advanced
Time Hours
Cost Free

Additional Details

Skills

Earning Criteria

The badge earner learned how to accomplish the following: set up 3-D references, use links and external references, consolidate data, set up worksheet and workbook protection, apply data validation, conduct formula evaluation and manage errors and issues, use data tables, create scenarios, use Goal Seek, forecast trends, create sparklines and maps, and embed a document.