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:
Course CurriculumCurriculum
- 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
- 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)
- Grouping / Ungrouping
- Creating Drop Down List
- Conditional Formatting
- Data Validation
- What if Analysis (Goal Seek, Scenario, Data Table)
- 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
Data Analysis using MS Excel - Course Fees
Why CFI Education
CLASSROOM TRAINING
Starts with personalized classroom training (16+ Hrs) with doubt clearing
CASE STUDY APPROACH
Real life cases for most effective and skill based learning.
PASSIONATE EDUCATORS
Highly experienced instructors who bring real business problems to the classroom.
INDIVIDUAL ATTENTION
Focus on building technical expertise and ensure the learning of all candidates.
CAPSTONE PROJECTS
A month long project work post classroom sessions to gain confidence in their domain area.
24*7 SUPPORT
Support for helping and enhancing student learning experience.
TESTIMONIALS
Success Stories of Successful Students
Shalu Kaushik
“CFI institute is a good place to learn financial modeling, all the teachers are very supportive and helpful. Teachers give attention to each and every student in the class. Even after class teachers are ready to clear doubts. Placement support is excellent here, special thanks to Sandeep sir for all his guidance and support.”
Priyanka Behl
“Faculty is very informative and helpful. With the help of their guidance I cleared interview for investment banking profile. Totally recommended to joiners.”
Aardhya Sood
“Got my level 1 classes from cfi!! Really amazed by the hard work!! Thank you so much sandeep sir for enlightening me!!! ????????.”
Bunwin Singh
“Helped me clear CFA level 1 on just 4 months. Very supportive, focus on conceptual clarity.”
Latest Blog
Data Analytics Certification: How a Excel VBA Program Can Land Your Dream Job?
Data Analytics Jobs: 9 Career Options You Can Explore
5 Data Aggregations You Can’t Live Without
