5.00
(1 Rating)
MS Excel Basic to Professional Master Course
About Course
MS Excel Basic to Professional Master Course is designed to help you get started with Microsoft Excel by covering key features and essential functions, from basic operations to customization for improved efficiency. By the end of this course, you will have gained advanced knowledge of Pivot Tables, allowing you to summarize and analyze data more effectively. You will also be equipped to create dynamic reports and dashboards and apply advanced Excel formulas. The session will be wrapped up with a comprehensive quiz and final exam to test your mastery of the content.
What Will You Learn?
- Manage Worksheets and Workbooks
- Manage Data Cells and Ranges
- Manage Tables, Table Data and Advance Table
- Manage Format Data
- Manage Charts
- Pivot Table, Pivot Charts & Slicers
- Perform Operations by using Formulas and Functions
- Associate Between Function
- Using Macros & Automation
- Conditional Formatting
- Data Validation
- Data Processing
- Data Architecture
- Data Organizing
- Data Clean & Trim
- Data Visualization
- Data Entry
- Data Filtering
- Data Sorting
- Data Replacing
- Data Normalization
- Dashboard
- Shortcuts
- Tips & Tricks
Course Content
Orientation
Introduction,
• What is Excel and its historical background
• Why Excel is important in modern work
• Key benefits and practical applications
Excel Mastery- Session # 01
Session Overview: Introduction to Excel Essentials
Excel Interface & Basic Setup:
In this session, learners will become confident with Excel’s user interface, ribbon, and essential workspace components. They'll discover how to customize Excel for efficiency, format cells professionally, manage rows and columns smartly, apply consistent styling, handle document properties, and explore basic file and proofing tools. This foundational knowledge sets the tone for working faster and more accurately in future sessions.
Excel Mastery – Session # 02
Session Overview: Data Entry & Inserting Elements
In this session, learners will master efficient data entry techniques and learn how to select, autofill, and structure information accurately. They’ll also discover how to enhance spreadsheets with notes, images, icons, and SmartArt, while customizing Excel’s working behavior for comfort and speed. By the end of this session, users will be able to input, personalize, and manage data and visual content confidently within any Excel sheet.
Excel Mastery- Session # 03
Session Overview: Copy, Paste, Sheet, and View Tools
In this session, learners will become skilled at various copy-paste techniques, including advanced options like Paste Special and copying only visible cells. They’ll also learn how to manage worksheets, workbooks, and visual layouts with precision. By the end, users will be equipped to organize data across sheets, format numbers effectively, apply visual tools, and customize views for a productive and clear workspace.
Excel Mastery- Session # 04
Session Overview:
Excel Mastery- Session # 05
Session Overview: Mastering Cell References, Data Cleaning & Text Functions in Excel
This session dives deep into Excel's referencing logic, teaching how to control and manipulate data across cells using different types of references. You'll also explore data cleaning tools, text extraction techniques, and useful ranking functions. The session ends with a fun and creative use case to reinforce learning in an engaging way.
Excel Mastery- Session # 06
Session Overview: SUM Variations & Advanced Calculations
In this session, learners will dive deeper into Excel’s summing capabilities, learning not just standard SUM, but also advanced techniques involving name ranges, multi-sheet summing, and conditional summing across unique scenarios like blanks, odd/even values, and unit-based entries. They’ll convert text to numbers using multiple methods, apply array formulas for text-based SUM, and use powerful functions like PRODUCT and SUMPRODUCT for advanced calculations. The session also introduces text case functions and wraps up with practical tools for managing financial tasks like stock registers and petty cash.
Excel Mastery- Session # 07
Session Overview: Advanced Aggregation Functions & Date-wise Calculations
In this session, learners will master powerful aggregation techniques using conditional logic. They’ll explore how to use functions like SUMIF, COUNTIF, AVERAGEIF, and their multi-criteria counterparts for detailed data analysis. Learners will also work with named ranges for cleaner formulas, detect blanks, and extract max/min values conditionally. The session ends with practical methods for grouping and summarizing data by date parts like month, year, and quarter—essential for financial and operational reporting.
Excel Mastery- Session # 08
Session Overview: - Logical Checks, Error Handling, Data Validation & Hyperlinks
Excel Mastery- Session # 09
Sorting, Filtering & Dynamic Array Functions
In this session, learners will master data sorting and filtering techniques to organize information clearly and efficiently. They’ll explore powerful dynamic array functions introduced in modern Excel versions to reshape, extract, and transform data more flexibly. The session also dives into row-wise and column-wise calculations using BYROW and BYCOL, enabling users to build smarter, more dynamic spreadsheets for complex data analysis.
Excel Mastery- Session # 10
SUBTOTAL, Data Import, AI Functions & Conditional Formatting
Excel Mastery- Session # 11
Session Overview: Date & Time Functions in Excel
This session dives deep into Excel’s powerful date and time functions. Learners will gain the ability to manage calendar-based data, extract date components, calculate business timelines, and handle real-life scenarios like age calculation and project scheduling. From simple date functions to advanced workday logic, this session builds a solid foundation for time-sensitive data analysis.
Excel Mastery- Session # 12
Logical Operations and Conditional Decision Making
Excel Mastery- Session # 13
Summary Overview: VLOOKUP, HLOOKUP, XLOOKUP & Database Functions
In this session, learners will gain deep expertise in Excel's powerful lookup and database functions. From traditional methods like VLOOKUP and HLOOKUP to modern solutions like XLOOKUP, the session builds the ability to fetch, match, and analyze data across complex spreadsheets. Learners will also work with Excel’s database functions to summarize structured data with precision.
Excel Mastery- Session # 14
Summary Overview: INDEX, MATCH, and Lookup Techniques
This session equips learners with advanced data retrieval and lookup techniques in Excel. By mastering functions like INDEX, MATCH, XLOOKUP, and others, learners will be able to extract and manipulate data in complex ways. They will also explore ways to enhance data management with sorting, filtering, and visual representation using Sparklines.
Excel Mastery- Session # 15
Session Overview: Financial Functions, Randomization, and Data Clean-up
In this session, learners will explore various financial functions for calculating payments, interest, present/future value, and more. They will also learn randomization techniques for generating data and rank values. The session will further dive into data cleansing, using essential functions to clean and format data. Lastly, learners will discover powerful advanced Excel features like Scenario Manager, Goal Seek, and Macros to automate tasks and optimize modeling.
Excel Mastery- Session # 16
Pivot Tables, Charts, and Dashboards
Bonus Session
Session Overview: Mastering LAMBDA Functions
In this bonus session, learners will dive into the power of LAMBDA functions to create custom formulas in Excel. They will learn both basic and advanced LAMBDA applications, including building recursive functions and utilizing LAMBDA for dynamic operations. The session will also explore dynamic Excel features for performing operations like SUMIF, COUNTIF, AVERAGEIF, MAXIF, and MINIF by color, making data manipulation more efficient.
Final Quiz
You have to get 40% mark to pass
-
50 Quizzes
Final Exam
You have to get 40% mark to pass
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
