Excel: Time Saving Tips That Will Boost Your Productivity

Microsoft Excel Tips for People Who Want to Improve Their Skills and Save Time.
4.2 (45 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,663 students enrolled
Take This Course
  • Lectures 86
  • Length 4.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course 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:


↳ 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


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

What are the 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.

What am I going to get from this course?

  • 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!

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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Latest Excel Time Savers Quick Tip

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

Section 2: Welcome to Excel Tips

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


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

Section 3: Excel Navigation, Workbook Environment, & Worksheet Tips

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.


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


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


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


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


Learn to Quickly Navigate to Worksheets in your Excel workbooks


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


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

1 page

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


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


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


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

You can.


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


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


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


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

2 pages

Keep this printable Keyboard Shortcut document handy when working on Excel

2 pages

Keep this printable Keyboard Shortcut document handy when working on Excel


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


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


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.


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


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

Section 4: Useful Tips on Excel Formulas & Functions

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


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.


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


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


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


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


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


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


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


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


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


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

There is a keyboard shortcut for that.

Section 5: Using Data Validation for Data Entry in Excel

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.


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


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


Create your own custom Error Messages in Excel

Section 6: Special, Custom, and Conditional Formatting in Excel
1 page

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.


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


An explanation of custom number formats in Excel


An example of custom number formats in Excel

1 page

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


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


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


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


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

Section 7: Excel Tables & Lists

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


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


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


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


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

Section 8: Excel Charts

Learn how to quickly create charts in Microsoft Excel


Quickly format the features of your charts in Excel


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


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


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


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

Section 9: Excel PivotTables & PivotCharts

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


Learn how to quickly analyze your Excel spreadsheets using PivotTables


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


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


Use Timelines in Excel to filter by dates

Section 10: Printing Excel Data

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.


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


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


Learn how to set your own Page Breaks in Excel


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


Add a watermark to your Excel spreadsheets

Section 11: Protecting Excel Files

Learn how you can protect your Excel files from someone accidentally deleting functions and formulas


You can create ranges that are only editable by certain people


Don't want others rearranging your Excel spreadsheets?
This lecture will show you how that's done


You can protect your Excel workbook so that users need a password to open it and/or modify it

Section 12: Excel Macros

Macros in Excel are a huge topic. This section will give you an introduction of what a macro can do


Learn how to quickly run your macro by assigning it to a button


Learn how to quickly run your macro by assigning it to the Quick Access Toolbar


A macro project for quickly navigating through your Excel workbook


A brief explanation of how you can maintain your macros in Excel

Section 13: Wrap Up!

Thanks for being a part of this Udemy course. I hope that it has helped to further your understanding of Microsoft Excel. If you have any questions, please let me know. I look forward to your feedback & review.

1 page

What can you do, now that the course is complete, to help you in Microsoft Excel?

Here are your next steps.


For those new to Excel 2013, this free guide provided by Microsoft has useful tips to help you find your way around.


Get Going on Your 2017 Goals by Enrolling in My Courses for $10

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, Computer 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.

Ready to start learning?
Take This Course