This virtual, interactive and hands-on session will explore additional formulas and functions and address absolute verse relative cell referencing, multiple worksheets and displaying of data using charts. It is appropriate for users that need to customize their worksheets, present data through charts, and/or develop long-range spreadsheets for data tracking. Attendees will learn how to expand their knowledge and use of functions and the creation of charts.

Individuals are encouraged to bring current spreadsheet projects with them to work on in real-time, privately with the instructor.

Topics covered include, but are not limited to:

• Functions in Excel
• Cell Referencing
• Creating and Linking Multiple Sheets in a Workbook
• Creating Charts
• Filtering and Sorting Data
• Inserting and Using a Pivot Table

All individuals participating in this training via Zoom are encouraged to have a second monitor, iPad or other tablet device to watch while you participate on your own computer.

Who Should Attend
This course is designed for individuals who are looking to learn more and enhance their MS Excel skills in the workplace. 

Class Format
This course is offered using Zoom. 

Attention Employers:
This Training is Eligible for Reimbursement! Click here for eligibility and application process information. Or join us for an upcoming information session. Click here for the schedule and to register for a session. 

Learn to use pivot tables to sort and organize data and build professional-looking reports containing large amounts of data in Microsoft Excel. This learning session will also cover the benefits of protected sheets and how to set them up and use them properly. Finally, we will cover spreadsheet best practices including tips and tricks to help you stay organized, like format painter, text wrapping, auto filling cells, and more! Bring questions!

Project Management is more about managing expectations than dates.  Effectively managing multiple projects, resources, and budgets is critical in today's global business environment.  This Project Management course will dive into the roles and responsibilities of the project manager and examine project management in theory as well as in practice.  The course offers a practical approach to managing projects, without requiring any previous project management experience.  We will focus on organizing, planning, and controlling the deliverables of the project using good practices.

Students will participate in structured workshops where simulated project plans are designed and implemented. At the end of the course, students will understand why project management requires a high degree of professionalism and attention to detail, and how to achieve that end in future projects.

We will examine project management roles, the project lifecycle, and various techniques of work planning, control, and evaluation to achieve project objectives using system tools and project management philosophies.

Topics:

1. What makes a good project?
2. Documentation of a project
3. Common pitfalls
4. Ownership versus governance of the project
5. Project communication
6. What to do when things go wrong
7. What to do when things go right

Course Format:
This course is offered using Zoom. 

Attention Employers: This Training is Eligible for Reimbursement! 
Click here for eligibility and application process information. Or join us for an upcoming information session. Click here for the schedule and to register for a session.