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 productivity-boosting tips and secrets that will speed up your work in Excel, save you hours of time and remove some of those hair-tearing-out moments.

Learning Objectives

• You will be able to identify data entry shortcuts.
• You will be able to recognize how to copy and paste with a single click.
• You will be able to recognize how to work with dynamic ranges.
• You will be able to differentiate between workbook and worksheet protection.

Agenda

• 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
• Protection
  • Worksheet Protection
  • Workbook Protection