Wits Act Sci Excel 202 Workshop
Wed Sep 13, 08:00 - Wed Sep 13, 16:00
Mathematical Sciences Building
ABOUT
Excel 202 is an advanced Excel workshop - teaching you sophisticated techniques for manipulating, analysing, summarising and visualising data in Excel.
WHAT WILL I LEARN?
- Become a Keyboard Person by unlocking the power of keyboard shortcuts.
- Master formulas and functions through hands-on examples and step-by-step exercises.
- A step-by-step data analysis blueprint – The Data Intelligence Integrator™.
- Improve efficiency using top-secret keyboard shortcuts.
- Apply advanced Sort and Filter techniques.
- Use Conditional Formatting to help with trends analysis.
- Manipulate and assess data with formulas and functions.
- Master VLOOKUP… and 5 reasons INDEX-MATCH is actually better!
- Use Data Validation to create useful dropdown lists and other rules.
- Summarize and visualize data with PivotTables and Charts.
#EXCELFIE GALLERY
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.
DIRECTIONS
Wits Act Sci Excel 202 Workshop
Mathematical Sciences Building
1 Jan Smuts Avenue, Braamfontein, Johannesburg, 2000, South Africa
Get Directions