Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide

Learn to Master 230+ Microsoft Excel Keyboard Shortcuts and Become an Excel Guru in No Time!

3.60 (44 reviews)

Udemy

platform

English

language

Microsoft

What you will 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

Why take this course?

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:

First, we'll provide an introduction to what we’ll cover in the lesson
Then we'll show you the keyboard shortcut
Next we'll show you how to achieve the same result without using the specific shortcut
Then. we'll review what we covered in the lesson
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

Screenshots

Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide - Screenshot_01

Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide - Screenshot_02

Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide - Screenshot_03

Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide - Screenshot_04

Reviews

Bob

February 27, 2017

Short lessons, easy to understand, easy to remember, easy to access key elements of the lessons as desired

Hendrick

October 3, 2016

Thorough, but an "abridged" version of the course seems like it would be better. Could easily be cut from 17 hours to 5 hours just by integrating multiple shortcuts into one 5 minute video rather than across 10 videos taking 30 minutes, 2/3rds of which is just the host saying "Hello" and such. Kind of padded for time. That's inefficiency. But, it does go thoroughly seemingly every combination of shortcuts, so, that's good. Recommended: watch it on 2x speed.

Excel

February 11, 2016

Very thorough course. It will literally cover every shortcut available. I would suggest cutting out the first and last 30 seconds of most of the videos. Since the videos are very short and plentiful the intro and ending of each course are unnecessary and time consuming.

Luz

November 18, 2015

I enjoyed this course for several reasons. The instructor was well-spoken and engaging, the examples given were easy to follow, and the explanations of how to achieve the same results without a shortcut were great. That being said, I am a daily Excel user and when I perusing through the course description, I saw that many of the shortcuts were familiar, but some were not. I opted to grab the class, but in taking it I realized quickly how bulky the course actually is. Since I didn't need to watch many of the videos, the ones that weren't watched sat untouched. I had to manually go in and mark all of them since (to my knowledge) Udemy doesn't have a bulk 'Mark as completed' functionality. I would have liked to see a smaller course - perhaps a series with the lectures split over two or three courses. The information was good, I was just not a fan of the format.

Charts

Price

Rating

Enrollment distribution

Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide - Distribution chart