Curriculum
- 6 Sections
- 72 Lessons
- 4 Weeks
Expand all sectionsCollapse all sections
- Excel FundamentalsBuild a strong foundation in Excel by learning essential formulas, data handling, formatting, and basic reporting. This course helps you work efficiently with spreadsheets and prepares you for advanced data analysis and business tasks.12
- 1.1Introduction to Excel
- 1.2Basic Data Entry & Formatting
- 1.3Basic Formulas & Functions
- 1.4Cell Referencing
- 1.5Logical Functions
- 1.6Data Handling & Sorting
- 1.7Charts & Visualization
- 1.8Tables & Data Management
- 1.9Data Validation
- 1.10Conditional Formatting
- 1.11Intermediate Functions
- 1.12Pivot Tables (Very Important)
- Intermediate ExcelEnhance your Excel skills with advanced formulas, data analysis tools, conditional formatting, and pivot tables. This course helps you manage larger datasets, create meaningful reports, and improve efficiency in real-world business tasks.12
- 2.1Advanced Logical Functions
- 2.2Lookup Functions (Deep Dive)
- 2.3Text Functions
- 2.4Date & Time Functions
- 2.5Conditional Formatting (Advanced)
- 2.6Data Validation (Advanced)
- 2.7Pivot Tables (Intermediate)
- 2.8Charts (Advanced)
- 2.9Named Ranges
- 2.10Error Handling
- 2.11Introduction to Dashboards
- 2.12Basic Automation (Intro)
- Advanced ExcelMaster Advanced Excel with powerful tools like complex formulas, PivotTables, dashboards, data visualization, and automation techniques. This course enables you to analyze large datasets, generate insightful reports, and streamline business processes efficiently.12
- 3.1Advanced Lookup Techniques
- 3.2Dynamic Arrays (Modern Excel)
- 3.3Advanced Pivot Tables
- 3.4Power Query (Data Transformation)
- 3.5Power Pivot & Data Model
- 3.6Dashboard Design (Professional Level)
- 3.7Advanced Conditional Formatting
- 3.8VBA & Macros (Automation)
- 3.9Financial Modeling in Excel
- 3.10Scenario Analysis
- 3.11Data Security & Protection
- 3.12Excel Integration & Advanced Tips
- Data Analysis & VisualizationLearn to turn raw data into meaningful insights using powerful analysis and visualization techniques. This course covers data cleaning, advanced analytics, interactive dashboards, and visual storytelling to support smarter business decisions.12
- 4.1Introduction to Data Analysis
- 4.2Data Cleaning Techniques
- 4.3Sorting, Filtering & Subtotal
- 4.4Data Analysis Functions
- 4.5Pivot Tables for Analysis
- 4.6Data Visualization Basics
- 4.7Advanced Charts
- 4.8Conditional Formatting for Analysis
- 4.9Dashboards (Core Lesson)
- 4.10Dynamic Dashboards
- 4.11Data Analysis ToolPak
- 4.12Real Business Use Cases
- Business ApplicationsLearn how to apply Excel and data tools to real-world business scenarios like finance, sales, inventory, and operations. This course helps you create practical reports, streamline workflows, and support better decision-making across business functions.12
- 5.1Excel in Business – Overview
- 5.2Financial Management
- 5.3MIS Reporting
- 5.4Sales & Revenue Analysis
- 5.5Inventory Management
- 5.6HR & Payroll Management
- 5.7Project Management
- 5.8Business Dashboards
- 5.9Forecasting & Planning
- 5.10Automation in Business
- 5.11Data Validation for Business Control
- 5.12Real Business Case Study
- Automation & ProductivityBoost efficiency by automating repetitive tasks and optimizing workflows using advanced Excel features and tools. This course helps you save time, reduce errors, and increase productivity through smart automation techniques.12
- 6.1Introduction to Automation
- 6.2Efficient Use of Formulas
- 6.3Named Ranges & Tables
- 6.4Data Validation Automation
- 6.5Conditional Formatting Automation
- 6.6Pivot Tables for Automation
- 6.7Power Query (Powerful Automation Tool)
- 6.8Macros (Recording Automation)
- 6.9VBA Basics
- 6.10Dashboard Automation
- 6.11Template Creation
- 6.12Workflow Automation (Business Level)
Basic Data Entry & Formatting
Next