Microsoft Excel: Beginner to Advanced for 2023
- Description
- Curriculum
- FAQ
- Reviews
Most Updated for 2023:
Includes the Most Needed Topics for Beginners Like:
-
Excel Formulas – 40 Different formulas in 100+ different Situation
-
Excel Pivot Tables – 15 Different Situations of Pivot Tables
-
Excel Dashboarding – Excel Charts and 2 Major Excel Dashboard Projects
-
Advanced Charting
-
20+ Practice Sheets to help you apply the learnings in the Course.
Take your Excel skills to the next level with our Advanced Excel Course and Excel Dashboarding Course bundle. Our comprehensive training program is designed to help you master Excel and become an expert in creating stunning dashboards that showcase your data.
In our Advanced Excel Course, you’ll learn advanced formulas and functions, data visualization, pivot tables, and macros with our expert instructors. Perfect for data analysts, business owners, and anyone looking to become an Excel power user. The course comes with over 35 super advanced practice files that will challenge and sharpen your skills.
Our Excel Dashboarding Course is designed to help you create effective and engaging dashboards that showcase your data and communicate insights to your audience. You’ll learn how to create visually appealing charts, graphs, and tables that communicate insights effectively, connect your dashboards to different data sources such as Excel, Access, SQL Server and other databases, and create interactive dashboards that allow users to explore the data on their own. The course comes with 5 practical dashboard projects that you will learn to create from scratch.
Our bundle is perfect for anyone who works with data and wants to create powerful, visually engaging dashboards. Whether you’re a business analyst, data scientist, or just someone who wants to take their data presentations to the next level, our courses will teach you everything you need to know.
Don’t settle for boring, confusing data presentations. Sign up for our Advanced Excel Course and Excel Dashboarding Course bundle today and start creating stunning dashboards that showcase your data in a powerful way.
What gives me the right to teach this class? Can’t I just Google this stuff?
I carry deep passion and respect for Excel, since 2013, Excel was the first tool I mastered. More than using Excel, I love teaching it, and I have been doing the same for the past 3 years. As the founder of YourExcelGuy and have helped 30000+ students across 140+ countries.
Teaching is what I do full-time and I really enjoy doing it.
Thanks!
-Kadhir (Founder, YourExcelGuy)
-
2
Structure of Excel and How the Application worksLearn the Basics of the Excel application and how the application is structured for the ease of use.
-
3
Practice File for Conditional Formatting -
4
Conditional Formatting
-
5
Conditional Formatting - Data Bars
-
6
Icon Sets - Top Bottom Rules
-
7
Answer file for Conditional Formatting
-
8
Section Introduction
-
9
Downloadable Practice File
-
10
Excel Formula Structure and First Formula
The video will cover the basic components of an Excel formula, including functions, cell references, and operators. You will learn how to create a formula by typing it directly into a cell or by using the formula bar.
The video will also provide examples of simple formulas, such as summing a range of numbers or calculating an average. You will learn how to use the basic functions available in Excel, such as SUM and how to combine these functions with cell references and operators to create more complex formulas.
The video will also cover common formula errors and how to fix them, as well as tips and tricks for working with formulas more efficiently.
Overall, after watching the video, you should have a good understanding of the basic structure of Excel formulas and how to create your first formula. You will be able to apply this knowledge to create and manipulate formulas in Excel for a range of purposes, such as analyzing data or performing calculations.
-
11
Average Count and CountA Formulas
You should be able to understand how to use the AVERAGE, COUNT, and COUNTA formulas in Excel for different purposes.
The video will cover the basic syntax and usage of each formula, as well as provide examples of how to use them to perform various calculations and analysis. You will learn how to use the AVERAGE formula to calculate the average value of a range of numbers, how to use the COUNT formula to count the number of cells in a range that contain numerical values, and how to use the COUNTA formula to count the number of cells in a range that are not empty.
Overall, after watching the video, you should have a good understanding of how to use the AVERAGE, COUNT, and COUNTA formulas in Excel for a range of purposes. You will be able to apply this knowledge to perform calculations and analysis on data sets in Excel for a variety of applications.
-
12
Max and Min Formula
-
13
Answer file for Basic Formulas
-
14
Quiz for Basic Excel FormulasThis Quiz Involves 3 questions that will practically test your formula knowledge.
-
21
Downloadable Practice File
-
22
Using SumIF and Calculating a Metric - Excel Formula
-
23
SumIF with Wild Cards
-
24
AverageIF and CountIF Formulas along with the Wildcard situations
-
25
IFS Formula and SumIFS Formula
-
26
SumIFS with Wild Card Situations and SumIFS with Operator Situations
-
27
AverageIFS with Wildcard and Operator Situations
-
28
MaxIFS with Operators and Wild Cards
-
29
MinIFS with Operators and Wild Cards
-
30
Answer File for all of these Functions
-
31
Business Situation Assignment
-
32
Quiz
-
33
VLOOKUP Practice Files
-
34
Introduction to VLOOKUP - Excel Formula
-
35
How VLookup Works
-
36
Vlookup in Simple Business Situation 1 - Text Clue
-
37
Vlookup in Simple Business Situation 2 - Text Clue
-
38
Vlookup in Simple Business Situation 3 - Number as the Clue
-
39
Vlookup in Simple Business Situation 4 - Number as the Clue
-
40
Vlookup in Simple Business Situation 5 - Approximate Lookup
-
41
Vlookup in Simple Business Situation 6 - Two Way Lookup
-
42
Introduction to XLookup
-
43
ALERT for XLookup
-
44
Practice File for XLookup
-
45
XLOOKUP on Simple Data
-
46
XLOOKUP on Date and Horizontal Data
-
47
XLOOKUP with Match mode of Higher Value
-
48
XLOOKUP with Match mode of Lower Value
-
49
XLOOKUP with Match mode of Wildcard Characters
-
50
Introduction to INDEX Formula
-
51
Introduction to MATCH formula
-
52
Using INDEX and MATCH Together
-
57
Section Introduction
-
58
Practice File for Pivot Tables
-
59
Understanding Pivot Tables
-
60
How Pivot Tables work and our First Pivot Table
-
61
Changing Default Calculations to Average
-
62
Changing Calculations to Max and Min in Pivot Tables
-
63
Using Rows and Columns for Optimal Analytical View
-
64
Pivot Tables - Calculations with Views
-
65
More Practice Files for Pivot Tables
-
66
Managing Data Sources with Pivot Tables
-
67
Grouping Data in Pivot Tables
-
68
Quiz for Pivot Tables
-
69
Dashboarding Project File for Download
-
70
Importance of Dashboard
-
71
Creating and Managing Business Questions for Dashboarding
-
72
Setting up the Environment for Dashboarding
-
73
Generating Business Answers and Questions for Dashboarding
-
74
Choosing Charts for Dashboarding
-
75
Removing Distractions from the Dashboard
-
76
Bringing the Insights Out from our Dashboard
