Business Analytics - Advanced Excel

Excel Overview

Excel is one of the most widely used tool in corporates across sectors and across functions

It has always been user friendly and feature rich and now has been expanded to provide an even wider array of tools helping businesses right from simple work to complex problem solving and decision making

Excel has become an integral part of everyday operations, making it a necessity for continuous flow of business

•Excel Overview & Basic Excel tools

•Basic & Advanced Excel Formulae

•Nested & Dynamic Formulas

•Charts – Basic, Multi Axis, Advanced & Dynamic

•Pivot Table, Pivot Charts & Pivot Dashboards

•Business Simulations – Sensitivity Analysis / Scenario Manager / Solver

•Management Dashboards

•Macro Recording, Macro Objects & VBA Coding

•Shortcut techniques for easy working

•Case Study based extensive hands on learning

•Wide range of managerial examples