Completed
- Introduction to Power Query in Excel
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Complete Microsoft Excel Tutorial 2024 - From Basics to Advanced
Automatically move to the next video in the Classroom when playback concludes
- 1 - Beginning
- 2 - Introduction to Excel
- 3 - Cell referencing
- 4 - What is a Formula in Excel
- 5 - How to enter a formula
- 6 - Precedence order of operations
- 7 - Smallest and Largest Value
- 8 - Function in workbook
- 9 - Multiple Values at once
- 10 - How to Enter Copy Edit and Hide a Formula
- 11 - Precedence order of operations
- 12 - Tables and Borders in Excel
- 13 - Date and Time Function in Excel
- 14 - Introduction to Conditional Formatting - Formatting in Excel
- 15 - Cells that Contain
- 16 - Greater than
- 17 - Top Bottom Values
- 18 - Unique and Similar Values
- 19 - Data Bars
- 20 - Color Scales
- 21 - Icon Sets
- 22 - Formula Based
- 23 - More Rule Types
- 24 - Google Sheets
- 25 - Color Scales in Google Sheets
- 26 - What is VLOOKUP
- 27 - VLOOKUP Function in the Same Sheet
- 28 - VLOOKUP Function in a Different Sheet
- 29 - VLOOKUP Function in a Different Workbook
- 30 - Copy VLOOKUP Function
- 31 - Lookup Functions
- 32 - Introduction to Power Query in Excel
- 33 - Understanding Functions for Power Query
- 34 - Data Transfering and Cleaning
- 35 - Power Query Dashboard Overview
- 36 - Introduction to Data Analytics
- 37 - Phases of Data Analytics Project
- 38 - Data Cleaning
- 39 - Data Validation
- 40 - Sort and Filter
- 41 - Data Visualisation Using Excel
- 42 - Introduction to Graphs and Charts in Excel
- 43 - Insert Slicer
- 44 - Style Options
- 45 - Refresh
- 46 - Various Tools
- 47 - Pivot Table and Its Importance
- 48 - How to Create a Pivot Table
- 49 - Pivot Tables in Excel
- 50 - Change Data Source
- 51 - Introduction to Budgeting
- 52 - Budget Categories and Budgeting Methods
- 53 - Types of Financial Goals
- 54 - Creating Budget using Excel
- 55 - Introduction to Savings and Investments
- 56 - Tips to Avoid Debts
- 57 - Introduction to AI
- 58 - Introduction to ChatGPT
- 59 - Understanding Excel Using ChatGPT
- 60 - Generating Excel Functions Using ChatGPT
- 61 - Preparation of Financial Statements using ChatGPT
- 62 - Dashboard Analysis using ChatGPT
- 63 - Interpretations of Financial Reports using ChatGPT
- 64 - Basic Level Tips
- 65 - Intermediate Level Tips
- 66 - Advanced Level Tips
