London Excel Meetup Workbooks

Written by

Dashboards, Microsoft Excel, Visualization

The workbooks used in my presentation on “Analytical and Interactive Dashboards in Excel” at the London Excel Meetup, September 3, 2020

233 words, ~1 minute read

Earlier today (September 3, 2020), I had the honour and privilege to give a little presentation about Analytical and Interactive Dashboards in Microsoft Excel at Tea Kuseva’s and Alan Murray’s great London Excel Meetup.

For everyone who attended the session and anyone else interested, here are the workbooks used in my presentation for free download.

This is the showcase of the interactive English Premier League Dashboard shown at the beginning of the session:

Download Dashboard Showcase Premier League (zipped Excel workbook, 2.5MB)

And this is the workbook used to present the different tips and tricks:

Download Analytical and Interactive Dashboards (zipped Excel workbook, 2.2MB)

I have to admit, the live presentation and performance was a bit sloppy on my side (my apologies), so I recommend to download and dissect the workbooks to get the most out of the meetup. I think both workbooks are worth a look.

Many thanks go to Tea Kuseva and Alan Murray for organizing the event and having me, to Carlos Barboza for suggesting me as a speaker and of course to everyone who took the time to attend the session.

If you have any feedback or questions, please leave me a comment here or contact me by email.

Stay tuned.

analytical and interactive dashboards in excel excel dashboards excel London meetup interactive dashboards excel

Comments

10 responses to “London Excel Meetup Workbooks”

September 3, 2020

Kallun

Thank you for kindly your presetation today, Robert, and for making your workbooks available for us to look over. I’m certainly better and understanding something if I can pull it apart and see what makes it tick.

Reply
September 3, 2020

Robert

Kallun,
many thanks for your comment. I hear you. I think we are two of a kind here. Have a look at the workbooks at your own speed and let me know, if you have any questions.

Reply
September 4, 2020

Alan

Thank you for your time and excellent presentation Robert.

Reply
September 4, 2020

Danny

thanks, nice stuff in there !

Reply
September 4, 2020

Cora

Thank you, well done!

Reply
September 5, 2020

Franco

Thank you, nice stuff!

Reply
September 7, 2020

Oken

Thanks a lot Robert. Your session was really a good one. So much to absorb in such a little time and every minute was worth the investment.

Reply
September 7, 2020

Microsoft Excel Recalc Or Die

Robert, you did very well mate! I saw many people saying “they felt inspired” (watching the presentation). I can related to that, since every new person I meet and tells me “I need to a build a report in Excel for this or that…” I recommend them to visit your blog for – inspiration -. Kudos!!!

Reply
February 3, 2021

Albert Josh

I need to be able to have a 3 sheet workbook where the first 2 sheets are password protected read only but the 3rd sheet is password protected to be viewed and edited by selected users only. Can this be done? And how?

Reply
February 3, 2021

Robert

Albert,
as far as I know, Excel does not provide an option to allow data entries on worksheets for selected users only.
The only option I see is to write VBA code which unprotects the worksheet (either when the workbook is opened, or the sheet is activated) only if the username equals to one of the users allowed to see and edit the sheet. You would then write another VBA routine (e.g. Workbook_BeforeClose) to protect the sheet again.

Reply