BloomTech’s Downfall: A Long Time Coming

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

YouTube

Conditional Calculations with Excel Formulas - Comprehensive Lessons

ExcelIsFun via YouTube

Start learning Write review

Overview

Limited-Time Offer: Up to 75% Off Coursera Plus!
7000+ certificate courses from Google, Microsoft, IBM, and many more.
India: 75% Off World: 40% Off
This course teaches learners how to make conditional calculations with Excel formulas, covering built-in functions like SUMIFS, AND, OR, IS functions, array formulas, and D functions. The course includes creating names from selection, generating monthly sales reports, counting sales between upper and lower limits, using IF functions, and analyzing credit for accounts receivable. The teaching method involves comprehensive lessons with practical examples and demonstrations. This course is intended for individuals looking to enhance their Excel skills, particularly those interested in data analysis, reporting, and financial modeling.

Syllabus

) Introduction.
) AND Logical Test (AND Criteria).
) AND Function.
) SUMIFS, COUNTIFS, AVERAGEIFS functions with AND Criteria.
) Create Names From Selection.
) Cross Tabulated Table for adding with 3 criteria: SUMIFS and Mixed Cell References..
) Between Logical Tests, Create Monthly Sales Report with SUMIFS..
) Create Monthly Sales Report with SUMIFS and EOMONTH functions..
) Count Sales Between Upper and Lower Limit (Frequency Table) with COUNTIFS (Alos consider how this method is different from FREQUENCY Array Function)..
) D Functions (Database functions) with AND Criteria.
) Array Formulas with AND Criteria. Use Two IF Functions. See how to calculate Standard Deviation with two conditions or criteria..
) OR Logical Test (OR Criteria).
) Defined Names and Scope in an Excel Workbook.
) OR Function.
) OR Criteria looking at one column using SUMIFS and SUMPRODUCT for adding and COUNTIFS and SUMPRODUCT for counting. Function Argument Array Operations..
) Average calculation with OR Criteria: AVERAGE & Array Formula (for 1 or more columns).
) D Functions (Database functions) with OR Criteria.
) AND and OR and IF Functions for Credit Analysis for Accounts Receivable Department.
) IF Function & IS functions. Bank Checkbook Example..
) Conditional Calculations: PivotTable or Formulas?.
) Summary.

Taught by

ExcelIsFun

Reviews

Start your review of Conditional Calculations with Excel Formulas - Comprehensive Lessons

Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.