MS Excel Pro Bootcamp
The Data Mastery & Productivity Accelerator
For the DESI Community | 9 Power-Packed Video Modules
Stop guessing. Start automating. This isn't generic training—it's a structured, hands-on bootcamp to turn you into a data-driven professional. From foundational skills to AI-powered reporting, every module delivers immediate, practical value.
About This Course
A focused video curriculum covering 9 essential Excel domains.
We built this for one reason: Skills that pay bills.
No theory-dumping. Every lesson sharpens your speed, accuracy, and analytical edge—boosting your productivity, career prospects, and decision-making confidence.
Curriculum
Excel Basics
Excel Formulas
Excel Charting
Excel Functions
Pivot Table
Data Analysis
Excel Shortcuts
Excel Tips
Excel Using AI
Course lessons are locked until you enroll. Simply click "Join This Course" — you'll be prompted to create an account or log in to gain full access.
| Responsible | Er. Arjun |
|---|---|
| Last Update | 28/07/2026 |
| Completion Time | 13 hours 47 minutes |
| Members | 3 |
-
1. Excel Basics15Lessons · 1 hr 17 mins
-
Introduction | Beginners Guide
-
Basics
-
Tabs & Groups
-
Create & Close Files
-
Formatting
-
Editing Data
-
Flash Fill
-
Copying and Filling - Tricks
-
Advanced Fill
-
Text to Columns
-
Characteristics of Cell
-
Cell Reference
-
Speak Cells
-
Fill Series
-
Comments
-
-
2. Excel Formulas13Lessons · 1 hr 2 mins
-
Statistical Functions
-
VLookup Rules
-
Maths & Trigonometry
-
H-Lookup
-
Lookup Full Record
-
VLookup with Trim
-
Vlookup in Excel Video Tutorials
-
VLookup Approximate Match
-
Lookup Function
-
Index Function
-
Match Function
-
Protect Cells
-
Protect Sheet
-
-
3. Excel Charting3Lessons · 1 hr 54 mins
-
Introduction to Excel Charting
-
Creating Dynamic Charts in Excel (Using Drop-down List and Scroll Bar)
-
10 Advanced Excel Charts and Graphs (Creating from Scratch)
-
-
4. Excel Functions14Lessons · 1 hr 12 mins
-
Name Range with Formulas
-
Name Range
-
MS Excel - IF Function
-
Logical Test
-
AND Function
-
Nested IF
-
Not and If Error
-
Text Functions
-
Date Functions Part 1
-
Date Functions Part 2
-
Date Functions Part 3
-
Auditing Tools
-
Compare Two Sheets
-
View Files Side by Side
-
-
5. Pivot Table7Lessons · 54 mins
-
Pivot Chart
-
Pivot Table Timeline
-
Pivot Table Example 1 Video Tutorials
-
Pivot Table Example 2
-
Pivot Table Example 3
-
Pivot Table Slice
-
Pivot Table Grouping
-
-
6. Data Analysis8Lessons · 1 hr 42 mins
-
Data Sorting & Filtering in Excel (Basic + Advanced)
-
Data Validation in Excel | Drop-down lists
-
Creating Named Ranges in Excel | Dynamic Named Range in Excel
-
How to Use Solver in Excel
-
How to use Goal Seek Function in Microsoft Excel
-
How to Use One Variable Data Table in Excel
-
How to Use Two Variable Data Table in Excel
-
How to use Scenario Manager in Excel
-
-
7. Excel Shortcuts3Lessons · 1 hr 24 mins
-
101 Excel Shortcuts That Will Save Your HOURS! (Must-Know Tips) ⏳🔥
-
Shortcuts Ctrl + Shift + Single Key
-
Shortcuts Ctrl+Shift+A To Ctrl+Shift+Z
-
-
8. Excel Tips15Lessons · 1 hr 35 mins
-
Hyperlink to Sheet
-
Subtotal
-
Hyperlink to File
-
Hyperlink to Webpage
-
Hyperlink to Update
-
Protect Workbook
-
Basic Table
-
Advanced Table
-
MS Excel - Advanced Filters
-
Filtering Data
-
Data Sorting
-
Design a Column Chart Part:1
-
Design a Column Chart Part:2
-
Print Page Setup & Print Data Tips
-
Header & Footer
-
-
9. Excel Using AI14Lessons · 2 hrs 47 mins
-
Use VLOOKUP in Excel using ChatGPT - Excel with AI | Be10x
-
Salary Breakup💵 : Understand Every Component of Your Paycheck | Be10x
-
How to Group and Ungroup Worksheets in Excel: ChatGPT Excel Guide | Be10x
-
Quickly create Drop-down List in Excel with ChatGPT | Be10x
-
Use Excel for Forecasting Sales & Profit : Integrate Chatgpt with Excel | Be10x
-
Create Dynamic Charts Effortlessly : Chatgpt Excel | Be10x
-
Master Excel Pivot Tables with AI: Use ChatGPT for Data Analysis & Visualization | Be10x
-
Excel Mastery with ChatGPT: Pro Conditional Formatting & Formula Tips | Be10x
-
AI Aided Formula Editor in Excel : AI in Excel | Be10x
-
MS Excel's AI Revolution: Find and Understand Formulas Easily | Be10x
-
How to use Excel Conversion Function with ChatGPT : ChatGPT with Excel | Be10x
-
Get Live Stock Market Data in your Excel🤯: Real Time Stock Price Tracker | Be10x
-
Excel Geodata Analysis with AI: Mastering ChatGPT for Advanced Data Insights | Be10x
-
How to use Scenario Manager in Excel (2023): Quickly Switch Values in Excel | Be10x
-