Microsoft Office Excel 2013: Dashboards

Request more details:

Description:
The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers is the cornerstone of driving a successful organization that is able to compete at a high level. This course builds upon the foundational knowledge presented in the Microsoft® Office Excel 2013: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that you can use to create dashboards.
Prerequisites:
To ensure success, participants should have completed Microsoft® Office Excel® 2013: Part 1 or have the equivalent knowledge and experience. In particular, participants should have some experience in creating workbooks with formulas and functions.
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.
Creating Advanced Formulas :
Use Range Names in Formulas
Use Specialized Functions
Automating Workbook Functionality:
Apply Data Validation
Work with Forms and Controls
Applying Conditional Logic :
Use Lookup Functions
Combine Functions
Visualizing Data with Basic Charts :
Create Charts
Modify and Format Charts
Advanced Charting Techniques:
Use Advanced Chart Features
Create Sparklines
Analyzing Data with PivotTables, Slicers, and PivotCharts :
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Slicers