Related Events:
Microsoft Planner Essentials, July 17, 2024
Excel Essentials, July 23-24, 2024
Excel Calculations and Charts, Aug. 13-14, 2024
Fast Start to OneNote, Aug. 27-28, 2024
Excel Database and List Management, Sept. 17-18, 2024
Lean Outlook - Simplify and Get More Done, Oct. 29-30, 2024
Microsoft To Do, Nov. 12, 2024
Excel Conditional Formatting, Nov. 13, 2024
Excel Get and Transform, Dec. 3-4, 2024
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:
In this course, you will gain an in-depth understanding of how to use Excel to perform calculations and create charts. The course covers the fundamentals and goes beyond, covering the function palette, VLOOKUP/XLOOKUP, net workdays, cell and range names, conditional formatting, Sparklines, protecting data, and saving a chart as a template. Upon successful completion of this two-part course, you will be able to:
- Find and use intermediate functions.
- Streamline formulas using cell and range names.
- Use Sparklines in addition to charts to create dynamic visual displays of data.
- Protect formulas and general cell data from editing.
- Use special tools such as cell comments and notes.
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, Jump-start Computer Training
Webinar Schedule:
The webinar will be held Oct. 1-2 from 1-3 p.m. Pacific Time each day. Attendees will be admitted 15 minutes before the webinar begins.
How to Participate:
Instructions will be emailed to attendees within 24 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 Google 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: $235
Associate Member Rate: $350
Non-Member Rate: $470
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:
For webinars, virtual classes, and section meetings: cancellation at least five days prior to the event, full refund; within 1-4 days or no show, 100% of the registration fee.
For
in-person events: 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; NWPPA does not charge a fee for substitutions. To request a refund, please contact registration@nwppa.org or (360) 254-0109.
Continuing Hours:
This course qualifies for 4 continuing hours. Certificates are issued upon full completion of the course.