0900 – 1000


Pre-assessment of the subject knowledge
Major time / minor time | concepts
Reactive & proactive approaches towards work

1000 – 1100

Recognize key accountabilities & tasks
Being aware of the impact of your work at org.
Brainstorming / questions & answers

1100 – 1200

What is a monkey / identification of monkeys
What is the process / the monkey process
Brainstorming / questions & answers

1200 – 1300

Managing other people’s monkeys
How do we prioritise tasks and objectives
Brainstorming / questions & answers


1400 – 1500


Day plan / month plan / year plan
Low productivity tasks / high productivity tasks
Brainstorming / questions & answers

1500 – 1600

Short time objectives / long time objectives
Value addition through your task management
Brainstorming / questions & answers

1600 – 1630

Being productive manager at work
How to delegate effectively and be a LEADER.
Brainstorming / activities / discussion

1630 – 1700

Managing other people’s monkeys
How do we prioritise tasks and objectives
Brainstorming / questions & answers

0900 – 1000 Managing & Analyzing Data
Advance sorting, effective filtering techniques,
Advanced Filter, subtotal and grouping
1400 – 1500 Interactive Dashboard Designing
Creating smart dashboard for data driven
decision making
1000 – 1100 Advanced Formatting techniques
Conditional formatting, paste special, Cell styles,
auto fill, fill series, flash fill, find and replace
1500 – 1600 Advanced Formulas and Functions
Math and stat functions, logical and lookup
functions, conditional functions, date functions
1100 – 1200 Dynamic Charts and Graphs
Advanced Charts concepts and elements, layout
and styles, Creating effective charts
1600 – 1630 Data Validation for accuracy
Validation criteria and range, dynamic lists, multilevel lists, adding conditional formatting
1200 – 1300 Data Analysis with Pivot Tables
Creating Pivot table, slicers and timeline,
formatting layout and design, adding Pivot charts
1630 – 1700 What-if Analysis
‘Scenario Manager’, ‘Data Table’ & ‘Goal Seek’,
Forecast sheet


If you are a manager it’s likely that you got that position because you were an excellent individual contributor. You did good work and you got it done on time. Now as a manager you have been asked to play a larger role. Some of the qualities and know-how that accounted for your earlier success will help you very little in that new role.

Your success as manager and leader will be determined by other capabilities; your ability to understand and summarize business data, and perform data analysis. In this course we will help you to take your data analysis skills using MS Excel from traditional to the next level.


Participants are going to get following learning benefits by attending this training course.
‣ They will learn advanced concepts in Excel for working with data efficiently.
‣ They will learn the advanced data analysis techniques and dynamic dashboards designing
‣ They will learn how to automate work by using advanced functions.
‣ This will be a great opportunity to get answers to their own practical problems


Any manager that has responsibility for working with data and numbers to produce summarized reports. First time & middle managers who want to expand their skills & understanding in MS Excel. Non business graduates who want to learn this tool to step up in their career. Professionals to be promoted to managers soon.