easyT
  • Subscribe
Sign In
easyT
  • Diplomas
  • Courses
  • E-books
  • Instructors
  • Subscribe
Sign In

Browse

  • All courses
  • Diplomas
  • Subscribe
  • Instructors

Account

  • My courses
  • Purchases
  • Wishlist
  • Settings

Join us

  • Become an instructor
  • Affiliate program
  • About us

Get the app

Apps in development
All rights reserved © 2003-2026 · easyT.onlineTerms & conditionsPrivacy policyRefund policyContact usVerify a certificate
Course page

Functions, Constraints, and Advanced Reports

Your progress
0%

Your progress reflects only what you've actually watched

Advanced Sumif/Sumifs Functions

Next lesson

Notes

Write notes as you watch, pinned to the exact moment in the video, and revisit them anytime.

Available with a subscription

Bookmarks

Mark the important moments in the video with one tap and jump straight back to them.

Available with a subscription

Zico — your learning guide

Summarizes the lesson, re-explains any point, answers your questions, and quizzes you after each lesson.

Available with a subscription

Community

Discuss with your coursemates, ask questions, and share what you know inside every lesson.

Available with a subscription
Your course progress0%
0 of 24 lessons
  • Introduction and Course Topics5:25
  • Advanced Sumif/Sumifs Functions13:12
  • Calculating Average with One or More Conditions Averageif/Averageifs6:29
  • Advanced Countif/Countifs Functions6:20
  • Logical IF Function (Simple and Compound)10:42
  • Vlookup/Hlookup Functions11:04
  • Aggregate Function That Can Bypass Errors7:48
  • INDEX/MATCH Functions and How to Combine Them11:07
  • Types of Cell References12:16
  • Pivot Table & Slicer15:12
  • Database Functions11:33
  • Macros6:42
  • Using the Scenario Analysis Tool for Forecasting and Deriving Potential Outcomes8:46
  • Goal Seek6:05
  • Printing8:36
  • Advanced Conditional Formatting Using Formulas8:49
  • Advanced Filter9:03
  • Custom List7:28
  • Solver7:04
  • Breakeven Point10:48
  • Integrated Accounting System from A to Z (Part One)29:51
  • Integrated Accounting System from A to Z (Part Two)28:59