About Contact Login Register
Light logo
Grow your business Know your business
Grow Your Business Excel – Intermediate

Programme

Excel – Intermediate

Date: Tuesday 11th March 2025
Time: 10am to 4pm 
Price: £120 +VAT Chamber members / £199 + VAT non members
Venue: The Melbreak Hotel, Workington, CA14 1XS

The aim of the course is to provide delegates with the skills to use functionality that will make formulae easier to work with, to create formulae using data from multiple worksheets, and to apply more complex formatting.

Delegates must have previously attended the “Excel for Beginners” course or gained similar knowledge in the workplace.

The course covers:

  • 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
  • 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
  • Text to Columns

Delegates must have a laptop (or equivalent) running Excel for Microsoft 365(not online version).

To book onto this course, you will be taken to our parent organisation Cumbria Chamber of Commerce's website.

Book here

Related Programmes

Growth hub website images 15

Excel for Beginners

11 February 2025

The Melbreak Country House Hotel

This course is suitable for delegates who are new to Excel or are self-taught and wish to ensure they make the most of the basic functions.

Growth hub website training images

Excel - Advanced

15 April 2025

The Melbreak Country House Hotel

The aim of the course is to provide delegates with the skills to manage and analyse large amounts of data in a worksheet.