Skillshareintermediateen

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

Master Excel shortcuts! Boost your productivity and work faster with keyboard tricks. Perfect for Excel beginners building on "Excel for the Real World I."

4.3(179)
12,060students
1h 10m
Certificate
Al Chen
Al ChenExcel Trainer & Coda Evangelist

Course Content

Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts is an intermediate-level Skillshare course taught by Al Chen. It runs 1h 10m, is taught in English, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 179 reviews, with 12,060 students enrolled. It is a paid course, first published May 2014.

Unlock Excel Efficiency: Master Keyboard Shortcuts in Excel II

Continue your Excel journey with Excel II, the second part of our comprehensive 3-part series from the creators of KeyCuts. This class focuses on leveraging keyboard shortcuts to dramatically speed up your data workflow in Microsoft Excel. Learn to work with data faster and more efficiently than ever before!

This hands-on class will teach you how to use Excel shortcuts to focus on your data, not the mechanics of navigating Excel. We'll learn by doing, using the provided Excel file in the "Projects & Resources" tab (Resources section). After the class, upload your own list of favorite Excel keyboard shortcuts and how you use them!

What You'll Learn:

  • Getting Started with Shortcuts: Discover how using the keyboard can make you 10X faster than using the mouse in Excel.
  • Moving Around: Efficiently navigate within Excel using just the keyboard.
  • Selecting Stuff: Master selecting cells and ranges with keyboard shortcuts.
  • Autofiltering & Making Lists: Quickly drill down into your data using autofilter and other list-related shortcuts.
  • Using Paste Special: Unlock the power of Paste Special for advanced data manipulation.
  • Formula Fills: Learn keyboard shortcuts for Fill Formula and Auto-Sum to rapidly create formulas.
  • Formatting: Quickly apply number formatting, borders, and alignment using Excel formatting shortcuts.
  • Using Special Shortcuts: Discover advanced shortcuts like AutoFit, Re-Do format, and utilizing the Quick Access Toolbar to become a true Excel power user.

Further Learning:

  • [Excel for the Real World I: Gain the Basic Skills in 1 Hour](link to Excel I course)
  • [Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint](link to Excel III course)

Why Master Excel Shortcuts?

Data drives decisions in every industry. Organizing and manipulating data efficiently is crucial. This series will not only enhance your technical skills but also empower you to work with data in a smart, efficient way.

Note: While this class uses Microsoft Excel 2011, the concepts are applicable to both PC and Mac versions. Become more productive with Excel keyboard shortcuts today!

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.