Excel - Creating Dashboards

Name: Excel - Creating Dashboards
Rating: 4.5 (8 reviews)

Learn Top Tips For Querying And Displaying Information In Microsoft Excel

Created byBigger Brains

Last updated 11/2023

English

What you'll learn

Use range names in formulas
Create nested functions
Work with forms, form controls, and data validation
Use lookup functions
Combine multiple functions
Create, modify, and format charts
Use sparklines, trendlines, and dual-axis charts
Create a PivotTable and analyze PivotTable data
Present data with PivotCharts
Filter data with slicers

Course content

1 section • 20 lectures • 2h 49m total length

Creating Range Names10:17
Using Defined Names in a Formula4:17
Using Specialized Functions, Part 17:18
Using Specialized Functions, Part 211:58
Applying Data Validation12:28
Using a Data Form5:49
Adding Form Controls9:26
Using Lookup Functions11:39
Combining Functions11:10
Creating a Chart7:19
Formatting and Modifying Charts13:56
Dual Axis Charts5:38
Create a dual axis combo chart in Excel, placing unit sales on the secondary axis, using a line for sales and columns for earnings, with scales in billions and millions.
Forecasting with Trend Lines8:03
Creating Chart Templates2:58
Save charts as templates to reuse layouts in files or spreadsheets, then apply the layout to new data using chart templates (crt x) like the 5 year forecast dual axis.
Creating Sparklines7:18
Inserting Pivot Tables9:47
Build a dynamic pivot table to summarize sales data and answer questions on your dashboard by dragging fields into rows, columns, and values, then compare by author and market.
Analyzing Pivot Table Data, Part 17:42
Analyzing Pivot Table Data, Part 28:36
analyze and visualize pivot table data to compare market earnings by genre, explore author and book-level sales, and format electronic versus print earnings with percentage and currency displays.
Presenting Data with Pivot Charts6:47
Filtering Data with Slicers6:53
Knowledge Check

Requirements

A copy of Microsoft Excel is recommended.

Description

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!

Objectives. You will be able to:

Use range names in formulas
Create nested functions
Work with forms, form controls, and data validation
Use lookup functions
Combine multiple functions
Create, modify, and format charts
Use sparklines, trendlines, and dual-axis charts
Create a PivotTable and analyze Pivot Table data
Present data with Pivot Charts
Filter data with slicers

Who this course is for:

Microsoft Excel users looking to get more out of their Excel experience.