Excel 1 Day Intermediate – Efficiency and Effectiveness – face to face
January 18, 2022 @ 9:30 am - 4:00 pm
EFFICIENCY AND EFFECTIVENESS
Duration 1 day
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
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
• 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
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.
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.
Charting – Understand and use the range of features in charts to present
your data in an exciting fashion.
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.
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.
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.
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.
PLEASE BRING IN YOUR OWN LAPTOP with an APPROPRIATE MICROSOFT SOFTWARE on it!