Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Blockchain Business Intelligence
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Google Analytics Email Marketing Startup Advertising Strategy

Office ProductivityMicrosoftExcel Dashboard

Fundamentals of Building Excel Dashboards

Learn All About Creating Excel Dashboards
Rating: 5.0 out of 55.0 (3 ratings)
722 students
Created by Donald F.
Last updated 5/2022
English
English [Auto]

What you'll learn

  • Learn the process of creating a dashboard worksheet
  • How to summarize spreadsheet data
  • Learn to set up a supporting workbook
  • How to manage and filter data
  • Learn to streamline charts for dashboards and create sparklines
  • How to create and manage cell links using PivotTable data in a formula
  • Learn about extending your dashboard with hidden rows

Requirements

  • Microsoft Excel to follow along

Description

In this course you will learn the basics of creating Excel dashboards. This course takes you through all you need to know to make beautiful Excel dashboards from start to finish.  You will learn how to create dashboards in Excel.

Dashboards in Microsoft Excel provides a powerful tool for summarizing and evaluating the performance of your business or organization.  Mastering those skills you need to create effective dashboards will let you work quickly and make great decisions. 

An Excel Dashboard provides insight, analysis and alerts.  They're fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

This comprehensive Excel Dashboard Course will teach you the simple techniques you can apply in Excel to make amazing dashboards that will set your skill level apart from the crowd.

Learn how to build Excel Dashboard reports from the ground up. By applying the simple techniques, you will have the skills to be able to create reports that save loads of time.

A dashboard is a visual representation of key metrics that allow you to quickly view and analyze your data in one place. Dashboards not only provide consolidated data views, but a self-service business intelligence opportunity, where users are able to filter the data to display just what’s important to them. In the past, Excel reporting often required you to generate multiple reports for different people or departments depending on their needs.

Who this course is for:

  • Business Professionals who use Excel
  • Data analysts
  • Anyone wanting to learn to create Excel dashboards and reports

Instructor

Donald F.
Consultant
Donald F.
  • 4.6 Instructor Rating
  • 10 Reviews
  • 969 Students
  • 2 Courses

With over 30 years in the Business management field, I have worked with a variety of Fortune 500 companies. Through my consultant company, we are focused on what truly matters – doing the right thing to advance and deepen relationships. We relentlessly seek the success of our clients through the expertise of our consultants. Our work together is deeply human and is changing the face of IT and management consulting.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.