New 1-day course for Microsoft Excel from just £135 including VAT (for Chamber Members)
17th September - 9:30 to 16:00
Duration 1 day
Overview
This course develops your essential Excel skills and takes you into areas where you can really save time and make a significant difference to the way you work. Understand how Excel works behind the scenes.
Recommended for
Anyone with some experience of Excel who is now finding they need to expand their skills and knowledge. In particular it will be useful for people who regularly create similar workbooks e.g. on a daily/weekly/monthly basis and those who need to analyse the data they hold.
What do you need to know already?
We will assume that you already have some experience of using Excel and are familiar with the following tasks:
Objectives
At the end of the training you will be able to successfully:
Modules covered in this course
1. Formula Addresses
In this module we will examine all the different ways in which you can reference cells in formulae and functions, making your spreadsheet easier to use.
2. 3-Dimensional Processing
By using data from other sheets and workbooks, you can rapidly create summaries and design solutions that eliminate the chances of mistakes. In this module you’ll learn how to design and format 3-dimensionally and to create formulas that reference and summarise data across the range.
3. Charting
Understand and use the range of features in charts to present your data in an exciting fashion.
4. Conditional Processing
Have you ever needed to see at a glance where there are problems with your figures? Learn how to organise your spreadsheets to automatically process your information and present it in different ways depending on the context.
5. Lookup Tables
Lookup tables will allow you to enter information in one sheet which other sheets will look at. This will not only help with speedy entry, it will make your data more accurate too.
6. Lists
Understanding how to use them correctly will not only save you time but ensure that you maintain data integrity. This is essential so you can make sure your staff and customers are always seeing accurate information.
Clearer
We recommend that you bring real-life examples and problems from work with you so that you can go back to work after training having made real progress.
All courses are accompanied by detailed training notes and exercises.
Courses run from 9:30 – 4:00. Refreshments and lunch are provided.
This course is priced at £135 including VAT for Chamber Members and £155 including VAT for Non-Members.
“We became a member of Halton Chamber because of the range of services on offer to help our business on a day to day basis, but also to develop and grow. One of Halton Chamber’s strengths is the staff. They have developed a one to one relationship with us and we are treated not as a number but as an individual company with specific needs - we have the support we need, when we need it.”