- This event has passed.
Microsoft Excel Level 2 Training Course – Efficiency & Effectiveness
September 17, 2019 @ 9:30 am - 4:00 pm
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.
Duration: 1 day
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:
- Entering, editing and formatting data in a simple Excel spreadsheet and then printing it
- Using autofill to enter data efficiently
- Using arithmetic formulas and simple functions to analyse numerical data
At the end of the training you will be able to successfully:
- Understand and use absolute cell references appropriately
- Create summary worksheets using data from other sheets in the book
- Create links between workbooks
- Create and format charts to produce exciting and professional graphs
- Use IF functions to produce logical results
- Conditionally format cells to highlight significant data
- Build and manage lists
- Use VLOOKUP and HLOOKUP functions using the documentation and support provided.
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.
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.
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.
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.
Refreshments and lunch are provided.
This course is priced at £135 including VAT for Chamber Members and £155 including VAT for Non-Members. This course is free to BID businesses.