Twin Cities Code Camp

Alan Wong

How to use Excel for good, and not evil (Microsoft Excel for developers)

by Alan Wong

Sat, Apr 21, 2018
Room: P1808
Time: 10:30

Say the words "Microsoft Excel" and you can get anywhere from praised reactions as a great tool to organize loose sets of data, to a clockwork nightmare of spreadsheets that strikes developers as a dagger to the heart. We will show you how to use Excel to improve your experience as a developer; learn tricks to make Excel help write code, create class properties, parse code, use it to supplement your database queries, and more. The talk is intended to provide realistic examples of common problems that developers face, and how Excel can be the right tool for the job, even for a developer.

About the Author

Computer Systems Analyst for Platinum Supplemental Insurance since 2016 doing regular software development things. Currently working with C#, JavaScript, and React. Formerly Administrative Assistant for Concorde Maintenance Services of YYC Airport in Calgary, Alberta, Canada. Developed Excel VBA scripts for Concorde and likely made Excel do things it was never meant to do. Bachelors in Management of Information Systems from Haskayne School of Business, where they teach you to Excel hard.