Microsoft Excel 2016 - Intermediate+
Time & Location
About The Event
Do you want to learn the true capabilities of what Microsoft Excel can do?
Do you want to be better and more confident at using Excel?
Would you like to learn how to complete tedious tasks more efficiently?
Our 6.5 hour workshop has been designed for current users of Excel that want to learn more of the intermediate + functions of Excel. You will learn everything you need to know to create small or large spreadsheets within your business, including working with multi sheets, formatting, formulas, functions, diagrams, graphs etc. We will give you the confidence to quickly create any spreadsheet you will require in business.
We don’t offer an advanced workshop as we feel that 99.9% of users will not require any other Excel skills over and above this workshop.
Our workshop is delivered in Office 2016 - compatible with Office 2010 upwards (please note that there may be minor differences). Mac is not compatible.
You will need to bring your own device (with Office 2010 upwards). If you are unable to bring your own device, please let us know prior to the workshop and we will arrange one for you.
Pre-requisite: We don’t start right at the beginner's level, therefore; you must already be a basic user of Microsoft Excel. If you are not, we also offer an Excel beginner workshop or can offer one-on-one training.
YOU WILL LEARN:
- How to use Excel efficiently
- A wide range of intermediate level tips and tricks
- How to customise the ribbon
- How to create and format spreadsheets
- How to manage worksheets and workbooks
- Essential / Intermediate formula knowledge
- How to analyse data, including charts and pivot tables
- Data validation in conjunction with other formulas
- How to combine functions into useful formulas and use in calculations
- Helpful keyboard shortcut keys
DURATION: 6.5hrs - includes lunch and a PDF training book
A minimum of two people and a maximum of five
We are registered with NZTE, which means that you maybe eligible for 50% off this workshop. Contact Hamish at Marlborough Chamber of Commerce to see if you qualify. Phone 03 577 9575 or email firstname.lastname@example.org. Please note that you do not have to be a Chamber member to qualify for the funding. Even if you are applying for funding, you still need to book and pay for the workshop in full. Once you have attended the workshop, we will refund you the funded portion directly to your bank account.
(a) Cancellations 10 days or more prior to the Workshop will attract a 5% cancellation fee. Cancellations less than 10 days prior to the Workshop will attract a 50% cancellation fee. Cancellations less than 2 days prior to the Workshop are non-refundable.
(b) We reserve the right to postpone or cancel a Workshop (e.g. due to insufficient registrations) in which case we will offer you an alternative workshop date or a full refund of all registration fees.
(c) If you receive NZTE funding, we will refund you the funded portion, once you attend the workshop.