speaker-info

Jordan Goldmeier

Chief Data Therapist

Hi there, I’m Jordan Goldmeier! I’m an internationally recognized data scientist and visualization expert, author, and keynote speaker. I’m the owner of Cambia Factor, a data consulting agency and the author of Advanced Excel Essentials (Apress 2014) and Dashboards for Excel (Apress 2015). I’ve consulted with and provided training for NATO, the Pentagon, and Financial Times among others, My work has been cited by and quoted in the Associated Press, Bloomberg BusinessWeek, Dice News, and American Express OPEN Forum. I’ve held the prestigious MVP award from Microsoft since 2013. Most of us have grown accustomed to certain spreadsheet styles or coding principles. But few have challenged these rules.

I’m convinced that always doing the same things over and over again holds up back. For instance, many people’s Excel skill top-out way before they should as macros and even some formulas feel too advanced for them to learn (or so they believe). The reality is, most of these concepts are easy. We have to stop looking at Excel and VBA as separate entities. And we have to stop teaching archaic development principles that no longer apply (blech: like Hungarian Notation).

I’m particularly interested in using Excel in ways we thought we couldn’t (or even shouldn’t). For instance, the rollover technique is one way we can use Excel to mimic the interactivity of a webpage. But Excel can also be used for what the late Paul Jensen referred to as “soft computing.” When we think of Operations Research type techniques like linear optimization and simulation, we’ll usually prefer larger software products. But Excel can do this type of computing. And for many companies, it’s often cheaper and better for them to build in Excel than go with a huge vendor package.

My Sessions

Building Advanced Interactive Charts in Excel (Session 1)

Create the charts Microsoft forgot to add in. In this masterclass, I’ll show you step-by-step how to create awesome interactive charts by using Excel in counterintuitive ways. We’ll employ a mix of slicers, the camera tool, pivot tables, and a bug in Microsoft Excel (a.k.a the “rollover method”) to build the type of charts you […]

Data Visualization & Reporting
READ MORE

Building Advanced Interactive Charts in Excel (Session 2)

Create the charts Microsoft forgot to add in. In this masterclass, I’ll show you step-by-step how to create awesome interactive charts by using Excel in counterintuitive ways. We’ll employ a mix of slicers, the camera tool, pivot tables, and a bug in Microsoft Excel (a.k.a the “rollover method”) to build the type of charts you […]

Data Visualization & Reporting
READ MORE