Ravindra BagaleCourses & study guides मराठी Track your progress

19. Keyboard Shortcuts and Function Cheat Sheet

Friends, there is a big speed difference between someone who works with the mouse and someone who works with the keyboard. This module puts the important Windows Excel shortcuts and all the important functions in one place. Use 3–4 new shortcuts every day – in one month your hands will move on their own.

Live story: Saving ten minutes a day

Suppose Shahrukh builds the daily Blinkit sheet with the mouse: right-click, Copy, scroll, right-click, Paste Values – about ten extra minutes every day. Ctrl + Shift + Down Arrow, Ctrl + T and Alt + = do the same work in seconds. This chapter lists the Windows shortcuts and a one-page function cheat sheet to keep next to you.

All numbers in this story are fictional practice data.

Full shortcut chapter. This page is a quick cheat sheet for Excel for Windows. For a much larger set of shortcuts in categorised tables for both Windows and Mac, checked against Microsoft's official keyboard shortcut pages, see Module 25: All Excel Keyboard Shortcuts (Windows and Mac). For 32 small time-savers, see Module 26: Excel Tricks Every Analyst Should Know.

Concepts in this chapter

  1. 19.1Keyboard Shortcuts (Excel for Windows)
  2. 19.2Function Cheat Sheet

The chapter recap is at the end of the last concept page.

Quick revision cards

Quick revision

Revise this chapter in two minutes. Save the cards on your phone or download them as PNG files. All names and numbers are made up for practice.

Revision card: Top shortcuts (Windows). Covers Ctrl+T; Ctrl+Shift+L; Alt+=; F4; Ctrl+;; Ctrl+1; Ctrl+E; Ctrl+D. With a photo of Ravindra Bagale and a short tip.
Card 1 of 2: Top shortcuts (Windows) · Download PNG
Revision card: Function cheat sheet. Covers Add with conditions; Count with conditions; Find a value; Choose by a rule; Hide errors; Clean text; Matching rows; Date gap. With a photo of Ravindra Bagale and a short tip.
Card 2 of 2: Function cheat sheet · Download PNG

More cards for every chapter: Ravi Sir's Cards.