Microsoft Excel Creating Dynamic Dashboards

Microsoft Excel – Creating Dynamic Dashboards, available at $64.99, has an average rating of 3.9, with 54 lectures, based on 66 reviews, and has 776 subscribers.

You will learn about configure data to work well with reporting dashboards create effective, functional dynamic dashboards to display Excel data This course is ideal for individuals who are Regular Microsoft Excel users looking to add another skill It is particularly useful for Regular Microsoft Excel users looking to add another skill.

Enroll now: Microsoft Excel – Creating Dynamic Dashboards

Summary

Title: Microsoft Excel – Creating Dynamic Dashboards

Price: $64.99

Average Rating: 3.9

Number of Lectures: 54

Number of Published Lectures: 54

Number of Curriculum Items: 54

Number of Published Curriculum Objects: 54

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

configure data to work well with reporting dashboards

create effective, functional dynamic dashboards to display Excel data

Who Should Attend

Regular Microsoft Excel users looking to add another skill

Target Audiences

Regular Microsoft Excel users looking to add another skill

Are you interested in how Excel can be used to present data in a functional, visually attractive, and user-friendly ways? This tightly focused course will show you how to create dynamic dashboards to present complex data using a variety of techniques. A basic knowledge of Excel is required.

You will start by learning how to prepare the data, then jump into building the dashboard. Throughout the course, you will be working to create a dashboard that provides a summary of a persons health information. Erin will teach you how to optimize Excel data for use in dashboards, create visual dashboard components, and add interactivity to customize them for each user. This video tutorial also covers how to create a distribution histogram, use a waffle chart to show progress, and add actions to buttons.

Finally, you will learn how to generate dashboards as outputs, produce them as PDFs, and utilize them within PowerPoint or share via OneDrive. Once you have completed the course, youll be able to create your own custom dynamic dashboards in Excel with ease. Working files are included, allowing you to follow along with the author throughout the lessons.

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Important – Download These First – Working Files

Lecture 2: About This Series

Lecture 3: What You Will Learn

Lecture 4: How To Access Your Working Files

Chapter 2: Deciding On Dashboards

Lecture 1: Deciding On Dashboards

Lecture 2: Reports, Dashboards And Scorecards

Lecture 3: Pondering The Plan

Lecture 4: Selecting Measures And Metrics

Chapter 3: Preparing The Data

Lecture 1: Preparing The Data

Lecture 2: Data Modeling Basics

Lecture 3: Structuring The Workbook

Lecture 4: Connecting To Data – Part 1

Lecture 5: Connecting To Data – Part 2

Lecture 6: Simplifying Data With Named Ranges

Lecture 7: Leveraging The Efficiency Of Tables

Lecture 8: Harnessing The Power Of Pivot Tables

Lecture 9: Managing Connected Data

Lecture 10: Simplifying With Custom Number Formats

Chapter 4: Building Dashboards

Lecture 1: Building Dashboards

Lecture 2: Dashboard Design Rules

Lecture 3: Managing Branding With Custom Themes

Lecture 4: Creating The Navigation Bar – Part 1

Lecture 5: Creating The Navigation Bar – Part 2

Lecture 6: Creating The Navigation Bar – Part 3

Lecture 7: What Is In A Word?

Lecture 8: Building Out Worksheets And Navigation

Lecture 9: Summarizing Data Using Groups

Lecture 10: Configuring Show Values As For Pivot Tables

Lecture 11: Assigning Categories Using Nested If

Lecture 12: Identifying Top Ten Values

Lecture 13: Finding The Last Value In A Series

Chapter 5: Getting Visual

Lecture 1: Getting Visual

Lecture 2: Customizing Display With Text-Based Elements

Lecture 3: Alerting With Conditional Formatting

Lecture 4: Chart And Sparkline Review

Lecture 5: Creating Sparklines For Dashboards

Lecture 6: Creating Charts For Dashboards

Lecture 7: Using A Waffle Chart To Show Progress

Lecture 8: Using The Excel Camera

Lecture 9: Creating A Distribution Histogram

Lecture 10: Hitting The Mark With Bullet Graphs

Chapter 6: Adding Interactivity

Lecture 1: Adding Interactivity

Lecture 2: Displaying The Developer Tab

Lecture 3: Understanding Interactive Dashboard Controls

Lecture 4: Adding Actions To Buttons

Lecture 5: Creating Custom Content With Combo Boxes

Lecture 6: Simplifying With Check Boxes

Lecture 7: Facilitating Filtering With Slicers And Timelines

Lecture 8: Finalizing By Color-Coding, Hiding And Protecting Worksheets

Chapter 7: Generating Dashboards As Output

Lecture 1: Generating Dashboards As Output

Lecture 2: Producing Dashboards As PDF

Lecture 3: Presenting Dashboards With Powerpoint

Lecture 4: Sharing Dashboards Via OneDrive

Chapter 8: Conclusion

Lecture 1: What You Now Know

Instructors

Infinite Skills
High Quality Training

Rating Distribution

1 stars: 5 votes

2 stars: 1 votes

3 stars: 12 votes

4 stars: 29 votes

5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!