-
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!
-
-
Conditional Formatting - Colors, Icons, and Data Bars
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
11 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
-
StartExcel Copilot Formula Completion: Create and Check Formulas
-
-
Z-STUFF The French Section - No Specific Category For These Goodies - More Stuff
5 Lessons
Your everyday Excel toolbox · With Mr. Aloha
Excel Shortcuts.
Tips & Tricks.
Start with the task in front of you. Find a useful technique. Put it to work in your own spreadsheet.
Explore community membership →Prefer the course on its own? $64.99 USD →Included with Practical AI & Easy Excel Community membership.
Standalone access is also available. Membership is separate.
Pick a task. Build a skill.
Make your next
spreadsheet less of a struggle.
Aloha! You don’t need to work through every lesson before putting something useful into practice. Use this course as a reference, and come back when the next question pops up.
01 / ENTER & CLEAN DATAYOUR WORKBOOK
ABC1ProjectOwnerStatus2Monthly reportAlexReady ▾3Team budgetSamReview ▾4Sales trackerJoReady ▾
Illustrative workbook · Practice with your own data.
Get the groundwork right
Less cleanup.
More useful data.
Explore data-entry forms, tables, dropdown lists, and ways to separate or reorganize text.
- Separate text with Text to Columns
- Build dependent dropdown lists
- Find and remove blank rows with Go To Special
02 / Formulas & lookups
Find the answer you need.
Work through VLOOKUP, XLOOKUP, named ranges, text functions, and dynamic arrays. Learn what to reach for when information lives somewhere else.
A TOOL TO EXPLORE IN THE COURSE
=XLOOKUP(E2,A2:A10,B2:B10)F4 Also inside: anchor a cell reference.
03 / Reports & charts
Help the story in your data stand out.
Explore PivotTables, chart shortcuts, Quick Analysis, and conditional formatting with icons and data bars.
Keep one workbook open.
Find a lesson → Try the technique → Return when you need it.
Learn at your own pace. Use the shortcut resources and relevant Copilot lessons alongside the everyday Excel topics.
Open the toolbox
A reference library
you can keep coming back to.
12 SECTIONS · 66 PUBLISHED LESSONS & RESOURCESExplore the existing course sections below. The library includes keyboard shortcuts, data skills, formulas, reporting, and newer Copilot topics.
Course Curriculum
Trusted By These Companies
Billy Wigley
Billy “Mr. Aloha” Wigley helps people build practical Excel and AI skills they can use at work and in business. A Microsoft Certified Trainer since 2013 and Microsoft Office Specialist Excel Expert, he makes complex topics easier to understand through clear explanations, real-world examples and hands-on learning.
As an instructor, course creator and consultant, Billy brings a warm Aloha spirit and a skills-first approach to every lesson. Teaching in English and Spanish, he helps learners turn frustration into confidence and put their knowledge to work. His philosophy is simple: “Don’t Get Mad…Get Skills!”
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.
Choose how you’d like to learn
Keep learning.
Bring your questions.
This course is included in the Practical AI & Easy Excel Community. Explore membership for the course library, community discussion, and live Q&A.
Explore community membership →Membership is optional. Review the current plans and terms before joining.
Already a member? Open this course through your existing account.
Do I need to follow the lessons in order?
Use the course as a practical reference. Choose a lesson that fits your current task, try it in a workbook, and return for a refresher.
Will every feature be available in my Excel?
Availability varies. The library includes different Excel versions, Windows and Mac shortcut resources, and Copilot topics that may require separate access.
