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.
Comments
10 responses to “London Excel Meetup Workbooks”
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.
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.
Thank you for your time and excellent presentation Robert.
thanks, nice stuff in there !
Thank you, well done!
Thank you, nice stuff!
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.
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!!!
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?
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.