Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide
4.3 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,309 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide to your Wishlist.

Add to Wishlist

Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide

Learn to Master 230+ Microsoft Excel Keyboard Shortcuts and Become an Excel Guru in No Time!
4.3 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,309 students enrolled
Last updated 1/2016
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 17 hours on-demand video
  • 1 Article
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use and deploy 230+ Excel keyboard shortcuts
  • Understand the 20 functional groups within Excel
  • Apply tips, tricks, and keyboard shortcuts to real-world problems
  • Build a powerful & persuasive professional skillset
  • Finish tasks with speed & accuracy
View Curriculum
Requirements
  • A Windows version of (i.e., PC version of) Excel 2007, Excel 2010, Excel 2013, or Excel 2016
Description

A Brief Introduction to the Course

Come. Watch. Learn. Conquer. Excel. One Simple Lesson at a Time.

Hi and welcome!

Hi and welcome! My name is Tolan, and I am the co-founder of ProductivityMe.

I’d like to welcome you to Excel Keyboard Shortcuts, where through a series of awesome tips, tricks, and keyboard shortcuts you’ll learn to Master Microsoft Excel, one simple lesson at a time.

Through a comprehensive set of unique, fun, easy-to-follow video tutorials, you can learn to become a Microsoft Excel Power User in less than a week!

What is Included in This Course?

  • 250+ individual lessons
  • Regular course updates
  • A dynamic, response Excel file listing all 233 keyboard shortcuts used in the course
  • A colored PDF reference guide of those 233 keyboard shortcuts
  • Instant access to course instructor


What is the Purpose of This Course?

Excel has become the industry standard for organizing, analyzing, manipulating, a storing both data and information in tabular form.

Thus, this course is designed to get you up and running as a highly-proficient Excel user by being able to use hundreds Excel's most common actions and functions in seconds.

By the end of this course, you’ll be able to use and deploy more than 230 keyboard shortcuts that will make you AWESOME at Microsoft Excel.

For example, you’ll learn shortcuts like:

  • Shift + F11 Inserting a New Worksheet (Lesson 04.01)
  • Ctrl + Shift + "=" Inserting Rows or Columns (Lesson 05.02 or Lesson 05.03)
  • Shift + Spacebar Selecting an Entire Row (Lesson 07.01)
  • Ctrl + Spacebar Selecting an Entire Column (Lesson 07.02)
  • Ctrl + Enter Entering the Same Data in Multiple Cells (Lesson 11.06)
  • Ctrl + Alt + V Displaying the Paste Special Dialog Box (Lesson 14.10)
  • Ctrl + Shift + ~ Applying General Format (Lesson 17.01)
  • Alt + = Autosumming Selected Cells (Lesson 18.04)
  • Ctrl + ` Toggling Formulas On and Off (Lesson 18.05)
  • F11 Creating a Chart in New Worksheet (Lesson 19.10)
  • Alt + F8 Opening the Macro Dialog Box (Lesson 20.06)


More generally, you'll be able to apply keyboard shortcuts for actions such as:

  • Autosumming cell values & instantly changing their formatting
  • Adding, formatting, and removing cell borders in a flash
  • Hiding, grouping, adding, deleting columns and rows
  • Moving to the next cell, worksheet, or workbook
  • Copying, moving, or deleting a cell, a selection, or a worksheet in Excel
  • Expanding or reducing your active selection by one or more cells, columns, or rows
  • Instantly creating new tables, filters, charts, and PivotTables
  • Launching macros & the VBA Editor with two simple clicks
  • And much, much more

In every lesson, we to follow the same logical structure.

Consistent Lesson Structure:

  1. First, we'll provide an introduction to what we’ll cover in the lesson
  2. Then we'll show you the keyboard shortcut
  3. Next we'll show you how to achieve the same result without using the specific shortcut
  4. Then. we'll review what we covered in the lesson
  5. And lastly, we'll discuss what is coming up in the next lesson

Final Thoughts:

ALRIGHT! The quality of our content speaks for itself. Come and check it out today!

See you in a few.

Cheers,

Tolan & Ryan
Course Instructors & ProductivityMe Co-Founders


Who is the target audience?
  • This Course is for PC-users of Microsoft Excel 2007, 2010, 2013, and 2016
  • Excel for Mac uses a different set of keyboard shortcuts; this course is not recommended for Excel 2011 Mac or Excel 2016 for Mac (unless user is running Windows on Boot Camp or Parallels)
Students Who Viewed This Course Also Viewed
Curriculum For This Course
257 Lectures
17:08:40
+
Course Basics
4 Lectures 31:27

DOWNLOAD: Referenceable PDF and Excel File
00:22

OPTIONAL LECTURE: Long Discussion Course Structure & Design
15:30

+
Using the File Menu (01.00) Using the Ribbon (02.00)
24 Lectures 01:44:00




01.04 - (F12) - Using the "Save-As" Feature
05:45

01.05 - (Ctrl + P) - Printing a File
05:15

01.06 - (Ctrl + F2) - Opening the Print Preview Window
04:30

01.07 - (Win + ↓) - Restoring Down a Maximized Excel Window
03:30

01.08 - (Win + ↓) - Minimizing a Non-Full Sized Excel Window
04:00

01.09 - (Win + ↑) - Maximizing a Non-Full Sized Excel Window
02:45

01.10 - (Ctrl + F4) - Closing the Current Workbook
03:15

01.11 - (Alt + F4) - Closing the Excel Application Entirely
05:00





02.04 - (Tab) - Moving to the Next Ribbon Control on a Tab
03:30

02.05 - (Shift + Tab) - Moving to the Previous Ribbon Control on a Tab
03:15

02.06 - (Esc) - Moving Up One Level within Ribbon Menu's Hierarchy
02:30

02.07 - (Spacebar) - Activating or Opening Selected Control(s)
02:30

02.08 - (Enter) - Confirming a Control Change
03:00

02.09 - (F1) - Getting Help on Selected Control(s)
03:30

02.10 - (Customize Q.A.T.) - Customizing the Ribbon in Excel
04:00

02.11 - (Customize Q.A.T.) - Customizing the Quick Access Toolbar (Q.A.T.)
07:00
+
Using Menus & Dialog Boxes (03.00)
11 Lectures 36:30
03.00 - (Section 3) - Introduction to Using Menus & Dialog Boxes
06:15

03.01 - (Shift + F10) - Displaying the Shortcut Menu
03:30

03.02 - (Alt + Spacebar) - Displaying the Control Menu
03:15

03.03 - (Tab) - Moving to Next Control
02:45

03.04 - (Shift + Tab) - Moving to Previous Control
02:00

03.05 - (Ctrl + Tab) - Moving to Next Tab
02:45

03.06 - (Ctrl + Shift + Tab) - Moving to Previous Tab
02:30

03.07 - (Spacebar) - Checking or Unchecking a Box
03:00

03.08 - (Enter) - Choosing to Accept and Apply Changes
03:00

03.09 - (Esc) - Canceling and Closing a Dialog Box
02:45

03.10 - (Alt + ') - Displaying the Modify Cell Style Dialog Box
04:45
+
Using Workbooks (04.00)
17 Lectures 01:10:27
04.00 - (Section 4) - Introduction to Using Workbooks
07:45


04.02 - (Ctrl + Page Down) - Going to Next Worksheet
02:30

04.03 - (Ctrl + Page Up) - Going to Previous Worksheet
02:00

04.04 - (F6) - Moving to Next Pane
03:30

04.05 - (Shift + F6) - Moving to Previous Pane
03:00

04.06 - (Ctrl + Tab) - Going to Next Workbook
03:26

04.07 - (Ctrl + Shift + Tab) - Going to Previous Workbook
03:00

04.08 - (Ctrl + F9) - Minimizing Current Workbook Window
03:30

04.09 - (Shift + Left Click) - Selecting Adjacent Worksheet(s)
03:15

04.10 - (Ctrl + Left Click) - Selecting Non-Adjacent Worksheet(s)
05:45

04.11 - (Customize Q.A.T.) - Hiding a Worksheet
04:30

04.12 - (Customize Q.A.T.) - Unhiding a Worksheet
04:30

04.13 - (Alt ... O ... HR) - Renaming a Worksheet
03:46

04.14 - (Alt ... E ... M) - Moving a Worksheet
06:00

04.15 - (Alt ... E ... M) - Copying a Worksheet
05:00

04.16 - (Alt ... E ... L) - Deleting a Worksheet
04:30
+
Modifying Columns & Rows (05.00)
18 Lectures 01:01:28
05.00 - (Section 5) - Introduction to Modifying Columns & Rows
08:00

05.01 - (Ctrl + Shift + "=") - Displaying the Insert Dialog Box
03:30

05.02 - (Ctrl + Shift + "=") - Inserting Rows
03:30

05.03 - (Ctrl + Shift + "=") - Inserting Columns
04:00

05.04 - (Ctrl + "-") - Displaying the Delete Dialog Box
03:30

05.05 - (Ctrl + "-") - Deleting Rows
03:30

05.06 - (Ctrl + "-") - Deleting Columns
03:15

05.07 - (Ctrl + "-") - Deleting Cells
02:30

05.08 - (Delete) - Deleting Contents of Selected Cells
02:45

05.09 - (Ctrl + 0) - Hiding Columns
03:45

05.10 - (Ctrl + Shift + 0) - Unhide Columns
03:45

05.11 - (Ctrl + 9) - Hiding Rows
02:30

05.12 - (Ctrl + Shift + 9) - Unhide Rows
02:45

05.13 - (Alt + Shift + →) - Grouping Columns or Rows
03:15

05.14 - (Alt + Shift + ←) - Ungrouping Columns or Rows
02:28

05.15 - (Alt + Shift + →) - Opening the Group Dialog Box
03:00

05.16 - (Alt + Shift + ←) - Opening the Ungroup Dialog Box
03:15

05.17 - (Ctrl + 8) - Hiding or Showing the Outline Symbols for Groups
02:15
+
Navigating within Excel (06.00)
17 Lectures 01:11:00
06.00 - (Section 6) - Introduction to Navigating within Excel
05:45

06.01 - (→) - Moving One Cell to the Right
04:15

06.02 - (←) - Moving One Cell to the Left
04:00

06.03 - (↑) - Moving One Cell Up
04:45

06.04 - (↓) - Moving One Cell Down
04:30

06.05 - (Alt + Page Down) - Moving One Screen to the Right
03:00

06.06 - (Alt + Page Up) - Moving One Screen to the Left
02:30

06.07 - (Page Down) - Moving One Screen Down
04:30

06.08 - (Page Up) - Moving One Screen Up
03:30

06.09 - (Ctrl + →) - Moving to the Right Edge of Data Region
05:15

06.10 - (Ctrl + ←) - Moving to the Left Edge of Data Region
04:45

06.11 - (Ctrl + ↑) - Moving to the Top Edge of Data Region
04:45

06.12 - (Ctrl + ↓) - Moving to the Bottom Edge of Data Region
03:15

06.13 - (Home) - Moving to the Beginning of a Row
05:00

06.14 - (End) - Turning “End Mode” On or Off
03:15

06.15 - (Ctrl + End) - Moving to the Last Cell in a Worksheet
04:00

06.16 - (Ctrl + Home) - Moving to the First Cell in a Worksheet
04:00
+
Making a Selection (08.00)
10 Lectures 38:00
07.00 - (Section 7) - Introduction to Making a Selection
04:30



07.03 - (Ctrl + A) - Selecting an Entire Worksheet
04:30

07.04 - (Shift + Left Click) - Adding Adjacent Cells to Selection
03:00

07.05 - (Ctrl + Left Click) - Adding Non-Adjacent Cells to Selection
03:15

07.06 - (Esc) - Canceling Selection
03:45

07.07 - (Shift + F8) - Toggling Add to Selection Mode
04:30

07.08 - (Ctrl + →) - Moving Right between Non-Adjacent Selections
04:00

07.09 - (Ctrl + ←) - Moving Left between Non-Adjacent Selections
02:30
+
Working with the Active Cell (08.00)
8 Lectures 21:45
08.00 - (Section 8) - Introduction to Working with the Active Cell
04:00

08.01 - (Shift + Backspace) - Selecting an Active Cell Only
04:00

08.02 - (Ctrl + Backspace) - Showing the Active Cell on Worksheet
02:30

08.03 - (Ctrl + ".") - Moving Active Cell Clockwise in Selection
02:15

08.04 - (Enter) - Moving Active Cell Down in Selection
01:30

08.05 - (Shift + Enter) - Moving Active Cell Up in Selection
02:45

08.06 - (Tab) - Moving Active Cell Right in Selection
02:00

08.07 - (Shift + Tab) - Moving Active Cell Left in Selection
02:45
+
Extending a Selection (09.00)
15 Lectures 40:30
09.00 - (Section 9) - Introduction to Extending a Selection
04:45

09.01 - (Shift + →) - Extending Selection by One Cell Right
02:00

09.02 - (Shift + ←) - Extending Selection by One Cell Left
03:00

09.03 - (Shift + ↑) - Extending Selection by One Cell Up
01:30

09.04 - (Shift + ↓) - Extending Selection by One Cell Down
03:00

09.05 - (Ctrl + Shift + →) - Extending Selection to the Last Cell Right
02:00

09.06 - (Ctrl + Shift + ←) - Extending Selection to the Last Cell Left
02:45

09.07 - (Ctrl + Shift + ↓) - Extending Selection to the Last Cell Down
02:15

09.08 - (Ctrl + Shift + ↑) - Extending Selection to the Last Cell Up
03:00

09.09 - (Shift + Page Up) - Extending Selection Up One Screen
02:15

09.10 - (Shift + Page Down) - Extending Selection Down One Screen
02:30

09.11 - (Shift + Home) - Extending Selection to Start of Row
02:45

09.12 - (Ctrl + Shift + Home) - Extending Selection to First Cell in Worksheet
02:45

09.13 - (Ctrl + Shift + End) - Extending Selection to Last Cell in Worksheet
03:30

09.14 - (F8) - Toggling Extend Selection Mode On or Off
02:30
+
Making a Special Selection (10.00)
15 Lectures 56:00
10.00 - (Section 10) - Introduction to Making a Special Selection
07:00

10.01 - (Ctrl + G) - Displaying the "Go-To" Dialog Box
04:30

10.02 - (Ctrl + Shift + O) - Selecting Cells with Comments
04:00

10.03 - (Ctrl + Shift + 8) - Selecting the Current Region around Active Cell
03:30

10.04 - (Ctrl + A) - Selecting the Current Region
02:30

10.05 - (Ctrl + \) - Selecting Row Differences
03:45

10.06 - (Ctrl + Shift + |) - Selecting Column Differences
03:00

10.07 - (Ctrl + [) - Selecting Direct Precedents
04:00

10.08 - (Ctrl + Shift + {) - Selecting All Precedents
04:30

10.09 - (Ctrl + ]) - Selecting Direct Dependents
03:45

10.10 - (Ctrl + Shift + }) - Selecting All Dependents
04:00

10.11 - (Alt + ;) - Selecting Visible Cells Only
05:00

10.12 - (Shift + Spacebar) - Selecting a Table Row
02:30

10.13 - (Ctrl + Spacebar) - Selecting a Table Column
01:30

10.14 - (Ctrl + A) - Selecting a Table
02:30
10 More Sections
About the Instructor
The ProductivityMe Company
4.1 Average rating
1,672 Reviews
36,303 Students
26 Courses
Excel Tips, Tricks, & Tutorials, One Lesson at a Time.

ProductivityMe

Try. Learn. Conquer. Excel.

We create short, engaging videos that help people Master Excel.

We offer simple and easy-to-follow courses, and like our thousands of students, we’re always excited to learn cool new things.

This is ProductivityMe.

Udemy Course Instructors

Tolan Thornton
ProductivityMe Co-founder & Lead Udemy Instructor

Tolan went to the University of Arizona. He graduated summa cuma laude in the top 1% of his class with a Bachelor’s of Science Administration in Finance & Entrepreneurship and a Bachelor’s of Arts in French & East Asian Studies.

Tolan has worked at a top-tier economic consulting firm, specializing in Energy Deals and Financial Litigation.

Fun Facts about Tolan:

Tolan is the oldest of 3 children. He loves to travel.

Tolan has lived in Paris, New York, London, Beijing, Hangzhou, and Casablanca.

Odd fact? Tolan’s left leg is 5mm shorter than his right.

If Tolan had a year off, he’d learn a fourth language- maybe Portuguese, Spanish, or Hindi.

Ryan FitzPatrick
ProductivityMe Co-founder & Udemy Instructor

Ryan graduated summa cuma laude in the top 3% of his class with a Bachelor’s of Science Administration in Management Information Systems & Entrepreneurship.

Ryan has worked in non-profits as well as in Enterprise Management Software. He has worked as a consultant, as a tutor, even a bit in retail!

Fun Facts about Ryan:

Ryan is the younger of 2 children. Though he travels a lot for work, Ryan thinks of Tucson as home.

Ryan loves to write. Short-stories and essays are mostly his passion, but Ryan has even started screenplays, just for kicks!

If Ryan had a year off, he’d probably learn to code. That or start (another) company. Who knows, maybe he’d even do both!