Excel Academy Productivity Intensive (Excel API)
Tue Nov 14, 07:30 - Wed Nov 15, 16:30
Houghton Golf Club
ABOUT
Excel API is an Excel Academy Signature Programme:
Day 1 - you will discover the fundamentals of Excel, so that you can quickly and easily create spreadsheets that meet your needs and save you time.
Day 2 - we will reveal advanced Excel techniques to help you manipulate, analyse, summarise and visualise data with confidence and ease.
You will also receive lifetime access to the entire syllabus on our online video platform, as well as lifetime access to Excel 303 - Macros and VBA.
Day 1 - you will discover the fundamentals of Excel, so that you can quickly and easily create spreadsheets that meet your needs and save you time.
Day 2 - we will reveal advanced Excel techniques to help you manipulate, analyse, summarise and visualise data with confidence and ease.
You will also receive lifetime access to the entire syllabus on our online video platform, as well as lifetime access to Excel 303 - Macros and VBA.
WHAT WILL I LEARN?
Day 1: 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).
- 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
#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.