View Courses
Technology & IT
Data Analysis using Advance Excel
Learn from : Madhu Tripathy
Power BI, Excel, Powerpoint, SQL, C++, Word
Course Language: English
Course Fee
$131.00
Course Fee
$131.00
Instructor Bio:
A Corporate Trainer, Designer-Consultant, Mentor, and Subject Matter Expert with over 20 years of experience in delivering impactful software application training across diverse corporate environments. I specialize in managing the complete training lifecycle—from setup (classroom, one-on-one, and online) to designing customized content and delivering engaging sessions tailored to audience needs. My expertise includes Advanced MS Office (EXcel including VBA, Word, Powerpoint & Access), Power BI, MS Teams, OneNote, Visual Basic, C/C++, Java, Data Structures, and SQL. With strong communication and presentation skills, I have conducted training programs for leading organizations such as DRDO, DHL, Accenture, Citibank, Tata Group, Vodafone, Schneider Electric, Honda, BHEL, NIIT, C-DAC, VIVO, and many more. I am passionate about simplifying complex technical concepts into practical, easy-to-apply learning experiences that help professionals enhance productivity, strengthen data analysis skills, and improve overall digital proficiency.
VIEW FULL PROFILE1 Weeks
10
DAILY
Post Course Support
- Assignments
- Forums
- Quizzes
- Resources
- Recorded Session Videos
Course Description:
This course will empower the participant to
-
Clean and prepare raw data
-
Use advanced formulas for analysis
-
Analyze large data using PivotTables
-
Create dashboards for MIS/reporting
-
Use Excel for decision-making scenarios
Course Curriculum:
Advanced Excel for Data Analysis and Decision Making
Session Plan (8 Hours)
Data Preparation & Cleaning
-
Converting data into Tables
-
Removing duplicates, Text to Columns
-
Data Validation
-
Conditional Formatting for quick insights
-
TRIM, CLEAN, Flash Fill
Essential Functions for Analysis
-
IF, IFS, AND, OR
-
SUMIF, COUNTIF, AVERAGEIF
-
Date functions for trend analysis
-
Text functions (LEFT, RIGHT, MID, LEN)
Advanced Lookup Techniques
-
XLOOKUP (exact, approximate, multiple criteria)
-
INDEX + MATCH (why better than VLOOKUP)
-
Handling errors with IFERROR
-
Dynamic arrays: FILTER, SORT, UNIQUE
PivotTables for Business Analysis
-
Creating PivotTables from raw data
-
Grouping by dates and numbers
-
Slicers
-
Calculated fields
-
PivotCharts
Data Visualization for Decisions
-
Choosing the right charts
-
Combo charts
-
Trend and comparison analysis
-
KPI indicators using Conditional Formatting
Dashboard Creation
-
Designing a summary sheet
-
Interactive dashboard using slicers
-
Linking charts, pivots, and formulas
-
Structuring a MIS dashboard
What-If & Scenario Analysis
-
Goal Seek
-
Data Tables
-
Scenario Manager
-
Practical business cases
Real Business Case Study & Practice
-
Sales / HR / Finance dataset analysis
-
Building a mini dashboard
-
Interpretation for decision making
-
Q&A and recap
Earn a Course Completion Certificate
Add this certificate in your LinkedIn Profile, resume or share it on social media platforms. It helps validate the learner’s knowledge and skills, boosting their resume and increasing their employability.
