Tutorialspoint

Microsoft Excel - Create Dashboards and Master Power Query

Master Excel's most useful formulas and create your own dashboard using Power Query - from scratch!

Course Description

If you are looking for the best place to learn Excel's basics and upgrade your skills - this is the course for YOU!

This course is designed to provide students with comprehensive training on how to create professional-looking dashboards in Excel. With over 3 hours of content, this course is packed with valuable information that is available to students forever.

In those 3 hours, students will learn how to create dashboards from scratch, and how to master advanced features such as Pivot tables and charts. These features are essential for creating dynamic and interactive reports and will give students the ability to analyze and present data in a clear and meaningful way.

In addition to learning about these advanced features, students will also learn about Excel formulas. These formulas are the backbone of Excel and are essential for automating calculations and analyzing data. We will cover a wide range of formulas, from basic arithmetic to more advanced functions, and will provide students with the knowledge they need to take their Excel skills to the next level.

Overall, this Excel online course is perfect for beginners who are looking to become proficient in Excel, as well as more advanced users who want to take their skills to the next level. With a focus on creating professional-looking dashboards and mastering advanced features, this course will provide students with the knowledge they need to succeed in the world of data analysis and reporting.

Come join us and start your journey today!

P.S. - I want to thank Danielle Harosh for editing this course. You are amazing.

Also, this course is dedicated to my late friends, Eytam Magini and Tomer Morad. I miss you guys.

Goals

  • Improve Excel skills.
  • Learn how to create your own dashboard.
  • Control and master advanced tools like Pivot Tables, Pivot Charts, Power Query.
  • Gain knowledge in Excel in just 3 hours.
  • Get to know basic and advanced Excel formulas.

Prerequisites

  • Microsoft Excel installed.
  • No Prior Microsoft Excel knowledge required.
Show More

Curriculum

  • Priview and Advertisement
    00:55
    Preview
  • Setting Expectations
    00:50
    Preview
  • Introducing the tables
    04:23
  • Excel + Computer's Basics
    15:24
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
5.0
Course Rating
100%
0%
0%
0%
0%

    Feedbacks (1)

  • Amit Marmari
    Amit Marmari

Microsoft Excel - Create Dashboards and Master Power Query
This Course Includes
  • 3 hours
  • 60 Lectures
  • 3 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate