Online Training in Data Analysis using Microsoft Advanced Excel

Introduction:

Institute of HRD will be hosting an Online training on Data Analysis using Microsoft Advanced Excel for the benefits of Managers, HOD's, Business Leaders from HR, Sales, Marketing, Operations and IT.  The details of the workshop are as follows:

Workshop Contents:

•    Overview of Microsoft Excel,
•    Understanding Cell reference,
•    Conditional Formatting, Building KPIs, creating thresholds,
•    Dynamic Data validation, Dependent Drop-downs,
•    Working with Ranges, Named Ranges, Dynamic Ranges, best practices,
•    Microsoft Excel’s Tables and Dynamic formulas to summarize data to get actionable insights,
•    Some 40+ powerful functions that we use: VLookup, Logical functions, Aggregators, Arithmetic functions
•    Using Drill-down & Drill-up approach in Pivot Tables,
•    Finding top Product, Customer, Region, Day conditionally,
•    Using Pivot Charts, Slicers, Timeline, Spark lines,
•    Grouping Dates, Times, Cross comparison between different categories in PivotTable,
•    Un-pivoting data from multiple rows/columns,
•    Creating Hierarchies using Pivot tables,
•    Using Advanced filters to report selected data views,
•    Removing duplicates conditionally,
•    Selecting the Right chart, Formatting charts,
•    Interactive charts with Form controls,
•    Building Column charts, Bar charts, Pie charts, Line charts, Spark-lines,
•    Plotting Geographical data on a World-maps,
•    Discussing best practices when using Microsoft Excel

Who Should attend:

•    Marketing Managers,
•    HR Managers,
•    Finance controllers,
•    Business Analysts,
•    Decision makers,
•    Data Analysts,
•    Information workers
•    Any other Excel Power Users.

Resource Person:

Mr. Ravi Kamana, is a Microsoft Certified Solutions Associate (MCSA) & Microsoft Office Specialist (Excel Expert 2010). He specializes in Power BI, Power Query, Power Pivot, M language, DAX stuff. He trains people in this technology helping businesses to make data-driven decisions. He conducts in-house training, online workshops, and public workshops. He also offers remote consulting services working for clients no matter where they are in the world.  He holds a B.Com Degree from Acharya Nagarjuna University. He has conducted training for many well-known organizations which include Adani Group, Ashok Leyland, TVS Group & CII.