|
- Excel Pivot Tables
-
Course fee: $135.00
Dates: 11/15/2024 - 11/15/2024
Times: 1:00 PM - 4:30 PM Pacific Time
Days: F
Sessions: 1
CEUs: 0.35
Room: Zoom Class
Instructor: Cliff Hanks
Refund Policy: FAQs & Policies
Learn how to use PivotTables to summarize, group, chart and analyze data effectively in Microsoft Excel.
Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel can do much more. Being able to harness the power of advanced PivotTable features and create Pivot Charts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. During this class, the instructor demonstrates the concepts while you perform the tasks at the same time.
Required:
Pre-Requisites: Basic experience with Microsoft Excel.
Please see CEU procedure and Student Learning Outcomes.
Required:
- Microsoft Excel for Office 365/2021: Data Analysis with PivotTables ($15.22)
- Access to Microsoft Excel
- Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Excel Level 2
-
Course fee: $225.00
Dates: 11/18/2024 - 11/25/2024
Times: 8:30 AM - 12:00 PM Pacific Time
Days: M
Sessions: 2
CEUs: 0.7
Room: Zoom Class
Instructor: Cliff Hanks
Refund Policy: FAQs & Policies
This course builds upon the foundational knowledge presented in the Excel 365 Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that can compete at a high level.
Prerequisite: Excel Level 1 or equivalent experience
Required:
Please see CEU procedure and Student Learning Outcomes.
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Excel PowerPivot
-
Course fee: $155.00
Dates: 11/18/2024 - 11/18/2024
Times: 1:00 PM - 5:00 PM Pacific Time
Days: M
Sessions: 1
CEUs: 0.4
Room: Zoom Class
Instructor: Cliff Hanks
Refund Policy: FAQs & Policies
We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.
Prerequisite: Excel Level 1 or equivalent experience
Required:
Please see CEU procedure and Student Learning Outcomes.
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Project Execution to Closing
-
Course fee: $339.00
Dates: 11/18/2024 - 12/4/2024
Times: 6:00 PM - 9:00 PM Pacific Time
Days: M W
Sessions: 5
CEUs: 1.5
Room: Zoom Class
Instructor: Daniel Yeomans
Refund Policy: FAQs & Policies
Your Project Management Plan is approved and accepted. What's next? This course shares best practices for implementing and controlling the project to success. Learn how to manage quality, develop and manage a project team, effectively communicate, manage risk and engage stakeholders. Key tools and techniques and valuable tips will be introduced, shared and applied - all to ensure that your project is successful. This class is offered in partnership with Green River College.
Prerequisite: Project Management Basics: Initiating the Project
TEXTBOOKS (available through Amazon)
- Required The PMBOK® Guide - 7th Edition, Project Management Institute, Inc., 2021, ISBN-13: 978-1628256642
- Recommended Project Management Made Simple and Effective, Yeomans, 2016, ISBN-13: 978-1457549816
This is the third required course in the Project Management Certificate Part A (3 Class Series). For complete details about our Project Management Certificate Program, visit our Project Management Certificate overview.
PMBOK® is a registered mark of the Project Management Institute, Inc.
Please Note: No class Nov 27
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- PowerPoint Level 1
-
Course fee: $225.00
Dates: 12/9/2024 - 12/16/2024
Times: 4:30 PM - 8:00 PM Pacific Time
Days: M
Sessions: 2
CEUs: 0.7
Room: Zoom Class
Instructor: Cliff Hanks
Refund Policy: FAQs & Policies
How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. Today's audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint 365, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint 365 to begin creating engaging, dynamic multimedia presentations.
Required:
Please see CEU procedure and Student Learning Outcomes.
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Bookkeeping Certificate
-
Fee: $495.00
Item Number: 43790
Dates: 9/3/2024 - 11/29/2024
CEUs: 4.8
Room: Arranged
Instructor: Sharon deFonteny
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
How do you manage the finances of a business? Whether you are an entrepreneur, running a family business, or just looking to advance your career and add to your skill set, this Bookkeeping Certificate will provide you with the knowledge needed to measure, and manage, the financial health of your business. This program focuses on cash basis accounting.
No one will care more about the financial health of your business than you! It's imperative that you understand how the process works and are able to complete the accounting cycle accurately and in a timely fashion. Even if you plan to outsource your bookkeeping needs, you should still understand how the process works. No one should be clueless when it comes to the finances of their business.
Class Dates for Certificate:
- Understanding Debits and Credits: Sep 3 - 28
- General Ledger and Month End Procedures: Oct 7 - Nov 1
- Closing Procedures and Financial Statements: Nov 4 - 29
|
|
|
- Japanese: Beginning Conversational
-
Course fee: $129.00
Dates: 9/25/2024 - 11/13/2024
Times: 6:00 PM - 7:15 PM
Days: W
Sessions: 8
Room: Zoom Class
Instructor: Earle Oda
ONLINE REGISTRATION FOR THIS CLASS IS CLOSED. Call 360.417.5683 to register if class is not yet in session.
This class is an introduction to Japanese language and culture designed for students with little to no experience. We will focus on conversational skills, pronunciation, everyday expressions, basic vocabulary, simple sentence structure, and basic grammar. Reading and writing are not covered.
This class is offered in partnership with Edmonds Community College.
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Leadership and Supervision Certification
-
Course fee: $599.00
Dates: 9/30/2024 - 11/18/2024
Times: 6:00 PM - 9:00 PM Pacific Time
Days: M W
Sessions: 12
CEUs: 3.6
Room: Zoom Class
Instructor: Sara Johnson
ONLINE REGISTRATION FOR THIS CLASS IS CLOSED. Call 360.417.5683 to register if class is not yet in session.
Develop your leadership, communication, motivation, and problem-solving skills with the Supervision Certificate. Through a series of six courses, you will acquire the interpersonal skills needed to interact successfully in a supervisory role. Topics include turning negative situations into positive outcomes; identifying your leadership traits through personal assessment; leading effective meetings; providing feedback; establishing priorities; problem-solving techniques, and more! This class is offered in partnership with Green River College.
See overview to learn more about this Certificate. Earn the certificate by taking the courses individually or register for the series and save.
Want to learn more about this certificate? Sign up for a FREE info session on September 23!
Please note: No class Oct 14, 16, and Nov 11.
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Beginning Screenwriting
-
Course fee: $235.00
Dates: 10/2/2024 - 11/20/2024
Times: 1:30 PM - 3:00 PM
Days: W
Sessions: 8
Room: Port Townsend Campus - PT207
Instructor: Mark Schwartz
ONLINE REGISTRATION FOR THIS CLASS IS CLOSED. Call 360.417.5683 to register if class is not yet in session.
Ready to write that screenplay? Build out an idea for a TV series? Or write that short film you want to shoot?
This course will not only cover the basics of screenwriting - theme, log line, story structure, character development, formatting - but also provide a supportive "writer's room" environment for students to build their work. Students will read and analyze scripts, watch and reflect on films, engage in writing exercises, and be provided ongoing feedback. Additionally, we will cover the nuts and bolts of the entertainment industry and how to pitch and get scripts in circulation.
Join in-person at the Port Townsend or online via Zoom. Please email communityed@pencol.edu if you wish to join by Zoom.
|
|
|
- HR Generalist Certificate
-
Course fee: $599.00
Dates: 10/3/2024 - 11/14/2024
Times: 6:00 PM - 9:00 PM Pacific Time
Days: Tu Th
Sessions: 12
CEUs: 3.6
Room: Zoom Class
Instructor: Claudia Malone
ONLINE REGISTRATION FOR THIS CLASS IS CLOSED. Call 360.417.5683 to register if class is not yet in session.
As an HR Generalist you are expected to be an expert in every human resource function including hiring, compensation, payroll, performance management, employment laws (FMLA, ADA, COBRA, etc.) and much more. Through lecture, discussion and activities, this program will help prepare you to effectively serve in an HR Generalist role. Additionally, you will be equipped with tools to assist you as you encounter situations in today's workplace. This class is offered in partnership with Green River College.
See course requirements and outline.
Want to learn more about this certificate? Sign up for a FREE info session on September 26!
Please note: No class Oct 31.
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Fall Photography Challenge
-
Course fee: $175.00
Dates: 10/8/2024 - 11/12/2024
Times: 6:30 PM - 8:30 PM
Days: Tu
Sessions: 6
Room: Zoom Class
Instructor: Karen Ulvestad
ONLINE REGISTRATION FOR THIS CLASS IS CLOSED. Call 360.417.5683 to register if class is not yet in session.
Feel like something is missing in your photography? Explore photography by learning to visualize a photograph and then create it through lighting, composition, and exposure. This class focuses on discovering new ways of seeing and an artistic approach to composition. Discover the steps beyond basic composition and exposure to create artistic photographs. There will be lectures, examples, and weekly assignments. The instructor will critique assignments and help students grow their photography knowledge. Some topics covered will be fall color, creative use of light, and composition.
This class is offered in partnership with Edmonds Community College.
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Health, Safety, and Security
-
Course fee: $69.00
Dates: 11/12/2024 - 11/12/2024
Times: 6:00 PM - 7:00 PM Pacific Time
Days: Tu
Sessions: 1
CEUs: 0.3
Room: Zoom Class
Instructor: Margaret Henning
ONLINE REGISTRATION FOR THIS CLASS IS CLOSED. Call 360.417.5683 to register if class is not yet in session.
OSHA and other laws require an employer to provide a safe and healthy working environment for their employees. In this course you will review both general and specific requirements and best practices for ensuring a safe and healthy workplace. You will also learn about the roles of OSHA and WISHA, how to manage L&I claims and gain tips on preparing for and dealing with violence in the workplace. This class is offered in partnership with Green River College.
This class is part of the HR Generalist Certificate Program (8 Class Series).
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|
- Problem Solving and Decision Making Strategies
-
Course fee: $139.00
Dates: 11/13/2024 - 11/18/2024
Times: 6:00 PM - 9:00 PM Pacific Time
Days: M W
Sessions: 2
CEUs: 0.6
Room: Zoom Class
Instructor: Sara Johnson
ONLINE REGISTRATION FOR THIS CLASS IS CLOSED. Call 360.417.5683 to register if class is not yet in session.
Creative problem-solving and effective decision-making skills are essential in today's workplace. Through the use of real-life case studies, discover four primary problem-solving tools, learn a format for group problem-solving, methods for effective decision-making and techniques to minimize conflict and dissension. This course concludes with an interactive problem-solving group exercise. Concepts taught in this course can be applied to all facets of life. This class is offered in partnership with Green River College.
For more information, please refer to our course outline.
This is the sixth and final course in the Supervision Certificate (6 Class Series).
Required: Ability to use Zoom (free video conferencing software) on a PC, tablet, or phone. If you are new to Zoom, please visit our Learning Online page for instructions and helpful links. As a reminder, online courses require an internet connection and the ability to interact both through audio and video using either a web camera and microphone, speakers and a headset, or via a mobile phone connection.
|
|
|