Excel made easier with these powerful tips and time savers
5.0 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6 students enrolled

Excel made easier with these powerful tips and time savers

Speed up your every day tasks in Excel by applying this powerful and easy-to-use tips and shortcuts.
5.0 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6 students enrolled
Created by Stephanie Johnson
Last updated 8/2019
English [Auto]
Current price: $12.99 Original price: $19.99 Discount: 35% off
14 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Tips and time savers that span from the novice to advance users. Each user can raise their level by applying the skills obtained in this powerful course.
  • Basic excel knowledge of formatting, formulas and reporting tools like tables and pivot tables

Some Excel tasks can be difficult which may cause us to work harder in Excel.  This tasks can now be completed much quicker once we know about the shortcuts contained in this course. 

I have spent many years compiling the tips that makes any user more proficient in Excel.  Use the time savers highlighted throughout the course to avoid doing tasks manually.  Complete common tasks quicker, faster and easier by using the right tool for each task.   This course also includes a link to student files and a quick reference guide for many of the shortcuts at a glance.

Who this course is for:
  • All audiences of any level
Course content
Expand all 33 lectures 01:33:20
+ Introduction
1 lecture 06:44

Watch this video that gives an overview of the course and 10 quick tips and shortcuts to get started

Preview 06:44
+ Entering and selecting data shortcuts and time savers
5 lectures 11:12

Create a sum formula vertically and horizontally at once to save time using this shortcut.

Preview 03:06

Use shift or ctrl to select cells.  Select all data at once without highlighting manually.

Preview 02:39

Quick copy contents from neighboring cells for quick data entry

Keyboard shortcuts - Copy contents from neighboring cells

Enter the current date or time using keyboard shortcuts instead of typing

Keyboard shortcuts - Enter today's time and date with typing

Use edit mode to enter data on separate lines within the same cell

Enter data on a second line in the same cell - keyboard shortcut
+ Microsoft suite shortcuts (universal shortcuts)
5 lectures 09:40

Use the keyboard shortcuts for save or save us to reduce steps to save or update spreadsheets.  Close current windows using a keyboard shortcut too.

Save and Save as

Use cut, copy, and paste keyboard shortcuts to quickly execute these common tasks in Excel

Copy, cut, and paste

No need to worry about mistakes in Excel, simply undo and redo using these keyboard shortcuts

Undo and Redo

Use spellcheck in all of the Microsoft suite using this keyboard shortcut


No cut and paste need just use the shortcut to move data

Bonus time saver - just move the data quickly
+ Navigating in Excel worksheets shortcuts
4 lectures 08:48

Navigate in a spreadsheet quickly using these keyboard shortcuts

Move up, down, left and right

Go to top or bottom of data with keyboard shortcuts instead of scrolling up and down with the mouse

Go to the beginning and end of data

Select a large range of data by using shortcuts instead of highlighting manually

Highlight a range of data shortcuts

Highlight a row or column using these keyboard shortcuts

Highlight a row or column
+ Formulas and charts shortcuts
7 lectures 17:21

Use this keyboard shortcut to create sum formulas vertically and horizontally all at once

Keyboard shortcut - sum all your data at once

Create an embedded chart using this keyboard shortcut

Keyboard shortcut - create an embedded chart

Create a chart on a separate worksheet using the keyboard shortcut

Keyboard shortcut - create a chart on a separate worksheet

Save time creating a named range by using the name box

Create a named range

Create multiple name ranges with the keyboard shortcut

Time saver - Save time selecting cells by using named ranges in formula

Save time using paste name shortcut to create formulas using named ranges

Keyboard shortcut - using named ranges in formulas

Keep cells constant in a formula by inserting the keyboard shortcut for absolute

Adjust your formulas to keep a cell constant - Keyboard shortcut
+ Formatting shortcuts
3 lectures 07:11

Quickly format using shortcuts

Keyboard shortcuts - Bold, underline, italicize and more

Apply date, percentage, currency or number formats with keyboard shortcuts

Currency, date, and percentage formats

Use this shortcut to easily change data types using format cells

Format cells dialogue box shortcut
+ Worksheet time savers
3 lectures 08:18

Save time by making a replica of a worksheet using a shortcut rather than move or copy command

Copy a worksheet - quickly make a replica of a worksheet

Update multiple worksheets at one time using grouping

Group worksheets - update multiple sheets at once

Update two or more spreadsheets at once with links

Link cells - save time by linking cells
+ Data manipulation time savers
5 lectures 24:06

Separate one column into multiple columns using this command

Text to columns - separate data

Join data using concatenate function and paste values using secret menus

Concatenate - join data

Change the appearance of the data by using text functions

Text functions - change the appearance of data

The ultimate time saver; join, separate, create new text strings, change the appearance of data all with one tool

Flash fill - separate or join data or change the appearance of data

This is a common time saver needed to paste only the filtered data

Keyboard shortcut - Copy filtered data only to a new location