Event Profile

Microsoft Office Essentials Webinar Series

July 30 — December 3, 2020


Online registration is currently closed, but spaces are still available. If you would like to attend this event, please contact Roy Cevallos at (360) 816-1446 or roy@nwppa.org.

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.

Series Overview:

Get acquainted with, or brush up on skills in, many applications of Microsoft Office and Office 365. Intimate class sizes will contribute to the ability to work with an expert who can provide you with tips and tricks applicable to your daily job functions. Webinars can be taken individually or as an entire series. By registering for the full series, you will receive all 12 webinars at a discounted price.

A quick-reference guide will also be provided that includes highlights of the course content, as well as additional tips and tricks.

Note: These courses are 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.

Microsoft Teams, July 30, 2020
Communicating and collaborating with Microsoft Teams is critical, especially as many are working remotely. In this course, students will utilize the power of Microsoft Teams to collaborate internally on projects and discussions.

Fast Start to OneNote, August 13, 2020
OneNote is one of Microsoft’s best-kept secrets, and one of its most useful programs. In this course, you will learn how OneNote can be used to organize and share information for task management and historical purposes. 

Microsoft 365 - When to Use What?, August 20, 2020
OneDrive, SharePoint, Teams, Outlook, and OneNote. When do you use what?
With the many collaboration tools available in Microsoft 365, users often become confused by what tool to use and when to use it. Many useful tools are misused, and some stay unused, bringing no value to the organization. In this course, students will explore the many tools available in today’s Office and start to develop best practices of when to use which tool individually and within their team. Participants receive templates to help document standardized work.

Excel Essentials, August 25-26, 2020
In this two-part course, students will learn required skills to work in Excel. These skills include understanding the terminology; the uses of Excel; how to enter and manipulate data; how to manage the spreadsheet layout, cell formats, and tabs; and how to set up a sheet for printing.

Excel Calculations and Charts, September 1-2, 2020
During this two-part session, participants will learn the advantages of using Excel to perform calculations, the different methods to perform calculations, how to display and read existing formulas, and how to create dynamic charts for effective visual data presentation.

Outlook Calendaring Best Practices, September 10, 2020
You use Outlook every day, and probably have for years. But many people do not unleash the full power of the Outlook Calendar. Become an Outlook Calendar power user by learning a variety of techniques for keeping an up-to-date and flexible calendar. Students will also learn to view other people’s calendars to provide needed information. Unlock new levels of efficiency that can increase your productivity and effectiveness.

Find Stuff Fast, September 23, 2020
Did you know that over 30% of our time is spent looking? Want to spend less time looking and more time doing? This course will help you find digital information quickly using a variety of tools and views. Participants will use the built-in and custom tools and views in Windows and Office to find data like never before.

Excel Conditional Formatting, October 15, 2020
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.

Excel Database/List Management, October 28-29, 2020
In this two-part series, students will learn the power of Excel as a database. Topics include understanding what Excel requires in the setup of a database; database terminology; how to sort and filter records; setting the data up in an easily managed, good-looking table; outlining and doing data subtotals; the power of pivot tables and pivot charts; and more.

Microsoft Planner, November 10, 2020
Are you looking for a tool that will help you with agile projects? Microsoft Planner can help! In this hands-on course, you will earn how to utilize Microsoft Planner to create a simple project plan consisting of tasks, assignments, star/due dates, and documents.

Word for Contracts, Procedures, and Manuals, December 2-3, 2020
In this two-part series, develop a mastery of your documents by learning advanced find/replace techniques; how to manipulate styles; and how to use the navigation pane and outline view. You will also learn how to create an automatic table of contents, headers, and footers.

Troubleshooting Problem Word Documents, December 8, 2020
Cleaning up bad formatting can be a nightmare until you understand how Word works and what tools are available to fix these issues. This highly interactive course will help you understand what causes these issues and shows you how to sanitize these documents. Participants are encouraged to bring their own problem documents to class in order to apply the techniques shown in class to a real-life document.

Webinar Instructor:

Neal Otto, Jumpstart Computer Training

Webinar Schedule:

Please see individual webinar schedules as they are held either between 10 a.m.- noon or 1-3 p.m. Pacific Time. Some courses span multiple days. Attendees will be admitted 15 minutes before each webinar begins. The course is only available live; no recording will be made available.

How to Participate:

Instructions will be emailed to attendees 12 hours before each webinar and we recommend that you test the link to the meeting as soon as you get the instructions. The webinars are 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 for All 12 Webinars: $1,080
Associate Member Rate for All 12 Webinars: $1,620
Non-member Rate for All 12 Webinars: $3,240

Multiple Webinar Pricing Option: If you are interested in registering for multiple sessions, but not all 12, we are offering a 10% discount to anyone who signs up for four or more webinars. To register for four or more, please complete this registration form and send it to Roy Cevallos at roy@nwppa.org. (Online registration for the full 12-part series is available, and a registration form does not need to be completed for this option.) 

Cancellation Policy:

Cancellations are accepted, with full refund, if request is made at least 30 days prior to the course. Within 30 days, fees are as follows: 15-29 days, $100; 1-14 days or no show, 100% of registration fee. When possible, please send a substitute instead of canceling; NWPPA does not charge a fee for substitutions.

For More Information:

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