Excel Data Analysis Full Course Tutorial

Excel Data Analysis Full Course Tutorial

Learnit Training via YouTube Direct link

Start

1 of 83

1 of 83

Start

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

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.