Study Learn Grow
Excel - IF, CountIF, SumIF and AverageIF

Excel - IF, CountIF, SumIF and AverageIF


There will be practical examples and real life situations to work through with the exercises attached.

Overview

About this Course
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 shortcuts
This 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!
Basic knowledge
Students are only required to have a basic understanding of formulas

Course Information

Students are only required to have a basic understanding of formulas

What you will learn
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

All Excel users from beginner to advanced

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs