Microsoft Excel Dashboards Level- Formatech

Digital Capabilities

hours

language

English

01 Lesson 1: Using Names in Formulas and Functions
+

Topic A: Examine Dashboards

Topic B: Use Range Names in Formulas

Topic C: Use Specialized Functions

02 Lesson 2: Automating Workbook Functionality
+

Topic A: Apply Data Validation

Topic B: Work with Forms and Controls

03 Lesson 3: Applying Conditional Logic
+

Topic A: Use Lookup Functions

Topic B: Combine Functions

04 Lesson 4: Visualizing Data with Basic Charts
+

Topic A: Create Charts

Topic B: Modify and Format Charts

05 Lesson 5: Using Advanced Charting Techniques
+

Topic A: Create Dual-Axis Charts and Trendlines

Topic B: Create Sparklines

06 Lesson 6: Analyzing Data with PivotTables, PivotCharts, and Slicers
+

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

Microsoft Excel Dashboards Level

In-Class Training

$ 245

Microsoft Excel Dashboards Level

Online Instructor-Led Training

$ 195