Advanced Techniques for Obscure but Useful Tips in Microsoft Office Webinar
You use Microsoft Office every day. You swear you know everything you need to know to do your job. But what if you didn't know it quite as well as you thought you did? Marie will show you some of the most obscure but still incredibly useful tips in Microsoft Office to help you work more effectively.
Participants will learn how to:
Combine multiple ranges into one in Excel, while adding up duplicate rows
Have formatting apply only when certain parameters are met
Ensure that everyone is consistent when multiple people enter data
Find data that varies when you need to replace it with something else
Get rid of excess spaces and tabs the easy way
Consolidate changes across multiple documents when the recipients have not used track changes
Organize your PowerPoint presentations for ease of rearranging and displaying.
Tweak your handouts beyond PowerPoint's scope
Create automated steps in Outlook that will repeat actions for you
Automatically generate new tasks when old tasks are completed
Attendees will be provided access to the live webinar as well as access to the recording for 30 days. All attendees will receive a handout with step by step instructions detailing what was covered during the webinar. In addition, a letter can be provided that is suitable for submitting for 1.5 Certified Administrative Professional (CAP) recertification points.
About the Instructor
Marie Herman, CAP-OM, ACS
When it comes to career and professional development to help administrative professionals advance, Marie Herman, CAP, OM, ACS, MOSM knows how to take you from where you are, to where you want to be. She has made her career helping others to develop their skills through strategic planning, website design, and technology. With certification as an internet webmaster designer, Microsoft Office Specialist (Master Level), Advanced Toastmaster-Silver, and an Associate's Degree in Business, Marie has an expansive knowledge in many areas, and can help you become an expert as well. She is an author, mentor, and expert on a number of computer and professional development topics. Marie is the owner of MRH Enterprises and teaches classes on Microsoft Office, Windows, and various other internet topics. She has been a member of the International Association of Administrative Professionals (IAAP) since 1997 and was the 2012-2013 President of the Illinois Division of IAAP. She has more than two decades of experience as an administrative professional and efficiency consultant.