MS Excel Advance LIVE Course (Basic to Advance)

About Trainer Profile & Experience - Ms. Nikki Sharma  an MBA Professional with over 5 years of rich industry experience in Data Analytics She has successfully trained 1500+ students both online and offline. With a strong grip on Ms Excel, Ms word, Ms Powerpoint, HTML,CSS,Javascript, Tally Prime etc. She delivers practical, industry-relvant training. Her clear and effective teaching style ensures a top-quality learning experience.

Here is the complete syllabus for Ms Excel Advance Live Course

 Module 1: Excel Introduction & Basics

* What is Microsoft Excel?
* History of Excel
* Why Excel is Used Worldwide
* Excel Versions & Features
* Workbook & Worksheet Concepts
* Rows, Columns & Cells
* Excel Interface Overview
* File Management

Module 2: Complete Excel Tabs & Tools

Home Tab

* Clipboard
* Font Formatting
* Alignment
* Number Formatting
* Styles
* Editing Tools

 Insert Tab

* Tables
* Pictures
* Shapes
* Icons
* SmartArt
* Charts
* Pivot Charts

 Page Layout Tab

 Formulas Tab

 Data Tab

 Review Tab

 View Tab

Developer Tab

Every Tool Explained with Practical Examples.

 Module 3: Data Handling

* Data Entry Techniques
* Flash Fill
* Auto Fill
* Sorting
* Filtering
* Advanced Filter
* Remove Duplicates
* Text to Columns
* Data Validation
* Data Cleaning
* Import & Export Data

 

Module 4: Excel Formulas & Functions

 Basic Formulas

* SUM
* AVERAGE
* MIN
* MAX
* COUNT
* COUNTA
* ROUND
* ABS

 Text Functions

* LEFT
* RIGHT
* MID
* LEN
* TRIM
* UPPER
* LOWER
* PROPER
* CONCAT
* TEXTJOIN

 Date & Time Functions

* TODAY
* NOW
* DATEDIF
* EDATE
* YEAR
* MONTH
* DAY

 Module 5: Logical Functions

* IF
* IFS
* AND
* OR
* NOT
* IFERROR
* Nested IF Formulas

Real-Life Examples Included

---

Module 6: Lookup Functions

* VLOOKUP
* HLOOKUP
* XLOOKUP
* INDEX
* MATCH
* INDEX + MATCH Combination
* Dynamic Lookup Techniques

Module 7: Advanced Excel Functions

* FILTER
* SORT
* UNIQUE
* SEQUENCE
* LET Function
* LAMBDA Function
* Dynamic Arrays

 Module 8: Conditional Formatting

* Highlight Duplicate Values
* Color Scales
* Data Bars
* Formula-Based Formatting
* Dashboard Formatting Techniques

 Module 9: Pivot Tables & Reports

* Creating Pivot Tables
* Pivot Charts
* Slicers
* Timelines
* Interactive Reports
* MIS Reporting

 Module 10: What-If Analysis

* Goal Seek
* Scenario Manager
* Data Tables
* Forecasting Tools

 Module 11: Charts & Dashboards

* Column Charts
* Line Charts
* Pie Charts
* Combo Charts
* Interactive Dashboards
* KPI Reports

Dashboard Projects

✔️ Revenue Dashboard

✔️ Sales Dashboard

✔️ Expense Dashboard

✔️ Profit Analysis Dashboard

✔️ Business Performance Dashboard

 Module 12: Protection & Sharing

* Sheet Protection
* Workbook Protection
* Sharing Files
* Collaboration
* Security Settings

Module 13: Real-Time Projects

* Sales Analysis Project
* Revenue Comparison Project
* Employee Data Project
* MIS Reporting Project
* Dashboard Project
* Business Analysis Project

Freelancing & Career Support

✅ How to Get Excel Jobs

✅ Freelancing Introduction

✅ Fiverr Profile Setup Guidance

✅ Upwork Profile Guidance

✅ Data Cleaning Projects

✅ Excel Project Practice

✅ Client Handling Basics

 Course Benefits

🎓 Certificate of Completion

📄 PDF Notes

⌨️ Excel Shortcut Keys PDF

📝 Practice Sheets

📊 Real-Time Datasets

🎥 Lifetime Recorded Video Access

💼 Job Assistance

🚀 Freelancing Guidance

📱 Doubt Support

 

 Duration Plan

35 Days Structured Training

Day 1 to Day 5 – Excel Basics & Interface

Day 6 to Day 10 – Formatting & Data Management

Day 11 to Day 15 – Basic & Text Functions

Day 16 to Day 20 – Logical Functions & Lookup Functions

Day 21 to Day 25 – Advanced Functions & Dynamic Arrays

Day 26 to Day 30 – Pivot Tables & Charts

Day 31 to Day 34 – Dashboards & Real-Time Projects

Day 35 – Final Assessment & Certificate

 Enroll Now & Become an Excel Expert

From Beginner to Advanced Level

Learn • Practice • Get Certified • Get Job Ready • Start Freelancing

Accounts Advisor