Advanced Techniques for Conditional Formatting in Microsoft Excel Webinar
Microsoft Excel has an extremely useful function called conditional formatting, which applies formatting only when certain parameters are met. This is a fabulous tool that can be used in many different ways. We'll take a deep dive into this function and learn the full ins and outs of how to best utilize it.
Participants will learn how to:
Create conditional formatting rules using built in parameters.
Customize and tweak conditional formatting rules exactly the way you want them.
Set up conditional formatting rules based on mathematical formulas.
Utilize conditional formatting as an organizational and tracking tool.
Edit existing conditional formatting rules.
Use conditional formatting to identify broken business rules.
Discover a formula that will allow you to apply conditional formatting to an entire row or column when certain conditions are met in a particular cell in that row or column.
Determine when and why you might need multiple conditional formatting rules.
Identify the many different visual formats that can be used.
Choose the appropriate format for the data you are trying to convey.
Understand the limitations and conflicts of using multiple conditional format rules.
Remove rules that are no longer needed or that were inherited with transferred spreadsheets.
Build layers of rules to allow multiple formats to show different information.
Create dynamic conditional formatting that changes when you select an entry from a drop down list.
Use conditional formats to discover duplicates within your spreadsheet.
Use conditional formats to compare values and reflect status of your data (i.e. actual versus budgeted or reordering stock when an item gets below a certain number in inventory).
Locate all instances of conditional formatting in your spreadsheet.
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.