Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts

Al Chen, Excel Trainer & Coda Evangelist

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Lessons (1h 10m)
    • 1. Trailer

      1:00
    • 2. Getting Started with Shortcuts

      7:24
    • 3. Moving Around

      5:56
    • 4. Selecting Stuff

      7:39
    • 5. Autofilters & Lists

      8:41
    • 6. Paste Special

      7:16
    • 7. Formulas Fills

      6:40
    • 8. Formatting

      9:01
    • 9. Special Shortcuts

      7:34
    • 10. Final Exercise

      8:56
21 students are watching this class

Project Description

Create your list of favorite Excel keyboard shortcuts

ASSIGNMENT

After going through this class, start memorizing 4-5 keyboard shortcuts that you will use all the time when you work in Excel.

DELIVERABLE

Create an Excel file with your favorite Excel keyboard shortcuts and upload a screenshot to this class' Project Gallery:

  • List out the shortcuts line by line and why you like them
  • For extra points, show examples in the Excel file of when you would use a given shortcut

Skillshare doesn't let you upload Excel files to the Project Gallery, so upload a screenshot of your Excel file and send me your Excel file at [email protected] The projects with the most interesting shortcuts and examples will receive a free KeyCuts Excel keyboard cover!

RESOURCES

  • Download the Excel for the Real World II Workbook below to follow along with the class videos (see full syllabus in the file)
  • Think about creating an Excel shortcut list for you to reference for your project, an example of mine is shown below

71213ccc

Student Projects

Sebastian Lopez
1 comment
Excel Shortcuts
Paul Mun
2 comments