Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide from Udemy

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

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

See you in a few.

Cheers,

Tolan & RyanCourse Instructors & ProductivityMe Co-Founders

What's inside

Syllabus

Course Basics

Welcome to the Course!

DOWNLOAD: Referenceable PDF and Excel File

OPTIONAL LECTURE: Long Discussion Course Structure & Design

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Provides a comprehensive guide to Excel keyboard shortcuts, which can significantly improve efficiency and productivity for users of all levels

Includes a dynamic Excel file and a colored PDF reference guide, offering learners readily accessible resources to reinforce their learning and practice

Breaks down complex actions into simple, easy-to-follow video tutorials, making it accessible for beginners to grasp and apply advanced Excel techniques

Focuses on using keyboard shortcuts to perform common Excel actions, which may not be applicable to other spreadsheet software

Features over 250 individual lessons, which may be overwhelming for learners seeking a quick introduction to Excel or a refresher on specific topics

Teaches shortcuts for a specific version of Excel, and some shortcuts may not work or may have changed in newer versions of the software

Reviews summary

Boost your excel efficiency with shortcuts

According to learners, this course is a highly effective guide to mastering Excel keyboard shortcuts, significantly boosting productivity and saving time. Students appreciate the bite-sized lessons and valuable reference files (Excel and PDF). It's often cited as excellent for beginners building a shortcut foundation. However, some experienced users found parts too basic. Overall sentiment is strongly positive, praising the clear instruction.

Covers a large number of useful Excel keyboard shortcuts.

"Was surprised by how many useful shortcuts I didn't know were covered."

"Truly comprehensive, covering everything from basic navigation to macros."

"Over 230 shortcuts covered means there's something for everyone."

Instructors explain concepts clearly and engagingly.

"The instructor was easy to understand and kept the lessons engaging."

"Tolan explains things very clearly."

"Appreciated the calm and methodical approach to teaching each shortcut."

Ideal for those new to shortcuts or wanting a solid foundation.

"As a beginner, this course was exactly what I needed to get started."

"Perfectly paced for someone who hasn't used many shortcuts before."

"Highly accessible even if you're not tech-savvy, just starting with Excel."

Provided Excel and PDF guides are excellent resources.

"The downloadable reference files are invaluable, I keep them open while working."

"The Excel file is dynamic and helps practice the shortcuts interactively."

"Having the PDF guide handy makes recalling shortcuts much easier."

"The reference documents alone are worth the price."

Short, focused lessons make learning and retention easy.

"The short, focused lessons were perfect for fitting into my busy schedule."

"Each video covers just one or two shortcuts, making it easy to digest."

"I appreciated the consistent structure of showing the shortcut vs. the long way."

"Great for learning incrementally without feeling overwhelmed."

Learn shortcuts to save significant time in Excel tasks.

"These shortcuts are incredibly practical and have already saved me hours at work."

"Finally tackling those tedious tasks in seconds thanks to these tips!"

"Highly recommend this course for anyone who uses Excel regularly and wants to work faster."

"Immediately applicable tips that make daily Excel use much more efficient."

May be too basic or repetitive for experienced users.

"Some of the lessons covered shortcuts I already knew, felt a bit repetitive."

"Wish there were more advanced techniques or real-world application examples."

"If you're already a heavy shortcut user, you might only find a few new gems."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide with these activities:

Review Basic Excel Functions

Show steps

Strengthen your understanding of fundamental Excel functions. This will provide a solid base for efficiently using keyboard shortcuts to manipulate these functions.

Browse courses on SUM

Show steps

Identify the most common Excel functions you use.
Practice using these functions with sample data.
Review the syntax and purpose of each function.

Shortcut Flashcards

Show steps

Memorize keyboard shortcuts through spaced repetition. This will improve recall speed and muscle memory.

Show steps

Create flashcards with the shortcut on one side and the action on the other.
Review the flashcards regularly, focusing on the ones you struggle with.
Use the shortcuts in Excel while reviewing to reinforce learning.

Create a Cheat Sheet

Show steps

Compile a personalized cheat sheet of the most useful shortcuts. This will serve as a quick reference guide and reinforce learning.

Show steps

Identify the shortcuts you use most frequently.
Organize the shortcuts by category (e.g., formatting, navigation).
Design a visually appealing and easy-to-read cheat sheet.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Read 'Excel 2019 Bible'

Show steps

Expand your knowledge of Excel features and functions. This will help you understand the context and purpose of various keyboard shortcuts.

View Putting Knowledge to Work on Amazon

Show steps

Browse the table of contents to identify relevant sections.
Read the sections related to the Excel features covered in the course.
Experiment with the features and shortcuts in Excel.

Automate a Task with Shortcuts

Show steps

Apply learned shortcuts to automate a repetitive Excel task. This will demonstrate practical application and improve efficiency.

Show steps

Identify a repetitive task you perform in Excel.
Determine which shortcuts can be used to automate the task.
Create a step-by-step guide using the shortcuts.
Test and refine the automated process.

Read 'Microsoft Excel Functions & Formulas'

Show steps

Deepen your understanding of Excel functions and formulas. This will allow you to use shortcuts more effectively to create complex calculations.

View Microsoft Excel Functions and Formulas with... on Amazon

Show steps

Review the chapters on the functions you use most often.
Practice using the functions and formulas with sample data.
Explore the advanced functions and formulas to expand your knowledge.

Help Others with Excel Shortcuts

Show steps

Reinforce your knowledge by teaching Excel shortcuts to others. This will solidify your understanding and identify any gaps in your knowledge.

Show steps

Offer to help colleagues or friends with Excel tasks.
Explain the relevant shortcuts and demonstrate their use.
Answer questions and provide guidance as needed.

Career center

Learners who complete Microsoft Excel Keyboard Shortcuts: A Comprehensive Guide will develop knowledge and skills that may be useful to these careers:

Accountant

An accountant prepares and examines financial records. They ensure accuracy of financial information. Accountants utilize Excel to manage financial data, reconcile accounts, and create financial reports. This course on Excel keyboard shortcuts helps the accountant streamline their workflow and improve accuracy. The ability to quickly navigate spreadsheets, format data, and perform calculations is invaluable for day-to-day tasks. By using shortcuts for actions, such as autosumming cell values and instantly changing their formatting, an accountant can save time and reduce errors.

See salaries and explore the career path for Accountant

Budget Analyst

A budget analyst assists organizations in planning and managing their finances. They develop budgets, monitor spending, and analyze financial data to ensure efficient resource allocation. This course on Excel keyboard shortcuts helps the budget analyst to speed up their work with spreadsheets and financial models. Mastery of these shortcuts helps the budget analyst to create and manipulate budgets, forecast expenses, and analyze variances quickly. The shortcuts for actions, such as autosumming cell values and instantly changing their formatting, are particularly valuable.

See salaries and explore the career path for Budget Analyst

Data Analyst

A data analyst examines and interprets data to identify trends and insights. This work often involves using tools like Excel to clean, organize, and analyze datasets. This course on Excel keyboard shortcuts helps the data analyst to significantly improve their efficiency and speed while working with large datasets. Mastering these shortcuts allows the data analyst to perform complex operations quickly, such as data manipulation, formatting, and creating charts, which are essential for presenting findings. Being able to use more than 230 keyboard shortcuts is an asset to any data analyst.

See salaries and explore the career path for Data Analyst

Financial Analyst

A financial analyst uses Excel extensively for financial modeling, forecasting, and data analysis. They evaluate past and current financial data to make predictions about future performance. This course on Excel keyboard shortcuts helps the financial analyst to streamline their workflow and improve accuracy. The time-saving shortcuts covered help the financial analyst to manage large spreadsheets, create complex formulas, and generate reports efficiently. Skills such as autosumming cell values and instantly changing their formatting are vital to the financial analyst.

See salaries and explore the career path for Financial Analyst

Auditor

An auditor reviews financial records to ensure compliance and accuracy. They use Excel extensively to analyze financial data, identify discrepancies, and prepare audit reports. This course on Excel keyboard shortcuts helps the auditor to improve their efficiency when reviewing large datasets. The ability to navigate spreadsheets, select data, and perform calculations quickly facilitates the audit process. Auditors can deploy keyboard shortcuts for actions, such as adding, formatting, and removing cell borders in a flash, which ensure efficient data validation and analysis.

See salaries and explore the career path for Auditor

Business Intelligence Analyst

A business intelligence analyst leverages data to provide insights that inform business decisions. They are often tasked with creating dashboards and reports to visualize data trends. This course on Excel keyboard shortcuts helps the business intelligence analyst to quickly manipulate data, create visuals, and generate reports. Excel is an indispensable tool for them. The ability to navigate spreadsheets and select data quickly makes them more productive. The quick creation of new tables, filters, charts, and pivot tables is of enormous utility.

See salaries and explore the career path for Business Intelligence Analyst

Operations Analyst

An operations analyst works to improve an organization's efficiency and effectiveness by analyzing processes and data. They use Excel to create models, analyze data, and develop reports that drive operational improvements. This course on Excel keyboard shortcuts helps the operations analyst to enhance their data analysis and modeling skills. Being able to use more than 230 keyboard shortcuts helps perform common actions and functions quickly. Excel keyboard shortcuts will streamline work.

See salaries and explore the career path for Operations Analyst

Data Entry Clerk

A data entry clerk inputs and updates data into computer systems and databases. They use Excel for organizing and managing data. This course on Excel keyboard shortcuts helps the data entry clerk to improve speed and accuracy in data entry tasks. The ability to quickly navigate spreadsheets, select data, and perform basic data manipulation helps streamline the data entry process. The shortcuts for actions, such as copying, moving, or deleting a cell, a selection, or a worksheet in Excel, are extremely helpful.

See salaries and explore the career path for Data Entry Clerk

Research Assistant

A research assistant supports researchers by collecting, organizing, and analyzing data. They help to manage data to create reports. This course on Excel keyboard shortcuts helps the research assistant to improve efficiency in these tasks. The ability to use shortcuts for data manipulation, formatting, and analysis helps them contribute more effectively to research projects. Skills such as autosumming cell values and instantly changing their formatting are helpful to the research assistant.

See salaries and explore the career path for Research Assistant

Project Manager

A project manager uses Excel for task management, resource allocation, and project tracking. They rely upon spreadsheets to organize project data, monitor progress, and generate reports. This course on Excel keyboard shortcuts helps the project manager to streamline their project management processes. The ability to quickly navigate spreadsheets, update task statuses, and generate reports helps in efficient project monitoring. They can deploy shortcuts for actions, such as hiding, grouping, adding, and deleting columns and rows.

See salaries and explore the career path for Project Manager

Administrative Assistant

An administrative assistant provides support to ensure efficient office operations. They use Excel for various tasks, including data entry, organizing information, and creating reports. This course on Excel keyboard shortcuts helps the administrative assistant to improve their productivity and accuracy. The ability to quickly navigate spreadsheets, format data, and perform calculations streamlines many administrative tasks. Shortcuts such as copying, moving, or deleting a cell, a selection, or a worksheet in Excel, are useful.

See salaries and explore the career path for Administrative Assistant

Actuary

An actuary assesses and manages financial risks, often in the insurance and finance industries. They analyze statistical data to estimate probabilities of events such as death, sickness, injury, disability, or loss of property. Actuaries frequently use very large spreadsheets. Skills such as autosumming cell values and instantly changing their formatting are very useful. An actuary typically has an advanced degree (master's or phd, for example).

See salaries and explore the career path for Actuary

Statistician

A statistician collects, analyzes, and interprets numerical data to identify significant trends and relationships. While statisticians may use more specialized statistical software, Excel often serves as a preliminary tool for data exploration and manipulation. This course on Excel keyboard shortcuts may be useful for statisticians, helping them to quickly clean, organize, and explore datasets. This course will help statisticians to manipulate data, such as expanding or reducing your active selection by one or more cells, columns, or rows.

See salaries and explore the career path for Statistician

Market Research Analyst

A market research analyst studies market conditions to examine potential sales of a product or service. They collect and analyze data on consumer demographics, preferences, needs, and buying habits. This course on Excel keyboard shortcuts may be useful for market research analysts, helping them to efficiently manage and analyze large sets of survey data and consumer information. The ability to use shortcuts for filtering data and creating charts quickly aids in identifying market trends. An analyst can use the shortcut training to speed up data processing and analysis.

See salaries and explore the career path for Market Research Analyst

Management Consultant

A management consultant advises organizations on how to improve their efficiency and effectiveness. This often involves analyzing data and creating reports to support recommendations; Excel is often a key tool. This course on Excel keyboard shortcuts may be useful for the management consultant, helping them to quickly process and analyze data. The skills learned help them to manipulate data efficiently. The ability to instantly create new tables, filters, charts, and PivotTables can be helpful in preparing presentations.

See salaries and explore the career path for Management Consultant

Microsoft Excel Keyboard Shortcuts

A Comprehensive Guide

What's inside

Syllabus

Traffic lights

Save this course

Reviews summary

Boost your excel efficiency with shortcuts

Activities

Career center

Reading list

Share

Similar courses