Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel Free Dashboard Course
Rating: 4.1 out of 5(427 ratings)
6,855 students

Microsoft Excel Free Dashboard Course

Master Excel with this free course—learn conditional logic, data visualization, and interactive dashboard creation. Thi
Created byTed Jordan
Last updated 9/2024
English
English [Auto],

What you'll learn

  • Master Conditional Logic in Excel: Understand and apply key Excel functions such as IF statements, COUNTIF, and other conditional formulas.
  • Create and Customize Data Visualizations: Learn the basics of graph creation, including how to choose, format, and customize various types of charts.
  • Build Interactive Dashboards: Use advanced Excel features like tick boxes and dropdown lists to create interactive dashboards.
  • Design a Comprehensive Checklist Dashboard: Apply your new skills to build a dynamic checklist dashboard that can be used across different industries.

Course content

6 sections • 11 lectures • 35m total length

  • Introduction1:01

    Explore the basics of spreadsheets, useful functions, graph creation and formatting, themes, custom charts beyond Excel defaults, and data validation boxes in this introductory Excel mini course.

  • Introduction Pt20:17

Requirements

  • A computer with an internet connection.
  • A willingness to learn and apply new skills.

Description

Unlock the power of Excel with our Microsoft Excel Free Dashboard Course. This beginner-friendly course is designed to equip you with essential skills in Excel, focusing on conditional logic, data visualization, and dashboard creation. Whether you're new to Excel or looking to refresh your skills, this course offers practical, hands-on learning that you can apply immediately.

In Phase 1, you'll dive into mastering Excel's conditional logic, learning how to use functions like IF, COUNTIF, and other conditional formulas to make your spreadsheets smarter and more efficient.

Moving into Phase 2, you'll explore the basics of data visualization, discovering how to create and customize various types of charts and graphs to present your data clearly and effectively.

Phase 3 takes your skills further by introducing advanced Excel features such as tick boxes, dropdown lists, and custom charts, enabling you to create more interactive and user-friendly dashboards.

Finally, in Phase 4, you'll apply everything you've learned to build a comprehensive checklist dashboard. This dynamic tool will help you track tasks and visualize progress, making it applicable to any industry.

By the end of this course, you'll have the confidence to create professional Excel dashboards and a strong foundation for further learning in data analysis and visualization.

Who this course is for:

  • Beginners in Data Analysis: Individuals who are new to Excel and want to learn the basics of creating dashboards.
  • Professionals Looking to Upskill: Those who want to enhance their Excel skills to improve efficiency and productivity at work.
  • Students Seeking to Boost Their CVs: Learners who want to add practical Excel skills to their resumes, making them more attractive to employers.
  • Anyone Interested in Data Visualization: If you’ve always wanted to create professional-looking dashboards but didn’t know where to start, this course is for you.

Report abuse