Data Analysis Using MS Excel
Course Description
MS Excel application is an extremely popular & powerful tool that possesses the ability to rapidly develop professional-looking workbooks and dynamic reports to efficiently summarize and represent finance and non-finance data.
Data Analysis using Excel course offers an immersive training of MS Excel application and makes candidates ready to perform most used data analysis in MNCs, investment banks, offshore research firms and other finance related MNCs.
Some of the areas include excel shortcuts, sorting, filtering, conditional formatting, paste special, pivot table. It covers a wide variety of functions, creation and formatting of charts which can be used in PowerPoints.
This program also covers dynamic dashboards, solver, goal seek, sensitivity analysis, workbook protection, validation, grouping and much more. Have a look at our day wise content for more details:
Curriculum
Day 1 – MS Excel Basics - i.e. Sorting, Filteting, Functions
- Keyboard Accelerators and Shortcuts
- Create and Customize the Excel List
- Data entry with AutoFill Feature
- Working with Advance Cut, Copy, Paste Command
- Use of Find and Replace
- Using Paste Special
- Sorting and Filtering
- Advanced Formatting
- Mathematical Functions
- Text Functions
- Statistical Functions
- Date & Time Functions
- Array Functions
- Reference and Lookup Functions
- Financial Function
- Pivot Table and Pivot Chart Reports
- Dashboard and Excel Macros Introduction
- Keyboard shortcuts
- Paste Special
- Dashboard and Excel Macros Introduction
- Functions (Mathematical, Text, Stats, Date and Time, Transpose, Sum product)
- Sum, Product, Power, SQRT, ABS, Lower, Upper, Text, Search, Len, Replace, Left, Right, Count, Min, Max, Average, CountA, AverageA, Today, Now, EOMonth, Transpose, Sumproduct, etc
Day 2 – MS Excel Formulas and Functions
- Stats Functions (SumIF, CountIF, SumIFs, CountIFs, AverageIF etc)
- Informative Functions (Isblank, Isnumber, Istext, Iserr)
- Database Fundtions (Dsum, Daverage, Dcount, Dmin)
- Logical Functions (If, Iferror, And, Or, Ture, False)
- Look and Ref Functions (Vlookup, Hlookup, Indirect, Index Match, etc)
- Various examples of Index / Match
- Financial (PV, FV, NPV, PMT)
Day 3 – MS Excel - Data Validation, Conditional Formatting, What If
- Grouping / Ungrouping
- Creating Drop Down List
- Conditional Formatting
- Data Validation
- What if Analysis (Goal Seek, Scenario, Data Table)
Day 4 – MS Excel - Graphs, Charts, Dashboards
- Creating Pivot Table and Charts Reports
- Column, Stacked Column, and Bar Charts
- Line Chart, Pie chart, Waterfall Charts
- Design Simple Dashboard using Charts Graphs
- Link charts with Presentations
- Introduction to VBA / Macros
- Macro Recording, Running, Setup
How It Works
Students Speak

Jay Veer








Pankaj Gupta








Amit Rajpal


Akshay Goyal


Chems Arora


Venus Saini


Shalu Kaushik








Shayak Upadhyay








Ashok Garg


Swati Gupta








Akash Rawat


Pooja Jindal


Priyanka Behl








Anuraag Roy
+91-9354266554 or mail us at [email protected]