Skip to main content

Distill Your Data: Excel's Conditional Formatting and Tables

ISBA Members: Use your 15 hours of Free CLE credits to order this program –
just use the green button next to the “Add to Cart” button below!
ISBA’s Practice Toolbox Series
Presented by the Illinois State Bar Association


1.0 hour MCLE credit, including 1.0 hour Professional Responsibility MCLE credit in the following category: Professionalism, Civility, or Legal Ethics credit, or Sexual Harassment Prevention credit


Original Program Date: Tuesday, April 23, 2024
Accreditation Expiration Date: ­­­­­­­­­­­­­­­­­­­­­­­­­May 20, 2026 (You must certify completion and save your certificate before this date to get MCLE credit)


Conditional formatting is more than a tool for quick analysis of data. When used to its full potential, it allows you to bring clarity to your data. Tables are an underutilized feature that allows you to quickly sort, filter, format, and replicate formulas. Combined, conditional formatting and tables offer powerful options a few keystrokes away.


Program Speaker:
Danielle DavisRoe, Affinity Consulting Group
About the Speaker: Danielle’s many responsibilities at Affinity include training, CLE/speaking, writing, and management consulting. Prior to joining the Affinity family, Danielle practiced family law. She discovered, however, that she enjoyed making efficient use of technology more than practicing law, making her a perfect fit for consulting. Danielle describes her superpower as “herding cats,” and her favorite parts of her job are making others’ jobs and lives easier.



Pricing Information
  • Please Note: You must attend the entire program in order to earn MCLE credit for this seminar.
  • ISBA sponsoring section members get a $10 registration discount (which is automatically calculated in your cart when you log in to register).
  • Fees:
    • ISBA Member Price of $35 is displayed below when you login and program is eligible for Free CLE member benefit.
    • New Attorney Member (within the first five years of practice) - $25
    • Law Students – Free