Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

Microsoft Excel - Create Dashboards and Master Power Query

person icon Amit Marmari

4.1

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 Jul, 2024

language icon Language - English

person icon Amit Marmari

English [CC]

category icon Office Productivity,Microsoft

Lectures -60

Resources -3

Duration -3 hours

4.1

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

  • 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.
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

Hi!


My name is Amit Marmari and I am an industrial engineer from Ben Gurion University in Be'er Sheva, Israel, with extensive experience in Microsoft Excel. Throughout my career, I have developed a deep understanding of the platform and am passionate about sharing my knowledge with others.


As an entrepreneur and instructor, I offer a comprehensive course in Microsoft Excel, demonstrating my expertise in the platform. I also have a solid understanding of related technologies such as Python programming and SQL.


With my years of experience as a data developer at Playtika, I bring practical knowledge to my classes, giving students a well-rounded education.


Whether you are looking to improve your skills or start from the beginning, I am dedicated to helping you achieve your goals.

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

R

Ricardo Gomez

It was an amazing course. I have learnt a lot from it. I need to practice this material and also understand the approach to create the dashboard. Thanks a million for your tutoring....

T

Teena Moras

very good lessons

P

Prerna Anu

good

S

Shailender ojha

Good teaching

N

Nurit servi

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

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