Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide

Learn to Master 230+ Microsoft Excel Keyboard Shortcuts and Become an Excel Guru in No Time!
4.1 (21 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,299 students enrolled
$19
$45
58% off
Take This Course
  • Lectures 257
  • Length 17 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2015 English

Course 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


What are the requirements?

  • A Windows version of (i.e., PC version of) Excel 2007, Excel 2010, Excel 2013, or Excel 2016

What am I going to get from this course?

  • 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

What 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)

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Basics
Welcome to the Course!
02:50
DOWNLOAD: Referenceable PDF and Excel File
Article
OPTIONAL LECTURE: Long Discussion Course Structure & Design
15:30
OPTIONAL LECTURE: Long Discussion on What's in the Course
Preview
12:45
Section 2: Using the File Menu (01.00) Using the Ribbon (02.00)
01.00 - (Section 1) - Introduction to Using the File Menu
Preview
07:00
01.01 - (Ctrl + N) - Creating a New Workbook
Preview
04:15
01.02 - (Ctrl + O) - Opening a Workbook
Preview
05:15
01.03 - (Ctrl + S) - Saving a Workbook
Preview
06:45
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.00 - (Section 2) - Introduction to Using the Ribbon in Excel
Preview
07:00
02.01 - (Ctrl + F1) - Expanding or Collapsing Ribbon Commands
Preview
03:15
02.02 - (Ctrl + Shift + F1) - Expanding or Collapsing Ribbon Commands & Tabs
Preview
02:45
02.03 - (Alt) - Activating the Access Keys
Preview
04:30
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
Section 3: Using Menus & Dialog Boxes (03.00)
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
Section 4: Using Workbooks (04.00)
04.00 - (Section 4) - Introduction to Using Workbooks
07:45
04.01 - (Shift + F11) - Inserting a New Worksheet
Preview
04:30
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
Section 5: Modifying Columns & Rows (05.00)
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
Section 6: Navigating within Excel (06.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
Section 7: Making a Selection (08.00)
07.00 - (Section 7) - Introduction to Making a Selection
04:30
07.01 - (Shift + Spacebar) - Selecting an Entire Row
Preview
03:45

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

The ProductivityMe Company, 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!

Ready to start learning?
Take This Course