Excel - Intermediate


Discover Excel’s more powerful features like sorting, filtering data and creating charts.

1 Day

We assume you have a basic understanding of Windows and Microsoft Excel, including creating workbooks, using AutoFill and AutoSum, constructing formulas, Absolute Cell References and formatting worksheets.

Course Contents

Worksheet Techniques

  • Inserting and Deleting Worksheets
  • Copying and Renaming a Worksheet
  • Moving a Worksheet
  • Hiding and Unhiding Worksheets
  • Copying and Moving Sheets to other Workbooks
  • Changing Worksheet Tab Colours
  • Grouping Worksheets
  • Hiding and Unhiding Rows and Columns
  • Freezing Rows and Columns
  • Splitting Windows

Some Useful Functions


Creating Charts

  • Choosing the Right Chart
  • Using a Recommended Chart
  • Creating a New Chart
  • Working With an Embedded Chart
  • Resizing and Repositioning Charts
  • Creating a Chart Sheet
  • Changing the Chart Type, Layout and Style
  • Embedding a Chart Into a Worksheet
  • Printing an Embedded Chart and Chart Sheet
  • Understanding Chart Elements (Title/Axes/Legend)

Special Pasting

  • Pasting Formulas and Values
  • The Paste Special Dialog Box
  • Copying Validations
  • Copying Column Widths

Custom Views

  • Adding and Creating a Custom View
  • Working With Custom Views

Sorting Data

  • Understanding Lists
  • Performing an Alphabetical and Numerical Sort
  • Sorting on More Than One Column
  • Sorting Numbered Lists
  • Sorting by Rows

Filtering Data

  • Applying and Using a Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards

Conditional Formatting

  • Formatting Cells Containing Values
  • Top Ten Items
  • More Top and Bottom Formatting Options
  • Working With Data Bars and Colour Scales
  • Creating and Editing Sparklines
  • Creating Custom Rules
  • The Conditional Formatting Rules Manager

Worksheet Tables

  • Creating a Table From Scratch
  • Working With Table Styles
  • Table Columns
  • Converting a Table to a Range
  • Creating a Table From Data
  • Inserting or Deleting Table Records
  • Removing Duplicates
  • Sorting, Filtering, Renaming, Splitting Tables

The Quick Analysis Tools

  • Quick Formatting
  • Quick Charting
  • Quick Totals
  • Quick Sparklines
  • Quick Tables
Sorry… This form is closed to new submissions.