Reducing Repetitive Tasks in Microsoft Office

• OVERVIEW

Many of us repeat tasks with Microsoft Office in our day-to-day work. Wouldn’t it be helpful if the programs provided some features to allow us to automate those tasks? Fortunately, there are many options available. This 60-minute webinar will explore several functions in Microsoft Word and Excel that will save you hours of effort and time.

• LEARNING OBJECTIVES

How they can save time copying and pasting multiple pieces of data across documents?

• How to utilize built-in Excel functionality to enforce consistency when multiple users are entering data?
• Lesser known options for globally finding and replacing data such as text that changes and formatting and more. 
• What macros are, why they should be used, and how they can save hours of time and effort?
• Ways to utilize the building blocks organizer to create boilerplate text 
• Methods of identifying and removing duplicate data in Excel
• Flash fill and other methods of combining and separating fields in Microsoft Excel and Word

 

• WHY SHOULD YOU ATTEND

If you find yourself frustrated by the amount of time you spend on routine tasks in Microsoft Office, you will definitely appreciate this webinar. The training will be delivered using Office 365 (2016) for Windows although, for users of earlier versions, the functionality is available in Office 2010 and 2013.

• AREAS COVERED

This webinar will cover: 

• Shortcuts to streamline copying and pasting.
• Setting up rules to enforce consistency and utilize drop-down lists through data validation in Microsoft Excel
• Find and replace settings that most people have never explored
• How to set up a macro?
• Creating AutoText entries and Building Blocks to automate document preparation from cover pages to corporate branding to document properties and more.
• The remove duplicates function in Microsoft Excel and other methods of identifying duplicate data
• Options for combining and separating data in Word and Excel 

 

• WHO WILL BENEFIT?

 

• Anybody who uses Microsoft Office on a regular basis, and wants to be more efficient and productive
• Administrative professionals
• Executive assistants
• Business owners
• CEO's / CFO's / CTO's
• Anybody who regularly inputs data