MS Excel Toronto Meetup - Creating awesome data visualizations in Excel - Jordan Goldmeier

Описание: Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
---------------------------------------------------------------------------------------------------------
Session recorded live on 2023-06-07

Creating awesome data visualizations in Excel​ | ​Jordan Goldmeier

To attend the MS Excel Toronto meetup group sessions live, please register for free as a member of the group: https://www.meetup.com/MSExcelToronto
The MS Excel Toronto Meetup group is organized by
Celia Alves -   / celiajordaoalves  
Vivek Patel -   / insight2action  
Dick Moffat -   / dick-moffat-65721  
____________________________________________________
In this presentation, I’ll show you how to make awesome Excel visualizations that you never thought possible in Excel. I’ll show you how to push Excel beyond its limits while also delivering critical insight to stakeholders.

---------------------

About the Speaker: Jordan Goldmeier

Jordan Goldmeier is one of the leading global minds on data science. He is an entrepreneur, author and speaker. His works include Dashboards for Excel, Advanced Excel Essentials, Becoming a Data Head, and Data Smart (2nd Ed). He has received the prestigious Microsoft Most Valuable Professional Award for a 9th year. Jordan has served as a volunteer Emergency Medical Technician and is an adjunct instructor at Wake Forest University.

--------------

Find more about Jordan's work and connect with him:
LinkedIn:   / jordangoldmeier  
Website: Advancedxl.com

-----------------------

VIDEO CHAPTERS: (Thank you to Gráinne Duggan for her help with this list.)

00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:05:15 - Celia Introduces Jordan Goldmeier
00:07:10 - Jordan introduces himself and the presentation
00:10:15 - Using Sparklines to analyze data: customizing sparklines to investigate the data story; visualization colour and formatting suggestions
00:16:40 - Hide columns using Groups without hiding sparklines; sparkline bars vs lines vs win-loss; use sparklines to tell a lot of information in a small amount of space
00:21:50 - Create a Heatmap using Conditional Formatting; customizing the conditional formats; hide the numbers using custom format with a great tip using one semi-colon ; create a custom legend
00:33:45 - Create a KPI combination line and area chart; customize the combo chart to remove distractions; use colours to emphasize important items.
00:42:35 - Create a KPI method 2; locate hidden series on charts; customize chart axis and series; dark colours should be used to indicate what is most interesting
00:50:00 - Building Infographics in Excel; using Camera Tool and paste to linked picture; advantages of linked picture
01:04:25 - Create a dashboard with an x-y scatter plot and in-cell bar chart; Formulas to use scroll bar to highlight a specific data point; using scroll bar form control; customize a scatter plot
01:12:55 - Create a drill down chart for selected year; REPT function with TRANSPOSE
01:19:40 – Jordan’s principles that make a difference in life and careers
01:20:00 – Questions and general discussions; Jordan talks about the books he wrote
01:31:30 – Wrap up

-----------------------