Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel - Excel Beginner to Advance to Pro 2026

Name: Microsoft Excel - Excel Beginner to Advance to Pro 2026
Rating: 4.5 (3583 reviews)

The complete Microsoft Excel Course, All-in-one excel, Hands on project with real world Example - Pivot - Data analysis

Highest Rated

Created byMeet Doshi • 200000+ students

Last updated 3/2026

English

What you'll learn

Go from complete beginner to confident Excel user with this step-by-step course, featuring over 4 hours of engaging, easy-to-follow content.
Complete idea about Pivot Table & Pivot chart
Learn all about: Excel tables, charts, formatting, formulas, functions, macros, pivot tables and charts, and much more!
Data analysis, Data cleansing, Shortcuts used in excel
Analytical dashboard creation
Data filtration, Border, Sr No., Format Painter
Hands on experience to the excel with understanding of shortcuts
Email shooting by using VBA Directly from excel to specific users
Codes used in VBA
Function today() and Equation additing
Command Dollar {$} understanding
Data Validation - Drop Down List creation
IF, Nested if, if(And) command
Use of Conditional Formatting with Example
Remove Duplicates value in Excel
Automate Boarder - Where data available
Understanding of VLOOKUP
Index - Match equation
Data Filter - Analyse data
Bar Chart, Pie Chart Creation - Dashboard
VBA Form Creation
Password Protected Mail shooting directly from excel
Basic excel equations widely used in

Course content

9 sections • 44 lectures • 4h 34m total length

Introduction to the Excel course5:11
Introductory lesson. You will go through each and every steps in details, which are shown in the video.
Embark on Your Excel Adventure: A Thorough Introduction to Our Comprehensive Excel Course - Discover the Power of Spreadsheets, Formulas, and Data Analysis!
Enroll Now..
Enjoy Now...
Hands on experience to the excel with understanding of shortcuts9:20
Excel Hands-On Experience and Shortcut Insights: Join us for a comprehensive journey where you'll gain practical skills in Excel. Learn the art of efficient data management, formula creation, and time-saving shortcuts in this immersive course.

Hands on experience to the excel with understanding of,
F2 --- To edit particular cell
Ctrl + Z -- Undo
Ctrl + Y -- Redo
Shift + Space-bar -- TO select entire row
Ctrl + Space-bar -- To select entire column
Ctrl + "+" -- Addition row / column
Ctrl + "-" -- Delete row / Column
Ctrl + C -- Copy
Ctrl + V -- Paste
Ctrl + B -- Bold
Data filtration, Border, Sr No., Format Painter8:48
Efficient Data Management in Excel: Explore Data Filtration, Borders, Serial Numbers, and Format Painter - Elevate Your Spreadsheet Skills!
Data Filtration and Border with Format Painter, with short cuts of,
Altr + H + O + I -- Fit column width
Altr + H + O + A -- Fit to row width
Altr + H + B + A -- Border
Altr + H + B + N -- To remove border
Home Tab Overview8:18
Exploring Excel's Home Tab: A Deep Dive into Formatting, Alignment, and Clipboard Functions - Elevate Your Excel Skills with Essential Tools for Data Presentation and Manipulation
Home Tab overview and different commands available in excel.
Attachment format2:06
Download attachment, practise as much as you can, and get ready for next lecture.
ALL THE BEST.
Quiz 1

Function today() and Equation additing6:08
Understanding Excel Functions: Unraveling the Power of TODAY() and Equations.
Command Dollar {$} understanding4:00
Dollar Sign ($) Command Demystified: Gain Proficiency in Understanding and Using the Dollar Sign in Excel - Learn its Significance in Absolute and Relative References, Master Cell Fixing Techniques for Precise Formulas

Understand and proper practice of use of command $.
Data Validation - Drop Down List creation5:50
Excel Data Validation: Creating Dynamic Drop-Down Lists - Master the Art of Data Validation, Enhance Data Accuracy, and Streamline Your Spreadsheets with Customizable Dropdown Menus

Understand the use of data validation and drop down list creation.
IF, Nested if, if(And) command15:22
Learn IF, Nested If and if-and statement by example.

Excel Conditional Logic Unveiled: Explore IF Statements, Nested IFs, and IF-AND Functions - Enhance Your Decision-Making Abilities, Learn Advanced Conditional Formatting, and Master Complex Logic Structures in Excel

Video is long, but proper explanation is given in layman language. Please watch, and practice as much as you can.
Quiz 2

Highlight cell which contains - by Conditional Formatting7:04
Understand the better way by taking example of conditional formatting.

Excel Conditional Formatting Mastery: Highlight Cells Containing Specific Text or Characters (-) - Transform Your Data Analysis with Dynamic Formatting, Emphasize Relevant Information, and Improve Visualization Techniques

Practice by your self, for any query drop in Q&A.
Conditional Formatting - Manage Rule2:15
Understand the tab of conditional formatting - Manage rule.

Efficient Data Presentation with Conditional Formatting: Master the 'Manage Rules' Feature - Fine-Tune Your Excel Spreadsheets, Customize Visual Cues, and Organize Data Effectively for Enhanced Decision-Making
Can you automate the boarder? (Wherever data is available - Auto border)
if statement use for mail shooting - VBA lecture3:31
We are going to use this generated data while shooting email by VBA.
Remove Duplicates value in Excel3:21
Understand in easy way to remove duplicates in Excel.

Excel Data Cleansing: Removing Duplicate Values Made Simple - Streamline Your Data Sets, Enhance Accuracy, and Optimize Efficiency by Eliminating Redundant Entries in Excel.
Automate Boarder - Where data available2:49
Automate the border where ever data is available and see magic.

Automating Borders in Excel: Smart Techniques for Dynamic Border Creation - Learn to Apply Borders Where Data Exists, Enhance Spreadsheet Aesthetics, and Streamline Your Excel Workflow with Automated Border Formatting.

Understanding of VLOOKUP3:41
Understand VLookup.

Mastering VLOOKUP in Excel: Unraveling the Power of Vertical Lookup - Gain In-Depth Understanding of the Function, Learn to Retrieve Data Efficiently, and Enhance Your Data Analysis Capabilities
Index - Match equation6:18
Understand the use of Index - Match syntax, Practice as much as you can.

Excel Index-Match Equation Decoded: Advanced Data Retrieval Techniques - Harness the Combined Power of Index and Match Functions, Learn Dynamic Data Lookup, and Excel at Complex Data Analysis Scenarios.
if - or equation4:59
Based on Students request, here is one more example of Nested If.

Excel IF-OR Function Demystified: Mastering Logical Tests with IF and OR - Unlock the Potential of Combining Conditional Statements, Make Complex Decisions, and Streamline Your Data Analysis with Excel's IF-OR Equation.

Request you to practice as much as you can. If any Query ask in Q&A Section.
Data Filter - Analyse data5:11
Strong and power full tool to Analyze the data - Data filter

Efficient Data Analysis with Excel Filters: Explore Smart Data Filtering Techniques - Learn to Filter and Analyze Data Effectively, Discover Advanced Filter Options, and Enhance Your Decision-Making Skills for Smarter Data Insights
Briefing video - Download file2:48
What we have done till now, I am taking and revising within 3 min. Just check once. Download excel file. For any query drop question under Q&A.

Analytical Dashboard Layout5:31
Analytical Dashboard Layout creation in easy way.

Designing Analytical Dashboards: Crafting Intuitive and Insightful Layouts - Explore Best Practices in Dashboard Design, Learn to Organize Data Effectively, and Create Visually Engaging Analytical Dashboards for Comprehensive Data Analysis.
Counta, CountIf, Sum, Freeze Row - Calculate the data for Dashboard8:33
Calculate the data under dashboard.
One additional Assignment is given - Try by your self.

Excel Data Calculation Essentials: Utilize COUNTA, COUNTIF, SUM, and Freeze Row Techniques - Master the Art of Counting, Summing, and Freezing Rows for Dashboard Data Precision. Learn to Efficiently Calculate Data for Your Comprehensive Dashboard Creation.

Understand the use of Countif, CountA, Sum, Freezing pan.
Solution to the question - countif2:23
Here is the solution to calculate the values of Dashboard.
Bar Chart - Dashboard4:07
Understand the Bar chart for dashboard.

Enhancing Dashboard Visuals: Creating Impactful Bar Charts - Learn to Design and Implement Bar Charts Effectively in Your Dashboard. Elevate Data Representation, Improve Visualization, and Enhance Dashboard Impact with Engaging Bar Chart Graphics.
Pie Chart - Dashboard5:56
Understand the PIE CHART and its element in easy way.

Elevating Dashboard Insights: Crafting Compelling Pie Charts - Master the Art of Pie Chart Design for Data Visualization in Your Dashboard. Enhance Clarity, Highlight Key Data Points, and Transform Your Dashboard into a Visual Storytelling Tool.
Quick Revision - Download attachment for reference1:15
Quick briefing what we done till now, and downloadable resources.
Quiz 3

Enable Developer Tab and Saving under Macro enabled file1:48
Enable Developer tab under options menu and save excel sheet under macro enabled workbook.

Empowering Excel: Enabling Developer Tab and Saving as Macro-Enabled Files - Unlock Advanced Excel Features by Activating Developer Tools. Learn to Save Your Work with Macros, Enabling Interactivity and Customization in Your Excel Projects.
VBA Form Creation6:02
Create User Input Form in Easy Way.

Creating Interactive VBA Forms: Unlocking the Power of User-Interface Design - Dive into VBA Programming to Develop Custom Forms. Master User Interaction, Input Validation, and Enhance Your Excel Projects with Dynamic Form Creation.
MACRO Coding to the Submit Button10:17
Add Code to the Submit button.
Find out the code under the Resources.
For any Query drop under Q&A.

Automating Actions with Macro Coding: Linking Macros to Submit Button - Explore VBA Programming to Create Dynamic and Responsive Forms. Learn to Code Macros Triggered by Submit Buttons, Enhancing User Experience and Efficiency in Your Applications.
Coding to Close, Clear & Goto Main Page3:55
Fundamentals of codding for Close, Clear & Goto Main Page Button.
Find out the code under the Resources.
For any Query drop under Q&A.

Efficient Navigation with VBA: Coding Close, Clear, and Main Page Functions - Master VBA Programming to Automate Actions. Learn to Code Macros for Closing Forms, Clearing Fields, and Navigating to Main Pages, Streamlining User Interaction in Your Applications.
Code to Open up outlook and Send Mail12:11
Understanding of VBA coding to send email from Outlook directly from Excel.
Code to open Outlook.
Find out the code under the Resources.
For any Query drop under Q&A.

Automating Email Communication: VBA Code to Open Outlook and Send Mail - Dive into Advanced VBA Programming to Initiate Outlook, Compose, and Send Emails. Master Automation, Enhance Efficiency, and Streamline Your Email Workflow with Custom VBA Solutions.
Create Email Body by Code16:43
Understanding of VBA coding to send email from Outlook directly from Excel.
Code to Create Email Body.
Find out the code under the Resources.
For any Query drop under Q&A.

Dynamic Email Content Creation with VBA: Generate Email Body Using Code - Explore Advanced VBA Techniques to Dynamically Generate Email Content. Learn to Customize Email Body, Embed Data, and Personalize Communication, Enhancing Your Email Automation Efforts
Easy Explanation of VBA MACRO code5:06
Understand the VBA by example.
Explanation of Email body and codding.
Shorting out issues and take trial9:00
Short out issue under the coding, and lets try.
Password Protected Mail shooting4:08
Convert direct mail shooting to Password protected mail shooting.
Download Final Excel Sheet0:42
Download final excel which we have created in the lecture series from the resources.

Conclusion5:57
At the last,
What we have learnt under this full lecture series, we have covered under this video.
Hope you get all the concepts with fundamentals.
Still you have query, you can ask me any time.
So finally you have completed Learn Excel from Beginner to Advance with Example Cousre.
And with the help of fundamentals, Now you are ready to Rock.
All the best - you excel expert... ! :)

Introduction to Section - 21:38
This lecture is start to the new section - 2. Will discuss more in detail from up-coming tutorials.
All About Mid & Search7:14
This tutorial will give you understand, how you can fetch out First Name from whole Name.
All About Mid, Search, Trim & Len - Part 27:34
This tutorial will give you understand, how you can fetch out Last Name from whole Name with the help of equation directly.

Pivot Table - Basics - How to create a Pivot Table5:26
Mastering Pivot Tables: Unraveling the Power of Data Analysis - Gain a Comprehensive Understanding of Pivot Tables in Excel. Learn to Summarize, Analyze, and Visualize Data Effectively for In-Depth Insights and Enhanced Decision-Making.
Data refining with Pivot table2:24
Refining Data with Pivot Tables: Streamlining Analysis for Actionable Insights - Learn Advanced Techniques to Clean, Organize, and Extract Key Information Using Pivot Tables. Elevate Your Data Refinement Skills and Boost Decision-Making Efficiency
Convert data in to Table6:52
Transforming Data into Excel Tables: Simplifying Organization and Analysis - Discover the Power of Converting Data into Dynamic Excel Tables. Streamline Data Management, Enhance Visual Presentation, and Facilitate Efficient Analysis for Improved Decision-Making
Everything you should know about Pivot Table23:40
Pivot Tables Unveiled: The Comprehensive Guide to Mastering Data Analysis - Dive into Everything You Need to Know About Pivot Tables. From Basics to Advanced Techniques, Learn How to Slice, Dice, and Visualize Data for Informed Decision-Making
Pivot Chart9:16
Unlocking Insights with Pivot Charts: Visualizing Data for Actionable Analysis - Learn to Create Dynamic Pivot Charts in Excel. Explore Visual Data Representation Techniques to Transform Your Pivot Table Insights into Engaging Charts for Effective Decision-Making

Requirements

No prior knowledge is required, You will learn everything you need to know from basic
Any Fresher to the Excel
You will learn everything at one place, whatever you need
You come with system, rest everything we will take care

Description

In this course you are going to learn, daily excel equations which are widely used in daily life with short cut. No prior knowledge is required. We have taken example to teach easily so one can learn from basic with example. Example here taken to send email to the specific person directly from excel by using one button and navigating to the outlook in easy way.

You are going to learn

1. Basic excel equations widely used in

2. Hands on experience to the excel with understanding of basic and widely use shortcuts

3. Analytical dashboard creation - Pie chart, Bar chart

4. Data filtration, Border, Sr No., Format Painter

5. Email shooting by using VBA from excel to specific users from outlook using single button

6. Codes used in VBA

7. Data Validation - Drop Down List creation

8. IF, Nested if, if(And) command as a equation

9. Use of Conditional Formatting with Example

10. Remove Duplicates value in Excel

11. Linking from excel to mail (You can shoot mail by clicking button from excel directly)

12. Bar Chart, Pie Chart Creation - Dashboard

13. Understanding of VLOOKUP

14. Index - Match equation for arranging and fetching right data

15. Data Filter - Analyze data

16. Password Protected Mail shooting directly from excel

17. And many more new things covered

Who this course is for:

Beginners to the excel
College students, working professional, businessman
To become expert in data analytics by using excel
Who wants to learn excel from basic, and want to become expert
Want to understand the real life corporate situation and solve from the basic
Who

Microsoft Excel - Excel Beginner to Advance to Pro 2026

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 34min

Basic Excel Function and Equations (if)4 lectures • 31min

More about Excel - Conditional formatting, remove duplicates, Automate border5 lectures • 19min

Data filter using Vlookup, Index-Match, Filter data.5 lectures • 23min

Create Analytical DashBoard6 lectures • 28min

User Input From Creation And Macro Coding10 lectures • 1hr 10min

Conclusion1 lecture • 6min

Section - 23 lectures • 16min

Pivot Table5 lectures • 48min

Requirements

Description

Who this course is for: