Microsoft Excel- Create Dashboards and Master Power Query

Focused View

Amit Marmari

3:11:47

140 View

1. Introduction

1. Preview and Advertisment.mp4

00:55

2. Setting Expectations.mp4

00:50

3. Introducing the tables.mp4

04:23

4. Excel + Computers Basics.mp4

15:47

2. Excel Functions

1.1 Customers.xlsx

1. Customers file.mp4

04:07

2. Date and Time.mp4

07:08

3. Text to Columns.mp4

01:51

4. Table Relationships.mp4

01:39

5. Table Design and Name.mp4

01:09

6. Month and Weeknum columns.mp4

01:33

7. Vlookup.mp4

08:43

8. Match.mp4

03:18

9. Countif and Countifs.mp4

02:34

10. Sumif and Sumifs.mp4

04:06

11. Conditional Formatting.mp4

08:18

12. Remove Duplicates.mp4

02:21

13. Filter Function and Q1.mp4

05:17

14. SortBy Function and Q2.mp4

03:45

3. Power Query

1.1 Orders.csv

1.2 Prices.csv

1. Get Data, Append, Merge.mp4

05:28

2. Power Query Editor - Basic.mp4

03:20

3. Power Query Editor - Home.mp4

05:32

4. Power Query Editor - Transform.mp4

02:05

5. Power Query Editor - Add Column.mp4

06:52

6. Work with Power Query Editor - Part 1.mp4

02:07

7. Work with Power Query Editor - Part 2.mp4

04:02

8. Work with Power Query Editor - Part 3.mp4

02:29

9.1 Power Query Formulas - Official Microsoft link.html

9. Work with Power Query Editor - Part 4.mp4

01:27

10. Work with Power Query Editor - Part 5.mp4

01:51

11. Work with Power Query Editor - Part 6.mp4

02:40

12. Connection Properties.mp4

04:47

13. Pro Tip - Fast Data Load.mp4

01:02

14. Sort Table by Month.mp4

01:20

4. Dashboard Tools

1. Final Dashboard preview.mp4

00:29

2. Pivot Table in general.mp4

05:01

3. Pivot Table Options.mp4

02:21

4. Pivot Table 1 and Basics.mp4

03:05

5. Pivot Chart.mp4

02:06

6. Slicer and Report Connections.mp4

03:23

7. TimeLine.mp4

03:59

5. Creating the Dashboard

1. Pivot Table - Total Income.mp4

02:29

2. Pivot Table - Total Quantity.mp4

01:47

3. Pivot Table - On Time percent.mp4

03:33

4. Pivot Table - Product Amount.mp4

01:42

5. Pivot Table - Average days to supply.mp4

01:40

6. Pivot Chart - Money per Category.mp4

03:36

7. Pivot Chart - Money per Month, change month to number.mp4

06:16

8. Pivot Chart - Quantity per Category.mp4

02:42

9. Pivot Chart - Quantity per Location.mp4

02:15

10. Pivot Chart - Days to Supply per Category.mp4

03:03

11. Pivot Chart - On Time per Distributor.mp4

02:41

12. Slicer - Category.mp4

01:55

13. Slicer - Month.mp4

01:18

14. Slicer - Distributor.mp4

01:12

15. Slicer - Location.mp4

02:17

6. Design

1. Background, Picture, Themes, Gridlines.mp4

02:07

2. Graph Design.mp4

01:27

3. Slicer Design.mp4

02:36

4. Align text and Text size.mp4

01:36

5. View.mp4

00:49

6. Save As.mp4

01:36

Description

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

What You'll Learn?

Learn how to create dashboard from scratch
Mastering Microsoft Excel fundamentals
Get to know Excel's basic formulas
Mastering Pivot Tables and Charts
Mastering Power Query and get to know the tool - as it also useful for Power BI

Who is this for?

Microsoft Excel users

Dashboard builders - beginners to pros

Power BI users

More details

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.
Additionally, there is a 30-day return policy, ensuring that students are completely satisfied with their learning experience.
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.
Who this course is for:
Microsoft Excel users
Dashboard builders - beginners to pros
Power BI users

User Reviews

Rating

average 0

Total votes0

Focused display

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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.