Level Up Your Skills

Tired of slow Excel work? Learn our exclusive keyboard shortcuts to speed up your tasks and impress your boss.

Excel Made Fun

Say goodbye to boring tutorials! Our Excel Obstacle Course turns learning into a game for a more engaging experience.

Excel Efficiency

Mastering shortcuts means saving time on repetitive tasks, giving you more time to focus on what truly matters.

Unlock the Excel Obstacle Course

Are you ready to transform your basic Excel skills into advanced proficiency? Dive into our Excel Obstacle Course method and discover a fun way to enhance your productivity.

Excel Obstacle Course Curriculum

19 Chapters · 92 Lessons

  1. 1

    Brief Introduction, Why the XLOC Method?

    1. About Me Free preview
    2. Quick History of the Excel Obstacle Course Free preview
    3. About the XLOC Method Free preview
    4. BUT CAN I STILL USE THE MOUSE? Free preview
    5. About this course Free preview
  2. 2

    Basic Excel Shortcuts

    1. Download this file before proceeding Free preview
    2. Very Basic Shortcut Refresher Free preview
    3. CTRL & arrows- aka the "WARP" keys Free preview
    4. CTRL and Shift together: "Warp" and Highlight Free preview
    5. Zooming in and out mouse-free Free preview
    6. Switching Sheets mouse-free Free preview
    7. About the Excel Obstacle Courses Free preview
    8. Basic Navigation Obstacle Course Free preview
  3. 3

    Puzzle Break 1

    1. Intro to Puzzles Free preview
    2. Puzzle 1 walkthrough and download Free preview
  4. 4

    Data Cleaning Shortcuts

    1. (Included in full purchase)

      A Word about Data Cleaning

    2. (Included in full purchase)

      Highlighting with CTRL / Shift and Spacebar

    3. (Included in full purchase)

      Insert and Delete

    4. (Included in full purchase)

      Clearing Contents

    5. (Included in full purchase)

      Copy, Paste Special Values

    6. (Included in full purchase)

      Copy Down / Copy Right

    7. (Included in full purchase)

      Practical Use Case Walkthrough

    8. (Included in full purchase)

      Obstacle Checkpoint 1 Walkthrough

  5. 5

    More Keyboard Shortcuts

    1. (Included in full purchase)

      Menu key: right click without a mouse!

    2. (Included in full purchase)

      Transpose

    3. (Included in full purchase)

      Flash Fill with CTRL E

    4. (Included in full purchase)

      CTRL G, the Ultimate Warp Key!

    5. (Included in full purchase)

      Obstacle Checkpoint 2

    6. (Included in full purchase)

      Obstacle Checkpoint 2 Walkthrough

  6. 6

    Basic ALT Key Shortcuts

    1. (Included in full purchase)

      Introducing... the mighty ALT key!

    2. (Included in full purchase)

      Awesome 'Text to Columns' Data Cleaning tricks!

    3. (Included in full purchase)

      Basic Alt Shortcuts Obstacle Course walkthrough

    4. (Included in full purchase)

      Practical Use Case Walkthrough (ALT keys)

  7. 7

    PUZZLE BREAK 2

    1. (Included in full purchase)

      Puzzle 2 walkthrough

  8. 8

    ALT Key Shortcut ELECTIVES

    1. (Included in full purchase)

      Quick Intro: Alt Key Electives

    2. (Included in full purchase)

      Adjust and Align Obstacle Course Walkthrough

    3. (Included in full purchase)

      Sort and Filter Obstacle Course Walkthrough

    4. (Included in full purchase)

      Fonts Colors and Borders

    5. (Included in full purchase)

      Alt Function Shortcuts

    6. (Included in full purchase)

      Alt Miscellaneous Shortcuts

    7. (Included in full purchase)

      Alt Key Elective Obstacle Course

  9. 9

    Puzzle Break 3

    1. (Included in full purchase)

      Puzzle 3 walkthrough

  10. 10

    Writing Formulas without the Mouse

    1. (Included in full purchase)

      F2 and Esc: the Basis for Mouse Free Formulas

    2. (Included in full purchase)

      Locking References with F4

    3. (Included in full purchase)

      Locking References Practice ELECTIVE

    4. (Included in full purchase)

      Highlighting multiple sections with Shift F8 ELECTIVE

    5. (Included in full purchase)

      Highlighting multiple single cells with Shift F8 ELECTIVE

    6. (Included in full purchase)

      Shift F8 Obstacle Course ELECTIVE

  11. 11

    Lookup Formulas

    1. (Included in full purchase)

      Intro/Overview of Lookups

    2. (Included in full purchase)

      Using the VLOOKUP Obstacle Course

    3. (Included in full purchase)

      XLOOKUP Intro

    4. (Included in full purchase)

      Using the XLOOKUP Obstacle Course

    5. (Included in full purchase)

      Index / Match ELECTIVE

    6. (Included in full purchase)

      Index/ Match Obstacle Course walkthrough ELECTIVE

  12. 12

    Lookup Puzzle Course ELECTIVE

    1. (Included in full purchase)

      Lookup Puzzle Course walkthrough ELECTIVE

  13. 13

    Logical Formulas

    1. (Included in full purchase)

      IF statements BASIC

    2. (Included in full purchase)

      IF statements INTERMEDIATE

    3. (Included in full purchase)

      IF statements ADVANCED

    4. (Included in full purchase)

      SWITCH Function

    5. (Included in full purchase)

      IF and SWITCH Challenge Intro

    6. (Included in full purchase)

      IF and SWITCH Challenge Walkthrough

  14. 14

    Aggregation Formulas

    1. (Included in full purchase)

      Intro to Aggregation (SUMIFS, COUNTIFS, Etc...)

    2. (Included in full purchase)

      Practical use case: Aggregations

    3. (Included in full purchase)

      Using the SUMIFS, COUNTIFS Obstacle Course

    4. (Included in full purchase)

      SUMIFS / COUNTIFS Obstacle Course Walkthrough

    5. (Included in full purchase)

      BONUS: 'Any' IFs Formula writing

  15. 15

    Pivot Tables

    1. (Included in full purchase)

      Pivot Table Intro

    2. (Included in full purchase)

      Pivot Table Refresher (Basics)

    3. (Included in full purchase)

      Pivot Table Shortcuts

    4. (Included in full purchase)

      Pivot Table Obstacle Course Intro

    5. (Included in full purchase)

      Pivot Table Obstacle Course Walkthrough

  16. 16

    Becoming a Formula "Technician"

    1. (Included in full purchase)

      What is a formula technician?

    2. (Included in full purchase)

      Error Correction Challenge

    3. (Included in full purchase)

      Evaluate formula

    4. (Included in full purchase)

      Wrapping/Nesting formulas

    5. (Included in full purchase)

      Intro to Arrays

    6. (Included in full purchase)

      Some Basic Array Formulas

    7. (Included in full purchase)

      IFERROR and Arrays Obstacle Course Intro

    8. (Included in full purchase)

      IFERROR and Arrays Obstacle Course Walkthrough

  17. 17

    Conditional Formatting

    1. (Included in full purchase)

      Conditional Formatting Intermediate Level

    2. (Included in full purchase)

      Conditional Formatting Shortcuts

    3. (Included in full purchase)

      Conditional Formatting Obstacle Course Walkthrough ELECTIVE

  18. 18

    More useful functions

    1. (Included in full purchase)

      Intro to More Useful Functions Chapter

    2. (Included in full purchase)

      Textsplit

    3. (Included in full purchase)

      Textjoin

    4. (Included in full purchase)

      Choose

    5. (Included in full purchase)

      Let

    6. (Included in full purchase)

      Lambda

    7. (Included in full purchase)

      Useful Functions Syntax Trainer

    8. (Included in full purchase)

      Useful Functions Challenge Walkthrough

  19. 19

    Self Test final assessment

    1. (Included in full purchase)

      Self Test Exam

    2. (Included in full purchase)

      What’s Next?

Meet Your Excel Coach

Hey there! I'm Ryan, your Excel coach, here to guide you through the exciting journey of mastering keyboard shortcuts. Let's navigate the world of Excel together and take your skills to new heights!

Ready to Excel?

Join our course now and revolutionize the way you work in Excel. Start mastering keyboard shortcuts and elevate your productivity to the next level!

$295.00

Enroll Now Try a Free Lesson