Making Progress with MS Excel - Level Two

Making Progress in Microsoft Excel - Intermediate level

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 over two sessions of 3.5 hours, 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, multipl 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

FAQS ABOUT THE COURSE

Do I have to book using Eventbrite?

No. You can simply contact us at training@civicostraining.org with your name, organisation, billing address and a note of any access issues. We will issue an invoice in advance of your attendance.

Is my registration/ticket transferrable?

If you want to transfer to another training course, please contact us with five or more days’ notice at training@civicostraining.org

What is the refund policy?

Civicos Training requires five working days' notice of cancellation. We will always attempt to place you on a later version of the same course, or transfer your booking to another course at no extra cost. However, if you cancel with less than the required notice, we do reserve the right to charge for the full cost of the course