-
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)
-
-
Z-STUFF The French Section - No Specific Category For These Goodies - More Stuff
5 Lessons
