AI, Data Science & Business Certificates from Google, IBM & Microsoft
AI Engineer - Learn how to integrate AI into software applications
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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