Excel: Time Saving Tips That Will Boost Your Productivity
4.5 (49 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,685 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: Time Saving Tips That Will Boost Your Productivity to your Wishlist.

Add to Wishlist

Excel: Time Saving Tips That Will Boost Your Productivity

The Tools You Need to to Improve Your Excel Skills, and Save Time.
4.5 (49 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,685 students enrolled
Created by Isá Harrison
Last updated 5/2017
English
Current price: $10 Original price: $105 Discount: 90% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 4 Articles
  • 50 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • QUICKLY Navigate Through Your Excel Workbooks
  • SAVE TIME with Keyboard Shortcuts
  • TRACK the Changes Users Make to Your Spreadsheets
  • CREATE a Data Entry Form Fast with Excel's Built-In Form Tool
  • CREATE Functional Tables with a Couple of Keystrokes
  • SORT Data with Your Own Custom Sort Lists
  • QUICKLY Format Your Charts
  • CREATE PivotTables & PivotCharts
  • SET UP Printing the Way You Want
  • PROTECT Your Excel Workbooks
  • CREATE Simple Time-Saving Macros
  • ... and much more!
View Curriculum
Requirements
  • You should already be familiar with basic navigation in Excel.
  • You should be familiar with concepts like entering data, and how to create charts.
Description

You use Excel.  You want to use it faster.

Faster Excel with Less Stress, That is What You Will Get By Enrolling In This Course.


By the end of this course, you will learn over 70 ways to:

↳ NAVIGATE FASTER and BETTER ORGANIZE your Workbooks

↳ Learn TIME SAVING Analysis Tools, and FORMULAS

↳ Have DATA VALIDATION Help You Restrict What Users Can Enter Into Your Workbooks

↳ CONDITIONAL FORMATTING Your Data for Faster Analysis.

↳ Create TABLES, and CHARTS Quickly.  Learn About SPARKLINES, and How to Create a SECONDARY AXIS.

↳ See How Easy it is to CREATE PIVOTTABLES

↳ PRINTING Done Right.

↳ Learn to Create Simple MACROS

... MUCH, MUCH MORE


ENROLL Right Now, and Join the Over 3,600 Others Who Decided to Become a Better Excel User.


Who is the target audience?
  • This Excel course is meant for anyone, and everyone who wants to save time, and work more efficiently in Excel 2010, 2013, or 2016
  • This course is not for anyone who needs to know the basics of Excel, step-by-step.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
86 Lectures
04:38:45
+
Latest Excel Time Savers Quick Tip
1 Lecture 00:05

Get the latest Quick Tip for Microsoft Excel Tips: Spotlight on Excel Time Savers

Preview 00:05
+
Welcome to Excel Tips
2 Lectures 02:15

Welcome to Excel 2013 Tips & Tricks: Spotlight on Time Savers on Udemy.com

Preview 01:58

Use copies of the attached workbook for exercises in thisExcel: Time Saving Tips That Will Boost Your ProductivityUdemy.com course

The Exercise Files
00:17
+
Excel Navigation, Workbook Environment, & Worksheet Tips
23 Lectures 01:16:19

Customize Excel's Ribbon. Create your own tab(s) on the Ribbon to find what you need most, when you need it.

Even share the customizations with others.

Preview 09:31

Find the Excel tools you need fast with the Quick Access Toolbar

Preview 06:36

Learn the quick ways to select cells and ranges of cells in your Excel workbooks

Selecting Cells & Ranges
05:50

Use your mouse and the CTRL key in this quick tip on moving and copying cells in Excel

Moving & Copying Cells
02:22

You are not limited to only copying one item onto the Clipboard. Learn the power of the keyboard.

Copying Multiple Items to Office Clipboard
01:58

Learn to Quickly Navigate to Worksheets in your Excel workbooks

Quickly Navigate to Worksheets
01:26

Take advantage of being able to name your cells and ranges by using those names as Navigation tools in your Excel workbooks

Named Ranges for Navigation
04:53

The Fill Series has so many uses. Learn how they can help you save time in Excel

Fill Series: Quickly Copy Formulas, Text, and Create Series Patterns
06:12

Learn the quick tip on inserting the same data into multiple cells

Quickly Insert the Same Data into Multiple Cells
1 page

Use Freeze Panes to keep your headings in place when working with long spreadsheets

Make Sure Your Headings Stay Put with Freeze Panes
04:04

Too much data in one cell? Learn how to split your data into multiple columns.

Splitting Data Into Multiple Columns
02:57

You have probably tracked changes in Microsoft Word. Did you know that you can also track changes in Excel?

You can.

Track, Accept, and Reject Changes Made to Your Workbooks
04:07

When you need to add data to multiple existing Excel worksheets, watch this lecture.

Grouping Worksheets to Quickly Add Data
02:32

This quick lecture, shows you the quick way to copy and rename your Excel worksheets

Copying and Renaming a Worksheet
02:02

Coloring your Excel worksheet tabs is a great way to get organized

Changing a Worksheet Tab Color to Help You Organize Your Workbook
01:33

Learn the quick way to enter the Current Date and Time on your Excel Worksheets

Entering the Current Date and Time
02:47

Keep this printable Keyboard Shortcut document handy when working on Excel

Useful Keyboard Shortcuts: Function Keys
2 pages

Keep this printable Keyboard Shortcut document handy when working on Excel

Useful Keyboard Shortcuts: CTRL +
2 pages

Learn how the ALT key can help you quickly navigate through Excel's Ribbon commands

Useful Keyboard Shortcuts: ALT keys - KeyTips
02:54

AutoCorrect can do a lot more than just fix your misspelled word in Excel. Find out what else AutoCorrect can do

AutoCorrect: It's More Than Just For Misspelled Words
03:45

Did you know you can turn your lists and tables into forms with just one click?
Learn to create a user-friendly form for easy data entry and searching.

Preview 03:34

Use Excel's Camera tool to Take a Picture of the Data You Need to Track

The Camera Tool: Take a Picture of the Data You Need to Track
04:43

In Excel you are not limited to rectangular shaped comment call-outs

Changing the Shapes of Comments - Make Your Notes Stand Out.
02:33
+
Useful Tips on Excel Formulas & Functions
12 Lectures 51:55

3D formulas allow you perform functions on values across multiple worksheets in your Excel workbooks

3D Formulas: Calculate Across Multiple Worksheets
04:24

You copy down your formulas and functions, but something is just not right.
Are you using Absolute or Relative Reference?
What is that, and how can you tell?

Watch this lecture and find out.

Preview 04:11

Probably one of my favorite ways to use named ranges. Learn how named ranges can benefit you, and others using your Excel workbooks

Named Ranges in Formulas
07:44

This is not just a regular SUM, but a SUM based on a true condition

SumIf: Sum Your Data Only If It Meets a Condition
04:09

This is not just a regular SUM, but a SUM based on multiple true conditions

SumIfs: Sum Your Data If It Meets Multiple Conditions
03:04

I am a visual person so I like to use the dashboard like features of the DSUM function in Excel

DSum: Sum Your Data with a Database Dashboard
06:50

VLookup is a powerful and very handy tool inside of Excel. Learn how you can use it for your spreadsheets

VLookup: Learn the Lookup Everyone Is Talking About
08:26

The IfError function in Excel returns a value if a formula evaluates to an error; or it will return the result of the formula.

IfError
02:30

Use Left, Right, and Mid functions in Excel to extract only parts of a cell's value

Left, Right, Mid: Use Information From Just Certain Parts of Strings
02:52

The Find function in Excel can help you quickly locate characters in your spreadsheet

Find: Quickly Locate Characters
04:37

You the Rank function in Excel to find how your values rank compared to others

Rank: Find the Ranked Values of Your Data
02:18

Ever look at your Excel spreadsheet and wonder what formula is running behind a cell, or cells?

There is a keyboard shortcut for that.

Showing and Printing Formulas
00:50
+
Using Data Validation for Data Entry in Excel
4 Lectures 11:22

Want an easy way to make sure users enter only the information you want them to enter into a cell or range of cells? Create a drop-down list.

Preview 02:36

Learn how to create drop down boxes that list values based off of the value in a previously selected drop down.

Dependent Drop-Down Lists
03:43

Limit the number of characters others can type into a cell or range of cells in Excel

Character Limits for Cells
01:31

Create your own custom Error Messages in Excel

Creating Custom Input Messages and Error Alerts
03:32
+
Special, Custom, and Conditional Formatting in Excel
9 Lectures 27:04

If you are enjoying this Microsoft Excel Tips & Tricks course, please leave a positive comment, and a rating, which you can do at the top right hand corner of the Course Dashboard.

It takes less than a minute and it is a huge help to other students, and to me too.

How Are You Enjoying the Course?
1 page

Learn about special number formats in Excel, like phone numbers, social security numbers, and more

Special Number Formats: Phone Numbers, Social Security Numbers, and Zip Codes
03:20

An explanation of custom number formats in Excel

Custom Number Formatting: Explained
07:42

An example of custom number formats in Excel

Custom Number Formatting: Examples
03:52

Learn how to use custom formatting to hide the data in your workbook.

Using Custom Formatting to Hide Portions of Your Worksheet
1 page

Learn how conditional formatting can turn your Excel spreadsheet from drab, to fab

Conditional Formatting
07:28

Quick Analysis is a new feature in Microsoft Excel. Learn how you can use it on your spreadsheets.

Conditional Formatting with Quick Analysis
01:22

When using Conditional Formatting in Excel, you can hide the values, and just show the icons

Conditional Formatting to Just Show Icons or Bars
01:16

It's not just Find and Replace, it's Find and Replace with Formatting.


Find & Replace with Formatting
02:04
+
Excel Tables & Lists
5 Lectures 21:14

Using tables instead of lists has big benefits in Excel. Learn what they are in this lecture

Creating Tables
07:23

Use Slicers in Excel to create a User-Friendly dashboard to help you and other users quickly filter data

Slicers: The User-Friendly Way to Filter Your Tables
04:29

When sorting ascending or descending just won't do, create your own custom sort list in Excel

Sorting by Custom Lists
03:14

Created a table, but need the rows in the columns and the columns in the rows? Transposing your data in Excel is quick and easy

Transposing Data
01:33

The Subtotals tool is a fast way to add subtotals to your Excel lists

Quickly Create Subtotals for Your Lists
04:35
+
Excel Charts
6 Lectures 14:40

Learn how to quickly create charts in Microsoft Excel

Keyboard Shortcut & Quick Analysis
01:48

Quickly format the features of your charts in Excel

Quick Formatting
02:35

Learn how to create an exploding, 3D pie chart in Excel

Exploding Pie Charts
01:30

Sparklines in Excel are like mini charts in a cell. See if it is a feature that would work for you.

Sparklines: Single Cell Charts
03:56

Creating a Secondary Axis in Excel has never been easier. Watch this lecture to see how easy it is.

Combination Charts – Secondary Axis
01:45

Need your Excel chart in a Word or PowerPoint presentation? Here is how to do it...

Copy a Chart to Word or PowerPoint
03:06
+
Excel PivotTables & PivotCharts
5 Lectures 21:20

What are PivotTables and why would you want to use them?

PivotTables & PivotCharts Overview
03:23

Learn how to quickly analyze your Excel spreadsheets using PivotTables

Creating PivotTables
06:37

PivotTables and PivotCharts go hand in hand. Learn how to quickly create PivotCharts in Excel

Creating PivotCharts
01:58

Just like with tables, Slicers are a great way to filter PivotTable data

Slicers
05:58

Use Timelines in Excel to filter by dates

Timelines: Dashboard Filters for Your Date Field
03:24
+
Printing Excel Data
6 Lectures 13:25

Ever notice that when you print a spreadsheet in Excel, the heading only show on the first page by default?
Learn how to change that so your headings appear on every printed page.

Print Titles: Repeat Headings on Each Page
01:59

When you only want a few cells or range of cells to print you can set the print area.

Setting a Print Area
02:07

Whether it's one column or many rows, learn how to fit all of your records on one page in Excel

Fitting Everything On One Page
02:00

Learn how to set your own Page Breaks in Excel

Page Breaks
02:38

You can hide your #N/As, #DIV0s, and other errors when printing your Excel spreadsheets

Hiding Errors
02:09

Add a watermark to your Excel spreadsheets

Watermarks
02:32
3 More Sections
About the Instructor
Isá Harrison
4.6 Average rating
875 Reviews
14,851 Students
15 Courses
Results & Convenience | Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.


Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, because Change Matters, Growth Matters.