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

إكسل محاسبي متقدم

This lesson is for subscribers only

Buy the course on its own, or subscribe for full access to every course on the platform.

Lessons marked withare free to preview.

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
Sign in
See plans