Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 32 Minute(s)
Language
English
Taught by
Tamal Majumder
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Master Excel with formulas, tables, charts, Pivot Tables, Macros & VBA— for data analysis, reporting, and automation.
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!
Course Content
- 19 section(s)
- 83 lecture(s)
- Section 1 Introduction
- Section 2 Explore Basics of Microsoft Excel
- Section 3 Cell
- Section 4 Working with Formulas and Functions
- Section 5 Data Management
- Section 6 Fill
- Section 7 Tables
- Section 8 Pivot Tables (Advanced Excel Features)
- Section 9 Excel Tips and Trick Short
- Section 10 Advanced Functions
- Section 11 Logical Functions
- Section 12 Macros
- Section 13 VBA- Visual Basic for Applications
- Section 14 Variables and Data Types - VBA
- Section 15 Control Structures in VBA
- Section 16 Loops in VBA
- Section 17 Graph and Charts in MS Excel
- Section 18 TOP 25 Interview QnA
- Section 19 Resources
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
Skills covered in this course
Reviews
-
PPlamen Ivanov Vasilev
Great course.
-
SSubhi Al-khafaji
Excellent Course and instructor .
-
RRavikiran Jiyalal Ambule
Good
-
GGeorge Dillon
This course was a good match for me. I found it to be very informative.
