Complete Excel Guide: Beginner to VBA Expert, Be Job Ready!

Name: Complete Excel Guide: Beginner to VBA Expert, Be Job Ready!
Rating: 4.6 (18 reviews)

Master Excel with formulas, tables, charts, Pivot Tables, Macros & VBA— for data analysis, reporting, and automation.

Created byTamal Majumder

Last updated 12/2025

English

What you'll learn

Master Excel basics including data entry, formatting, and navigation
Use formulas and functions like SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, LOOKUP, INDEX and more
Apply cell references: relative, absolute, and mixed
Format cells, rows, and columns for clarity
Create and manage tables, charts, and Pivot Tables for dynamic reports
Perform data sorting, filtering, and validation to clean and organize data
Automate repetitive tasks using Macros and VBA scripting
Understand and apply logical and lookup functions (IF, INDEX, MATCH, etc.)
Build interactive dashboards using slicers, graphs, and advanced features
Boost speed with Excel shortcuts and pro tips
Prepare confidently for job interviews with real-world Excel scenarios and Q&A

Course content

19 sections • 84 lectures • 8h 32m total length

Welcome to Our Exhaustive COURSE4:08
Why MS - Excel?3:03
Introduction to Microsoft Excel8:07
Microsoft Excel : An Overview4:04

Opening and Closing Excel2:07
Open Excel from the start menu and choose a blank workbook or templates to begin. When closing, save with a name and location or choose don't save or cancel.
Templates2:19
Working with Worksheets4:58
Entering and Editing Data11:35
Learn to enter and edit data in an Excel worksheet, use autofill for series or repeated values, and master copy, paste, cut, navigation shortcuts, and cell addressing.
Formatting Cells- Part 114:32
Explore cell formatting in Excel, applying font styles (bold, italic, underline), font color and background color, borders, and alignment, then use wrap text and merge options to control layout.
Formatting Cells- Part 210:17

Sorting Data (Basic)4:28
Sorting Data (Advanced)4:02
Sort data by color in Excel to enable advanced grouping of students by total marks, using cell color and font color options in the data tab.
Multicolumn Sorting2:48
Filtering Data (Basic)3:52
master basic data filtering in excel by using filters, shortcut ctrl+shift+l, and applying text, number, and date filters to view specific records, then clear filters and sort
Filtering Data (Basic)- II2:04
Learn how to apply and manage filters in Excel using keyboard shortcuts and the data tab, including activating and clearing filters and copying filtered data to other tables or worksheets.
Filtering Data (Advanced) - I4:19
Data Validation9:09
Apply data validation to restrict cell input to whole numbers, decimals, dates, times, or text length, with optional input messages, error alerts, and dropdown lists from a source.

Pivot Table- Introduction2:15
Learn how pivot tables summarize data and stay flexible, update data as needed, and create them in Excel via insert, pivot chart, and an existing worksheet.
Why Pivot table is called as 'Flexible'?5:17
Pivot Table- 1 : Interesting Hacks!6:17
Discover practical pivot table hacks by creating a pivot table from source data, viewing detailed records with a double click, and showing counts versus totals while managing totals and layout.
Pivot Table - 22:19
Pivot Table - 31:54
Pivot Table - 42:57
Pivot Table - 54:12

Introduction to VLOOKUP, Formula and Functionality: Exact Match10:43
Master vlookup for vertical value lookup and exact matches, and learn how the leftmost column rule limits lookups with examples on price, availability, and brand data.
VLOOKUP- Data Validation2:39
VLOOKUP Approximate Match9:54
VLOOKUP- Trim Function 13:59
VLOOKUP- Trim Function 21:35
Introduction to HLOOKUP, Formula and Functionality: Exact Match3:14
LOOKUP: Introduction, Formula, Functionality9:18
LOOKUP- New Formula2:49
Explore the first lookup formula in Excel, using the lookup value, lookup vector, and result vector to retrieve full column data such as SKU, brand, and price.
INDEX Function3:54
Explore how the index function retrieves a cell value from an array or reference using row and column numbers in Excel. Learn to select data by specifying row and column.

Requirements

A computer or laptop with Microsoft Excel installed (any recent version will work)
Basic familiarity with using a computer (mouse, keyboard, opening files, etc.)
Willingness to learn and practice through hands-on examples
Stable Internet Connection
No Prior Experience Required

Description

Complete Excel Guide: Beginner to VBA Expert, Be Job Ready! Master Excel with formulas, tables, charts, Pivot Tables, Macros & VBA— for data analysis, reporting, and automation.

Unlock the full power of Microsoft Excel with this all-in-one course designed to take you from beginner to advanced level. Whether you're just starting or want to sharpen your Excel skills for the workplace, this course covers everything you need to become job-ready and confident in using Excel.

You’ll start with the basics—navigating the interface, formatting cells, entering data—and quickly move on to mastering formulas, functions, tables, charts, and Pivot Tables. Learn how to sort and filter data, validate entries, and create beautiful dashboards and reports.

But that’s not all. We’ll take you beyond the basics with hands-on lessons in VLOOKUP, HLOOKUP, INDEX, MATCH, logical functions (IF, AND, OR), and advanced Excel features like Macros and VBA (Visual Basic for Applications). Automate repetitive tasks, write your first VBA scripts, and understand how to build powerful Excel tools.

Perfect for students, professionals, business analysts, or anyone looking to upgrade their Excel skills. By the end of this course, you’ll have the confidence to tackle real-world Excel tasks and impress in job interviews.

Enroll now and become an Excel expert—from beginner to VBA pro!

Who this course is for:

Beginners
Students looking to boost their academic and project work with essential Excel skills
Job seekers preparing for roles that require Excel knowledge in data entry, analysis, or reporting
Professionals who want to improve productivity and confidence using Excel at work
Anyone who wants to learn how to use Excel formulas, functions, and lookup tools without getting overwhelmed

Complete Excel Guide: Beginner to VBA Expert, Be Job Ready!

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 19min

Explore Basics of Microsoft Excel6 lectures • 46min

Cell7 lectures • 29min

Working with Formulas and Functions4 lectures • 55min

Data Management7 lectures • 31min

Fill2 lectures • 13min

Tables3 lectures • 16min

Pivot Tables (Advanced Excel Features)7 lectures • 25min

Excel Tips and Trick Short3 lectures • 16min

Advanced Functions9 lectures • 48min

Requirements

Description

Who this course is for: