Excel - IF, CountIF, SumIF and AverageIF
Course
Online
Description
-
Type
Course
-
Methodology
Online
-
Start date
Different dates available
So, you've mastered the basics but now need to step up a gear! The IF Formula is one of those functions that, since the early versions of Excel, remains useful, practical and almost essential to any Excel user, regardless of what you do on Spreadsheets. Learning about IF Formulas will be ideal for anyone who is (but not limited to):A business professional who needs to upskill
Applying for a job which requires 'Excellent use of Excel skills etc
A graduate who needs to fill in skill gaps to make their CV stand out more
An advanced user but needs refreshing and looking to pick up some new tips and shortcutsThis course will introduce you to what an IF Formula is, where it can be used and how to set one up. You'll also be shown how these can be used in reporting on large datasets to produce summaries. There will be practical examples and real life situations to work through with the exercises attached.Enjoy learning your new skills and putting them to use!Who is the target audience?All Excel users from beginner to advanced
Facilities
Location
Start date
Start date
About this course
Understand IF Statements and when to use them
Creating an IF Statement to analyse data
Using CountIF, SumIF and AverageIF to summarise and report on your data
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
- MS Excel
- Excel
Course programme
Additional information
Excel - IF, CountIF, SumIF and AverageIF
