fbpx

Excel Intermediate

excelintermediate.png

Description

This course is for users who have either completed the Beginner course or who have gained sufficient experience to be familiar with the Beginner topics.

 

Duration

Classroom: 1 day

Online: 2 half days

 

Session 1: November 10th 9.15am - 12.45pm

Session 2: November 24th 9.15am - 12.45pm

 

Content

  • Be comfortable with the content of the Beginner course – revision of this if required
  • Revision of use of absolute and fixed cells references
  • Be able to insert and delete rows and columns
  • Be able to create a chart in a number of different formats
  • Insert, rename, move, copy sheets within and between spreadsheets
  • Be able to link sheets, so that changes in one are automatically updated in another
  • Set up a list, do simple and complex sorting (including multiple levels, by colour and by icon)
  • Use basic If Function
  • Introduction to Conditional Formatting
  • Introduction to VLookup Function
  • Formatting a list as a table – why and when you do it
  • Introduction to Pivot Tables
  • (If time allows) Introduction to Countif/Sumif/Countifs/Sumifs

 

Upcoming Dates (online)

Session 1: August 31st 9.15am - 12.45pm

Session 2: September 7th 9.15am - 12.45pm

 

 

This training will be delivered by Anne Walsh - The Excel Expert