Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons
Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htm
In this video learn about All the ways to make conditional Calculations with Formulas in Excel: Built-in Functions like SUMIFS, AND function, OR Function, IS Functions, Array Formulas, D Functions and more:
1. (00:23) Introduction
2. (01:28) AND Logical Test (AND Criteria)
3. (02:35) AND Function
4. (05:14) SUMIFS, COUNTIFS, AVERAGEIFS functions with AND Criteria
5. (05:43) Create Names From Selection
6. (10:55) Cross Tabulated Table for adding with 3 criteria: SUMIFS and Mixed Cell References.
7. (13:51) Between Logical Tests, Create Monthly Sales Report with SUMIFS.
8. (18:39) Create Monthly Sales Report with SUMIFS and EOMONTH functions.
9. (21:44) Count Sales Between Upper and Lower Limit (Frequency Table) with COUNTIFS (Alos consider how this method is different from FREQUENCY Array Function).
10. (25:40) D Functions (Database functions) with AND Criteria
11. (32:31) Array Formulas with AND Criteria. Use Two IF Functions. See how to calculate Standard Deviation with two conditions or criteria.
12. (41:15) OR Logical Test (OR Criteria)
13. (42:26) Defined Names and Scope in an Excel Workbook
14. (44:03) OR Function
15. (46:34) OR Criteria looking at one column using SUMIFS and SUMPRODUCT for adding and COUNTIFS and SUMPRODUCT for counting. Function Argument Array Operations.
16. (49:08) Average calculation with OR Criteria: AVERAGE & Array Formula (for 1 or more columns)
17. (01:01:10) D Functions (Database functions) with OR Criteria
18. (01:05:00) AND and OR and IF Functions for Credit Analysis for Accounts Receivable Department
19. (01:12:42) IF Function & IS functions. Bank Checkbook Example.
20. (01:20:17) Conditional Calculations: PivotTable or Formulas?
21. (01:22:18) Summary
Видео Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons канала excelisfun
In this video learn about All the ways to make conditional Calculations with Formulas in Excel: Built-in Functions like SUMIFS, AND function, OR Function, IS Functions, Array Formulas, D Functions and more:
1. (00:23) Introduction
2. (01:28) AND Logical Test (AND Criteria)
3. (02:35) AND Function
4. (05:14) SUMIFS, COUNTIFS, AVERAGEIFS functions with AND Criteria
5. (05:43) Create Names From Selection
6. (10:55) Cross Tabulated Table for adding with 3 criteria: SUMIFS and Mixed Cell References.
7. (13:51) Between Logical Tests, Create Monthly Sales Report with SUMIFS.
8. (18:39) Create Monthly Sales Report with SUMIFS and EOMONTH functions.
9. (21:44) Count Sales Between Upper and Lower Limit (Frequency Table) with COUNTIFS (Alos consider how this method is different from FREQUENCY Array Function).
10. (25:40) D Functions (Database functions) with AND Criteria
11. (32:31) Array Formulas with AND Criteria. Use Two IF Functions. See how to calculate Standard Deviation with two conditions or criteria.
12. (41:15) OR Logical Test (OR Criteria)
13. (42:26) Defined Names and Scope in an Excel Workbook
14. (44:03) OR Function
15. (46:34) OR Criteria looking at one column using SUMIFS and SUMPRODUCT for adding and COUNTIFS and SUMPRODUCT for counting. Function Argument Array Operations.
16. (49:08) Average calculation with OR Criteria: AVERAGE & Array Formula (for 1 or more columns)
17. (01:01:10) D Functions (Database functions) with OR Criteria
18. (01:05:00) AND and OR and IF Functions for Credit Analysis for Accounts Receivable Department
19. (01:12:42) IF Function & IS functions. Bank Checkbook Example.
20. (01:20:17) Conditional Calculations: PivotTable or Formulas?
21. (01:22:18) Summary
Видео Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons канала excelisfun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Highline College Busn 218 Advanced Excel Fall, 2024 IntroductionHighline College Busn 210 Excel Statistical Analysis Fall, 2024 IntroductionYTL Excel #130: Income Statement from Excel Table: Array ForExcel Finance Class 74: IRR and Non-conventional Cash Flows, Plot Chart To See Multiple IRRCtrl + Shift + Enter: Excel Array Formulas #05: Function Argument Array OperationsFree Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big DataIntroduction to the excelisfun Channel @ YouTube: Excel & Power BI Videos & Free Classes_Store Full Table to One Column? Excel Power Query Puts Records in One Cell! Excel Magic Trick1734.Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756Excel 2013 Statistical Analysis #5 Data Categorical, Quantitative, Nominal, Ordinal, Interval, RatioMSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Classexcelisfun’s new book The Only App That Matters Book is Released!!! Microsoft 365 Excel = The Best!MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different CountriesSpilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to ExcelMSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database SizeOffice 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/ConditionsHighline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668.E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations