Ms Excel Essentials - From Basic To Advance

Learn Excel from Basics to Advanced: Formulas, Functions, Pivot Tables, Charts, Data Analysis & AI Tools

What you'll learn

Master Excel basics including interface, navigation, and data entry.

Format data effectively using text, number, and conditional formatting.

Use formulas, functions, and logical operators for powerful data analysis.

Create Pivot Tables and charts to summarize and visualize data easily.

Boost productivity using AI tools, automation tips, and smart Excel tricks.

Apply advanced Excel features like XLOOKUP, INDEX-MATCH, and data validation.

Requirements

No prior Excel knowledge is required — this course is designed for complete beginners.

A computer or laptop with Microsoft Excel installed (Excel 2016 or later recommended).

Basic computer skills such as using a mouse, keyboard, and navigating files.

Willingness to learn and practice with hands-on exercises and assignments.

Description

Master Microsoft Excel from the ground up with this comprehensive course designed for beginners, intermediate users, and professionals seeking to enhance their data skills. Whether you're new to Excel or aiming to boost your proficiency, this course covers everything from basic spreadsheet operations to advanced data analysis techniques.You’ll start with an introduction to Excel’s interface, navigation shortcuts, and essential features. Learn data entry, editing, and formatting (text, numbers, dates, and cells) with ease. Discover tools like conditional formatting, sorting, filtering, and data validation to organize your data effectively.Formulas and functions form a core part of the course, including logical, statistical, lookup, date/time, and text operations. Explore powerful Excel features such as Pivot Tables, charts, slicers, and advanced filtering. Advanced functions like INDEX, MATCH, SWITCH, and XLOOKUP are covered in detail.This course follows a scenario-based learning approach—before each new topic, you’ll see real-world scenarios that explain the practical application of the concepts. This helps you understand not just the how, but the why behind every feature.You’ll also learn to leverage AI tools and automation to boost productivity. Ideal for students, job seekers, professionals, and aspiring data analysts who want to gain confidence and real-world skills in Excel.

Overview

Section 1: Getting Start with The Course

Lecture 1 Course Introduction

Lecture 2 Course Structure

Lecture 3 Course Resources

Lecture 4 It's a Milstone

Lecture 5 Practice Files

Section 2: Introduction to MS Excel

Lecture 6 Section Goals & Agenda

Lecture 7 What is MS Excel

Lecture 8 MS Excel Version History

Lecture 9 MS Excel Features

Lecture 10 Launching MS Excel and It's Interface

Section 3: Getting Started with MS Excel

Lecture 11 Section Goals & Agenda

Lecture 12 Basic Elements of MS Excel

Lecture 13 Shortcut Keys in Excel

Lecture 14 Navigation Shortcut Keys in Excel

Lecture 15 Data Entry & Editing in Excel

Lecture 16 More On Ribbon Options in Excel

Section 4: Data Formatting in Excel

Lecture 17 Section Goals & Agenda

Lecture 18 Text Formatting in Excel

Lecture 19 Number Formatting in Excel

Lecture 20 Date & Time Formatting

Lecture 21 Cell Formatting in MS Excel

Lecture 22 Format Painter in MS Excel

Lecture 23 Creating Cell Style MS Excel

Lecture 24 Conditional Formatting in MS Excel

Section 5: Key Features of MS Excel

Lecture 25 Section Goals & Agenda

Lecture 26 Data Sorting in MS Excel

Lecture 27 Data Filtering in MS Excel

Lecture 28 Data Validation in MS Excel

Lecture 29 Text to Column in MS Excel

Lecture 30 Remove Duplicate in MS Excel

Lecture 31 Auto Fill In MS Excel

Lecture 32 Freeze Panes in MS Excel

Lecture 33 Grouping/Ungrouping & Subtotals in MS Excel

Section 6: Formula & Functions in MS Excel

Lecture 34 Section Goals & Agenda

Lecture 35 Getting Started with Formulas

Lecture 36 Basic Formulas & Order of Operations

Lecture 37 Relative & Absolute Cell Referencing in Excel

Lecture 38 Getting Started with Formula Functions in MS Excel

Lecture 39 Statistical Functions in MS Excel

Lecture 40 Logical Functions in MS Excel

Lecture 41 Look-Up Functions in MS Excel

Lecture 42 Date & Time Functions in MS Excel

Lecture 43 Text Functions in MS Excel

Lecture 44 Common Errors in MS Excel and How to Fix Them

Section 7: Pivot Table in Excel

Lecture 45 Section Goals & Agenda

Lecture 46 Introduction to Pivot Tables

Lecture 47 Converting Data to Excel Tables

Lecture 48 Inserting Pivot Tables & Exploring it’s Interface

Lecture 49 Creating & Modifying Pivot Tables

Lecture 50 Calculations in Pivot Tables

Lecture 51 Filtering and Sorting in Pivot Tables

Lecture 52 Groupings in Pivot Tables

Lecture 53 Adding Charts & Slicers for Pivot Chart

Lecture 54 Formatting of Pivot Tables

Lecture 55 Other Important Options in Pivot Table

Section 8: Data Visualization & Analysis in Excel

Lecture 56 Section Goals & Agenda

Lecture 57 Introduction to Data Visualization & Analysis

Lecture 58 Creating Charts in MS Excel

Lecture 59 Working With Chart Elements in Excel

Lecture 60 Working with Data for Chart in Excel

Lecture 61 Bar & Column Charts in MS Excel

Lecture 62 Line & Area Charts in MS Excel

Lecture 63 Pie & Tree Maps Charts in MS Excel

Lecture 64 Scatter Plot in MS Excel

Lecture 65 Histogram in MS Excel

Lecture 66 Formatting of Charts in MS Excel

Section 9: Portfolio Project

Lecture 67 Section Goals & Agenda

Section 10: Advance & Updated Topics in Excel

Lecture 68 Section Goals & Agenda

Section 11: AI For Excel

Lecture 69 Section Goals & Agenda

Section 12: Excel Tips & Tricks

Lecture 70 Section Goals & Agenda

Section 13: Course Wrap-up

Lecture 71 Course Wrap-up

Beginners who want to build a strong foundation in Microsoft Excel from scratch.,Aspiring Data Analysts and Data Scientists who want to strengthen their Excel skills for data manipulation and analysis.,Working professionals, business analysts, and managers who need to analyze and present data effectively.,Students, job seekers, and fresh graduates looking to improve their Excel skills for academic or professional use.