MS Excel Toronto - Give Your Data the Chance to Tell a Story with EXCEL lent Visualization
Session recorded live on Jun 12
The MS Excel Toronto Meetup group was founded in May 2019 and has had monthly sessions since then. Sessions are currently offered for free online, with a different topic presented by an Excel Expert each month. Members are from all over the world, totalling more than 4,000.
ATTEND THE MS EXCEL TORONTO MEETUP GROUP SESSIONS LIVE 👇
Register for free as a member of the group: https://www.meetup.com/MSExcelToronto
ACCESS THE EXERCISE FILES shared by the presenter are available to the group members on the Meetup website 👇
Access on the browser (not the mobile app) go to the main menu and select More - Message Boards.
The MS Excel Toronto Meetup group sessions are organized and run by
Celia Alves - / celiajordaoalves
Gráinne Dugan - / grainneduggan1
-----------------------
Keep up with the Excel News by subscribing to Celia’s newsletter: https://snapreportschamp.com/subscrib...
Learn how to automate your Excel reports:
https://snapreportschamp.com/course
-------------------------------------
About this session:
Because of Excel's flexibility, millions of business users use it daily.
However, Excel's flexibility can often result in poor data visualization practices, such as illegible tables, charts with too many details, or colour schemes that do not help interpret the message intended to be conveyed.
How can we create charts that provide immediate and informative insights to the user without wasting hours building and customizing those charts for our reports and presentations?
Matija Prijatelj from Zebra BI will explain how to create good storytelling with your data in Excel and produce a live demo of Zebra BI for Office to visualize your data effectively.
Zebra BI is an add-in for Excel that allows you to create insightful, actionable, and interactive reports and dashboards in Excel.
---------------------
About the Speaker: Matija Prijatelj
Matija loves creating engaging educational and marketing videos for business professionals, focusing on actionable reporting and effective data communication. He is currently a Video Content Creator at Zebra BI, blending his expertise in Business Intelligence, marketing, and filmmaking to showcase Zebra BI products and educate business analysts.
With over a decade in business intelligence and advanced analytics, including roles at A1 Slovenija d.d. and the Statistical Office of Slovenia, Matija brings a wealth of experience in data-driven storytelling and impactful visual content.
Find more about Matija's work and connect with him:
LinkedIn: / matija-prijatelj
Youtube: / @zebrabi
Website: https://zebrabi.com
Timestamps
00:00:00 - Gráinne Duggan MS Excel Toronto news and upcoming events
00:06:25 - Gráinne introduces Matija Prijatelj
00:09:15 - Matija Prijatelj introduces himself and the presentation
00:15:00 - Data storytelling definition and interpretation, presenting to an audience,
00:22:35 - Typical structure of data storytelling
00:26:50 - Data visualization to put data into context by comparing data to previous period
00:31:30 - Showing trends and variances on charts and guidelines for effective storytelling
00:37:10 - Actual, budget and forecast on a chart with comments/narrative, the importance of adding the narrative
00:47:30 - Visualizing categorical data, visualizing Profit and Loss data
00:57:45 – Interactive small multiples charts based on Pivot tables, consolidated financials dashboard,
01:03:30 - Free templates from Zebra BI, download free version of Zebra BI and licences discussion, data preparation discussion,
01:12:00 - Questions
01:18:30 - Wrap up