Educational Webinar
Excel Efficiency: Conditional Formatting
2021-02-18
Thursday
11:00 AM PST
until
12:00 PM PST
Duration: 1 hour
Registration
THIS EVENT IS IN THE PAST
Registration for this event is currently closed
Excel with man.jpg

Learning Session

  • Free CPE
  • Non-sponsored Events mean you never listen to a 3rd party sales pitch – it’s all just great education
  • Expert-instructor-led learning with live Q&A
  • Based on a great course on Illumeo

Conditional Formatting is one of the most powerful, yet sometimes, the most frustrating features in Excel. In this presentation, Excel expert David Ringstrom, CPA, delves deep into the nuances of Conditional Formatting. Techniques David covers range from simple color-coding to sophisticated techniques, such as highlighting every other row or formatting a set of cells based on amounts in other cells.


David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly known as Office 365) version of Excel. David will draw your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.


Microsoft 365 is a subscription-based product that is sometimes updated as often as monthly with new features. The perpetual licensed versions of Excel have year numbers, such as 2019, 2016, and so on, have feature sets frozen in time and do not receive updates with new features.



OBJECTIVES

After attending this event you will be able to:

  • State on which menu the Conditional Formatting command appears.
  • Describe the purpose of the Reapply command in Excel.
  • Recall which Conditional Formatting feature fills cells with color that’s sized commensurate with the underlying cell values.
    

SPEAKERS

David Ringstrom, President & CPA, Accounting Advisors

David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.


Jennifer Robbins, Webinar Manager, Illumeo

Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 300 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.


Continuing Education Information

Certified Public Accountant

Continuing Ed Credit: 1 CPE Credits
Field of Study:
Computer Software & Applications
CPE Delivery Method: Group-Internet
Program Location: Online

Chartered Accountant (IES7 CPD)

Continuing Ed Credit: 1 Hours
Field of Study: Accounting
CPE Delivery Method: Group-Internet
Program Location: Online

Certified Management Accountant

Continuing Ed Credit: 1 CPE Credits
Field of Study: Accounting
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certified Internal Auditor

Continuing Ed Credit: 1 CPE Credits
Field of Study: Computer science
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.

Certification in Risk Management Assurance

Continuing Ed Credit: 1 CPE Credits
Field of Study:
Other activities contributing to professional competence
CPE Delivery Method: Group-Internet
Program Location: Online
Program Level: Basic
Prerequisites:
No advanced preparation or prerequisites are required for this course.