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:

• 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
• Pivot Table and Pivot Chart Reports
• 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
• Design Simple Dashboard using Charts Graphs
• Quick Introduction to Macro