Grow Your Business Excel - Intermediate

Programme

Excel - Intermediate

Date: Wednesday, 11th of June 2025
Time: 9am to 4pm
Price: £120 +VAT members / £199 +VAT non members
Venue: Cumbria Chamber of Commerce, 3rd Floor, Broadacre House, 16-20 Lowther Street, Carlisle, CA3 8DA

Prerequisites
Delegates must have previously attended the “Introduction to Excel” course or gained similar knowledge in the workplace.

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
  • 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 will be asked to carry out exercises as we progress. Handouts will be provided for reference during the course.

Related Programmes

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.

11 March 2025

The Melbreak Country House Hotel

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.

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.