Skip to Main Content

Excel - Intermediate

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.

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

Book here

Event Details

  • Date: 11 June 2025 -
  • Venue: Cumbria Chamber of Commerce, Carlisle
Sign in to register