Excel - IF, CountIF, SumIF and AverageIF

Course

Online

£ 10 + VAT

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

Online

Start date

Different dates availableEnrolment now open

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

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

Analyzing Data using IF Formulas 2 lectures 19:54 Introduction to IF Statements Creating IF Statements to Analyse Data Analyzing Data using IF Formulas 2 lectures 19:54 Introduction to IF Statements Creating IF Statements to Analyse Data Introduction to IF Statements Introduction to IF Statements Introduction to IF Statements Introduction to IF Statements Creating IF Statements to Analyse Data Creating IF Statements to Analyse Data Creating IF Statements to Analyse Data Creating IF Statements to Analyse Data Summarising Data with CountIF, SumIF and AverageIF 3 lectures 28:20 Summarising data with CountIF Using SumIF to Add up values based on criteria AverageIF to calculate averages against a criteria Summarising Data with CountIF, SumIF and AverageIF 3 lectures 28:20 Summarising data with CountIF Using SumIF to Add up values based on criteria AverageIF to calculate averages against a criteria Summarising data with CountIF Summarising data with CountIF Summarising data with CountIF Summarising data with CountIF Using SumIF to Add up values based on criteria Using SumIF to Add up values based on criteria Using SumIF to Add up values based on criteria Using SumIF to Add up values based on criteria AverageIF to calculate averages against a criteria AverageIF to calculate averages against a criteria AverageIF to calculate averages against a criteria AverageIF to calculate averages against a criteria

Additional information

Students are only required to have a basic understanding of formulas

Excel - IF, CountIF, SumIF and AverageIF

£ 10 + VAT