top of page

Take your Excel skills to another level - master the IF Functions

Out of all the Excel functions, the IF function is probably the most useful. It lets us tell Excel to look for a condition and perform one action if it is true or another action if it is false.

The IF Function doesn’t stop there, though – it will also let you count only those items in a list that meet your criteria, or let you define several criteria that can be either dependent or mutually exclusive.

This one day course uses our own Excel worksheet to take you through the different uses of the IF Function. There is plenty of scope for questions, and each section comes with a series of exercises, to let you get to grips with your new knowledge.

We look at:

· The basic IF statement

· Repeating IF statements

· The IF Function and Relative Vs Absolute addressing

· Nested IF statements

· The IFS function – Excel’s new, easier way to code

· Meeting more than one condition

· Conditions that are mutually exclusive

· COUNTIF and SUMIF – use IF to count or total only what you need to count or total, and ignore the rest.

We use our specially-designed booklet to take you through the various lessons Each lesson comes with its own practise exercises, and questions are encouraged by the tutor, who will also be on hand to help you with anything you get suck on.

The booklet is yours to keep, and the course also comes with free access for six months to our free online Excel helpdesk, so you can contact us at any point for help if you are stuck on an Excel problem.


Attendees may bring their own laptop, or work from one of ours, supplied on the d

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 or call us on 07415 652 522

Master the Excel IF Functions :

"Fantasic trainer!  I have always struggled with Excel and his walk through and workbook to work alongside was just brilliant! Looking forward to using my new skill and building on it."


Robertson House, 152 Bath Street, Glasgow G2 4TB

Tuesday, 12 November 2024

09.30 - 16.30


If you would like to chat with us about a course before booking email us at or call us on 07415 652 522

ZOOM LOGO smaller.png
App Screens

Public Relations and Communication

Civicos has thirty years experience of public relations and communication work and we are available to help your organisation to polish your  image and get your message across.

Electronic Devices on Table

Web Design and Social Media 

Civicos can help  you to write all of the 'copy' for your new website, and then build the actual site for you.  We'll also help you to maintain your new site, and train your staff in its different functions, if needed. 

Business Team

Training Needs Analysis

FREE from Civicos:  A Training Needs Analysis report for your organisation

Find out your staff training needs – and save £££s on cost. We will be delighted to perform a FREE, absolutely no-commitment Training Needs Analysis for your organisation.

bottom of page