Yes, lunch is provided in the cost please let us know if you have any specific requirements.

Do I need to bring my own laptop?

Yes, we will work on your own equipment.

Sales end soon

Monday, 2 June

Intermediate Microsoft Excel - West Cumbria

Are you a regular user of Microsoft Excel? Do you have staff who are needing to extend their Excel skills? Second of a set of 3 courses

By Lake Mill Training and Consulting

Date and time

Mon, 2 Jun 2025 09:30 - 16:00 GMT+1

Location

The Vicky Business Centre Meeting Room & Office Hire

13B Station Street Cockermouth CA13 9QQ United Kingdom

Refund Policy

Refunds up to 7 days before event

About this event

Event lasts 6 hours 30 minutes

During this course you will learn the next level of Microsoft Excel.

Understand the terminology, work your way around spreadsheets and make your reports look professional using data tools, charts, formulas and all the latest functionality available in Excel.

£120 for the full day including refreshments and lunch.

Course Outline

· Saving and File Management

· Converting and Encrypting Files

· File Properties and Digital Signatures

· • File Accessibility and Compatibility

· Formulas with Absolute References

· Autosum Functions (SUM & AVERAGE)

· IF and Nested Functions

· Working with Named Ranges

· Array Functions (SUMIF & AVERAGEIF)

· Formula Auditing

· Text Functions

· Creating Excel Tables

· Working with Records and Filters

· Advanced Filters

· Text to Columns

· Flash Fill

· Remove Duplicates

· Data Validation

· Consolidate

· Trendlines

· Error Bars

· Working with Axis Options

· Advanced Chart Formatting

· Creating Sparklines

· Editing Sparklines

· Working with Themes

· Creating Custom Styles

· Applying Cell Styles

Organised by

Lake Mill Training and Consulting

Lake Mill Training and Consulting provide Microsoft Office training services online and bespoke, onsite courses specific to clients needs.