Event Profile

Microsoft 365 Essentials Webinar Series: Excel Conditional Formatting

Date(s):
September 29, 2022
Venue:
Online
Description:

Who Should Attend:

Any users of Microsoft Office products who would like to enhance their skills, learn expert tips, and receive advice to improve performance with their daily duties.

Webinar Overview:

This deep dive starts with the essentials of Excel's conditional formatting and then takes off quickly. You will learn to call out interesting data using colors, icons, or data bars. Upon successful completion of this course, you will be able to:

  • Apply basic conditional formatting
  • Format rows/columns based on single/multiple cell values
  • Format based on a dynamic date
  • Determine duplicate items
  • Use the AND/OR functions in formatting
  • Understand and apply icon, three/four scale, and data bar conditional formatting

A quick-reference guide will also be provided that includes highlights of the course content, as well as additional tips and tricks. Classes will be small to ensure interactive, personalized instruction.

Note: This course is taught from a Windows perspective. Apple users are welcome to join, but not all features are available for MacOS or function the same way that will be shown in class.

Webinar Instructor:

Neal Otto, Jumpstart Computer Training

Webinar Schedule:

The webinar will be held on September 29 from 1-3 p.m. Pacific Time. Attendees will be admitted 15 minutes before the webinar begins.

Related Event(s):

Microsoft 365 Essentials Webinar Series, April 19 - December 7, 2022

Fast Start to OneNote, April 19, 2022

Word and Outlook Tables Made Easy, April 20, 2022

Excel Essentials, May 10-11, 2022

Find Stuff Fast, May 26, 2022

Microsoft Teams Essentials, May 31, 2022

Excel Calculations and Charts, June 7-8, 2022

Excel Database/List Management, July 19-20, 2022

Simplify and Get More Done, June 28-29, 2022

Word for Contracts, Procedures, and Manuals, August 10-11, 2022

Microsoft Planner Essentials, October 12, 2022

M365 - The Mysterious Apps, October 13, 2022

PowerPoint for Presenters, November 8-9. 2022

Reuse Microsoft 365 Content the Right Way, November 15, 2022

Excel - Get and Transform, December 1, 2022

Troubleshooting Problem Word Documents, December 6, 2022

End-of-Year Digital Cleanup Workshop, December 7, 2022

How to Participate:

Instructions will be emailed to attendees within 12 hours of the webinar and we recommend that you test the link to the meeting as soon as you get the instructions. The webinar is best viewed using Chrome as your browser. We recommend that you use a landline for both your phone and your internet connections.

This registration is for one person to attend. We manage our webinars on an honor-system basis; if more than one person from a utility wishes to attend, each is to register separately.

Webinar Fees:

Utility Member Rate: $100
Associate Member Rate: $150
Non-Member Rate: $300

Note: Organizations that register a group of employees will receive every fifth registration for free. For example, if you register five employees, you only pay for four; register 10 employees, you only pay for eight; and so on. There is nothing additional you need to do to receive this discount.

Cancellation Policy:

Cancellations are accepted with a full refund as follows:

For webinars and virtual classes, if the request is made at least five days prior to the course, then 100% of the registration fee will be refunded.

For in-person events, the following fee structure applies: cancellation at least 30 days prior to the event, full refund; within 15-29 days, $100 fee; and within 1-14 days or no show, 100% of the registration fee. When possible, please send a substitute instead of canceling because NWPPA does not charge a fee for substitutions.

Continuing Hours:

This course qualifies for two continuing hours. Certificates are issued upon full completion of the course.

For More Information:

To find out more about this event, or to learn about other events, view the Training and Event Catalog.