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
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.
Requirements
  • Basic excel knowledge of formatting, formulas and reporting tools like tables and pivot tables
Description

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
01:05

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

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

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
02:20
+ 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
02:37

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

Copy, cut, and paste
02:18

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

Undo and Redo
01:56

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

Spellcheck
01:25

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

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

Navigate in a spreadsheet quickly using these keyboard shortcuts

Move up, down, left and right
03:25

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
01:51

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

Highlight a range of data shortcuts
02:06

Highlight a row or column using these keyboard shortcuts

Highlight a row or column
01:26
+ 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
03:12

Create an embedded chart using this keyboard shortcut

Keyboard shortcut - create an embedded chart
01:37

Create a chart on a separate worksheet using the keyboard shortcut

Keyboard shortcut - create a chart on a separate worksheet
00:46

Save time creating a named range by using the name box

Create a named range
02:29

Create multiple name ranges with the keyboard shortcut

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

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

Keyboard shortcut - using named ranges in formulas
01:47

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

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

Quickly format using shortcuts

Keyboard shortcuts - Bold, underline, italicize and more
01:41

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

Currency, date, and percentage formats
02:52

Use this shortcut to easily change data types using format cells

Format cells dialogue box shortcut
02:38
+ 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
00:55

Update multiple worksheets at one time using grouping

Group worksheets - update multiple sheets at once
02:52

Update two or more spreadsheets at once with links

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

Separate one column into multiple columns using this command

Text to columns - separate data
04:32

Join data using concatenate function and paste values using secret menus

Concatenate - join data
03:32

Change the appearance of the data by using text functions

Text functions - change the appearance of data
02:48

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
07:41

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

Keyboard shortcut - Copy filtered data only to a new location
05:33