Skip to content

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.

Course Content

Templates
Identify the template principles to maintain consistent workbooks with accurate data.

  • Create a template
  • Edit a template
  • Apply a template

Duplicate Data
Reproducing data effectively and easily

  • Using Paste Special
  • Using the Office Clipboard
  • Drag and Drop – cells, rows, columns

Data Validation
Controlling the entry of data to ensure its integrity.

  • Settings
  • 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

Booking Details

Please email training@firstpointconsultants.co.uk to book a place.

Date:

Thursday 26th April 2018

Venue:

This course can be delivered on-site. Please enquire for details.

Duration:

3 Hours

Delegate Nos:

6 – 8

Timings:

Registration 9.15am, Start 9.30 – Finish 12.30pm

Course Fee:

£65.00 plus vat

Upcoming Events

No events coming up!

Microsoft Partner
Microsoft specialist
City Guilds
OCR
Rickmansworth
The Education & Training Foundation