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!