Completed
Nesting AND with IF
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Data Analysis Full Course Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction - Excel Intro to Data Analysis
- 3 List Design Basics
- 4 Inserting Tables for Analysis
- 5 Filtering Data in Tables
- 6 Using the Total Row
- 7 Conditional Formatting
- 8 IF Function
- 9 SUMIF and AVERAGEIF
- 10 SUMIFS
- 11 Inserting Recommended Charts
- 12 Adjusting Charts
- 13 Sparklines
- 14 Inserting Pivot Tables
- 15 Displaying Data as Count
- 16 Filtering Pivot Tables
- 17 Inserting Pivot Charts
- 18 Conclusion - Intro to Data Analysis
- 19 Introduction - Excel Pivot Tables
- 20 What are Pivot Tables?
- 21 Preparing Data for Analysis
- 22 Pivot Table Components
- 23 Building Pivot Tables to Show Different Values
- 24 Adding Fields to Pivot Tables
- 25 Using Built-In Filters
- 26 Filtering Data with Slicers
- 27 Displaying New Values from Data Sources
- 28 Inserting Pivot Charts
- 29 XLOOKUP
- 30 Joining Data Sets with XLOOKUP
- 31 Introduction to Advanced Pivot Tables
- 32 Inserting Pivot Tables from Tables
- 33 Calculated Fields
- 34 Using the Timeline Tool
- 35 Report Filter Pages
- 36 Pivot Table Layouts
- 37 Creating Pivot Table Designs
- 38 Adding Power Pivot Tabs to the Ribbon
- 39 Adding Tables to Power Pivot Data Model
- 40 Creating Table Relationships
- 41 Creating Columns with DAX Expressions
- 42 Displaying New Source Data in Power Pivot Tables
- 43 Data Mining with Flash Fill
- 44 Conclusion - Excel Pivot Tables
- 45 Introduction - Excel Copilot
- 46 What is Copilot?
- 47 Setting Up Copilot in Excel
- 48 Copilot Pane and Insights
- 49 Visualizing Data with Copilot
- 50 Sorting, Highlighting, and Filtering
- 51 Adding Formulas with Copilot
- 52 Asking Copilot Questions
- 53 Accessing Copilot Lab
- 54 Copilot Lab
- 55 Copilot with Excel Web Version
- 56 Conclusion - Excel Copilot
- 57 Introduction - Excel Power User
- 58 IF Function Basics
- 59 IF Functions with Calculations
- 60 Nesting AND with IF
- 61 Naming Ranges and COUNTIF
- 62 SUMIF and AVERAGEIF
- 63 SUMIFS
- 64 XLOOKUP
- 65 Populating Forms with XLOOKUP
- 66 Displaying Pivot Table Fields with COUNT Function
- 67 Calculated Fields
- 68 Slicers
- 69 Using the Timeline
- 70 Inserting Report Filter Pages
- 71 Flash Fill for Text Functions
- 72 Introduction to Advanced Conditional Formatting and Macros
- 73 Array Formula Basics
- 74 Looking Up Multiple Values with XLOOKUP
- 75 Array Functions
- 76 Advanced Conditional Formatting
- 77 Combo Charts
- 78 Developer Tab
- 79 Macro Basics
- 80 Relative Reference Macros
- 81 VBA Basics
- 82 Cleaning Up Macros
- 83 Conclusion - Excel Power User
