Excel Pivot Tables for Quick Analysis: Livestream Recording
*Note: I may be compensated, but you will not be charged, if you click on the links below.
🔵Download the slides from the lectures in the series here: https://buff.ly/40VvfAh
🟠Want to participate in our upcoming free online workshop “Application Basics”? Details are here: https://buff.ly/43SfASM
🟢Check out all the lectures in the series: https://buff.ly/44AtKZv
💖This livestream event was originally recorded on January 2, 2024. See original LinkedIn event here: / excelpivottablesforquickanalysi71388547223...
💖To register for our live events , follow our company page on LinkedIn: / dethwench-professional-services
💡 Read about all our online educational resources: https://buff.ly/45amjaQ
💡 Learn more about online group mentoring program: https://buff.ly/3Sw4Fsa
💡 EXCLUSIVE! Download 9-page list of applications terminology with definitions along with flash cards from the course! https://buff.ly/43yEUgT
💡 EXCLUSIVE! Download cheat sheet for Monika’s preferred Microsoft Excel defaults! https://mailchi.mp/3092e5e77ee5/rsasa...
WANT TO SUPPORT MONIKA ON SOCIAL MEDIA?
🔵Sign up for Monika’s weekly data science e-newsletter: https://buff.ly/2UYW60l
🟠Follow/connect with Monika on LinkedIn: / dethwench
🟢Try Monika’s courses on LinkedIn Learning: https://linkedin-learning.pxf.io/NKN0JO
⚫Follow Monika on Twitter: / dethwench
🟣Follow Monika on Instagram: https://www.instagram.com/dethwench/?...
🟤Follow Monika on Facebook: / dwprofsvcs
💜Intro and outro by CJ Hutchings, recorded exclusively for DPS. Check out more of CJ’s music and art here: https://dethwench.com/cjhutchings/
❤️Got too much work? You can hire Ebenezer as YOUR executive assistant, too! He is highly competent and reliable. Contact him here: https://ebdado.netlify.app/
Links/Timestamps from Video:
01:18 The pivot table controversy: Love ‘em or hate ‘em
03:35 What “pivot table” means in Microsoft Excel
05:45 When to choose pivot table instead of R, SAS, SQL or Python
08:00 Best practices for using pivot table for portfolio projects: Four steps
09:11 Context: Black Friday Death Count data and the variables I added
11:54 Let’s take an existing pivot table and mess it up first
12:30 How to manipulate an existing pivot table
16:30 Translating pivot table data into an analysis
18:36 How to put down a pivot table to begin with
19:42 Warning about pivot tables