Session recorded live on Jul 10
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:
SPEED UP YOUR EXCEL FILTERS WUTH LIST SLICER
To kick off the session, Jakob Nielsen will demonstrate the List Slicer addin for Excel, the fastest way to filter PivotTables and Tables to a list of values.
If you spend too much time filtering data lists manually, you cannot miss this demo. You are going to love it!
https://bit.ly/listslicer
Speaker: Jakob Nielsen
CEO and Founder, Make Digital Solutions ApS
[email protected]
/ makedigitalsolutions
Jakob is passionate about helping people become more productive and achieve better results with spreadsheets. He is the founder and CEO of Make Digital Solutions ApS and a Principal Designer on Microsoft's Excel team.
GUERRILLA PIVOT TABLES FOR EXPLORATORY DATA ANALYSIS
Don't worry if you have never created a Pivot Table before; in this session, you learn how to create interactive tools for exploratory data analysis using basic to advanced features.
Come and dive into the world of Excel’s Pivot Tables with practical tips to augment your data analysis, streamline your workflow, make your data management more efficient and enhance your reporting skills.
Many of the tips are based on common challenges and solutions Carlos encountered in his professional journey, and they are worthy of knowing to help you save time, avoid frustration, and enhance productivity with mighty Excel.
If you’re looking to analyze data quickly, create reports, and gain insights, pivot tables are a great way to make data analysis accessible and enlightening.
Speaker: Carlos Barboza
A guerrilla data analyst, consultant, and trainer with experience in crafting robust, flexible and scalable spreadsheets and data models with Excel and Power BI to facilitate and help support datadriven decisions.
Find more about Carlos Barboza work and connect with him:
LinkedIn: / merod
Youtube: / @spilledgraphics
Website: https://spilledgraphics.com/
https://graficasdinamicas.com/
Blog: https://spilledgraphics.com/vlog/
GitHub: https://github.com/RecalcOrDie
Meetup: https://www.meetup.com/members/392315...
Timestamps
00:00:00 Celia Alves MS Excel Toronto news and upcoming events
00:11:30 Celia introduces Jakob Nielsen, Excel designer at Microsoft and Make Digital Solutions
00:13:00 Jacob presents Speed Up Your Excel Filters with List Slicer (Addin)
00:21:55 Celia introduces Carlos Barboza
00:23:20 Carlos introduces himself and his presentation, anatomy of the door: pivot table
00:28:00 Introduction to Pivot Tables and Pivot Table Fields panel
00:33:25 Summarize data for management
00:39:15 Impact of moving fields between Pivot Table areas
00:41:30 Exploring the data for outliers, distribution, patterns and insights
00:50:00 Adjusting months to display under different calendar years such as campaign year
00:57:00 Visualize the data along the way to see outliers, patterns etc.; importance of axis starting at zero; flexibility of Pivot Tables; adding formula outside the pivot; looking for trends
01:08:45 Add variance from previous year, and share % of total
01:13:55 Case study, category, contribution, variances, metrics etc. all in one Pivot Table
01:20:00 Pivot Tables based on Data Model; collapsing sections; move metrices to rows instead of adding more columns; make Pivot Tables easier to read
01:32:15 Drill down for more details; Sort; the power of ∑ Values; Enable Selection option and use to navigate
01:40:20 Discussion and Questions
01:51:00 Wrap up