Synopsis • Excel with Data Analytics will make your command in advanced analytical tools & also a data keeping tool. By Excel formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, an advanced user of it would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. • Apart from knowing the formulas, advanced Excel users know how to make these formulas dynamic, how to audit them and how to use which formula for which occasion (and they also know few alternatives for any given formula problem). Project How to Create a Dynamic Dashboard on Sales Data Using Offset, Name Manager, Form Controls, Graphs, Tables and Some Functions Dashboard Reports Allow User to Get High-Level Overview of the Business and Help Them Make Quick Decisions. Dashboards are Often Called as Management Information System (MIS), Which Provides Information that Organizations Require to Manage Themselves Efficiently and Effectively. Course Highlights - Online Live / In Class room Training - Dedicated Trainer for Queries - Updated Content with Industry Requirements - Focus more on Technical Skills - Live Projects & Assignments - Guidance on Technical Interviews - Assistance in Job Placement in MNC’s - Referrals for Job through Ex Students