Call us at +1-(510)-868-1040

Login Register

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.


  • 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


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.


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 


  • 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


Marie Herman CAP, OM, ACS, MOSM conducts seminars and workshops around the world on technology and professional development topics. She leads online study groups for a variety of certification programs, including the Certified Administrative Professional exam and the Microsoft Office Specialist Master program. She writes a regular feature in Executive Secretary Magazine and has hosted multiple #adminchats.

Marie worked as an administrative professional for several decades, with past positions including support of the Chief Technology Officer of the Fermi National Accelerator Lab and the Chairman Emeritus of ServiceMaster, a Fortune 1000 company. She has been a member of the International Association of Administrative Professionals (IAAP) since 1997, serving in a variety of leadership and other roles. In addition to being a Certified Administrative Professional with an Organizational Management specialty, Ms. Herman is also a Microsoft Office Specialist, certified at the Master level in multiple versions of Microsoft Office.

View all trainings by this speaker
 
Live Webinar

Live + Recorded Session

Get unlimited access to the link for one participant, from the date of webinar completion.

$269

Live + Transcript

Get unlimited access to the link for one participant, from the date of webinar completion.

$249

Live + Training CD

Free shipment within 3 to 5 Days from the date of webinar completion.

$450

On Demand

Transcript

PDF Transcript of the Training which are available once the webinar is completed.(Transcript for single user only)

$179

Downloadable recorded session

Get unlimited access to the link for six months.

$239

Training CD

Free shipment within 72 Hours, from the date of webinar completion

$350

Group Session

Group Session unlimited participants + Recorded

Live session for unlimited participants

$799

  

Upcoming Webinars