Advanced Techniques Webinar - TEXT and DATE & TIME Functions in Microsoft Excel
My next Advanced Techniques webinar will focus on Microsoft Excel TEXT and DATE & TIME functions. These can save you all kinds of time and effort as they reduce repetitive tasks and decrease errors. Check out this 90-minute webinar to learn more about these functions.
Participants will discover functions that will:
Combine the data from more than one cell (plus add in other text as needed).
Determine how to calculate the number of days between dates, NOT counting weekend days or holidays.
Use dates in mathematical formulas, including automatically calculating due dates and other types of dates.
Change the case of your text to uppercase, lowercase, or title case.
Allow you to extract characters from the beginning, middle, or end of your fields.
Find out the length of characters in a field.
Insert the current date and time where needed, and keep it updated.
Remove unnecessary/excessive spaces from your cells.
Identify the number of days between two dates automatically (such as for calculating age).
Replace one set of characters or words with another.
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, MOSM
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 LLC 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.