Microsoft Excel Dashboards Level- Formatech

Information Technologies

hours

language

English

Topic A: Examine Dashboards

Topic B: Use Range Names in Formulas

Topic C: Use Specialized Functions

Topic A: Apply Data Validation

Topic B: Work with Forms and Controls

Topic A: Use Lookup Functions

Topic B: Combine Functions

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic A: Create Dual-Axis Charts and Trendlines

Topic B: Create Sparklines

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Topic C: Present Data with PivotCharts

Topic D: Filter Data by Using Slicers

minimize course outline

Topics Covered