Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

The Complete Excel Practical Course: Learn, Build & Visualiz

Name: The Complete Excel Practical Course: Learn, Build & Visualiz
Rating: 4.4 (22 reviews)

Turn Raw Data into Stunning, Interactive Dashboards that Elevate Your Professional Edge

Created bySadiq Al Lawati

Last updated 12/2025

English

English [Auto],

What you'll learn

Build a strong expeience in understanding the basics of Microsoft Excel
Understand the most common features and functions used in Microsoft Excel
Understand the most powerful formatting tools to make your tables uniqe in shape
Enable your speed by understanding the power of Excel shortcuts
Convert ideas to real projects in Excel by identifying inputs and desired outputs and link between them
Create your own designed simple to complex data from scratch
Amaze your sorrounding by unlocking major dynamic formulas like: SUMIF, COUNTIF, INDEX, MATCH, OFFSET & More
Enable the power of HLOOKUP formula in dynamic reporting
Create dynamic dashboards by mastering the most powerful tool like PivotTables
Control your dynamic reports by adding slicers
Generate amazing graphs and format them like a BOSS
Design and format your dynamic dashboards with reflective themes to your business
Promote your career or business by enabling the power of using excel dashbaords
Automate your day to day And/Or opertaions activity and be the first to show your results
Be amazed with building 5 real projects from scratch to proffesional that you won't find in ANY other course

Course content

10 sections • 74 lectures • 4h 19m total length

Introduction to The Course8:23
An introduction and welcoming to the course along with explaining the most important things to learn and what to expect at the end of the course
ABC of MS Excel (Part 1)15:24
I will take you in a fast tour to show the most popular functions and features of Excel that is widely used
ABC of MS Excel (Part II)11:10
Excel Shortcuts5:05
I will explain the most powerful shortcuts used in Excel that will make your convert your work to be faster
Dynamic Dashboards & Reports Changes Your Experience0:34
I will explain you more about dashboards and the critical need of it

Understanding & Formatting Fonts & Cells1:43
You will be able to format your tables in terms of font type and size along with changing the style of representing your data.
You will also be able to format your specific cells in terms of colors and fonts along with adding different type of borders
Inserting Columns & Rows1:32
You will learn all the ways to add, move, delete columns and rows
Optimize Your Time By Applying Magic Pen0:31
You will learn the use of format painter and the ways to use it on single and multiple cells, rows or columns
Aligning Data & Setting Up Columns0:58
You will be able to apply different alignment styles on your cells
Formatting Numbers0:53
You will be able to understand and apply various number of number's formats for different uses
Cut, Copy & Paste Functions0:44
Learn how to cut, copy, and paste selected cells in Excel using shortcuts such as Ctrl+X to move them to a new location.
Wrapping Texts & Merging Cells1:53
Setting & Formatting Specific Tables0:44
Master setting and formatting specific tables in Excel by selecting the table area with quick shortcuts and adding data while preserving the same formatting.
Quiz 1

SUM Formula3:01
SUMIF Formula1:47
Apply the sumif formula to calculate total profit per brand by defining the criteria range and the sum range for Toyota.
MAX & MIN Formulas1:43
Use max and min formulas in Excel to identify the highest and lowest vehicle sales, then format the results showing 187,000 as the maximum and 11,000 as the minimum.
AVERAGE Formula1:00
COUNT Formula0:41
COUNTIF Formula0:50
TODAY Formula1:02
Use the TODAY() function to display the current date in reports and dashboards; it updates daily when you open the file, ensuring printed or shared documents show the correct date.
Name Manager2:30
MATCH Formula2:27
INDEX Formula2:57
VLOOKUP Formula1:46
Learn how to use vlookup to fetch exact sales values from large data sets, using absolute references and the correct column index to pull each salesperson’s 2019 figures.
HLOOKUP Formula2:01
You will be able to understand and apply HLOOKUP formula and find it's power in dynamic reporting
Data Validation4:18
You will be able to understand and apply the most useful data validation types in your data
Conditional Formatting3:37
You will be able to understand and apply different type of conditional formatting and you will be able to create your own conditions
Quiz 2

PivotTables & The Five Common Mistakes2:20
Obtain PivotTables from Row Data0:58
You will be able to obtain as many as PivotTables for your row data
Analyzing Your Data3:57
You will be able to select PivotTable's representations among different columns from row data
Add & Format Slicers3:58
You will understand the need of adding slicers and how it affects your dynamic reports
Generate Attractive Charts2:52
You will be able to generate as many as charts for your data
Test Slicers1:10
Test slicers in dynamic dashboards to see how selections from June to July reshape sales data across categories like accessories and watches, revealing Peter's performance and guiding shop decisions.
Adding & Updating New Data1:22
Quiz 3

Why You Need to Have Personal Budget Dashboard?1:21
Identifying Inputs & Outputs1:57
Identify inputs such as month, transaction type, amount, owner, and reason to feed the dashboard, then calculate monthly budget, income, expenses, savings, and investments using pivot tables and formulas.
Formatting Row Data Sheet & Applying Data Validation4:27
Creating PivotTables, Slicers & Charts5:23
Preparing & Formatting The Dashboard6:50
Testing The Dashboard5:16
Test and refine the dashboard by configuring slicers, formatting, and a horizontal layout for 12 months, then validate interactivity with multiple selections using the control key to reveal transaction detail.

Why You Need to Have Human Resources Dashboard1:17
Identifying Inputs & Outputs1:34
Identify inputs and outputs for the dashboard, including employee name, code, birth date, nationality, gender, education, department, job, salary details, and benefits; show gender and department distributions and salary by player.
Formatting Row Data Sheet4:56
Format the raw data sheet by applying data validation, consistent currency and date formats, center alignment, bold titles, and column width adjustments to prepare the dashboard and pivot table.
Applying Required Calculations & Links3:10
Creating PivotTables, Slicers & Charts7:55
Arranging Charts on The Dashboard5:56
Copy, arrange, and format charts on the dashboard to create a neat, professional layout. Add slicers and data labels to build a dynamic, tested data dashboard.
Testing The Dashboard3:02
Explore a dynamic dashboard that tests interactively, showing employee data, salary trends, hiring years, and department, job layer, and country distributions with filterable visuals.

As a Business Owner, Why Do You Need A Dashboard1:47
Harness dynamic dashboards to monitor annual and monthly performance, update visuals with a single button, and track employees, branches, and countries to drive decisions on products and locations.
Identifying Inputs & Outputs1:18
Identify and define inputs and outputs to guide dynamic data dashboards, capturing monthly and annual performance, sales metrics, customer satisfaction, and branch, country, and product insights.
Formatting Row Data Sheet5:56
Format the raw data sheet for a dynamic Excel dashboard by applying currency and percentage formatting, borders, alignment, and data validation across U.S., U.K., and Oman.
Applying Required Calculations & Links2:03
Creating PivotTables, Slicers & Charts8:32
Arranging Charts on The Dashboard4:52
Final Dashboard Arrangements & Testing5:01

The Importance of Having An Interactive Dashboard in Your Agency1:29
Explore how interactive dashboards empower airline and holiday agencies to monitor destinations, passenger behavior, and key performance indicators with dynamic reporting on a single dashboard sheet for informed management decisions.
Identifying Inputs & Outputs1:18
Formatting Row Data Sheet4:53
Creating PivotTables, Slicers & Charts5:51
Create dynamic data dashboards by building pivot tables, adding slicers for month, aircraft type, and airline name, and visualizing data with charts and 3D maps.
Creating Maps & Analyzing Data7:27
Learn to use Excel 3D maps to visualize correlations between destinations and vacation types with heat maps and scatter plots. Build dashboards by capturing screenshots and refreshing monthly data.
Arranging Charts on The Dashboard2:33
Testing The Dashboard5:17

Do Business Owners Really Need to Have Profit & Loss Interactive Dashboard?1:21
Profit & Loss Structure2:57
You will be able to understand the structure of P/L and link available data to it
What Data I Can Inject & What Do I Expect to Have As An Output?1:42
Identify inputs such as revenue streams, cost of sale, op ex, capex, depreciation and amortization, interest, and taxes to drive a pnl dashboard and compare this year to last year.
Formatting Row Data Sheet4:05
Applying Required Calculations & Links13:04
Develop a dynamic Excel dashboard to analyze revenue, costs, OpEx, and net profit by linking cells to source data, applying percentage calculations, depreciation and amortization, tax, and year-over-year insights.
How "HLOOKUP" Formula Can Energize My Interactive Dashboard9:20
Implementing Conditional Formatting for Growth Function3:06
Apply conditional formatting to show growth or decline between 2019 and 2022 in the dashboard, using the simple growth formula value divided by the initial value minus one.
Creating Critical Charts3:58
Preparing & Formatting The Dashboard6:05
Testing The Dashboard4:08

Requirements

A computer or laptop with any version of Microsoft Excel starting from 2007 (Some features may not be available in earlier versions)
Basic understanding of Microsoft Excel formulas writing is recommended but not mandate (We will have fast recap on fundamentals)
You are familiar with Microsoft Excel spreadsheet environment

Description

Get ready to discover why this program is designed to become one of the top Microsoft Excel courses available today.

My name is Sadiq Al Lawati, a strategic planning expert with over 15 years of experience helping major companies make smarter, data-driven decisions. With a background in Project Management (PMI-certified), Contract Management, and Budget Management, I’ve worked with complex data every day—and mastered the Excel skills needed to turn that data into clear, powerful insights. Now, I’m here to share those skills with you.

Is This Course for You?

Do any of these sound familiar?

1- You feel overwhelmed when working with large datasets.

2- You struggle to analyze data and extract meaningful insights.

3- You find it difficult to build a clean, single-page dashboard.

4- You want your reports to look professional and visually appealing.

5- You think automation and dynamic dashboards are only for experts.

If yes—this course will change the way you use Excel.

---

What You Will Learn

1- We start with a quick and friendly introduction to Excel’s essential tools, features, and formatting—perfect for beginners or anyone needing a refreshers

2- Then we move step-by-step into the real power of Excel:

3- The most important formulas used around the world

4- Practical examples that make every formula easy to understand

5- How to use PivotTables and graphs to build dynamic, interactive reports

6- The secrets behind turning raw data into clear, compelling dashboards

Finally, you’ll apply everything through 5 real-world projects, learning exactly how to create dashboards that are not only functional—but impressive and professional.

---

Why This Course Matters

By the end of this course, you’ll be able to work smarter and faster, not harder.

Whether you're aiming to grow in your career, add valuable skills to your business, or even start a freelancing journey, Excel will become one of your strongest tools.

---

Enroll Now

Join the course, practice what you learn, and unlock the ability to transform everyday data into meaningful insights with confidence.

Let’s start your journey toward becoming an Excel pro.

Who this course is for:

Anyone wishing to expand His/Her skills in dealing effeciently with data
Anyone would like to take His/Her career to the next level
Excel basic users aiming to master their skills to link data, create interactive charts & dashboards
Students and graduates looking to extend their skills and be prepared for their first Job
Small to Medium business owners looking to take better decisions using dynamic report, charts & dashboards

The Complete Excel Practical Course: Learn, Build & Visualiz

What you'll learn

Explore related topics

Course content

Getting Started5 lectures • 41min

Formatting in Excel8 lectures • 9min

The Power of Formulas in Excel14 lectures • 30min

The power of PivotTables7 lectures • 17min

PROJECT. 1: Personal Budget Dashbaord6 lectures • 25min

PROJECT. 2: Human Resources Dashboard7 lectures • 28min

PROJECT. 3: Sales Group Dashboard7 lectures • 29min

PROJECT. 4: Holidays Agency Dashboard7 lectures • 29min

PROJECT. 5: Profit & Loss Dashboard10 lectures • 50min

Conclusion3 lectures • 2min

Requirements

Description

Who this course is for: