-
Featured Shortcuts - The Newest Lectures And Discussion Answers - Featured Here!
1 Lesson-
StartUnleashing AI in Excel: Mastering LABS.GENERATIVEAI for Enhanced Data Tasks
-
-
In The Beginning... Some Quick Tips, And Basic Elements Of The Excel Screen
4 Lessons -
Entering and Editing Data
13 Lessons-
StartExcellent Habit - Format As Table And Insert A Total Row In Seconds!
-
StartHow To Make An Easy Data Entry Form
-
Start(QUIZ) Where Are You? An Easy Push-up For Your Brain To Get It Warmed Up And Ready.
-
StartTOP SECRET! - Ever Hear Of Secret Features In Excel? - Well, Meet The QAT
-
StartText To Columns- That's Nice, I'll take Care Of It! - Separate Text into Columns
-
StartWhat's The Difference? - Are You Really In Excel 2013? Can You Tell The Version?
-
StartQuickly Insert Rows And Columns
-
StartQuickly Insert BLANK Rows In Between Cells - I Call It "Sorting Them In"
-
StartGo To Special - Find Blank Rows and Delete. Find Specific Text and Delete Row.
-
StartDid You Say Go To Special Again?! - Here Is Another Twist To Removing Blank Rows
-
StartSpeed Up Your Data Entry - Data Validation, VLOOKUP, Format As Table, Date Stamp
-
StartTRANSPOSE Your Data - Copy Vertical Data Range And Paste It Horizontally!
-
StartLearn How To Use Worksheet Cell Protection In Excel
-
-
Words In Excel? Yikes! - Make It Work With Easy Text Functions
5 Lessons-
StartExcel 365 Function: ARRAYTOTEXT - Live Stream Recording
-
StartIntroducing Dynamic Arrays with TEXTJOIN and TEXSPLIT
-
StartI Gotta Change The Case! - UPPER_LOWER_PROPER
-
StartCONCATENATE - Join The Contents Of Cells Into One Cell - Words Into Sentences
-
Start(QUIZ) EXCEL is for math. When you use text you have to use TEXT functions like these.
-
-
Calculations - Using FUNCTIONS and Building Formulas Like a Professional User!
12 Lessons-
StartF4 To Anchor- This Is Going To Change Your Life - Make A Cell Reference Absolute
-
StartDate & Time Function. This Is Only One Of Many Ways - So Easy!
-
StartVLOOKUP - Looking For Something Over There And You Want The Answer Over Here?
-
StartBuild A Mini-Dashboard Using The PivotTable Wizard! The What Wizard? PivotTable!
-
StartMAGICAL PIVOTTABLE - Slice And Dice Your Data Like A Rocket Scientist On Charts
-
Start(QUIZ) With over 300 functions in Excel it's hard to learn how, when, and which to use.
-
StartTired Of Seeing #N/A In Your Empty Cells? - Check Out The IFNA Function in 2013
-
StartXLOOKUP - How To Use The XLOOKUP Function
-
StartXLOOKUP - How To Use The [match_mode] And The [search_mode] Arguments
-
StartXLOOKUP - How To Use The XLOOKUP To Replace VLOOKUP, HLOOKUP and INDEX and MATCH
-
StartLevel Up Your Excel Lookup Skills with VLOOKUP, XLOOKUP & Spilled Arrays
-
StartTake Your Excel Lookups to Pro Level with Named Ranges & Nested Formulas
-
-
Working With Other Documents And Saying This Will Make You Sound Smart.
6 Lessons-
StartOpen a NEW Workbook, and Easily Duplicate a Worksheet
-
StartSHARE A Workbook and MERGE Shared Workbooks Using A Secret Tool!
-
StartI Forgot To SHARE The Workbook! How Can I Merge The Two Versions I Now Have?
-
StartFor Your Charts Only - F11 And The Little Known Att+F1
-
StartLet Excel Tell You What It Likes Best - The Quick Analysis Tool - Recommended!
-
Start(QUIZ) Can't figure out which chart to use? Where to put the total? Put the chart here!
-
-
Make It Pretty - Look at all those colors - Cool!Untitled Section
1 Lesson-
StartExcel Conditional Formatting - Combine Icons and Databars In One Cell ✅ (Live)
-
-
The AI Fast Track: Master Excel with Copilot, ChatGPT, DeepSeek, Gemini & Claude
10 Lessons-
StartExcel Focus Cell Shortcut: Highlight Active Rows and Columns in Large Worksheets
-
StartGetting Started with Copilot in Excel: Create a Workbook Using AI and SPARK
-
StartMicrosoft Copilot in Excel Tips: Better AI Prompts, Follow-Ups & Smarter Results
-
StartCopilot in Excel Personalization: Set Preferences for Faster, Consistent Results
-
StartCopilot in Excel Workbook Rules: Create Consistent Formatting, Charts & Analysis
-
StartGet Data Insights with Copilot in Excel: Analyze Sales, Profit, Trends & Outlier
-
StartExcel Copilot: Create Charts, PivotTables, Filters, and Visual Insights in Excel
-
StartExcel Copilot: Search the Web and Import Connected Data Into Your Excel Workbook
-
StartReview Copilot Change History in Excel
-
StartAnalyze Power BI Reports with Copilot in Excel
-
-
Z-STUFF The French Section - No Specific Category For These Goodies - More Stuff
5 Lessons

