Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
6 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
6 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
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
Course Overview
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.
Pre-requisites
- No prior Microsoft Excel knowledge required
- Microsoft Excel installed
Target Audience
- Microsoft Excel users
- Dashboard builders - beginners to pros
- Power BI users
- Analysts
- Students
- Industrial Engineers
Curriculum 70 Lectures 02:50:20
-
Section 1 : Introduction
- Lecture 2 :
- Setting Expectations
- Lecture 3 :
- Introducing the tables
- Lecture 4 :
- Excel + Computer's Basics - Part 1
- Lecture 5 :
- Excel + Computer's Basics - Part 2
- Lecture 6 :
- Excel + Computer's Basics - Part 4
- Lecture 7 :
- Excel + Computer's Basics - Part 3
-
Section 2 : Excel Functions
- Lecture 1 :
- "Customers" file
- Lecture 2 :
- Date and Time - Part 1
- Lecture 3 :
- Text to Columns
- Lecture 4 :
- Table Relationships
- Lecture 5 :
- Table Design and Name
- Lecture 6 :
- Month and Weeknum columns
- Lecture 7 :
- Vlookup and Xlookup - Part 1
- Lecture 8 :
- Match
- Lecture 9 :
- Countif and Countifs
- Lecture 10 :
- Sumif and Sumifs
- Lecture 11 :
- Conditional Formatting - Part 1
- Lecture 12 :
- Remove Duplicates
- Lecture 13 :
- Filter Function and Q1
- Lecture 14 :
- SortBy Function and Q2
- Lecture 15 :
- Date and Time - Part 2
- Lecture 16 :
- Vlookup and Xlookup - Part 2
- Lecture 17 :
- Conditional Formatting - Part 2
-
Section 3 : Power Query
- Lecture 1 :
- Get Data, Append, Merge
- Lecture 2 :
- Power Query Editor - Basic
- Lecture 3 :
- Power Query Editor - Home - Part 1
- Lecture 4 :
- Power Query Editor - Transform
- Lecture 5 :
- Power Query Editor - Add Column
- Lecture 6 :
- Work with Power Query Editor - Part 1
- Lecture 7 :
- Work with Power Query Editor - Part 2
- Lecture 8 :
- Work with Power Query Editor - Part 3
- Lecture 9 :
- Work with Power Query Editor - Part 4
- Lecture 10 :
- Work with Power Query Editor - Part 5
- Lecture 11 :
- Work with Power Query Editor - Part 6
- Lecture 12 :
- Connection Properties
- Lecture 13 :
- Pro Tip - Fast Data Load
- Lecture 14 :
- Sort Table by Month
- Lecture 15 :
- Power Query Editor - Home - Part 2
- Lecture 16 :
- Download file - Orders
- Lecture 17 :
- Download file - Prices
-
Section 4 : Dashboard Tools
- Lecture 1 :
- TimeLine
- Lecture 2 :
- Slicer and Report Connections
- Lecture 3 :
- Pivot Chart
- Lecture 4 :
- Pivot Table Basics
- Lecture 5 :
- Pivot Table Options
- Lecture 6 :
- Pivot Table in general
- Lecture 7 :
- Final Dashboard preview
-
Section 5 : Creating the Dashboard
- Lecture 1 :
- Slicer - Location
- Lecture 2 :
- Slicer - Distributor
- Lecture 3 :
- Slicer - Month
- Lecture 4 :
- Slicer - Category
- Lecture 5 :
- Pivot Chart - On Time per Distributor
- Lecture 6 :
- Pivot Chart - Days to Supply per Category
- Lecture 7 :
- Pivot Chart - Quantity per Location
- Lecture 8 :
- Pivot Chart - Quantity per Category
- Lecture 9 :
- Pivot Chart - Money per Month, change month to number - Part 1
- Lecture 10 :
- Pivot Chart - Money per Category
- Lecture 11 :
- Pivot Table - Average days to supply
- Lecture 12 :
- Pivot Table - Product Amount
- Lecture 13 :
- Pivot Table - On Time percent
- Lecture 14 :
- Pivot Table - Total Quantity
- Lecture 15 :
- Pivot Table - Total Income
- Lecture 16 :
- Pivot Chart - Money per Month, change month to number - Part 2
-
Section 6 : Design
- Lecture 1 :
- Background, Picture, Themes, Gridlines
- Lecture 2 :
- Graph Design
- Lecture 3 :
- Slicer Design
- Lecture 4 :
- Align text and Text size
- Lecture 5 :
- View
- Lecture 6 :
- Save As
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
-
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
0 Course Views
Courses
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.
View More...
