Upping your Excel game *pre-registered attendees only

  • Event: 2019 CAR Conference
  • Speaker: MaryJo Webster of Star Tribune
  • Date/Time: Saturday, Mar. 9 at 9:00am
  • Location: Salon 3
  • 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. This is an intermediate Excel class intended for those who have mastered the basics, such as sorting, filtering, pivot tables and using functions. It is a fast-paced class intended to introduce you to these tools. You'll walk out with practice data and a 20-page tipsheet that covers in detail everything we do in class, plus other great Excel tips.

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.

Speaker Bios

  • MaryJo has been data editor at the Star Tribune in Minneapolis for five years. Previously, she had stints with the St. Paul Pioneer Press, USA Today, Digital First Media and Investigative Reporters and Editors. She started her career as a reporter at small papers in Minnesota and Wisconsin. @MaryJoWebster

Related Tipsheets

No tipsheets have yet been uploaded for this event.