Print this page
back to courses

Excel Intermediate 1 & 2

This course is for existing users of Excel who wish to who wish to improve competence working with calculations, large spreadsheets, and lists.
You can choose to do Intermediate session 1 or 2 or both depending on your requirements.

Duration 3 hours for each session (full day for both)
Group Size Up to 10 people maximum
Prerequisite No Prerequisite
Course type Microsoft 365
Training Room Requirements Meeting Room
TV/Projector
PC/Laptop with Windows 10
Remote Training Requirements Sessions will be hosted using either Webex or Microsoft Teams sessions
Attendees must have access to a PC/ Laptop that can access Webex or Microsoft Teams
Note This course should take place before a cutover

Course Content

Delegates will undertake the following modules:

Excel Intermediate session 1:

Formulas and Functions

  • Revision of basic formulas & AutoSum
  • Creating statistical functions
  • Using absolute & mixed cell addresses
  • Using the Insert Function button
  • Testing data using the IF function (to include IFS)
  • The ERROR function

Formula Auditing

  • Tracing precedents and dependents
  • Tracing errors
  • Showing formulas

Multiple Worksheets

  • Inserting & deleting worksheets
  • Colour-coding worksheet tabs
  • Moving and copying worksheets
  • Grouping worksheets for formatting and printing
  • Linking cells between worksheets
  • Creating calculations across worksheets

Excel Intermediate session 2:

Lists

  • Sorting lists
  • Filtering lists
  • AutoSum with lists
  • Formatting a list as a table

Managing Large Worksheets

  • Freezing columns and rows
  • Splitting the screen
  • Hiding & unhiding columns and rows

Printing

  • Printing a selection
  • Setting & clearing print areas
  • Scaling a sheet to fit
  • Centring horizontally & vertically
  • Inserting & removing page breaks
  • Headers & footers revision
  • Repeating titles on each page

Request more information on any of our courses

Contact Us