Advanced Techniques for Conditional Formatting in Microsoft Excel Webinar

Conditional Formatting in Microsoft Excel

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:

bullet Create conditional formatting rules using built in parameters.

bullet Customize and tweak conditional formatting rules exactly the way you want them.

bullet Set up conditional formatting rules based on mathematical formulas.

bullet Utilize conditional formatting as an organizational and tracking tool.

bullet Edit existing conditional formatting rules.

bullet Use conditional formatting to identify broken business rules.

bullet 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.

bullet Determine when and why you might need multiple conditional formatting rules.

bullet Identify the many different visual formats that can be used.

bullet Choose the appropriate format for the data you are trying to convey.

bullet Understand the limitations and conflicts of using multiple conditional format rules.

bullet Remove rules that are no longer needed or that were inherited with transferred spreadsheets.

bullet Build layers of rules to allow multiple formats to show different information.

bullet Create dynamic conditional formatting that changes when you select an entry from a drop down list.

bullet Use conditional formats to discover duplicates within your spreadsheet.

bullet 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).

bullet Locate all instances of conditional formatting in your spreadsheet.

and more!!!

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.

Student Name
Preferred Email Address