Contact Us

Expert course

Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!

Use simple Excel shortcuts to Excel at work, impress your boss, and Excel your income. Macros, Formulas, PivotTable Tips

Rating: 4.638,510 ratings110,099 students7.5 total hours77 lectures
Open course in DoJo Back to courses
Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills! Expert

Course facts

  • Last updated 04/2026
  • English English, Dutch [Auto] , 6 more
  • Instructor: Billy Wigley
  • practical AI capability and workflow improvement

What you'll learn

Practical outcomes

  • The skills to deliver a great performance at work, and have a happy boss.
  • Increased earning potential - Make more more money!
  • Access to a MOS Excel Expert!
  • Lifetime access to an increasing number of lectures (shortcuts, tips, and tricks) in a variety of formats.
  • Know how to make the most Excel and have fun with it.
  • A confidence boost by learning the way around Excel.
  • Learn how to use little known features like the Quick Analysis and Camera tools.
  • Cut down time wasted going line by line by learning how to use the Auto Filter.
  • Reduce before work time, and replace with time to spend on other duties.
  • Improve and streamline existing spreadsheets in minutes.
  • Quickly create Pivot Tables with charts, and control by Slicers.
  • Be able to teach/help others at home or work.
  • Be able to use this course to drive future needs.
  • The ability to work "smarter not harder."
  • Shortcuts that lead to better time management, and increased efficiency.
  • Implement frequently used tools more effectively.

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

Who it is for

  • You want to have fun, and learn Excel.
  • You want like to learn a "faster way" of using Excel.
  • You like simple, easy to follow, lively lectures
  • Do not take this course if you are looking for complicated, difficult techniques, and solutions.

Course description

Overview

Do you use Microsoft Excel? -Learn Excel Shortcuts, Tips and Tricks that will make you money (money moves)! -What would it be like to create a chart by pressing one button? -What would it be like to easily create a slicer controlled pivot table with a chart in just minutes? ALERT! - This course is not meant to be completed! I am continuously adding lectures that quickly resolve issues professionals in my live seminars across the USA are having while using Excel in their daily work. To ensure that you have all of the ingredients in place when using Excel it takes years of using the program before you learn all of these “Secrets of Excel." You have taught me a few things that irritate you about Excel, (VLOOKUP, PivotTable, Conditional Formatting, Charts, Formulas), and I have developed this course full of Excel Shortcuts Tips and Tricks that will take years off your learning curve. You will be using Excel like a professional within seconds of viewing this course. There's only 86,400 seconds in a day, and you can't make time, or save time – you can only spend it and invest it. ================================================= Super easy to follow! "If you have trouble with Excel, then this course makes it much easier to understand. The instructor is very knowledgeable and he makes it fun to learn." ================================================== Billy Wigley Is #1 Excel Trainer "Billy's Course is great for newcomers to excel and excel veterans alike that want to increase their knowledge, proficiency, and Skills!!! Billy is by far the most entertaining and knowledgeable Excel mentors I've had the privilege of learning from. I recommend his online course as a must for the aspiring excel guru, and I HIGHLY RECOMMEND trying to find one of his live lectures." ================================================== You are an ACHIEVER. You KNOW what to do – Take This Course – and let's get started.

Instructor

Billy Wigley

Billy Wigley Excel & AI Productivity Expert | Microsoft Certified Trainer Meet Billy "Mr. Aloha" Wigley, the Excel & AI Productivity Expert | Microsoft Certified Trainer (MCT). With his entrepreneur status, MCT credentials, and over 25 years of leadership experience, Billy has empowered thousands of professionals to reach their maximum potential. He's not just a consultant, but a passionate AI champion who is devoted to unlocking your skills and taking you beyond your perceived limits. Billy's digital classroom boasts over 115,000 active online students who benefit from his extensive Excel and AI knowledge. His multicultural background and fluency in both English and Spanish enable him to connect with professionals worldwide. Wherever you are in the world, Billy is available during regular office hours to guide you toward an effective AI Strategy or solving a complex Excel formula. So why wait? Let Mr. Aloha lead the way and let's get started on your journey towards AI aided success and Excel expertise. Billy "Mr. Aloha" Wigley always says: "Don't Get Mad…Get Skills!"