From Data 2 Dashboard in 1 Day | Mark Rosenkrantz

From Data 2 Dashboard in 1 Day covers everything you need to know to build state-of-the-art dashboards. With EXCEL and nothing more than EXCEL.

This presentation does not list all kinds of neatly shaped examples but is a project approach to building dashboards in Excel.

This means starting from scratch, imperfect sets of data and sometimes taking a step back to find a better alternative to get things done.
From D 2 D in 1 D covers all the smart Excel tools like Pivot Tables, Pivot Charts, and Slicers. It focuses on building tables with Excel’s Table functionality, the versatile Subtotal function, and lots of other Excel functions like Trim, Len, and Round. It also pays lots of attention to creating charts and aligning chart objects, which is the key to visual success. When you’re done, the ALT key will be your best friend!
---------------------

About the Speaker: Mark Rosenkrantz

Mark is an independent spreadsheet developer from the Netherlands with some 23 years of experience in working with Microsoft Excel. Mark mainly works for a large number of billion-dollar companies in the Netherlands and has a special interest in spreadsheet design.

This presentation is based on everything he has run into during his efforts in bringing your data to life!

If Mark is not crunching the numbers, you can probably find him on the tennis courts or roads around Uithoorn riding his road race bike!
--------------
Find more about Mark's work and connect with him:
Website: www.spreadsheetsolutions.nl
---------------------
AGENDA: (Eastern Time)

5:30 PM - 5:40 PM- Introduction
5:40 PM - 6:40 PM - " From Data 2 Dashboard in 1 Day!" by Mark Rosenkrantz
6:40 PM - 7:00 PM - Q&A + Closing by Celia Alves and MS Excel Toronto Team

We are looking forward to meeting you there!