Learn Excel & Sheets Free

Start with 3 Cool Effects You Did NOT Think are Possible in PowerPoint (11 min, Leila Gharani), then Excel for Data Analytics - Full Course for Beginners (660 min, Luke Barousse). All 1301 lessons here are free, from the teachers' own official uploads. You'll need laptop stand, noise-cancelling headphones, second monitor and a few more basics (about $270 of kit). The book to keep beside you: Excel Formulas and Functions for Dummies by Ken Bluttman.

What you'll need

Laptop stand: Screen at eye level for long study sessions.
Noise-cancelling headphones: Focus through long video lessons.
Second monitor: Video on one screen, practice on the other.
Wireless keyboard and mouse: Comfortable for hours of typing.

Lessons

3 Cool Effects You Did NOT Think are Possible in PowerPoint | Morph (11 min, Leila Gharani, Intermediate)
Excel for Data Analytics - Full Course for Beginners (660 min, Luke Barousse, Beginner)
Stop Writing Huge Excel Formulas. (Use ONE DOT Instead) (10 min, Leila Gharani, Intermediate)
Pictogram Charts in Excel: Add Icons to Bars [Rounded + Dynamic] (16 min, Leila Gharani, Intermediate)
The Excel Timeline chart you'll actually keep using (free template included) (11 min, Leila Gharani, Intermediate)
14 New Excel Functions: TEXTSPLIT, VSTACK, TAKE and More (11 min, Leila Gharani, Intermediate)
Microsoft PowerToys Tutorial: Free Tools for Windows 11 (13 min, Leila Gharani, Intermediate)
TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips included (13 min, Leila Gharani, Intermediate)
7 Excel Mistakes You Must Stop Making (15 min, Leila Gharani, Intermediate)
Make Beautiful Excel Charts Like The Economist (file included) (19 min, Leila Gharani, Intermediate)
Advanced Pivot Table Techniques (to achieve more in Excel) (12 min, Leila Gharani, Advanced)
Excel for Accounting - 10 Excel Functions You NEED to KNOW! (19 min, Leila Gharani, Intermediate)
Excel Time-Savers - 5 Hidden Features for Busy People (14 min, Leila Gharani, Intermediate)
Excel Tutorial for Beginners (16 min, Kevin Stratvert, Beginner)
How an Excel Expert Sets Up Their Spreadsheet (6 Settings) (10 min, Leila Gharani, Advanced)
How I use Excel as a Data Analyst (12 min, Luke Barousse, Intermediate)
How to Use XLOOKUP in Excel (5 Practical Examples) (14 min, Leila Gharani, Intermediate)
Python in Excel: 1-minute Hacks You Can Use Today (10 min, Leila Gharani, Intermediate)
You Won't Believe These Crazy PIVOT TABLE Hacks! (12 min, Leila Gharani, Intermediate)
Business Math & Statistics Using Excel For Data Analysts and Data Scientists (85 min, codebasics, Intermediate)
Excel's NEW Checkboxes Are Incredibly Cool! Here's why (14 min, Leila Gharani, Intermediate)
Full Project in Excel (41 min, Alex The Analyst, Intermediate)
Python in Excel Tutorial for Beginners (=PY, pandas, Charts) (19 min, Leila Gharani, Beginner)
Stop Doing Extra Work in Excel! (8 Hidden Features) (12 min, Leila Gharani, Intermediate)
Stop Sending Ugly Pivot Tables to Your Boss (16 min, Leila Gharani, Intermediate)
4 Hidden Excel Dashboard Design Tips for Beautiful Reports (11 min, Leila Gharani, Intermediate)
Excel Shortcuts You SHOULD Know! (9 min, Leila Gharani, Intermediate)
Excel Tutorial for Beginners | How to Use Excel (16 min, Leila Gharani, Beginner)
10 INCREDIBLE things Google Sheets can do Right Now! (13 min, Jeff Su, Intermediate)
3 PowerPoint HACKS for INSTANT Improvement (incl. Morph between Shapes) (9 min, Leila Gharani, Intermediate)
5 Excel Functions EVERYONE Needs (12 min, Leila Gharani, Intermediate)
Accounting Basics Explained Through a Story (10 min, Leila Gharani, Beginner)
Answering Your Questions: My Age, Nose, Marriage, Background (1 Million Subscriber Milestone) (27 min, Leila Gharani, Intermediate)
Cleaning Data in Excel (21 min, Alex The Analyst, Intermediate)
Create INTERACTIVE Excel Dashboards With Option Buttons | How to use Radio Buttons (14 min, Leila Gharani, Intermediate)
Do you know these 5 PowerPoint Hacks? (10 min, Leila Gharani, Intermediate)
Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup (63 min, ExcelIsFun, Beginner)
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!) (13 min, Leila Gharani, Intermediate)
FREE Windows Apps You Should be Using (who thought these are ACTUALLY FREE?!) (8 min, Leila Gharani, Intermediate)
Google Sheets BEATS Excel with THESE 10 Features! (17 min, Leila Gharani, Intermediate)
How to use Microsoft Access - Beginner Tutorial (31 min, Kevin Stratvert, Beginner)
I Replaced My Pivot Tables with 2 New Functions | GROUPBY & PIVOTBY (17 min, Leila Gharani, Intermediate)
Power Query for Beginners: Automate Your Excel Work in 25 Mins (27 min, Leila Gharani, Beginner)
Searchable Drop Down List in Excel (Very Easy with FILTER Function) (11 min, Leila Gharani, Beginner)
Stop Scrolling! 4 Pro Ways to Navigate Excel (10 min, Leila Gharani, Intermediate)
Stop Using Pivot Tables! 7 New Excel GROUPBY Tricks (16 min, Leila Gharani, Intermediate)
When Should You Use the Hash Sign in Excel Formulas? (11 min, Leila Gharani, Intermediate)
10 Hidden Windows 10 Features (Most Still Work in Windows 11) (17 min, Leila Gharani, Intermediate)
6 FREE Add-Ins for Excel to Start Using Now (16 min, Leila Gharani, Intermediate)
Bring ChatGPT INSIDE Excel to Solve ANY Problem Lightning FAST (12 min, Leila Gharani, Intermediate)
Build a CRM with Google Sheets + PostgreSQL + Stripe API Tutorial (Ecommerce Course) (130 min, freeCodeCamp.org, Intermediate)
Common Excel Pivot Table Features People Miss (and you?) (13 min, Leila Gharani, Intermediate)
Data Analysis using AI Tools | Quadratic | N8N | Supply Chain (67 min, codebasics, Intermediate)
Excel 365 Basics #1: What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup (65 min, ExcelIsFun, Beginner)
Excel Features You NEED to KNOW (If you work in Accounting) (17 min, Leila Gharani, Intermediate)
Excel LAMBDA - HOW & WHEN you Should use it (16 min, Leila Gharani, Intermediate)
Google Sheets - Full Course (184 min, freeCodeCamp.org, Intermediate)
How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data (21 min, Leila Gharani, Intermediate)
How to Make Money with Excel Skills (13 min, Leila Gharani, Intermediate)
How to Use OneNote Effectively (Stay organized with little effort!) (15 min, Leila Gharani, Intermediate)

Books on Excel & Sheets

Excel Formulas and Functions for Dummies by Ken Bluttman - View on Amazon
Storytelling with Data by Cole Nussbaumer Knaflic - View on Amazon
Excel VBA Programming For Dummies by John Walkenbach - View on Amazon
Interactive Computing Series by Kenneth C. Laudon - View on Amazon