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
Protection
- Worksheet Protection
- Workbook Protection
Certification / Credits
Credits: AIPB ,ASAP PACE ,IAAP ,CPE
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...
