Thu, 18 Feb|
Microsoft Excel 2016 - Intermediate+
Our 6 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 to large spreadsheets within your business, including working with multi sheets, formatting, formulas etc..
Time & Location
18 Feb 2021, 9:00 am – 3:00 pm
Sass Boardroom, Level 4 Rangitane House, 2 Main St, Blenheim, 7201, New Zealand
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?
Pre-requisite: You have attended our Excel Beginner+ to Intermediate workshop or regard yourself as a confident/intermediate Excel user
Our 6 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: You must already be a basic to intermediate user of Microsoft Excel. If you are not, we also offer an Excel beginner to intermediate 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: 6hrs - includes lunch and a PDF training book
A minimum of two people and a maximum of five
"There were only 2 of us so we had plenty of attention. Instructor very organised and the course very well run. Excellent facilities, food etc" Frances Wickham
(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 funding, we will refund you the funded portion, once you attend the workshop.
Includes lunch and PDF training book