Overview:

With so much data available, created on a nearly constant basis, the ability to make sense of that data becomes more critical and challenging with every passing day.

Course Objectives:

Upon successful completion of this course, you will be able to create dashboards in Microsoft Office Excel 2013.

You will:

         Create advanced formulas.

         Automate workbook functionality.

         Apply conditional logic.

         Visualize data by using basic charts.

         Implement advanced charting techniques.

         Analyze data by using PivotTables, slicers, and PivotCharts.

Target Student:

This course is designed for students with foundational knowledge and skills in Excel 2013 and who desire to utilize higher-level functionality in Excel to summarize table data in Excel by using functions, charts, and pivot tables and display those elements in a dashboard format.

Prerequisites:

To ensure success, students should have completed Excel 2013: Part 1 or have the equivalent knowledge and experience. In particular, students should have some experience in creating workbooks with formulas and functions.

Course Content:

Lesson 1: Creating Advanced Formulas

Topic A: Use Range Names in Formulas

Topic B: Use Specialized Functions

Lesson 2: Automating Workbook Functionality

Topic A: Apply Data Validation

Topic B: Work with Forms and Controls

Lesson 3: Applying Conditional Logic

Topic A: Use Lookup Functions

Topic B: Combine Functions

Lesson 4: Visualizing Data with Basic Charts

Topic A: Create Charts

Topic B: Modify and Format Charts

Lesson 5: Advanced Charting Techniques

Topic A: Use Advanced Chart Features

Topic B: Create Sparklines

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

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Topic C: Present Data with PivotCharts

Topic D: Filter Data by Using Slicers