Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel – Beginner to Intermediate (Fast-Track)
Rating: 4.5 out of 5(159 ratings)
12,418 students

Microsoft Excel – Beginner to Intermediate (Fast-Track)

Master Excel in Just 4 Hours: Hands-On Tasks, Real-World Sheets, Formulas & Charts for Work, Home & Interviews
Created byZahed Zisan
Last updated 5/2025
English

What you'll learn

  • The Basics of Microsoft Excel
  • Formulas such as if, sum, countif, lookup....etc.
  • Duplicating data and formula
  • Salary sheet making
  • Water bill sheet
  • Mark sheet making
  • Error messages & how to fix them
  • Conditional formatting
  • Data Validation
  • Flash Fill
  • Nested if
  • Quick Access Toolbar
  • Copying worksheets
  • Custom Tab creation
  • Use of Find and Replace
  • Named ranges
  • different save as types
  • Number formats
  • Print area
  • Insert pictures and icons
  • Custom sorting
  • Tables
  • Text to column
  • Charts and composite chart making
  • Excel shortcut keys

Course content

7 sections46 lectures4h 32m total length
  • Introduction9:07

    In this video, we talk about a brief introduction to the course. How many lessons or lectures or videos there are and which video will show what is explained in great detail for the purpose of helping one to decide if one should take the course or not.


    In the video and in the downloadable PDF of the curriculum PDF the white text is the name of the lecture whereas, and the green text is the learning outcome of the lecture.

  • Microsoft Excel Tutorial [1] Introduction to Interface3:16

    In this lecture, we are going to see the interface of Microsoft Excel. we will learn about Tabs and ribbons.


    we will also learn about cells, column naming, row naming, and the intersection of columns and rows.

    and we will learn how the cells are named and how many cells a spreadsheet has, what is a spreadsheet and what is a workbook.


    The learning outcome of this is similar to or has the same tag as the following:

    MS Excel interface introduction

    Excel Interface (Part 1)

    Microsoft Office EXCEL | What is the User Interface / Parts of Excel (Introduction) in 2 minutes - 1

    The Beginner's Guide to Excel - Excel Basics Tutorial

    Microsoft Excel Tutorial - Beginners Level 1

    Excel User Interface Explained | Excel Introduction

    User Interface | Introduction to MS Excel | MS Excel |

    Microsoft Excel Tutorial in Just 15 Min 2020 in Telugu | Every Computer User Should Learn Ms Excel

    Excel 2021 Beginner Tutorial

    MS Excel Tutorial - Lesson 1 - Excel Interface

    MS Excel || Interface of Spreadsheet || Introduction to Excel Interface

    03 Introduction To Excel Interface

    [MS Excel Tutorial] | Excel Interface and Terminology 2019 | Eduonix

    An Introduction to MS Excel User Interface | Microsoft Excel Tutorial

    Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course

    Introduction of Excel User Interface or Excel Screen

    Introduction to the Excel Interface

    Creating Easy Data Entry Forms in Excel

    Learn Excel Tutorial || Component of MS Excel || Interface of Spreadsheet

    How to Create User Interface and Navigation in MS-Excel Spreadsheet

  • Microsoft Excel Tutorial [2] View, Range, Color fill, Border5:03

    topics covered are zoom, zoom to selection, zoom slider, 100% zoom, ranges, and ranges in Excel.





    Related content to this lesson:

    Zooming in and Out in Excel

    shortcut key of zoom in excel #exceltricks #shorts

    Zooming in and out the Excel Sheet

    For Zoom in or out excel sheet Excel Tips and Tricks #exceltips #exceltricks

    Serial Number in excel shortcut || Automatic serial Number in Excel

    ZOOM IN / ZOOM OUT In Excel? #shorts #exceltricks #excelshortcutkeys #msexcel #exceltips #zoom ?

    Zoom-In and Zoom-Out in Excel ? (Shortcuts)

    Most Useful Keyboard Shortcuts for Zooming in Excel - Excel Quickie 26

    A Complete Guide To Zoom Features in Microsoft Excel 2016 Tutorial

    Where is my Zoom slider? Microsoft Excel?

    Set all Excel sheets at a defined zoom level

    Zoom in or out | Excel useful shortcut key

    Excel Quick Tip: What are Named Ranges?

    How to Calculate Range in Excel

    Name cells and ranges in Excel

    Range, Variance, Standard Deviation in Excel

    How to Calculate Range in Excel | How to Find a Conditional Range in Excel

    How to Create Named Ranges in Excel

    How to Calculate the Range in Excel



    Content not related to this lesson:

    Unlocking Excel Macros with CHAT GPT: Boost Your Efficiency?!

    How to Create Named Range in Excel - Office 365

    How to use Vlookup for Giving range to numbers? | Easy Excel Tricks

    Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)



  • Microsoft Excel Tutorial [2,A] Alignment In Excel:7:54

    Topics covered in this lecture are alignment group in the ribbon, alignment settings, borders, border styles, border edits, cell borders,  and alignment shortcut.


    Contents related to this lecture:

    Excel Alignment Options Tutorial

    How to Center Align Columns in Excel : Using Excel & Spreadsheets

    How to Align Column line and Row line in Excel

    automatic adjust cell column width length | excel

    Autofit Columns and Rows in Excel

    How to fix Columns Width and Row Height with shortcut in Ms Excel | Excel tips and tricks | Hindi

    how to centre text across a selection in Microsoft Excel centre align heading and subheadings#excel

    Excel Text: Horizontal and vertical alignment

    Excel VBA - Alignment

    How to Top Align, Middle Align and Bottom Align Text Inside a Cell in MS Excel? | shorts

    Excel Short Cut Key Align Center Auto fit Column Width || YOU TUBE SHORT

    justify in excel | adjust multiple column text to one cell in excel | excel

    Excel Alignment Options Tutorial | Excel - Alignment,Text Alignment, Wrap Text, Merge & Center

    Text Alignment , Orientation, Word Wrap in Excel

    Excel Dynamic Arrays (How they will change EVERYTHING!)

    The Beginner's Guide to Excel - Excel Basics Tutorial

    Aligning and Formatting Text in Excel 2010

    Shortcut key to Wrap & Justify Text in MS Excel (All Versions)

    Align & Size Excel Dashboard Elements with Snap to Shape

    Text Alignment & Indent Options To Align & Indent Text in MS Excel | Alignment & Indent In Excel # 8


  • Microsoft Excel Tutorial [3] Worksheet and Input data:2:30

    we are going to learn about different data types in Excel and will also learn about worksheets and workbooks.


    topics relevant to this lecture:

    Difference between Workbook AND Worksheet #excel #tutorial #2

    What Are Excel Workbooks and Worksheets Spreadsheet, | Difference Between Spreadsheet And Worksheet?

    COMBINE Multiple Excel WORKBOOKS into One | ExcelJunction.com

    Creating Easy Data Entry Forms in Excel

    MS Excel - Protect Workbook

    How to Pull Data from Another Sheet based on Criteria in Excel & Google Sheets?

    Create a spreadsheet in Excel | Microsoft

    Microsoft Excel Data Types

    Using Linked Data Types in Excel

    Using the Excel Data Types Tools

    Types of Data Types in MS Excel,#5

    How to Get your Own Data Types ? in the Excel Menu (Intern vs manager vs Power BI)

    Video 2: How Excel handles different data types

    MS EXCEL BASIC TO ADVANCE | PART - 11 | DATA TYPES | NUMBER FORMAT| ALL DATA TYPES | DIGITAL BHANDAR

    The Complete Guide to Rich Data Types in Excel

    Master Data Analysis on Excel in Just 10 Minutes

    New Automated Data Entry Software in Excel | Data Entry Form in Excel | Data Entry in Excel

    Most Useful Excel Keyboard Shortcuts

    This Excel Chart will grab your attention (Infographic template included)

    New Data Types in Excel - Creating Your own - Most influential change for Organizations in Excel

    Excel Automatic Data Type: Dog Breeds and Diseases

    Fully Automated Data Entry User Form in Excel - Step By Step Tutorial

    AWESOME Excel trick to combine data from multiple sheets

    Make an Awesome Excel Dashboard in Just 15 Minutes

    numbers, hours, currency, formula, functions

  • Microsoft Excel Tutorial [4] Introduction to Formula SUM7:57

    in this lecture we will learn what formulas are and how are they used and how to activate formulas and what is the difference between text and formulas, we will also see a few formulas for example.


    Topics related to this lecture:

    what are formulas in excel

    Excel Formulas and Functions Tutorial

    Top 10 Most Important Excel Formulas - Made Easy!

    Excel: Intro to Formulas

    Excel Formulas and Functions | Full Course

    Basic Excel Formulas and Functions You NEED to KNOW!

    Top 10 Essential Excel Formulas for Analysts in 2023

    How to Make a Totaling Column Formula in Excel : Using Microsoft Excel

    How to use Formulas and Functions in Microsoft Excel

    Dollar Sign $ in Excel | Excel in Minutes

    I saw my boss do these 10 things in Excel!

    Basic Excel Formulas - Add, Subtract, Divide, Multiply

    How To Use Simple Formulae In Excel | Add, Subtract, Divide, Multiply | Skillslash

    How to multiply Numbers in Microsoft Excel?

    How to Find Sum of Numbers with Text in MS Excel? MS Excel Made Easier | One Minute Series

    How to Subtract In Excel।। Subtraction In Excel।। What is the formula of Subtraction Excel।। #Excel

    How to Multiply Cells in Excel | Multiplication function in Excel #Shorts

    How to Multiply and Sum in Single Cell using Formula in MS Excel 2013 | Sumproduct formula

    Microsoft Excel Tutorials | Do Addition, Subtraction, Multiply, Divisions, Autosum with Excel

    How to Multiply Numbers in Excel (Basic way)

    How to Multiply in Excel

    How to Subtract In Excel।। Subtraction In Excel।। What is the formula of Subtraction Excel।। #Excel

    How to Multiply Cells in Excel | Multiplication function in Excel #Shorts

    How to use Sumifs function for Multiple Condition

    Autosum in One Click | Excel Sum Function | MultiPle Sum By One Click | Excel TIPs & Tricks

    Formula of Addition, Subtraction, Multiplication, Division, Percentage, Average In Excel in Hindi

    Quickly Multiply All Values in an Excel Column / Row / Table by the Same Value NO FORMULA REQUIRED!

    10 Excel Formula used daily at WORK (Excel formula for job interview)

    Complete All Sum formula in excel like SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2 ETC

    MS Excel - Vlookup in Excel Video Tutorials

    Fully ? Automatic Invoice in Excel | Create Invoice Bill in Excel | MS Excel

    Excel Operators: How to Add, Subtract, Divide, Multiply, and use Brackets in Excel!

    How To Use Multiplication Formula in Excel | How to Multiply in Microsoft Excel | Multiply Cells

    Formula of Addition, Subtraction, Multiplication, Division, Percentage and Average in EXCEL

    How to Multiply Alpha-Numeric Values in Excel | Awesome Excel Trick

    TOP 10 Excel Formulas to Make You a PRO User



  • Quiz on Introduction

Requirements

  • Have a Computer
  • Microsoft Excel 2013 or higher

Description

Learn Microsoft Excel Fast — From Absolute Beginner to Confident User in Just 4 Hours

Looking for a beginner-friendly, time-efficient way to learn Excel?
This course is your shortcut to mastering the most essential Excel skills — with real-world examples, practice problems, and projects you can apply at home, in the office, or on your resume.


Whether you're starting from scratch, refreshing your skills, or catching up after “exaggerating” on your CV (we’ve all been there), this course is designed to get you Excel-ready fast.


What You'll Learn

  • Navigate the Excel interface, ribbons, views, and worksheets

  • Input, format, and manage data with confidence

  • Master essential formulas: SUM, AVERAGE, IF, COUNTIF, ROUND, LOOKUP, and more

  • Create charts, use Flash Fill, and apply Conditional Formatting

  • Work with ranges, merge cells, create tables, and customize tabs

  • Build useful sheets like salary slips, mark sheets, and water bill analyzers

  • Perform data validation, custom sorting, and printing setup

  • Understand common error messages and how to fix them


Practice-Based Learning

Every concept is taught with hands-on examples and practice problems to reinforce your understanding. You won’t just learn what each feature does — you’ll learn when and why to use it.


Real-World Mini Projects You'll Build

  • Salary Sheet with Subtotals and Group-wise Grand Totals

  • Area-Wise Water Bill Calculator with Charts

  • Student Mark Sheet with Lookup and Filtering

  • Conditional Formatting to Trace Customer Purchase History

  • Mental Math Practice Sheet (Great for Parents & Teachers)

  • Custom Tabs, Print Setup, and more


Who This Course is For

  • Complete beginners to Excel

  • Office users and students who want to build real, usable Excel sheets

  • Job seekers preparing for Excel assessments or interviews

  • Entrepreneurs, freelancers, and home users tracking expenses, tasks, or data

  • Anyone needing to “catch up fast” or start with a solid foundation


Bonus Features

  • Course navigation is easy: lessons are clearly labeled by task

  • Designed for self-paced learning and quick topic revisits

  • Short, digestible videos — no fluff, just what you need


By the end of this course, you'll feel confident in your ability to use Excel to solve everyday problems, build reports, and organize information like a pro — without feeling overwhelmed.


Ready to master Excel in just a few hours?
Enroll now and start building skills you’ll actually use.

Who this course is for:

  • Anyone who wants to Learn