Note:
Thank you for your interest in this event. Registration for this webinar is now closed. For questions or to learn about future opportunities please contact Roy Cevallos at (360) 816-1446 or roy@nwppa.org.
Who Should Attend:
Any users of Microsoft Excel who would like to enhance their skills, learn expert tips, and receive advice to improve performance with their daily duties.
Related Events:
Microsoft Office Essentials Webinar Series: All 14 Webinars, January 21-June 22, 2021
M365 - The Mysterious Apps, January 21, 2021
Excel Essentials, January 26-27, 2021
PowerPoint for Presenters, February 16-17, 2021
Microsoft Teams Essentials, February 24, 2021
Excel Calculations and Charts, March 2-3, 2021
Find Stuff Fast, March 18, 2021
M365 - When to Use What?, March 30, 2021
Microsoft Planner Essentials, April 8, 2021
Outlook Calendaring Best Practices, April 14, 2021
Word for Contracts, Procedures, and Manuals, April 21-22, 2021
Excel Database/List Management, May 11-12, 2021
Excel - Get and Transform, May 25-26, 2021
Troubleshooting Problem Word Documents, June 22, 2021
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 Recordings:
Webinar recordings can be made available to registrants who are unable to attend live.
Webinar Instructor:
Neal Otto, Jump-start Computer Training
Webinar Schedule:
The webinar will be held from 10 a.m.-noon PST. Attendees will be admitted 15 minutes before the webinar begins.
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: $90
Associate Member Rate: $135
Non-Member Rate: $270
Multiple Webinar Pricing Option: To register for four or more webinars in this series at a discounted rate, please visit Microsoft Office Essentials Webinar Series for details.
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.