Managing Excel Data with Formulae & Functions
The aim of this training is to build on your knowledge of Formulae, Functions and the handling of duplicate data. This follows on from the “introduction to Excel Formulae and Functions” course or is suitable for delegates with some experience of creating Formulae and Functions.
By the end of the course delegates will be able to control the input and duplication of their data. It is also an opportunity to reinforce knowledge of Formulae and Functions, whilst introducing further calculation options.
Identify the template principles to maintain consistent workbooks with accurate data.
- Create a template
- Edit a template
- Apply a template
Reproducing data effectively and easily
- Using Paste Special
- Using the Office Clipboard
- Drag and Drop – cells, rows, columns
Controlling the entry of data to ensure its integrity.
- Input messages
- Error messages
Logical and Lookup functions
Build on your existing knowledge to get answers from your data.
- Using AND and OR functions
- Using the IF function
- Nested IF statements
- Using LOOKUP functions
- Using IS, ERROR functions
- Using INDEX and MATCH
Please email firstname.lastname@example.org to book a place.
Thursday 26th April 2018
This course can be delivered on-site. Please enquire for details.
6 – 8
Registration 9.15am, Start 9.30 – Finish 12.30pm
£65.00 plus vat