Advanced Techniques - Data Validation in Microsoft Excel
Microsoft Excel has powerful data validation rules available for you to set up. I'll show you what they are, how they streamline life for you and what you can do to set up useful rules in this 90-minute webinar.
Participants will discover:
What data validation is
How to find existing data validation rules in documents you have inherited from others
How to set up data validation rules
What happens when you have existing data that doesn't meet the validation criteria and how to identify those cells
How to create custom rules including using formulas
The best way to create drop down lists in cells to enforce data choices
Why you would want to create custom input messages
How you can prevent others from inputting data that doesn't meet your standards
Why these rules will save you time and ensure consistency in document data
Attendees will be provided a link to the live webinar approximately 48 hours prior to the webinar as well as access to the recording for 30 days afterwards. 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.