Analytics with MS Excel and Power BI

The analytics program designed for everyday analysis

Our advanced MS Excel program rechristened as Analytics with MS Excel and Power BI is focused on boosting productivity and analytical capability of professionals across discipline.

Whether you are in finance, marketing, production or HR, our wide variety of practical case studies will help you directly relate this to your work and help you improve your productivity and your capability to handle data. This program does not just cover formulas and functionalities but our proprietary module on reverse flow charting technique will also enable you to develop your own solutions to problems in hand.

In this program, you will be working with over 60 practical case studies including two full fledged analytical case studies all inspired from real life corporate situations.

The program is up to date and covers all the latest functions and functionalities including XLOOKUP, XMATCH and Dynamic Arrays.

Duration: 40 hours (36 hours in case of virtual training sessions)

Course outline

Best practices in storing data
Cleaning unclean data
Advanced MS Excel functions
Working with date and text
Reverse flow charting technique to develop algorithms and solutions
Working with tables and arrays
Dash boarding in MS Excel
Working with power query and power Pivot
Fundamentals of working with Power BI
Introduction to DAX functions
Introduction to VBA