Microsoft Office & 365 Apps
Excel - Functional Logic
A one-hour live class on conditional functions such as SUMIF, COUNTIF, AVERAGEIF and IF to answer questions about specific categories of data.
1 hourIntermediate1 modules
About this course
A one-hour live class on conditional functions such as SUMIF, COUNTIF, AVERAGEIF and IF to answer questions about specific categories of data.
Curriculum
1 modules
- Summarize data with SUMIF, COUNTIF, and AVERAGEIF
- Answer specific questions about specific categories of data using conditional summary functions.
- Analyze with logical functions and use logical operators and work with logical functions such as if, and, or, and not.
- Use nested if functions inside other if functions and combine them with other functions to create advanced logical tests.
- New functions and learn about ifs and switch functions.
- Handle errors with functions and use the IFNA and IFERROR functions to circumvent errors.
Who it's for
Excel users who summarise data.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Advanced
55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →Intermediate
55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Intermediate
Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.