Microsoft Excel and Power Query
Contact us

Why Learn Excel ?

Did you know 97% of the world’s working professional uses Excel? 

 College Student to Fresh Graduate to Working Professional and even founders and CEO, mastering Excel can boost your career, improve productivity, and make data handling effortless. 

 With this course, you will understand basic to advanced Excel and also Excel automation tool, Power Query in depth. 

Look at the Numbers

Global Users



Built-In Functions

    

Chart Variation


Key Job Opportunities


Powerful Add-Ins & Automation

Microsoft Excel Fundamental
  • Build a strong foundation in Excel, from basics to advanced tools
  • Getting Started with Excel: UI, Custom Tabs, & more...
  • Learn data input, formatting, sheets, clipboard tricks & more...
  • Master text, date, logical, statistical & other powerful excel functions.
  • Combine and analyze data for a complete view
  • Visualize insights with impactful charts and graphs
  • Learn advanced features like conditional formatting, goal seek & more..

Adv. Excel with Power Query
  • Clean and transform messy data in just a few clicks
  • Merge and join data from multiple sources
  • Remove duplicates, fix errors & format data into structured tables
  • Apply powerful functions to transform data
  • Create dynamic queries that updates with one click
  • Use conditional formatting, custom functions, etc. for smart automation
  • Apply learnt in excel & connect it smoothly with Power BI

*Get Access to BONUS Course Content on Copilot with Microsoft Office*

What you’ll get in this package

01

Course Material 1 attachment(s)

1 attachment(s)

  • cloud_download
    Course Material

02

Introduction to Microsoft Excel 6 attachment(s) • 48 min 31 sec

6 attachment(s) • 48 min 31 sec

  • ondemand_video
    User Interface of MS Excel
  • ondemand_video
    Custom Tab in MS Excel
  • ondemand_video
    Save MS Excel File with Passwords
  • ondemand_video
    Custom List in MS Excel
  • ondemand_video
    Data Types in MS Excel
  • assignment
    Session 1 MCQs

03

Basics of MS Excel 6 attachment(s) • 48 min 25 sec

6 attachment(s) • 48 min 25 sec

  • ondemand_video
    Enter & Edit Data in MS Excel
  • ondemand_video
    Cut, Copy, Paste & Clipboard
  • ondemand_video
    Font Formatting in MS Excel
  • ondemand_video
    Alignment in MS Excel
  • ondemand_video
    Formatting of Numbers in MS Excel
  • assignment
    Session 2 MCQs

04

Functions in MS Excel 8 attachment(s) • 2 hour 22 min 10 sec

8 attachment(s) • 2 hour 22 min 10 sec

  • ondemand_video
    Text Functions in MS Excel
  • ondemand_video
    Date Functions in MS Excel
  • ondemand_video
    Logical Functions in MS Excel
  • ondemand_video
    Master Shortcut in MS Excel
  • ondemand_video
    Name Range in MS Excel
  • ondemand_video
    Statistical Functions in MS Excel
  • ondemand_video
    Cell Referencing in MS Excel
  • assignment
    Session 3 MCQs

05

Data Validation & LOOKUP Functions 5 attachment(s) • 56 min 28 sec

5 attachment(s) • 56 min 28 sec

  • ondemand_video
    Data Validation in MS Excel
  • ondemand_video
    VLOOKUP Function in MS Excel
  • ondemand_video
    MATCH & INDEX Function in MS Excel
  • ondemand_video
    LOOKUP Function in MS Excel
  • assignment
    Session 4 MCQs

06

Conditional Formatting in MS Excel 9 attachment(s) • 1 hour 39 min 23 sec

9 attachment(s) • 1 hour 39 min 23 sec

  • ondemand_video
    Conditional Formatting in MS Excel
  • ondemand_video
    Advanced Conditional Formatting in MS Excel
  • ondemand_video
    Passwords in MS Excel
  • ondemand_video
    Text Hyperlink in MS Excel
  • ondemand_video
    Hyperlink on Pictures, Shapes, & More in MS Excel
  • ondemand_video
    SmartArt in MS Excel
  • ondemand_video
    Screenshots in MS Excel
  • ondemand_video
    Hyperlink on Object in MS Excel
  • assignment
    Session 5 MCQs

07

Data Management Techniques 8 attachment(s) • 1 hour 13 min 4 sec

8 attachment(s) • 1 hour 13 min 4 sec

  • ondemand_video
    Sorting in MS Excel
  • ondemand_video
    Filters in MS Excel
  • ondemand_video
    Advanced Filters in MS Excel
  • ondemand_video
    Tables in MS Excel
  • ondemand_video
    Slicers & Timeline in MS Excel
  • ondemand_video
    3D Sum in MS Excel
  • ondemand_video
    Consolidate Data in MS Excel
  • assignment
    Session 6 MCQs

08

Data Analysis in MS Excel 7 attachment(s) • 48 min 8 sec

7 attachment(s) • 48 min 8 sec

  • ondemand_video
    Data Analysis in MS Excel
  • ondemand_video
    Creating Pivot Table in MS Excel
  • ondemand_video
    Aggregation in Pivot Table
  • ondemand_video
    Formatting of Pivot Table in MS Excel
  • ondemand_video
    Create Multiple Sheets Using Pivot Table in MS Excel
  • ondemand_video
    Slicers and Timeline in Pivot Table
  • assignment
    Session 7 MCQs

09

Excel Views & Layouts 5 attachment(s) • 23 min 19 sec

5 attachment(s) • 23 min 19 sec

  • ondemand_video
    Freeze and Split in MS Excel
  • ondemand_video
    Hide and Unhide in MS Excel
  • ondemand_video
    Custom Views
  • ondemand_video
    Arrange All in MS Excel
  • assignment
    Session 8 MCQs

10

BONUS 2 attachment(s)

2 attachment(s)

  • picture_as_pdf
    Excel Shortcuts (33 pages)
  • picture_as_pdf
    LookUp Functions Power Guide (28 pages)

11

BONUS: Copilot for MS Office 4 attachment(s) • 43 min 59 sec

4 attachment(s) • 43 min 59 sec

  • ondemand_video
    Copilot in Word
  • ondemand_video
    Copilot in Excel
  • ondemand_video
    Copilot in PowerPoint
  • assignment
    Quiz

01

Power Query Material 1 attachment(s)

1 attachment(s)

  • cloud_download
    Material

02

Introduction to Power Query 1 attachment(s) • 8 min 53 sec

1 attachment(s) • 8 min 53 sec

  • ondemand_video
    Introduction to Power Query

03

Getting Started With Basics Of Functions 16 attachment(s) • 1 hour 23 min 13 sec

16 attachment(s) • 1 hour 23 min 13 sec

  • ondemand_video
    Introduction to Basic Functions in Power Query
  • ondemand_video
    Loading Data in Power Query
  • ondemand_video
    Learning Basic Text Functions
  • ondemand_video
    Trim Text Functions
  • ondemand_video
    Split Text in Multiple Columns
  • ondemand_video
    Split Text with Delimiter
  • ondemand_video
    Adding Prefix & Suffix
  • ondemand_video
    Date Functions
  • ondemand_video
    Date Functions Weekdays
  • ondemand_video
    Calculate Age
  • ondemand_video
    Date Functions Start & End of Particular Date
  • ondemand_video
    Number Function
  • assignment
    Text Functions
  • assignment
    Date Functions
  • assignment
    Number Functions
  • cloud_download
    Assignment 2

04

Conditional Column & Column From Examples 12 attachment(s) • 43 min 28 sec

12 attachment(s) • 43 min 28 sec

  • ondemand_video
    Introduction to Conditional Column & Column From Example
  • ondemand_video
    Conditional Column on Numbers
  • ondemand_video
    Conditional Column on Text
  • ondemand_video
    Conditional Column on Dates
  • ondemand_video
    Comparing Columns with Conditional Column
  • ondemand_video
    Flash Fill with Column From Examples
  • ondemand_video
    Column From Examples - Split Text
  • ondemand_video
    Column From Examples - Merge Text
  • ondemand_video
    Column From Examples - Date
  • ondemand_video
    Column From Examples Extract Text
  • assignment
    Conditional Column & Column From Examples
  • cloud_download
    Assignment 3

05

Appending & Combing Files 8 attachment(s) • 43 min 14 sec

8 attachment(s) • 43 min 14 sec

  • ondemand_video
    Introduction to Appending or Combining Files
  • ondemand_video
    Combine Tables in One Table
  • ondemand_video
    Combine Multiple Table with Functions
  • ondemand_video
    Consolidate Multiple CSV Files
  • ondemand_video
    Combine Multiple Excel Files From Folder
  • ondemand_video
    Combine Multiple Data Sources
  • assignment
    Append Queries
  • cloud_download
    Assignment 4

06

Powerful Cleaning Features In Power Query 12 attachment(s) • 46 min 17 sec

12 attachment(s) • 46 min 17 sec

  • ondemand_video
    Introduction to Cleaning Data in Power Query
  • ondemand_video
    Fill Down Unmerged Cells
  • ondemand_video
    Promote & Demote Header
  • ondemand_video
    Removing Blank Rows
  • ondemand_video
    Data Types in Power Query
  • ondemand_video
    Dealing with Error Values
  • ondemand_video
    Transposing Data Set
  • ondemand_video
    Replacing Null Values
  • ondemand_video
    Group By in Power Query
  • assignment
    Data Cleaning Part1
  • assignment
    Data Cleaning Part2
  • cloud_download
    Assignment 5

07

Replacing VLOOKUP With Merge Queries 14 attachment(s) • 1 hour 5 min 12 sec

14 attachment(s) • 1 hour 5 min 12 sec

  • ondemand_video
    Introduction to Replacing VLOOKUP
  • ondemand_video
    What is VLOOKUP in Excel
  • ondemand_video
    Merge Queries
  • ondemand_video
    Merge Two Tables
  • ondemand_video
    Merge Two Different Table From Two Different Excel Files
  • ondemand_video
    Merge Two Different Data Sources
  • ondemand_video
    Merge Queries with Multiple Matching Columns
  • ondemand_video
    Find Out Common Records From Two Tables
  • ondemand_video
    Merge Queries with No Common Columns
  • ondemand_video
    Fuzzy Match in Power Query
  • ondemand_video
    Challenge - Find Out Only Working Days
  • ondemand_video
    Solutions - Finding Working Days
  • assignment
    Replacing VLOOKUP
  • cloud_download
    Assignment 6

08

Working With Rows & Columns In Power Query 9 attachment(s) • 21 min 16 sec

9 attachment(s) • 21 min 16 sec

  • ondemand_video
    Introduction to Working With Rows & Columns
  • ondemand_video
    Remove Blank Records
  • ondemand_video
    Remove Duplicates Values
  • ondemand_video
    Remove Top or Bottom Rows
  • ondemand_video
    Keep Top or Bottom Rows
  • ondemand_video
    Remove Columns
  • ondemand_video
    Rename, Delete, Duplicate & Move Columns
  • assignment
    Working with Rows & Columns
  • cloud_download
    Assignment 7

09

Working With Filters & Parameters 10 attachment(s) • 28 min 21 sec

10 attachment(s) • 28 min 21 sec

  • ondemand_video
    Introduction to Working With Filters & Parameters
  • ondemand_video
    Filtering Textual Data
  • ondemand_video
    Filtering Date Data
  • ondemand_video
    Filtering Numerical Data
  • ondemand_video
    Sorting Data
  • ondemand_video
    Creating a Parameter
  • ondemand_video
    Connect Parameter With Dataset
  • ondemand_video
    Case Study - Filter Data Using Excel Cell Value
  • assignment
    Working with Filters & Parameters
  • cloud_download
    Assignment 8

10

Custom Function Feature To Clean & Combine Files 5 attachment(s) • 25 min 13 sec

5 attachment(s) • 25 min 13 sec

  • ondemand_video
    Introduction to Custom Function to Clean & Combine Files
  • ondemand_video
    Clean & Combine Multiple CSV Files
  • ondemand_video
    Clean & Combine Multiple Excel Files
  • assignment
    Custom Function Features
  • cloud_download
    Assignment 9

11

Getting Data From Different Sources 6 attachment(s) • 14 min 42 sec

6 attachment(s) • 14 min 42 sec

  • ondemand_video
    Get Data From Google Sheets
  • ondemand_video
    Get Data From XML Files
  • ondemand_video
    Get Data From MS Access
  • ondemand_video
    Get Data From JSON
  • ondemand_video
    Get Data From Website
  • assignment
    Get Data From PDF, WEB & CSV

12

Object in Power Query 5 attachment(s) • 33 min 49 sec

5 attachment(s) • 33 min 49 sec

  • ondemand_video
    Introduction of Objects in Power Query
  • ondemand_video
    List in Power Query
  • ondemand_video
    Records in Power Query
  • ondemand_video
    Case Study - Creating Dynamic Calendars in PQ
  • ondemand_video
    Case Study - Extract Relevant Information

13

Case Studies 14 attachment(s) • 1 hour 30 min 4 sec

14 attachment(s) • 1 hour 30 min 4 sec

  • ondemand_video
    Introduction to Case Study in Power Query
  • ondemand_video
    Clean Bank Statement Available In PDF
  • ondemand_video
    Create Fiscal Year Calendar in Power Query
  • ondemand_video
    Matching Records in Two Tables
  • ondemand_video
    Pick Up The Latest File From The Folder
  • ondemand_video
    Technoedge Case Study
  • ondemand_video
    Cleaning Bank Financial Data
  • ondemand_video
    Changing Stacked Address Table
  • ondemand_video
    Split Data In Rows & Columns
  • ondemand_video
    Clean Data & Get Discounts
  • ondemand_video
    Cleaning Payroll Data
  • ondemand_video
    Get File Names From a folder
  • ondemand_video
    Data Cleaning-Unpivot Columns Ex-1
  • ondemand_video
    Data Cleaning-Unpivot Columns Ex-2

14

Excel Power Query to Power BI Power Query 2 attachment(s) • 11 min 56 sec

2 attachment(s) • 11 min 56 sec

  • ondemand_video
    Excel Power Query To Power BI Power Query
  • cloud_download
    Power Query Project

15

Capstone Project 6 attachment(s)

6 attachment(s)

  • cloud_download
    Project Template
  • cloud_download
    Project 1
  • cloud_download
    Project 2
  • cloud_download
    Project 3
  • cloud_download
    Project 4
  • cloud_download
    Project 5

5 Reasons Why You Need This Course

Learn from Pavan Lalwani: one of the best educators in the industry.

Super Easy Explanations: no technical jargon just real learning.

Hands-On Learning: Exercise file and Real-World Projects

Self-paced & Flexible: Learn anytime, anywhere.

Learn from Basic to Advance with Excel and Power Query

Get Dual Certification Upon

Successfull Course Completion

ABOUT

    Pavan Lalwani

  • Microsoft-Certified Trainer
  • 15+ Years of Industry Experience
  • Founder of Pavan Lalwani Academy
  • Founder of TechnoEdge Learning Services
  • 40 Crores+ Views Across Social Media
  • 11000+ Training Videos Across Platforms

Mr. Pavan Lalwani is known for making complex concepts easy & practical, ensuring you learn Power BI effortlessly.

Pavan’s expertise goes beyond Power BI—he’s skilled in Tableau, Excel, Alteryx, AI, and Automation tools like ChatGPT and Microsoft Copilot. His ability to break down complex topics into simple, digestible lessons has made him one of India’s most renowned Power BI trainers. He is a trainer who knows trends, understands what industry demands and teaches only why you need to excel in this competitive market of evolving technology and industry.

Pavan Lalwani's mission is to help professionals take control of their skills and present them in a way that inspires, impresses, and builds confidence in their abilities, products, and services.

Who Should Enroll?

COLLEGE STUDENTS

FRESHERS & JOB SEEKERS

WORKING PROFESSIONALS

BUSINESS & FINANCE ENTHUSIASTS

Anyone who wants to boost productivity with Excel

Words of Our Learners

Contact us for Enquiries