Microsoft Excel Bundle
The Microsoft Excel Bundle is a complete, career-focused learning package designed to take you from basic to advanced and automation-level Excel skills in one structured program. This bundle is specially created for students, job seekers, professionals, and business users who want to master Excel for real-world productivity and career growth. In this course, you will not only learn formulas but also gain practical, job-ready skills in data analysis, reporting, dashboard creation, and automation, helping you work faster, smarter, and more efficiently in any office or business environment. 🎯 What You Will Learn: Microsoft Excel Basics to Advanced Features Advanced Formulas …
Curriculum
- 17 Sections
- 115 Lessons
- Lifetime
- Course Overview12
- 1.1Course Overview2 Minutes
- 1.2Content Overview8 Minutes
- 1.3Course Documents & Exercise Files2 Minutes
- 1.4Excel Screen4 Minutes
- 1.5Managing Sheets-Hide Unhide,Insert, Delete, Color4 Minutes
- 1.6Sheet Move Or Copy3 Minutes
- 1.7Customizing Quick Access Toolbar3 Minutes
- 1.8Managing Columns And Rows6 Minutes
- 1.9Change Workbook Views3 Minutes
- 1.10Custom View – Create, Edit And Manage6 Minutes
- 1.11Save The File In Different Format (Pdf, Csv, Text Etc)3 Minutes
- 1.12Hyperlink – Create, Edit And Manage5 Minutes
- Different Cell Formatting Techniques6
- Page Setup and Print Professionally8
- 4.1Set Print Scaling3 Minutes
- 4.2Fixing Number Of Pages To Be Printed Of Whole Sheet3 Minutes
- 4.3Row(S) To Be Printed At Top On Every Page2 Minutes
- 4.4Setting Margin-Top, Bottom, Left, Right3 Minutes
- 4.5Printing in center-horizontally or vertically in a page3 Minutes
- 4.6Customizing Header And Footer – Create, Edit And Manage5 Minutes
- 4.7Printing A Specific Area Of The Sheet – Create, Edit And Manage3 Minutes
- 4.8Page Break – Create, Edit And Manage5 Minutes
- Insert data in cells and ranges3
- Viewing Data on Excel Sheet2
- Create and manage tables6
- Cell Reference (Relative Vs Absolute)3
- Most Common Functions for Text Handling12
- 9.1Left Function4 Minutes
- 9.2Right Function2 Minutes
- 9.3Mid Function3 Minutes
- 9.4Upper Function2 Minutes
- 9.5Lower Function1 Minute
- 9.6Proper Function2 Minutes
- 9.7Trim Function5 Minutes
- 9.8Trim+Proper In The Same Formula3 Minutes
- 9.9Cell Joining Using Concatenate Function4 Minutes
- 9.10Cell Joining Using (Ampersand)7 Minutes
- 9.11Value Function2 Minutes
- 9.12Text Function7 Minutes
- Most Common Functions for Number Handling4
- Logical Functions5
- Data Sorting6
- Data Filtering8
- 13.1Data Filtering With Single Criteria3 Minutes
- 13.2Data Filtering With Multiple Criteria3 Minutes
- 13.3Filter By Color3 Minutes
- 13.4Customized Filtering With Text Values5 Minutes
- 13.5Customized Filtering With Number Values4 Minutes
- 13.6Making Unique List And Pasting In A Different Location2 Minutes
- 13.7Summation On Only Visible Filtered Data3 Minutes
- 13.8Clear All Filtered Data Using One Click4 Minutes
- Conditional Formatting12
- 14.1Setting A Single Conditional Formatting5 Minutes
- 14.2Setting Multi-Level Conditional Formatting In The Same Range7 Minutes
- 14.3Using Data Bar Type Conditional Formatting3 Minutes
- 14.4Highlighting The Duplicate Values4 Minutes
- 14.5Conditional Formatting Using Formula5 Minutes
- 14.6Highlighting Top Or Bottom Values4 Minutes
- 14.7Conditional Formatting Using Color Scale3 Minutes
- 14.8Conditional Formatting Using Icon Set2 Minutes
- 14.9Customizing The Icon Set5 Minutes
- 14.10Add, Edit Or Remove Conditional Formatting2 Minutes
- 14.11Clearing The Conditional Formatting2 Minutes
- 14.12Finding Out The Conditional Formatting Applied Cells5 Minutes
- Lookup and References Functions9
- 15.1Vlookup Function When The Range Is Whole Column8 Minutes
- 15.2Vlookup Function For The Specific Range7 Minutes
- 15.3Copy-Paste Techniques For The Vlookup Formula6 Minutes
- 15.4Difference Between True And False In Vlookup Function3 Minutes
- 15.5Carefulness For Vlookup Function6 Minutes
- 15.6Hlookup Function4 Minutes
- 15.7Match Function3 Minutes
- 15.8Index Function3 Minutes
- 15.9Combination Of Index And Match Function In A Single Formula6 Minutes
- PivotTable10
- 16.1Overview Of Pivottable6 Minutes
- 16.2Creating Pivottable Using One Row And One Column-18 Minutes
- 16.3Creating Pivottable Report With Multiple Groups5 Minutes
- 16.4Changing Layout Of Pivottable4 Minutes
- 16.5Drill Down Your Pivottable Value4 Minutes
- 16.6Filtering The Pivottable Data4 Minutes
- 16.7Formatting Pivottable Data-Finished3 Minutes
- 16.8Creating Pivotchart6 Minutes
- 16.9Use Slicers In Pivottable5 Minutes
- 16.10Conclusion Of Pivottable2 Minutes
- Secure Your Sheet and File with Password Protected5
- Data Validation4
Overview
The Microsoft Excel Bundle is a complete, career-focused learning package designed to take you from basic to advanced and automation-level Excel skills in one structured program. This bundle is specially created for students, job seekers, professionals, and business users who want to master Excel for real-world productivity and career growth.
In this course, you will not only learn formulas but also gain practical, job-ready skills in data analysis, reporting, dashboard creation, and automation, helping you work faster, smarter, and more efficiently in any office or business environment.
🎯 What You Will Learn:
- Microsoft Excel Basics to Advanced Features
- Advanced Formulas & Functions (VLOOKUP, INDEX-MATCH, IF, and more)
- Pivot Tables & Pivot Charts for Business Reporting
- Data Visualization using Charts & Graphs
- Advanced Dashboard Reporting Techniques
- Power Query for Data Cleaning & Transformation
- Interactive Dashboard Design (with modern techniques)
- VBA & Macros for Automation
- Real-world Data Analysis & Reporting Projects
💡 Key Features of This Bundle:
- Step-by-step video lessons in simple language
- Practical, project-based learning approach
- Downloadable practice files
- Certificate upon completion
- Lifetime access (as per platform policy)
👨💼 Who This Course Is For:
- Students and job seekers
- Corporate employees and office professionals
- Aspiring data analysts and reporting specialists
- Freelancers and business owners
- Anyone who wants to become confident in Excel for professional use





