This repository documents my Microsoft Excel learning journey, covering data preparation, cleaning, analysis, visualization, formulas, PivotTables, Power Query, Power Pivot, Data Modeling, DAX, and interactive dashboard development. The concepts have been learned through structured courses and reinforced through practical business-oriented data analysis situations and end-to-end Excel dashboard projects.
The repository includes learning from both Microsoft Excel – Beginner to Advanced | 2024–2026 + AI and Complete Excel Tutorial for Data Analysis, along with the Excel projects created by applying the concepts covered throughout these courses.
Microsoft Excel – Beginner to Advanced in animation 2024, 2025 & 2026 + AI is a comprehensive Excel course focused on building practical skills for data preparation, analysis, visualization, dashboard development, and automation through real-world business situations.
Course: Microsoft Excel – Beginner to Advanced in animation 2024, 2025 & 2026 + AI
Instructors: Kadhiravan Jayachandiran & KultureHire Edtech
Duration: 19+ hours
Sections: 31
Lectures: 231
- Excel Fundamentals & Worksheet Management
- Data Entry, Data Validation & Flash Fill
- Data Cleaning, Filtering & Sorting
- PivotTables, Slicers & Timelines
- Conditional Formatting
- Excel Formulas & Functions
- Logical, Text & Date/Time Functions
- VLOOKUP, INDEX-MATCH & XLOOKUP
- Advanced & Nested Formulas
- Statistical & Rounding Functions
- Dynamic Array Functions
- Charts & Data Visualization
- Excel Dashboard Development
- AI-Assisted Excel & ChatGPT
- Power Pivot & Data Modeling
- Macros & VBA Automation
The course includes practical exercises and business situations covering:
- Data cleaning and preparation
- Formula-based analysis
- Conditional calculations
- Lookup and reference operations
- PivotTable-based analysis
- Data visualization
- Dashboard development
- AI-assisted Excel solutions
- Basic automation
The concepts learned through the course were applied to three Excel dashboard projects:
Focus: Sales performance, transaction-value analysis, product performance, regional analysis, and sales trends.
Focus: Order performance, revenue, products, discounts, order types, agents, and daily trends.
Focus: Customer interactions, contact types, agent performance, customer satisfaction, and service trends.
Excel: Formulas, Functions, PivotTables, PivotCharts, Slicers, Conditional Formatting, Charts, Dashboards
Analysis: Data Cleaning, Data Analysis, Business Questions, Data Visualization, Data Storytelling
Advanced: XLOOKUP, Dynamic Arrays, Power Pivot, Data Modeling, VBA
AI: ChatGPT-assisted formulas, business-rule implementation, validation, and automation
Developed practical experience using Microsoft Excel for data preparation, analysis, visualization, interactive dashboard development, AI-assisted workflows, and basic automation, with concepts reinforced through real-world business situations and applied dashboard projects.
Udemy Course Link : https://www.udemy.com/course/learn-advanced-excel-in-animation/
Project Repository:
Excel Dashboard Suite – Customer Service, Finance & Orders: https://github.com/Cyberoctane29/Excel-Dashboard-Suite-Customer-Service-Finance-and-Orders
Complete Excel Tutorial for Data Analysis in 4 Hours is a practical Excel course focused on developing data analysis skills through data preparation, formulas, PivotTables, visualization, dashboard development, and Excel's Data Model. The course emphasizes solving real-world data analysis situations rather than simply learning individual Excel features.
Course: Complete Excel Tutorial for Data Analysis (with FREE Files)
Instructor: Chandoo
Duration: 4+ hours
Course: Free Data Analyst Course – Excel Module
- Excel Fundamentals & Data Management
- Data Cleaning & Transformation with Power Query
- Web Data Extraction & Web Scraping
- Excel Tables
- Excel Formulas & Functions
- COUNTIFS, SUMIFS & AVERAGEIFS
- XLOOKUP, INDEX & FILTER
- Dynamic Array Functions
- SORT, UNIQUE & CHOOSECOLS
- Statistical Analysis
- PivotTables & Interactive Pivots
- Slicers & Timelines
- PivotCharts & Interactive Charts
- Conditional Formatting
- Excel Data Model & Power Pivot
- DAX in Excel
- Excel Dashboard Development
- Dynamic Dashboards & Chart Customization
- Using Pictures in Excel
The course includes practical data analysis situations covering:
- Data cleaning and transformation
- Power Query-based data preparation and automation
- Formula-based analysis
- Lookup and reference operations
- Dynamic array analysis
- Statistical analysis
- PivotTable-based analysis
- Interactive filtering with Slicers
- Data visualization and chart customization
- Data Model and DAX-based analysis
- Interactive and dynamic dashboard development
The concepts learned through the course were applied to a Call Centre Performance Dashboard project.
Focus: Call centre operations, representative performance, purchase amounts, call duration, customer satisfaction, call trends, customer demographics, and representative-level analysis.
The project incorporated:
- Excel Data Model connecting Calls and Customers data through Customer ID
- Power Pivot & DAX measures for call count, purchase amount, call duration, average rating, and five-star calls
- PivotTables & PivotCharts for analytical reporting
- Slicers & Report Connections for interactive representative-level analysis
- Monthly and day-of-week call trend analysis
- Satisfaction rating distribution
- Male vs. female caller analysis by city
- Calls and purchase amount comparisons by representative
- Customer-level purchase amount analysis with data bars
- Conditional formatting for selected representative analysis
- XLOOKUP for dynamic representative details and images
- RANK.AVG for representative performance rankings
- Dynamic dashboard elements that update when different representatives are selected
- Refreshable analysis for newly added call data
Excel: Tables, Formulas, Functions, PivotTables, PivotCharts, Slicers, Timelines, Conditional Formatting, Charts, Dashboards
Data Analysis: Data Cleaning, Data Transformation, Statistical Analysis, Business Questions, Data Visualization, Data Storytelling
Advanced: Power Query, XLOOKUP, FILTER, Dynamic Arrays, Power Pivot, Data Model, DAX
Dashboarding: Interactive Dashboards, Dynamic Filtering, KPI Cards, Chart Customization, Conditional Formatting, Data Visualization
Developed practical experience using Microsoft Excel for data preparation, analysis, visualization, data modeling, and interactive dashboard development, with concepts reinforced through real-world data analysis situations and an end-to-end Call Centre Performance Dashboard project.
Youtube Course Link : https://www.youtube.com/watch?v=7QNgqq154gE&t=2s