This is an 8 hour course, delivered online @ 4 hours / day across 2 days. Participants will learn the workng of MS Excel, application in day-to-day work life and how they can improve their productivity by using MS Excel.

You'll acquire a highly impressive data analysis skills, including What-If Scenarios, PivotTables, PivotCharts, HLOOKUPs, VLOOKUPs and basic Macros
What-If Analysis - Exploring Scenarios - Goal Seek and Data Tables - Using Solver
Grouping & Outlining and Subtotals - Outlining and Grouping Data - Using the Subtotals Tool
PivotTables - Getting Started with PivotTables - Displaying Data in a PivotTable - Formatting a PivotTable - Using the Classic PivotTable Layout
Charting Pivoted Data - Getting Started with PivotCharts - Using the PivotChart Tools Tabs - Formatting a PivotChart
Advanced Excel Tasks - Excel and Hyperlinks - Using Custom AutoFill Lists
HLOOKUP and VLOOKUP Functions - Using the VLOOKUP Function - Using the many other Excel Functions
Introduction to Macros in Excel - Recording and Playing Macros - Copying and Deleting Macros - Visual Basic and Macros

Gallery (2)

About the Trainer

Avg Rating

0 Reviews

1 Students

1 Courses

Anand Arora

MBA-HR

18 Years of Experience

Anand has successfully completed an MBA in HR and has 15+ years of work experience as an L&D Professional in various Industries like IT / ITES, FMCG, Retail, Financial Services. He has worked with organisations such as HP, NIIT, Aditya Birla Retail, Jack & Jones, and NTUC Singapore.
Anand is proficient at Training Needs Analysis, Leadership skills, Designing Learning Frameworks for large corporate teams through Focused Group Discussions & Bucket Analysis using his working knowledge of MS Excel.