Countdown to Event
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.
Registration: Participants must register. If no registrations are completed, this training will be canceled 24 hours prior to the date. Please register at least 2 working days prior to the training date.