Excel – Creating Dashboards

# of Lessons

Duration

2:49:19

Skill Level

Intermediate

MSRP

$20

Instructor(s)

Barbara Evers

Available Captions

Not Captioned

Also Included

Handout, Practice Files, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!

Get more from Excel and learn to use Forms, Lookup Functions, Charts, PivotTables, and Slicers to turn data into answers

Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards.

The ability to easily query and display information from your Excel data is a helpful tool for reporting and decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, Pivot Tables, and Slicers) which will do just that.

If you are comfortable with the basics of Excel, let our Microsoft Certified Trainer Barbara Evers walk you through even more useful Excel topics and tools.

Topics covered include:

Using range names in formulas
Creating nested functions
Working with forms, form controls, and data validation
Using lookup functions
Combining multiple functions
Creating, modifying, and formatting charts
Using sparklines, trendlines, and dual-axis charts
Creating a Pivot Table and analyzing Pivot Table data
Presenting data with Pivot Charts
Filtering data with slicers

Over 2 hours of high-quality HD content in the “Uniquely Engaging”^TM Bigger Brains Teacher-Learner style!

Course Contents:

Lesson	Length
Creating Range Names	10:17
Using Defined Names in a Formula	4:17
Using Specialized Functions, Part 1	7:18
Using Specialized Functions, Part 2	11:58
Applying Data Validation	12:28
Using a Data Form	5:49
Adding Form Controls	9:26
Using Lookup Functions	11:39
Combining Functions	11:10
Creating a Chart	7:19
Formatting and Modifying Charts	13:56
Dual Axis Charts	5:38
Forecasting with Trend Lines	8:03
Creating Chart Templates	2:58
Creating Sparklines	7:18
Inserting Pivot Tables	9:47
Analyzing Pivot Table Data, Part 1	7:42
Analyzing Pivot Table Data, Part 2	8:36
Presenting Data with Pivot Charts	6:47
Filtering Data with Slicers	6:53

Related Course Recommendations:

Excel – Creating Dashboards

About

Friendly experts, modern technology, and a unique Teacher-Learner style, make award-winning Bigger Brains courses the first choice of learners and training professionals around the world.

Catalog Request

Get course updates, Learning and Development ideas, and Information on how to use Bigger Brains!