Home / Events / Intermediate Excel

Share event:

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.

This event is available for: Members and Non Members

9:00am - 4:00pm

Online

This is a funded event and will be subject to eligibility questions during the checkout process to ensure you match the required criteria.

Members must Sign in / Register to purchase member only tickets

Price Type

Clear

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

For further information on this event, please contact Jodey Adams on 012346 256252 or email jodey.adams@emc-dnl.co.uk

Events

Our Services

Members

Events & Training

About

Intermediate Excel

Description

Overview

Outcome

You may also like

Excel Jodey

Jodey Set Test funded 19.6.24

EW breakfast

Copilot Jodey