M365 Excel Basics Video 6: Excel Table Feature and Calculations with more than one Criteria

Download Excel File: https://people.highline.edu/mgirvin/A...
Pdf File: https://people.highline.edu/mgirvin/A...

This is a BUSN 216 Class Video. In this video we will learn the three types of formulas, we will learn the Excel Table Feature, Naming the Excel Tables, Advantages of using Excel Table Formulas and how to create Define Names for the Cells Ranges, single Cell and Tables.

Topics:
00:00 Introduction and Topics to cover in this video
01:24 3 types of Formulas explained
04:10 Types of Formula calculation Examples
04:31 Traditional Formula (Single-Input, Single-Output Formula)
05:50 Dynamic Spilled Array Formula
07:23 Excel Table Formula
09:03 Naming a Table
12:57 COUNTIFS Function using the Excel Table Formula
26:51 Adding Conditional Formatting
30:31 COUNTIFS Function with a comparative operator using the Excel Table Formula
31:31 Different Options of how to convert a Proper Dataset to an Excel Table
38:42 AVERAGEIFS using the Excel Table Formula
45:18 SUMIFS using the Excel Table Formula
53:46 Adding new records to an Excel Table
56:35 Creating Define Names
01:03:49 SUMIFS using the Excel Table Formulas and the Define Names for our cell reference
01:09:48 Summary



Mary Kajoka
Business Department Instructor
Highline College