Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

Microsoft Excel - Create Dashboards and Master Power Query

person icon Amit Marmari

4.6

Microsoft Excel - Create Dashboards and Master Power Query

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

updated on icon Updated on May, 2024

language icon Language - English

person icon Amit Marmari

English [CC]

category icon Office Productivity,Microsoft

Lectures -60

Resources -3

Duration -3 hours

4.6

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

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

What will you learn in this course:

  • 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

What are the prerequisites for this course?

  • Microsoft Excel installed.
  • No Prior Microsoft Excel knowledge required.
Microsoft Excel - Create Dashboards and Master Power Query

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
4 Lectures
  • play icon Priview and Advertisement 00:55 00:55
  • play icon Setting Expectations 00:50 00:50
  • play icon Introducing the tables 04:23 04:23
  • play icon Excel + Computer's Basics 15:24 15:24
Excel Functions
14 Lectures
Tutorialspoint
Power Query
14 Lectures
Tutorialspoint
Dashboard Tools
7 Lectures
Tutorialspoint
Creating the Dashboard
15 Lectures
Tutorialspoint
Design
6 Lectures
Tutorialspoint

Instructor Details

Amit Marmari

Amit Marmari

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Feedbacks

P

Prerna Anu

e

good

N

nurit servi

e

I was looking for a course that shows how to create dashboards in Excel and finally found this one. Thank you so much, very well explained!

Y

yoni marom

e

A great course! Easy to understand, full of tips and usefull information to implement. highly recommennded!!

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515