Upping your Excel game *pre-registered attendees only

  • Event: 2020 NICAR Conference
  • Speaker: TBA
  • Date/Time: Thursday, Mar. 5 at 9:00am
  • Location: Studio 2 - 2nd floor
  • Audio file: No audio file available.

Skill level: Intermediate

If you've found yourself struggling in a spreadsheet, thinking that whatever you were trying to achieve seemed harder than it should've been, then this is the class for you. We’ll learn about various tools and functions in Excel that come in handy when you need to re-structure or otherwise get your data ready for analysis. We'll cover string functions, logical functions, date functions, reshaping data, merging data using lookup functions and perhaps a few other nifty tricks if time allows. We’ll do some “drills” introducing you to these concepts, then put your new skills to work in a sort of “scrimmage,” fixing up some real-life data. You’ll also walk out with practice data and a 30-page tipsheet that covers, in detail, everything from the class, plus more that we won’t have time for.

Preregistration is required and seating is limited. Laptops will be provided for the training. 

Workshop prerequisites: You should have prior experience using Excel or Google Sheets, and be comfortable with introductory-level spreadsheet skills, such as sorting, filtering, SUM and AVERAGE functions, calculations such as percentage change or percent of total, and how to use pivot tables.

 

Related Tipsheets

No tipsheets have yet been uploaded for this event.