Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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

Al Chen, Excel Developer & Trainer

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

      1:00
    • Getting Started with Shortcuts

      7:24
    • Moving Around

      5:56
    • Selecting Stuff

      7:39
    • Autofilters & Lists

      8:41
    • Paste Special

      7:16
    • Formulas Fills

      6:40
    • Formatting

      9:01
    • Special Shortcuts

      7:34
    • Final Exercise

      8:56

About This Class

Keyboard shortcuts are fun and increase your efficiency in Excel.

We pick up from Excel for the Real World I to start using Microsoft Excel as fast as possible. This is the 2nd part of a 3-part series on learning to use Excel from the producers of KeyCuts. In this second class, Excel II, you will learn to use keyboard shortcuts to speed up your data workflow. These will not only be fun, but they will maximize your workflow like you didn't know possible. Excel shortcuts were built for the user to be able to focus on data rather than logistics – and this class will help you learn to do just that!

Learn by doing.

You'll follow along with me in the Excel for the Real World II file I have provided under the "Your Project" tab (in this tab see the "Attached Files" section). Then I want you to upload an Excel file listing out your favorite keyboard shortcuts. Examples of how you use your shortcuts will be even better!

What You'll Learn

  • Getting Started with Shortcuts. Learn how using the keboard makes you 10X faster than using the mouse in Excel.
  • Moving Around. Move around and navigate within Excel efficiently.
  • Selecting Stuff. Select cells and ranges using only the keyboard.
  • Autofiltering & Making Lists. You have a basic data set, how do you drill down to the data you need?
  • Using Paste Special. Paste Special is one of the most powerful operations in Excel
  • Using Formula Fills. We'll learn shortcuts for Fill Formula and Auto-Sum to quickly create formulas on the fly.
  • Formatting. We'll go over quick number formatting, borders, and alignment shortcuts.
  • Using Special Shortcuts. Here are the keyboard shortcuts that will make you truly stand out among your peers and make you even faster such as AutoFit, Re-Do format, and the Quick Access Toolbar.

Also see: Excel for the Real World I: Gain the Basic Skills in 1 Hour & Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint

e09b7938

Data drives all decisions, regardless of the business or industry you work on. You need to know how to organize it! Data is power! This Excel series will not only develop your technical skills, but also help you work with data in an efficient, smart way.

Note: The version of Excel used in this class is Max Excel 2011, but the concepts apply to both PC and Mac.

55 of 56 students recommendSee All

Great!
Maribel Reyes

Graphic Designer and Maker

Al's extremely likable and easy to follow. I use a Windows laptop, and this course centers around Mac use, but I know the Windows-equivalent shortcuts will be valuable. I use Excel all day, every day. I frequently paused a given lesson to experiment with the Windows shortcut version Al provided. Some of them may be outdated in Excel 2016, but I just googled them to get the latest; obviously a shortcut exists for that function and I'll use it! Thanks so much, Al!

1,423

Students

2

Projects

Al Chen

Excel Developer & Trainer

Al didn't know how to use Excel at all until he became a financial analyst at Google. He used to think that people who were good in Excel were accountants who thought a fun weekend meant writing formulas in spreadsheets! He was very wrong...

His first job required him to use Excel to efficiently analyze data. He started to understand the power Excel and data analysis has on making decisions. He founded KeyCuts, an Excel training company where the main product is a silicone keyb...

See full profile