Excel magic (advanced functions)

  • Event: 2015 CAR Conference
  • Speaker: MaryJo Webster of Star Tribune
  • Date/Time: Thursday, Mar. 5 at 9:00am
  • Location: M105
  • Audio file: No audio file available.

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, the Tableau Reshaper, merging data using lookup functions and perhaps a few other nifty tricks if time allows. This is a fast-paced class intended to introduce you to these tools, not master them. But 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.

Recommended for: anyone feeling comfortable with basic Excel functions and formulas.

Speaker Bios

  • MaryJo has been data editor at the Minneapolis Star Tribune for four 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.