Microsoft Excel | Basic, Intermediate & Advanced Modules

Formulae, Formatting, Charts, PivotTables and many more things.

What you'll learn

Learn to use Excel efficiently with keyboard shortcuts and without relying on a mouse.

Master formulas and functions to perform calculations, data analysis, and problem-solving.

Create and customize charts, tables, and dashboards to present data visually and professionally.

Apply Excel skills in real-world scenarios like budgeting, reporting, and data management.

Requirements

No prior Excel experience required — this course starts from the basics, Willingness to practice along with the lessons for the best learning experience.

Description

All-in-One Microsoft Excel Training: Become an Excel ExpertThis comprehensive course empowers you to become a proficient Excel user, boosting your efficiency and productivity. With lessons on advanced tools like Macros and VBA, you will become an expert in unlocking the full potential of Microsoft Excel.This Excel version agnostic training helps you master all versions of Microsoft Excel,Here’s what you’ll learn through this course:Efficiently navigate Excel using keyboard shortcuts, enhancing your speed in data entry, formatting, and worksheet management in day-to-day operations.Apply consistent formatting, including fonts, alignments, and conditional formatting, ensuring well-structured reports and presentations.Perform complex calculations and apply logical functions like IF, AND, OR, and nested IFs for decision-making in financial, operational, and analytical tasks.Clean large datasets by removing duplicates, handling missing values, and preparing data for marketing, sales, or operational dashboard analysis.Create various charts, graphs, and dashboards to present data insights to stakeholders in meetings and business reviews.Summarise and analyse large datasets using Pivot Tables and Pivot Charts, which are crucial for generating monthly sales reports, budget analysis, and performance tracking.Handling and manipulating date and text data for real-time scheduling, reporting, and data consolidation tasks.Automate repetitive tasks to streamline repetitive processes.Who is this course for:Freshers and Working Professionals who want to take their Excel skills from beginner to expert level.

Overview

Section 1: Excel Introduction

Lecture 1 Excel Introduction

Lecture 2 Font style & Allgiment

Lecture 3 Cell Formatting

Lecture 4 Auto calculation and Short cut

Lecture 5 Different type of Paste value

Lecture 6 Note & Comment

Lecture 7 Different type of Sample Templetes

Section 2: Functions, Reference, Naming ranges

Lecture 8 Basic Arithmetic functions

Lecture 9 Advance Arithmetic Functions

Lecture 10 Different type of Cell References

Lecture 11 Name Manger

Section 3: Subtotal, Aggeragate, Consolidation

Lecture 12 Usage of Subtotal

Lecture 13 Outline of Subtotal

Lecture 14 Consolidation

Section 4: Financial Functions, Goal Seek, EMI Table

Lecture 15 EMI Calculations

Lecture 16 Future Value Functions

Lecture 17 Present Values Goal Seek

Section 5: New function in Office 365

Lecture 18 Unique Function

Lecture 19 Rand & Sequence Functions

Lecture 20 Text Split Text Functions Text Join

Lecture 21 Filter Function

Section 6: Worksheet Operations Paste Special

Lecture 22 Worksheet Operations

Lecture 23 Moving Worksheets Protect Workbook

Lecture 24 Structure Level Protection

Lecture 25 Transpose past in paste special

Lecture 26 Past Link & Skip Blank

Lecture 27 Paste Special Operations

Lecture 28 Maths & Trignomentry Functions

Lecture 29 Maths & Trignomentry applying conditions using IFS function

Lecture 30 Subtotal Function & Aggregate

Lecture 31 Assignment 01

Section 7: Fill Series Fash Fill Remove Duplicates Text to column

Lecture 32 Fill Series Linear, Growth

Lecture 33 Fill Series Date

Lecture 34 Fill Series Custom List

Lecture 35 Fill Series Flash Fill

Lecture 36 Remove Duplicates

Lecture 37 Text Column Name Manager

Section 8: Date and time and Text functions

Lecture 38 Date Function

Lecture 39 Time Function

Lecture 40 Extraction of Date, Month, & Years

Lecture 41 Basic Text Function or Basic String Function

Lecture 42 Advance Text Function or Advance String Function

Lecture 43 Substitute, Text Join, Text After, Text Before

Lecture 44 Assignment 04

Section 9: Data Validation

Lecture 45 Data Validation

Lecture 46 Data Validation Practical

Lecture 47 Lists

Lecture 48 Date Data Validation

Section 10: Sort & Filter

Lecture 49 Sorting

Lecture 50 Filter

Lecture 51 Advance Filters

Lecture 52 Assignment 05

Section 11: Logical Functioning

Lecture 53 Logical Functioning

Lecture 54 Practical Part of Logical Functioning

Lecture 55 if Function

Lecture 56 If & and Function

Lecture 57 If & or Function

Lecture 58 nestedif Function

Lecture 59 nestedif With If & or Function

Lecture 60 nestedif With If / or & and Function

Lecture 61 Gross, Net, Annual Salary Calculations

Lecture 62 Assignment 02

Section 12: Conditional formatting

Lecture 63 What is Condition Formatting

Lecture 64 Condition Formatting highlight cell rules

Lecture 65 Top bottom rules

Lecture 66 Data bar's / Colour Scales / Iconic Set's

Lecture 67 Condition Formatting using formulas

Section 13: Lookup and Reference

Lecture 68 Lookup Reference Theory Part

Lecture 69 Lookup Function

Lecture 70 V Lookup Function

Lecture 71 H Lookup Function

Lecture 72 Reverse V Lookup

Lecture 73 V Lookup using If Function

Lecture 74 Define name & Index Function

Lecture 75 V Lookup using in Large dataset

Lecture 76 X Lookup Function

Lecture 77 Assignment 03

Section 14: Pivot Table

Lecture 78 What is Pivot Table

Lecture 79 Create a Pivot Table

Lecture 80 Design tab in pivot table

Lecture 81 Pivot Chat in Pivot table analyse tab

Lecture 82 Field Items / Sets Calculated Field

Lecture 83 Slicer & Time Line

Lecture 84 Get Pivot Data Function & custom

Lecture 85 Qucik Dashboard

Section 15: Power Pivot

Lecture 86 Power Pivot

Section 16: Power Query

Lecture 87 What is Power Query

Lecture 88 Data Types in Power Query

Lecture 89 Split Column by Delimiter

Lecture 90 Add Column by Using Conditional Column & Date

Lecture 91 Flash Fill in Power Query

Lecture 92 Edit Query, Transform in Power Query

Lecture 93 Import data from web

Lecture 94 import data from pdf & csv

Lecture 95 Apend & merge Queries

Lecture 96 Assignment 07

Section 17: Charts in Excel

Lecture 97 What is Charts

Lecture 98 Charts Practical

Lecture 99 Format Chart & Plot Area

Lecture 100 Data Series, Data Point & Data Label

Lecture 101 Gridlines / Title / Trend Line / Axis

Lecture 102 Formating Wall & Floor

Lecture 103 Pie & doughnut Chart

Lecture 104 Combo Chart

Lecture 105 Funnel Chart

Lecture 106 Waterfall Chart

Lecture 107 Gantt Chart

Lecture 108 Histogram Chart

Lecture 109 Assignment 06

Section 18: Macros in Excel

Lecture 110 What is usage of Macro

Lecture 111 How to enable macro & record macro

Lecture 112 What is VBA

Lecture 113 How to write a macro

Section 19: Looping Concept VBA Userdefined Function and VBA Userform

Lecture 114 For Loop

Lecture 115 Nested For Loop

Lecture 116 While Loop

Lecture 117 Until Loop

Lecture 118 Excel Function in VBA and Date & Time Function

Lecture 119 Function Work in VBA

Lecture 120 Excel Add In

Lecture 121 Excel Function using in VBA

Lecture 122 Create User Forms

Lecture 123 Assignment 08

Section 20: Mini Project

Lecture 124 Mini Project

Section 21: Major Project

Lecture 125 Major Project

Freshers and Working Professionals who want to take their Excel skills from beginner to expert level.