Event Profile

Microsoft Office Essentials Webinar Series: All 14 Webinars

January 21 — June 22, 2021

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 14 webinars at a discounted price.

A quick-reference guide, highlighting the content, tips, and tricks, will be provided with each course.

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.

M365 - The Mysterious Apps, January 21, 2021

In this interactive and informative webinar, we will examine four M365 tools (Power Automate, Forms, Lists, and Delve) that don't get a lot of attention but are extremely useful. Learn how to harness the power of these tools and understand how they can work together with other Microsoft 365 tools to increase your productivity.

Excel Essentials, January 26-27, 2021

In this two-part course, you will learn required Excel skills, such as 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.

PowerPoint for Presenters, February 16-17, 2021

You may have been using PowerPoint for years, but instructor Neal Otto wants to refresh your view of this powerful and essential tool. In this two-part course, you will learn how to create dynamic, engaging PowerPoint presentations by considering your audience and defining the purpose of your presentation. You will learn the basics of choosing themes, working with slides, bullet lists, outline view, spellcheck, and adding and working with graphics. You will also learn how to set up printouts and the tricks of running slide shows.

Microsoft Teams Essentials, February 24, 2021

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

Excel Calculations and Charts, March 2-3, 2021

During this two-part webinar, you will learn the fundamentals of using Excel to perform calculations and create charts, such as the different methods to perform calculations, how to display and read existing formulas, and how to create dynamic charts for effective visual data presentation.

Find Stuff Fast, March 18, 2021

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. You will learn to use the built-in and custom tools and views in Windows and Office to find data like never before.

M365 - When to Use What?, March 30, 2021

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, you 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 your team.

Microsoft Planner Essentials, April 8, 2021

Are you looking for a tool that will help you with 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, start/due dates, and documents.

Outlook Calendaring Best Practices, April 14, 2021

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. You 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.

Word for Contracts, Procedures, and Manuals, April 21-22, 2021

In this two-part course, develop a mastery of your Word documents by learning advanced selection techniques, how to create and use styles; how to use the navigation pane and outline view; how to automatically create a table of contents; and how to work efficiently with headers and footers.

Excel Database/List Management, May 11-12, 2021

In this two-part webinar, learn the power of Excel as a database. Topics include database terminology, outlining and doing data subtotals, and more.

Excel - Get and Transform, May 25-26, 2021

This two-part course is for experienced Excel users who spend too much time manipulating data into the right format before they even begin to analyze it month after month or week after week or day after day. Get and Transform (aka Power Query) can perform repetitive data cleansing such as deleting rows and columns, merging data from various data sources, and fixing layout issues without macros or VBA. Data source examples used in this class include Excel, CSV, and text, but the concepts taught can be applied to many different sources. Once Get and Transform is set up, simply click the Refresh button. You’ll save hours!

Excel Conditional Formatting, June 8, 2021

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.

Troubleshooting Problem Word Documents, June 22, 2021

Cleaning up bad formatting can be a nightmare until you understand how Word works and what tools are available to fix these issues. You are encouraged to bring your own problem documents to class in order to apply the techniques to a real-life document.

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:

Please see individual webinar schedules as they are held either between 10 a.m.- noon or 1-3 p.m. PST. Some courses span multiple days. Attendees will be admitted 15 minutes before each 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:

All 14 Webinars:

    Utility Member Rate: $1,620
    Associate Member Rate: $2,430
    Non-member Rate: $4,860

Multiple Webinar Pricing Option: If you are interested in registering for multiple sessions, but not all 14, 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. (Online registration for the full 14-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 event, or to learn about other events, view the Training and Event Catalog.