Master your Spreadsheets - Demystify the Full Power of Excel
A quick guide to take you beyond the basic concepts and use the full power and scope of this fantastic tool
Outline
Business analytics and reporting, project management, budgeting and planning - all these management responsibilities and tasks at times require the use of Excel. Yet many managers and executives have no formal grounding in Excel that can ensure speedy and simple methodologies are used to get their spreadsheets to do exactly what they want. And as EAs and PAs move into more senior roles and take on more of these responsibilities for their Executives it is also becoming essential for them to know more than just the basics of this powerful tool. This fun and interactive intermediate to advanced level course will help you work more effectively and efficiently and operate with German precision. Exploring the full scope and power of Excel this course is a must for anyone who wants to function with the capabilities upper management now expect.
Who should attend?
This course is essential for any Executive or Personal Assistant who has a reasonable grounding in Excel but knows that more in-depth knowledge will provide them with the skills to take on more spreadsheet work on behalf of their Executive or other managers or use Excel more efficiently in their own reporting, planning or budgeting.
Do you want to take a quantum leap in terms of you business analytic, reporting or planning skills? Would you like an insight into uses for Excel you haven't previously considered? Would you like an insight into the true power behind the functionality of this program? Do you want Excel to do what you want and be more confident about all your moves?
This course is especially designed for ALL EAs and PAs who are time-poor and want to be more productive and effective with their existing financial models and calculations as well as any other tools they might currently use Excel for. A Good basic knowledge of Excel and experience in working in an Excel spreadsheet is necessary grounding for anyone taking this course.
Course objectives
- Understand advanced concepts and functionalities within Excel
- Workshop the approach of creating a complex spreadsheet
- Run through the 30 most useful advanced tips for excel
- Key strategies to get MS Excel to do more for you
- Unleash the incredible potential of Excel and be in control
- Become an experienced and confident Excel user
Course content
- Learn the top tips in Excel and see them in action
- Discuss your issues and get a solution on the spot
- Create a new complex project with Excel
- Create advanced graphs and charts
- Working with Pivot-tables and large data
- Operate with ease in large lists
Your Workshop Presenter
Jürgen Schmechel - Software Wizard
EAN Training Academy
With over 23 years experience in IT, Jürgen combines his German precision with his professional and fun training as an internationally accredited software and business consultant.
Jürgen is a great communicator who is an entertaining and compelling facilitator, effectively engaging his audiences and leaving them enthused to take personal action to enhance their personal and computer skills. Thousands of individuals from numerous industries have benefited from Jürgen's work. He understands people and can assess their real needs and tailor the training accordingly.
Jürgen's purpose is to empower you directly from the ‘take-away' useful skills you learn.
Jürgen ensures that his workshops are practical, interactive and produce hands-on outcomes. He is passionate about helping
you enhance confidence, competence and creativity to be more effective and productive with your existing software tools.
Duration
Three Hour Workshop
Price
EAN Members: $445.00 + GST
EAN Associate Members & Non-Members: $595.00 + GST
Please contact Katrena Friel at BSI Learning on 02 9215 0196 to discuss your program needs.