Making Progress in MS Excel: Level Two

11 – 12 March 2024

Please note that places on this course have now been filled. Use the form below to join the waiting list for this session, and to be notified when another session is scheduled.

If you have some existing knowledge of Excel functions and wish to enhance and refresh your skills, this course is for you.

This course takes place on Monday 11th and Tuesday 12th March via Microsoft Teams, 9:30 – 13:30 both days.

This is your chance to dig in deeper to your SUMIFS, ISBLANKS and VLOOKUPS amongst other things.

Learn to organise table data, present data as charts and enhance the look and appeal of workbooks by adding graphic objects. Upon successful completion of this course, you will have the necessary skills to:

  • Organise worksheet and table data using various techniques
  • Create and modify charts
  • Manipulate more complex formulas and functions
  • Insert and modify graphic objects in a worksheet
  • Customise and enhance workbooks and the MS Excel environment

Course content:

  • Further formulas and functions, working with dates and percentages, functions and the formula palette, absolute cell addressing, displaying underlying formula
  • Printing and custom formatting, hiding columns and outlining
  • Working with multiple worksheets and creating a workspace
  • Filtering, sorting and analysing data and using subtotals
  • Creating, modifying, and printing charts with further customisation
  • Sharing workbooks, worksheet auditing and adding comments

Places on the course are limited and learners are expected to take part in hands-on activities. To get the best out of this online course the attendees should have access to a large screen device.

The course will be delivered online using MS Teams and it will take place over two morning sessions. Participants need to join both sessions.

To apply, fill in this form (As mentioned above: course spaces have now been allocated and by completing this form you will be added to the course waiting list to be notified if a place becomes available, or when the course is scheduled to run again in future): 


Our online forms use javascript to enable advanced features such as saving and continuing later, and to improve security. Please either enable javascript for this site or contact your IT department for further help.

Excel Level 2 March 2024

    This course is only open to UNISON members
  • If you don’t know your membership number please tell us your home postcode so we can find it for you.
  • We will use this information to check your UNISON membership and to send you information about attendance. If we are able to offer you a place on your chosen course, then you will receive an email from us with further information.
  • UNISON Learning & Organising Equality Monitoring Form

  • This section of the form is entirely voluntary; however your co-operation would be appreciated. UNISON gathers this information so that participation in education and training can be monitored. This allows us to identify where there are areas of underrepresentation and work with our colleagues in the wider union to address any barriers to equal access.
  • We appreciate that some of the categories below are limited, but within these constraints, please give the answer most applicable to you.
  • This information will be used to update your UNISON membership records and will be treated in the strictest confidence.