Training Course

Intermediate Excel

Digital & IT

Digital & Technology

Event Banner Image
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 and XLOOKUP)
• Introduction to Pivot Tables
• Filling series (Including Flash Fill)

Tips, tricks and shortcuts throughout
Outcome
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.
Additional Information
Lunch and refreshments are provided as part of this course.

 

Please note, you are required to bring a laptop to this training, if this is a problem, please advise us prior to the training.

This event is available for: Members and Non Members

9:30am - 4:30pm

East Midlands Chamber - Nottingham, Nottingham, NG2 1EP

Select your tickets

Members must to purchase member only tickets

*All our business prices are excluding VAT at 20%.

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

Presenters & Panelists

Martin Perry
Learn more

Events

You may also like

Intermediate Excel

2nd June 2025

09:30 - 16:30

Chesterfield , S41 8ND

£245.00 - £315.00

Advanced Excel

27th October 2025

09:30 - 16:30

Chesterfield , S41 8ND

£245.00 - £315.00

Lunch and Learn: The AI+ Innovation For Business Programme

26th November 2024

12:00 - 13:00

FREE

Foundation Excel

29th September 2025

09:30 - 16:30

Chesterfield , S41 8ND

£245.00 - £315.00