Excel® Tips: Time-saving Tricks and Hints

Lorman Education Services
Training overview
Professional Course
Self-paced Online
1 hour
From 99 USD

Start dates
99 USD
Start anytime

Course description

Excel® Tips: Time-saving Tricks and Hints

Learn powerful productivity-boosting tips and secrets that will speed up your work in Excel.

Few people learn or use Excel for fun. In fact, many people see it as a necessary evil. So if you have to use it, why not learn to use it faster and more effectively? How often have you found yourself in Excel thinking there must be a better and faster way to do this.

This material will help you learn a handful of powerful productivityboosting tips and secrets that will speed up your work in Excel, save you hours of time and remove some of those hairtearingout moments.

Who should attend?

This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers, and accountants.

Training content

Data Entry Shortcuts

  • Transpose
  • Autofill
  • Flash Fill

Copy and Paste With a Single Click

  • Automate Cell Formatting
  • Using Conditional Formatting to Automatically Format a Cell Based on Its Contents

Working With Dynamic Ranges

  • Create and Manage Range Names
  • Create, Manage, and Work With Tables


  • Worksheet Protection
  • Workbook Protection

Certification / Credits


Learning Objectives

  • You will be able to define flash fill and why you should use it.
  • You will be able to describe how conditional formatting can save you time.
  • You will be able to discuss the benefits of tables.
  • You will be able to explain how to use autofill lists.

About Lorman Education Services

Lorman Education Services - Live and On-Demand Courses

Lorman Education Services is a leading provider of online professional development and corporate training for organizations and individual professionals. For more than 30 years, Lorman has delivered relevant, high-quality, professional-level courses that cover a broad range of business and technical...

Read more and show all training delivered by this supplier

Contact info

Lorman Education Services

Lorman Education Services
2510 Alpine Road
54702 Eau Claire Wisconsin

Training reviews

No reviews available

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote