Loading…
← Back to schedule
Skip the reports and get more from Synergy data exports with pivot tables and vlookup FULL
Thursday March 6, 2025 3:45pm - 4:45pm PST
Crooked River
A pivot table is a user-friendly tool to quickly and interactively summarize large amounts of data.  Vlookup is a handy formula allowing you to merge data from one spreadsheet onto another spreadsheet.  In many cases, once you are proficient with these skills you can stop searching for “canned” Synergy reports and get exactly what you need by exporting data to Excel or Google Sheets.

In this session, we will walk through several examples in which we quickly get relevant summary information from Synergy exports. We will also explore how the VLOOKUP formula can work together with pivot tables to take your spreadsheet skills to the next level.

This session assumes intermediate skills with Excel or Google Sheets, including navigation, selecting and filtering, and the use of basic formulas.


Speakers
E

erin.hyde@lblesd.k12.or.us

CSR - Educational Data Specialist, Linn Benton Lincoln ESD
Thursday March 6, 2025 3:45pm - 4:45pm PST
Crooked River
  Analytics

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Share Modal

Share this link via

Or copy link