Udemy

Microsoft Excel Free Dashboard Course

Master Excel with this free course—learn conditional logic, data visualization, and interactive dashboard creation. Thi
Free tutorial
Rating: 4.1 out of 5 (342 ratings)
5,634 students
30min of on-demand video
English
English [CC]

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.

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.

Instructor

Business and Media Analyst, CEO at Ted Jordan
  • 4.1 Instructor Rating
  • 342 Reviews
  • 5,761 Students
  • 1 Course

Hi there! I'm passionate about helping businesses and individuals navigate the exciting world of programmatic advertising. With years of experience working alongside agencies and trading hundreds of successful campaigns across Europe, I've seen firsthand how powerful and transformative programmatic strategies can be.

I specialize in everything from video, display, and native ads to the cutting-edge realms of audio, DOOH, and Connected TV (CTV). My mission is to make programmatic advertising accessible, effective, and, most importantly, impactful for everyone I work with.

Whether you're a job seeker looking to boost your skills, a student eager to learn the ropes, an entrepreneur wanting to make your mark, or an agency aiming to up your game, I'm here to help. Through expert consulting, media trading, and hands-on training, I strive to empower my clients and partners with the tools and knowledge they need to succeed.

Top companies trust Udemy

Get your team access to Udemy's top 30,000+ courses