Learn Excel from Scratch

No prior experience needed - we'll guide you every step of the way

Master Essential Excel Techniques

Gain practical skills through DOING! Our practice sheets give you hands-on experience

Excel for Career Growth

Transform your career with Excel fluency and stand out in your field

About the Course

I've developed 50+ lessons to help cover the building blocks to Excel. Along with explanations, I have included Practice Sheets that encourage hands-on learning, and walkthroughs step-by-step so you can't get lost! My face, keyboard and mouse are always visible-- Using subtitles and plain English I will break it down for you, like a friendly co-worker would.

Meet Your Excel Mentor

Hi there! I'm RP, I've trained hundreds of analysts IN PERSON over 20 years! I've mastered the technique of breaking down explanations into bite-sized pieces (most lessons are no longer than 5 minutes). If you want building blocks essential to take your Excel game to the next level, START HERE!

Course Curriculum

19 Chapters · 61 Lessons

  1. 1

    The Very Basics

    1. (Included in full purchase)

      About this course: What to expect

    2. (Included in full purchase)

      What is Excel? Very brief history

    3. (Included in full purchase)

      Cursor Basics

  2. 2

    Data Entry and Editing

    1. (Included in full purchase)

      Mini Excel Sheet to Download

    2. (Included in full purchase)

      Entering Stuff

    3. (Included in full purchase)

      Deleting Stuff

    4. (Included in full purchase)

      Copy/Cut/Paste Stuff

    5. (Included in full purchase)

      Insert Stuff / Delete lesson #2

    6. (Included in full purchase)

      Undo (CTRL Z) and Redo

  3. 3

    Data entry and editing CHECKPOINT

    1. (Included in full purchase)

      Data Entry and Editing Practice Course

    2. (Included in full purchase)

      Data Entry and Editing Answer Key / Walkthrough

  4. 4

    Adjusting Your View and Layout

    1. (Included in full purchase)

      Changing the grid

    2. (Included in full purchase)

      Zooming in and out

    3. (Included in full purchase)

      Add, Rename, Move and Copy Sheets

    4. (Included in full purchase)

      About the Ribbon

    5. (Included in full purchase)

      Freezing / Unfreezing Panes

    6. (Included in full purchase)

      Hiding and Unhiding Rows and Columns

    7. (Included in full purchase)

      Beginner level Printing ELECTIVE

  5. 5

    View and Layout CHECKPOINT

    1. (Included in full purchase)

      View and Layout Practice Course

    2. (Included in full purchase)

      View and Layout Answer Key/Walkthrough

  6. 6

    Formatting Made Easy

    1. (Included in full purchase)

      Formatting Basics / Format Painter

    2. (Included in full purchase)

      Look like a genius with Cell Styles!

    3. (Included in full purchase)

      Short lesson on borders

    4. (Included in full purchase)

      Look like a genius with Conditional Formatting!

    5. (Included in full purchase)

      Merge and Center Options

    6. (Included in full purchase)

      Wrap Text

    7. (Included in full purchase)

      Watch out for these Formatting PITFALLS!

  7. 7

    Formatting Made Easy CHECKPOINT

    1. (Included in full purchase)

      Formatting Made Easy Practice Course

    2. (Included in full purchase)

      Formatting Made Easy Answer Key/Walkthrough

  8. 8

    Intro to Formulas

    1. (Included in full purchase)

      Totaling Stuff

    2. (Included in full purchase)

      Basic Math Stuff to Know

    3. (Included in full purchase)

      References for Beginners

  9. 9

    Intro to Formulas CHECKPOINT

    1. (Included in full purchase)

      Intro to Formulas Practice Course

    2. (Included in full purchase)

      Intro to Formulas Practice Course Answer Key/Walkthrough

  10. 10

    How to Function

    1. (Included in full purchase)

      Intro to FUNCTIONS!

    2. (Included in full purchase)

      Function Practice for Beginners Part 1: Arithmetic

    3. (Included in full purchase)

      Function Practice for Beginners Part 2: Text

    4. (Included in full purchase)

      Function Practice for Beginners Part 3: Logic

  11. 11

    How to Function CHECKPOINT

    1. (Included in full purchase)

      Function Practice Course Intro / Download

    2. (Included in full purchase)

      Function Practice Course Answer Key/Walkthrough

  12. 12

    Addresses, Ranges, and Tables

    1. (Included in full purchase)

      Addresses, Named Ranges, and the Name Manager

    2. (Included in full purchase)

      Tables

  13. 13

    Addresses, Named Ranges, etc. CHECKPOINT

    1. (Included in full purchase)

      Address, Named Ranges, Etc. Practice Course Intro/Download

    2. (Included in full purchase)

      Address, Named Ranges, Etc. Practice Course Answer Key/Walkthrough

  14. 14

    Notes, Shapes and Text Boxes

    1. (Included in full purchase)

      Comments and Notes

    2. (Included in full purchase)

      Shapes and Text Boxes

    3. (Included in full purchase)

      Notes, Shapes and Text Boxes CHECKPOINT POLL

  15. 15

    Graphs, Charts and Pivot Tables

    1. (Included in full purchase)

      Short intro to Chart Basics

    2. (Included in full purchase)

      Pivot Tables for Beginners

    3. (Included in full purchase)

      Making Check boxes

  16. 16

    Graphs, Charts and Pivot Tables CHECKPOINT

    1. (Included in full purchase)

      Graphs, Charts and Pivot Tables Practice Course Download

    2. (Included in full purchase)

      Graphs, Charts and Pivot Table Practice Sheet Answer Key/Walkthrough

  17. 17

    More Helpful Features

    1. (Included in full purchase)

      Flash Fill! / Ctrl E

    2. (Included in full purchase)

      Find and Replace

    3. (Included in full purchase)

      Text to Columns

    4. (Included in full purchase)

      Sort and Filter

    5. (Included in full purchase)

      Data Validation: Making drop down options

    6. (Included in full purchase)

      Removing Duplicates with ease!

  18. 18

    More Helpful Features CHECKPOINT

    1. (Included in full purchase)

      More Helpful Features Practice Course Download

    2. (Included in full purchase)

      More Helpful Features Practice Course Answer Key/Walkthrough

  19. 19

    Next Steps on your Excel Journey

    1. (Included in full purchase)

      The road to Intermediate and Advanced Excel!

Ready to Boost Your Career?

Start your Excel journey HERE!

Enroll Now