Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

How to Use IF, IFS, COUNTIFS, SUMIFS, IFERROR, and IFNA in Excel

Simon Sez IT via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore Excel's logic functions in this comprehensive 21-minute tutorial. Master nested IF statements for complex conditions and simplify them with the IFS function. Learn to use COUNTIFS and SUMIFS for efficient counting and summing based on multiple criteria. Discover error handling techniques with IFERROR and IFNA to manage NA errors and more. Enhance spreadsheet skills through practical examples and expert guidance. Gain valuable insights to streamline formulas and improve Excel proficiency for more effective data analysis and reporting.

Syllabus

How to Use IF, IFS, COUNTIFS, SUMIFS, IFERROR, and IFNA in Excel

Taught by

Simon Sez IT

Reviews

Start your review of How to Use IF, IFS, COUNTIFS, SUMIFS, IFERROR, and IFNA in Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.