Training

Intermediate Excel

Digital & IT, Digital & Technology

09/07/2024 9:30 am

09/07/2024 4:30 pm

Online

Chamber Members: £245

Non-members: £315

*All our business prices are excluding VAT at 20%

Book a place

Online

For further information on this event, please contact: Business Training on 03333200333 or email business.training@emc-dnl.co.uk

Description

This one-day course extends the learner’s basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks.

It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks.

Overview

Course programme in detail
• Working with multiple workbooks
• Formulas – recap the basics
• Formula referencing (understanding $ in formulas)
• Filtering data
• Working with Excel Tables
• Logical Functions (IF, AND, OR)
• Conditional Formatting
• Lookup functions (VLOOKUP)
• Introduction to Pivot Tables
• Filling series (Including Flash Fill)

This course is being delivered online and is fully interactive, you will be expected to have your camera on during the training.

A joining link will be sent around a week before the course start date. It is suggested that delegates take notes throughout. Time will be provided for practicing and recapping along with Q & A.

What outcomes can you expect from joining us

On completion of this course you should be able to use the fill operations available; understand and use absolute and relative formula referencing; sort data in a worksheet; use a range of logical and lookup functions; work with a variety of elements in a worksheet; work with more than one workbook at a time and filter large amounts of data in a table.

Martin Perry

The tutor for the course is Martin Perry who has many years experience as an IT Trainer. Martin's courses are geared to ensuring all delegates walk away with new skills regardless of their ability when they arrived. All courses are delivered in such a way that delegates continually use Excel throughout the day ensuring maximum hands on experience.

Additional Information

Lunch and refreshments are provided as part of this course. Please note, there is no requirement for delegates to bring any stationery or IT equipment unless otherwise stated in the joining instructions

book your place

Are you interested in attending this event? Book today to secure your place.
Booking Form

Looking to book for our event?

Please complete with delegate details, we can only accept one delegate booking per form. If you wish to book multiple delegates, please email business.training@emc-dnl.co.uk or complete a form for each delegate.