Skip to content
AI Masters DoJo
ExploreMenu
Book a discovery call

Spreadsheet skills

Excel Shortcuts, Formulas and Data Tools

Explore Excel shortcuts and skills, including data entry, validation, formulas, macros and PivotTables.

A small sample of 30,000+ courses curated from around the world, all available to DoJo members.

Book a discovery callExplore DoJo membership

A free 30-minute conversation with Ted about your goals.

Already a member? Open this course

Course topics

Spreadsheet skills

  • Data entry
  • Formulas and functions
  • Excel tables

You check the calculation

Find your fit

Is this a useful starting point?

For learners who want to build Excel skills; no technical prerequisite is stated.

Starting point
Check requirements
Course length
7.5 total hours
Lessons
77 lectures

Course by Billy Wigley

Course last updated: 04/2026

Requirements
  • You only need to have the desire make Excel easier for yourself.
What is included
  • Role Play
  • 7.5 hours on-demand video
  • 58 downloadable resources
  • Access on mobile
  • Certificate of completion

DoJo membership: A$250 per month per seat, excluding GST. Includes fortnightly group support and a private member community.

Explore the lessons

Course curriculum.

18 sections • 77 lectures • 7h 33m total length

Featured Shortcuts - The Newest Lectures And Discussion Answers - Featured Here!1 lecture • 3min
  1. Welcome to Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!03:00
  2. Interviewing for an Entry-Level Office Job That Requires Basic Excel Skills
In The Beginning... Some Quick Tips, And Basic Elements Of The Excel Screen4 lectures • 7min
  1. HONE YOUR SKILLS - 4 Shortcuts in 17 Seconds!00:16
  2. CTRL+A - Instantly Select Your Desired Range Of Data Like a Pro!00:17
  3. GO HERE - Learn The Proper Terminology - Basic Elements Of The Screen-PART 102:55
  4. NOW HERE - Learn The Proper Terminology - Basic Elements Of The Screen - PART 203:36
Let's Get Back To The Basics3 lectures • 11min
  1. Use The Clear Format Tool Like A Professional!03:46
  2. FORMATTING SHORTCUTS-You ever have to Bold, Underline, Italicize, Strikethrough?04:26
  3. UNIVERSAL SHORTCUTS - They work in just about every program you work with!02:29
Entering and Editing Data12 lectures • 48min
  1. Excellent Habit - Format As Table And Insert A Total Row In Seconds!00:31
  2. How To Make An Easy Data Entry Form02:20
  3. Where Are You? An Easy Push-up For Your Brain To Get It Warmed Up And Ready. 4 questions
  4. TOP SECRET! - Ever Hear Of Secret Features In Excel? - Well, Meet The QAT03:53
  5. Text To Columns- That's Nice, I'll take Care Of It! - Separate Text into Columns07:52
  6. What's The Difference? - Are You Really In Excel 2013? Can You Tell The Version?03:03
  7. Quickly Insert Rows And Columns00:29
  8. Quickly Insert BLANK Rows In Between Cells - I Call It "Sorting Them In"01:45
  9. Go To Special - Find Blank Rows and Delete. Find Specific Text and Delete Row.01:22
  10. Did You Say Go To Special Again?! - Here Is Another Twist To Removing Blank Rows01:56
  11. Speed Up Your Data Entry - Data Validation, VLOOKUP, Format As Table, Date Stamp09:28
  12. TRANSPOSE Your Data - Copy Vertical Data Range And Paste It Horizontally!01:38
  13. Learn How To Use Worksheet Cell Protection In Excel13:32
  14. Your Boss Needs a Spreadsheet Fixed Before a Meeting
Data Validation - Let's Make Some Drop-down Lists3 lectures • 21min
  1. Create A Drop-down List From Data On Another Excel Worksheet05:38
  2. Learn How To Make A Dependent Drop-down List09:36
  3. Add Color To Your Drop-down Lists In Excel!05:36
Words In Excel? Yikes! - Make It Work With Easy Text Functions4 lectures • 29min
  1. NEW Excel 365 Function: ARRAYTOTEXT - Live Stream Recording10:34
  2. Introducing Dynamic Arrays with TEXTJOIN and TEXSPLIT07:07
  3. I Gotta Change The Case! - UPPER_LOWER_PROPER07:39
  4. CONCATENATE - Join The Contents Of Cells Into One Cell - Words Into Sentences03:34
  5. EXCEL is for math. When you use text you have to use TEXT functions like these. 2 questions
Auto Fill Magic2 lectures • 6min
  1. ID Columns - Quick Tip On Organizing Your Data - Keep Your Stuff In Order!03:40
  2. Imagine Your First Drop-Down And A Bunch More Stuff02:27
Calculations - Using FUNCTIONS and Building Formulas Like a Professional User!11 lectures • 1hr 29min
  1. F4 To Anchor- This Is Going To Change Your Life - Make A Cell Reference Absolute00:29
  2. Date & Time Function. This Is Only One Of Many Ways - So Easy!03:08
  3. VLOOKUP - Looking For Something Over There And You Want The Answer Over Here?06:17
  4. Build A Mini-Dashboard Using The PivotTable Wizard! The What Wizard? PivotTable!03:40
  5. MAGICAL PIVOTTABLE - Slice And Dice Your Data Like A Rocket Scientist On Charts01:54
  6. With over 300 functions in Excel it's hard to learn how, when, and which to use. 4 questions
  7. Tired Of Seeing #N/A In Your Empty Cells? - Check Out The IFNA Function in 201304:03
  8. XLOOKUP - How To Use The XLOOKUP Function14:11
  9. XLOOKUP - How To Use The [match_mode] And The [search_mode] Arguments12:27
  10. XLOOKUP - How To Use The XLOOKUP To Replace VLOOKUP, HLOOKUP and INDEX and MATCH11:12
  11. Level Up Your Excel Lookup Skills with VLOOKUP, XLOOKUP & Spilled Arrays15:46
  12. Take Your Excel Lookups to Pro Level with Named Ranges & Nested Formulas16:09
  13. Helping a Coworker Use Sort, Filter, and Excel Tools to Find Answers Fast
Working With Other Documents And Saying This Will Make You Sound Smart.5 lectures • 17min
  1. Open a NEW Workbook, and Easily Duplicate a Worksheet03:10
  2. SHARE A Workbook and MERGE Shared Workbooks Using A Secret Tool!04:10
  3. I Forgot To SHARE The Workbook! How Can I Merge The Two Versions I Now Have?07:11
  4. For Your Charts Only - F11 And The Little Known Att+F101:19
  5. Let Excel Tell You What It Likes Best - The Quick Analysis Tool - Recommended!01:30
  6. Can't figure out which chart to use? Where to put the total? Put the chart here! 2 questions
Make It Pretty - Look at all those colors - Cool!1 lecture • 8min
  1. Excel Conditional Formatting - Combine Icons and Databars In One Cell ✅ (Live)07:51
Excel Tables: Structure, Speed & Smarter Data14 lectures • 42min
  1. Meet Excel Tables: Why This Section Will Level Up Your Skills01:09
  2. Create an Excel Table: What It Is and Why It Beats a Data Range03:15
  3. Unlock Excel Tables: Hidden Features That Make Your Data Work for You03:08
  4. Instant Excel Tables: The CTRL+T Shortcut You’ll Use Every Day02:03
  5. Excel Tables Demystified: Master the Parts That Do the Work for You02:45
  6. Instant Table Makeovers: Transform Your Data with One Click01:36
  7. Custom Excel Styles: Design Tables That Match Your Data03:22
  8. Personalized Excel Styles: Save Time with Custom Table Designs02:53
  9. Edit Excel Tables Like a Pro: Add, Delete & Update Data Instantly02:28
  10. Filter Like a Pro: Master Excel Sorting, Filtering & Slicers in Minutes04:28
  11. Smart Formulas: Automate Excel Tables with Dynamic Calculations04:07
  12. PivotTable Power: Turn Raw Data into Instant Insights03:36
  13. Work Smarter with Excel Templates: Reuse Tables in Seconds03:52
  14. Conditional Formatting Magic: Make Important Data Stand Out Instantly03:05
  15. Summarizing Spreadsheet Data for a Manager Using PivotTables and Charts
The Excel + AI Challenge: Secure, Smart, Time-Saving Workflows + The Excel Agent5 lectures • 20min
  1. Day 1 - Before You Use AI in Excel: Do This Security Check First03:35
  2. Day 2 - Build XLOOKUP Formulas with AI Using Plain English03:30
  3. Day 3 - Turn Repetitive Excel Tasks into One-Click Macros with AI05:26
  4. Day 4 - Watch AI Build an Entire Excel Spreadsheet for You05:18
  5. Day 5 - Now It’s Your Turn: Apply What You’ve Learned with Excel + AI01:57
The AI Fast Track: Master Excel with Copilot, ChatGPT, DeepSeek, Gemini & Claude3 lectures • 13min
  1. Master the Language of AI: The SPARK Prompting Framework (The Foundation)01:37
  2. Excel Copilot: Build Instant Dashboards & Summaries with SPARK07:10
  3. Unleashing AI in Excel: Mastering LABS.GENERATIVEAI for Enhanced Data Tasks03:52
Z-STUFF The French Section - No Specific Category For These Goodies - More Stuff3 lectures • 8min
  1. Quick Steps To Record A Macro - Downloadable GIF02:12
  2. 200 Excel 2013 Shortcuts For You To Print Out And Share 3 pages
  3. 7 Steps To Worksheet Success - It's Gotta Be Right! (rough cut edit)05:52
Video Answers1 lecture • 4min
  1. This is for you Kanishk.03:38
Here Are The Announcements - Good Stuff In Here!1 lecture • 2min
  1. Great News! New office hours and Habit #2 - 12/03/201502:10
KEEP ON LEARNING SECTION3 lectures • 2hr 2min
  1. My 30 Favorite Excel Power-Tips ⚡⚡⚡ (01/08/2021) :4701:25
  2. 8 Secrets In Excel (Aloha Friday Live Stream)18:56
  3. How To Use Excel 3D Referencing To Add (sum) Your Worksheets ??➕?❗??17:10
BONUS SECTION1 lecture • 1min
  1. Learn More With Mr. Aloha (BONUS LECTURE)01:11

From learning to practice

Try this next.

Try a shortcut or formula on a sample workbook and compare the result with a checked answer.

A useful next step

Choose where to start.

Talk through your goals in a free 30-minute discovery call with Ted. Bring a task you want to improve and the tools you already use.

Book a discovery callExplore DoJo membership

More to explore

Find a course for your next task.

Browse the course sample