Making Progress in Microsoft Excel - Intermediate level

Delivered online, via Teams, over one day, 23 June 2027

This course is for people who are already familiar with the basic functions of Microsoft Excel and would like to take their skills to another level. It is delivered  using segmented lessons that are backed up by short exercises that the tutor takes you through. Content includes:

• Reviewing the basics: a reminder on the ribbon, formatting, simple formulas etc

• Using dates in Excel

• Using IF with the basic formulas - for example, tell Excel to sum items ONLY if a defined criteria is met

• The stand-alone IF function. This is when Excel starts to get really useful. For example, IF cell A2 is greater than 5, multiply celll B2 by 3, otherwise, do nothing.

• Absolute and Relative References: locking formulas to specific data

• Using the LOOKUP functions. Excel's other great tool - learn to lookup yout data according to your specified conditions

• The concept of Helper columns. Find out how a helper column can make your formulas work better.

• Naming a range. Give a specified range a name, so you can use it again and again

 A Teams invitation wil be sent to attendees a few days in advance of the course. If you are unused to online meetings or online training, we shall be very happy to arrange a pre-course trial-run on Teams, to  let you feel more at home with its features.

The course is delivered using our purpose-built Excel booklet, which is sent to  you in advance and is yours to keep.

And attendees also have free access to an online Excel helpdesk for six months, where we will be happy to provide online refreshers, or help with any issue you have.

This Excel training can be delivered as an in-house session. 

We will be happy to arrange either an online or a classroom session of this course for up to 12 of your staff, at a time that suits best for you, The cost can be as low as £45 per attendee.

For a no-commitments chat please contact training@civicostraining.org or call us on 07415 652 522