MS Excel Intermediate


Event details

  • November 26, 2019
  • Tuesday, 9AM to 4PM

Contact event manager

1 2 3 4

Book your tickets

Thank you Kindly

MS Excel Intermediate

Tuesday, 9AM to 4PM
November 26, 2019


MS Excel Intermediate

Tuesday, 9AM to 4PM
November 26, 2019


This course is designed for learners who have used Excel before and want to expand their knowledge, improving formatting, organising data, highlighting key information and creating formulas/links between sheets. The course will introduce new concepts for sorting data, and building conditional formulae. If you think you know Excel, this course will show you what you’ve been missing. Learners will leave feeling a new confidence in their Excel expertise and ready to take on new challenges with data. During the training session, each learner will work through exercises and practice using the various Excel features covered during the course.

Learning outcomes

Learners will be able to:

✓ Work with Multiple Worksheets

✓ Create Charts

✓ Manage Lists

✓ Work with dates

✓ Work with formulae and functions.


We will begin the day with an overview of some of the Level One topics.  This will act as a recap for those who have already attended Level One, and will ensure that the experienced users who have not attended Level One become more aware of the use of Speed Keys etc.  We will then cover some of the intermediate topics – working with and linking multiple worksheets, creating charts, managing lists (Sorting & AutoFilter) among some other options.

Excel Basics (An Overview)

  • Review of Excel Basics concentrating on quick methods of performing commonly used commands / features including an overview of Speed Keys


  • Advanced Formatting Options
  • Using the Format Painter
  • Deleting Formats
  • Using AutoFormat
  • Conditional Formatting

Viewing and Modifying Worksheets

  • Zoom Setting
  • Splitting a Worksheet
  • Freezing Titles
  • Print Titles
  • Hiding and Un-hiding Columns and Rows

Formulae and Functions

  • Recap of Basic Formulae
  • Recap of Basic Functions
  • Copying Formulae
  • Relative vs. Absolute cell addressing

Custom Lists

  • Working with Lists in Excel
  • Creating Custom Lists
  • Incrementing Numbers & Dates

Working with Multiple Worksheets

  • Switching between sheets
  • Inserting / Renaming / Deleting sheets
  • Moving / Copying sheets
  • Group Edit
  • Linking sheets using Formulae
  • Breaking Links

Charts and Drawing Tools

  • Creating a chart
  • Changing the Chart Type
  • Changing / Adding chart elements
  • Formatting charts
  • Moving / Resizing the chart
  • Creating combined charts
  • Displaying data on a secondary axis

Database Features

  • Sorting Records
  • Using AutoFilter

Working with Dates

  • Formatting Dates
  • Date Calculations
  • The Today Function