ADVANCE – MICROSOFT EXCEL
TIME
0900 – 1000
TOPICS
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
TIME
1400 – 1500
TOPICS
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
| TIME | TOPICS | TIME | TOPICS |
|---|---|---|---|
| 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 |
COURSE OVERVIEW
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.
COURSE BENEFITS
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
WHO SHOULD ATTEND
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.