Agenda

Download to Excel...Now What?

Track: Technical and Reporting

Session Number: 10580
Date: Tue, Mar 5th, 2024
Time: 2:00 PM - 3:00 PM

Description:

Vlookup, Pivot Tables, and Macros, oh my! The trifecta of Excel skills, the mastery of which separates the elementary from the elevated (at least in common perception). "Download to Excel" isn't the end of reporting, it's where U start "going Up".

If you're anything like me, you currently have at least a dozen Excel documents open on your computer. Whether from a PS Query output, SQL export, dashboard data extract, or any of a myriad other sources, Excel continues to be one of the primary ways we interact with data. Make the most of it by leveraging some of the powerful tools Excel has to offer. This session will look at some of the lesser-known functions/features available in Excel in addition to the "Big Three" (no not Kevin, Kate and Randal). We'll address some general as well as some PeopleSoft specific uses and how, even the best query writer should still be taking advantage of everything Excel has to offer. **Bonus: most of these can be used in Google Sheets as well.
Sub-Categorization: Other
Session Type: Presentation

Focus Area: Elevating "U"
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1732
ERP Systems: Oracle, Other
Knowledge Level: Overview
Field of Study: Computer Software and Applications
CPE: Yes
Sub-Categorization: Other
Session Type: Presentation

Focus Area: Elevating "U"
Session Length: Regular Length (60 min)
Cross Listed Areas: trk-1732
ERP Systems: Oracle, Other
Knowledge Level: Overview
Field of Study: Computer Software and Applications
CPE: Yes