Library Closure for Thanksgiving

Both library branches will close at 5 p.m. on November 27 and remain closed on November 28 and 29 in observance of Thanksgiving. We will reopen with normal hours on November 30.

Microsoft Excel - Pivot Tables (Online Class)

Primary tabs

Program Type:

Technology Classes

Age Group:

Adult
Please note you are looking at an event that has already happened.

Program Description

Event Details

This is a free online class through Gale Courses, an online learning platform that the library provides to our patrons. An internet-connected device is required and the course can be accessed from the library or at home with a valid FRVPLD card. For more information, please visit the Course Details page. You can also access Gale Courses from our Research page.

Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. 

You'll see how to work with the numerous pivot table options and system settings to become skilled in developing useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You'll discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid reporting mistakes when data is added or deleted.

Whether you're new to pivot tables, need a refresher, or want to become the pivot table guru within your organization, this course is for you!

Feel free to contact the Information Services department if you would like more information about the online course or if you need help accessing it. You can contact us via email at libraryhelp@frvpld.info or via phone at 847-428-3661, option 3.