Completed
Excel 365 Basics #5: IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 365 Basics - Learn to Efficiently Use Excel at Work and to Get a Job
Automatically move to the next video in the Classroom when playback concludes
- 1 Excel 365 Basics #1: What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup
- 2 Excel 365 Basics #2: SUMIFS, COUNTIFS, COUNT, COUNTA, ROWS, SUM & IF Functions to Add & Count
- 3 Excel 365 Basics #3: Number Formatting as Façade & when you MUST use ROUND Function
- 4 Excel 365 Basics #4: Date & Time Formulas, Functions & Formatting: All The Basics You Need to Know
- 5 Excel 365 Basics #5: IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More
- 6 Excel 365 Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!
- 7 Excel 365 Basics #7: Comprehensive Formula & Function Lesson To Become An Excel Formula Guru!
- 8 MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34
- 9 MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!
- 10 Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video
- 11 MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!
- 12 MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.
- 13 MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve!
- 14 MS 365 Excel Basics #10 Part 03: FILTER Array Function to Dynamically Filter!
- 15 MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total
- 16 MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too!
- 17 MS 365 Excel Basics 12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data Model
- 18 MS 365 Excel Basics #13: Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas
