Excel - Creating Dashboards
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
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.
Instructor
- 4.4 Instructor Rating
- 10,694 Reviews
- 107,334 Students
- 148 Courses
Let's face it, no online training courses are "fun." But some (like Bigger Brains) are engaging and better to spend time on than others!
Bigger Brains courses are built in a unique Teacher/Learner style, featuring two people on camera to recreate some of the interactivity and physiological benefits of classroom training, including dialogue, humor, and practical use case examples. This uniquely engaging video-based format is more enjoyable and, more importantly, more effective than traditional eLearning formats.
Bigger Brains courses are popular with both learners and training professionals around the world. Because we use experienced teachers and subject matter experts with real-world experience, we have the most realistic and comprehensive online training courses possible.
There are also resources to help you learn along with the way. Most Bigger Brains courses include handouts and practice files. Some even include free post-training reinforcement through the BrainBot learning retention app.
Join the hundreds of thousands of learners around the world and upskill, reskill, and stay in the know with Bigger Brains!