Excel 202 Workshop
Tue Jun 13, 07:30 - Tue Jun 13, 16:30
Houghton Golf Club
ABOUT
This practical, hands-on workshop will give you the techniques and skills you need to work with Excel data more efficiently, accurately and confidently.In EXCEL 202, you will learn how to perform data tasks in much less time, with much less effort, and with none of those glaring, costly mistakes.
What’s covered?
- A step-by-step data analysis blueprint – The Data Intelligence Integrator™
- How to slice and dice your data like a pro, using advanced Sort and Filter techniques
- How to leverage the magic of Conditional Formatting to help you spot trends and highlight important data
- How to tidy, manipulate, summarise and scrutinise your data using advanced formulas and functions
- How to master VLOOKUP… and 5 reasons INDEX-MATCH is actually better!
- How to use Data Validation to create dropdowns, to ensure clean, consistent data and to spot errors
- How to use PivotTables and PivotCharts – two of Excel’s most powerful tools for summarising complex data
WHAT WILL I LEARN?
Look forward to a journey through the fundamental principles within Excel:
- Become a Keyboard Person by unlocking the power of keyboard shortcuts.
- Master formulas and functions through hands-on examples and step-by-step exercises.
- Work efficiently and accurately across multiple spreadsheet tabs.
- Learn how to format your work so it looks world-class.
- Protect and share your work so you can collaborate with colleagues and/or clients.
- Make informed business decisions based on your data.
- Much, much more (seriously).
#EXCELFIE GALLERY
WORKSHOP SCHEDULE
Registration and tea/coffee
Workshop Session 1
Morning Tea
Workshop Session 2
Lunch
Workshop Session 3
Afternoon Tea
Workshop Session 4
WHO IS EXCEL ACADEMY?
The story behind Excel Academy
Hi there, Dan here.
Thanks for stopping by.
Back in 2009 as an actuarial graduate, I found myself in a new and exciting specialist life insurer. Exciting times... but stressful times too. My role was 100% Excel based - and I was CLUELESS!
Excel Zero → Excel Hero:
After a few rough months I began to appreciate the real-life applications, capabilities and risks of using Excel as a business tool. I began to feel like an EXCEL HERO.
When I qualified as an Actuary in September 2013, I resigned from my job and founded Excel Academy - to help other people get to Excel Hero status too!
MISSION:
At Excel Academy we inspire global productivity and success through our fun and experiential Excel Workshops.
We are proud to have trained approx. 4000 people over the last 3 years at some of South Africa's and the UK's top institutions.
We are now the exclusive preferred provider for Discovery, Investec, and 11 partner universities through SAICA's Thuthuka Bursary Fund.
Thanks for stopping by.
Back in 2009 as an actuarial graduate, I found myself in a new and exciting specialist life insurer. Exciting times... but stressful times too. My role was 100% Excel based - and I was CLUELESS!
Excel Zero → Excel Hero:
After a few rough months I began to appreciate the real-life applications, capabilities and risks of using Excel as a business tool. I began to feel like an EXCEL HERO.
When I qualified as an Actuary in September 2013, I resigned from my job and founded Excel Academy - to help other people get to Excel Hero status too!
MISSION:
At Excel Academy we inspire global productivity and success through our fun and experiential Excel Workshops.
We are proud to have trained approx. 4000 people over the last 3 years at some of South Africa's and the UK's top institutions.
We are now the exclusive preferred provider for Discovery, Investec, and 11 partner universities through SAICA's Thuthuka Bursary Fund.