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

Introduction and Course Topics

Previous 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