Beyond 1M rows: Using and joining large datasets in Excel

  • Event: 2018 CAR Conference
  • Speakers: Joseph Chirilov of Microsoft; Leo Zhao of Microsoft; Callie Neylan of Microsoft
  • Date/Time: Friday, Mar. 9 at 9:00am
  • Location: Indiana/Iowa
  • Audio file: No audio file available.

*Please note: This session will be a demo only.

The old restriction of 1 million rows in Excel no longer applies. Get and Transform in Office 2016 allows you to connect to large data sources, query them and even merge tables straight from your spreadsheet. We will be looking at visualizing this data in Excel with Pivot Charts.

Speaker Bios

  • Joseph Chirilov is a Principal Program Manager at Microsoft.  In his 17-years at Microsoft, he has spent the majority of that time working on the Excel product team.  Wearing the hat of customer representative and bringing customer and market insights to the engineering team, Joseph drove design of numerous feature improvements to Excel, dating back to Excel 2003.  His current area of focus in Excel is data visualization.

  • Callie Neylan is a designer at Microsoft focused on the intersection of humanity, technology, design, and data visualization. She has designed for organizations including Gensler, Teague, and NPR and held faculty appointments at the University of Washington and the Maryland Institute College of Art. Her work has been recognized by Communication Arts, The Peabody Awards, AIGA, and I.D. Magazine, and featured in the New York Times, Fast Company, and Gizmodo.

  • Leo is currently a Software Engineer in Microsoft, focusing on Charting experience across Microsoft Office, including Excel, PowerPoint and Word, etc. 

Related Tipsheets

No tipsheets have yet been uploaded for this event.