Master the Excel 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 a 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 day.

FAQs

• Do I have to book using Eventbrite?No. You can simply contact us at [email protected] with your name, organisation, billing address and a note of any access issues. We will issue an invoice in advance of your attendance.What refreshments are served at the training?Two free rounds of tea, coffee and biscuits are served on arrival and at mid-morning. There is also a sandwich and wraps lunch served as part of the ticket cost.Is there disabled access?The venue is fully accessible, although wheelchair entry has to be from the rear of the building, as there are steps at the front. Please let us know in advance of any access requirements.What can/can't I bring to the event?No need to bring equipment or laptop unless we specifically ask in the training descriptor. Pen and paper may be handy for notes.Is my registration/ticket transferrable?If you want to transfer to another training course, please contact us with five or more days’ notice at [email protected]Do I have to bring my printed ticket to the event?No needWhat 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

Host or Publisher Civicos Training and Communications CiC