Show notes are at https://stevelitchfield.com/sshow/chat.html
…
continue reading
Innhold levert av Chandoo. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Chandoo eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.player.fm/legal.
Lik Chandoo.org Podcast - Become Awesome in Data Analytics
Android Backstage, a podcast by and for Android developers. Hosted by developers from the Android engineering team, this show covers topics of interest to Android programmers, with in-depth discussions and interviews with engineers on the Android team at Google. Subscribe to Android Developers YouTube → https://goo.gle/AndroidDevs
…
continue reading
We help founders make something people want.
…
continue reading
Developer Tea exists to help driven developers connect to their ultimate purpose and excel at their work so that they can positively impact the people they influence. With over 13 million downloads to date, Developer Tea is a short podcast hosted by Jonathan Cutrell (@jcutrell), co-founder of Spec and Director of Engineering at PBS. We hope you'll take the topics from this podcast and continue the conversation, either online or in person with your peers. Twitter: @developertea :: Email: deve ...
…
continue reading
Stay current on JavaScript, Node, and Front-End development. Learn from experts in programming, careers, and technology every week. Become a supporter of this podcast: https://www.spreaker.com/podcast/javascript-jabber--6102064/support.
…
continue reading
Hanselminutes is Fresh Air for Developers. A weekly commute-time podcast that promotes fresh technology and fresh voices. Talk and Tech for Developers, Life-long Learners, and Technologists.
…
continue reading
The Fragmented Podcast is the leading Android developer podcast started by Kaushik Gopal & Donn Felker. Our goal is to help you become a better Android Developer through conversation & to capture the zeitgeist of Android development. We chat about topics such as Testing, Dependency Injection, Patterns and Practices, useful libraries, and much more. We will also be interviewing some of the top developers out there. Subscribe now and join us on the journey of becoming a better Android Developer.
…
continue reading
Bitcoin pioneer Charlie Shrem peels back the layers on the lives and backgrounds of the world's most impactful innovators. Centering around intimate narratives, Shrem uncovers a detailed, previously unspoken story of the genesis and evolution of bitcoin, cryptocurrency, artificial intelligence, and the web3 movements. Join Shrem as he journeys through the uncharted territories of tech revolutions, revealing the human side of the stories that shaped the digital world we live in today.
…
continue reading
Discover a whole new take on Artificial Intelligence with Squirro's educational podcast! Join host Lauren Hawker Zafer, a top voice in Artificial Intelligence on LinkedIn, for insightful chats that unravel the fascinating world of tech innovation, use case exploration and AI knowledge. Dive into candid discussions with accomplished industry experts and established academics. With each episode, you'll expand your grasp of cutting-edge technologies and their incredible impact on society, and y ...
…
continue reading
How can business help solve society’s biggest challenges? Welcome to Series 3 of Take on Tomorrow, the award-winning podcast from PwC that examines the biggest problems facing society and the role business can—and should—play in solving them. This series, we’re welcoming broadcaster and journalist Femi Oke to the show. She joins podcaster and journalist Lizzie O’Leary, and together with industry innovators, tech trailblazers and visionary leaders from around the globe, they’ll explore timely ...
…
continue reading
Player FM - Podcast-app
Gå frakoblet med Player FM -appen!
Gå frakoblet med Player FM -appen!
))
CP054: Top 10 Pivot Table Tricks for YOU
Manage episode 193605460 series 1836424
Innhold levert av Chandoo. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Chandoo eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.player.fm/legal.
In the 54th session of Chandoo.org podcast, let’s make you awesome in Pivot Tables.
What is in this session?
In this podcast,
- Quick updates
- Top 10 pivot table tricks
- Adding same value field twice
- Tabular layouts
- GETPIVOTDATA & 2 bonus tricks
- Relationships & data model
- One slicer to rule them all
- Show only top x values
- Relative performance
- Show unique count
- Spruce up with conditional formats
- Not so ugly pivot charts
- Resources & Show notes for you
Listen to this session
Click here to download the MP3 file.
Resources for this podcast
Comprehensive guides on,
- Excel Pivot Tables intro – Podcast
- Excel Pivot Tables an introduction
- Excel Slicers what are they, how to use and advanced tips
- GETPIVOTDATA examples & usage
- Relationships & Data model example & downloadable workbook
- Power Pivot introduction and overview
Pivot Table Tips & Tricks
- Use report filters with VBA
- Structured references for Pivot Tables
- Group data in Pivot Tables
- Matching transactions using Pivot Tables
- Highlight quarters / weekends using styles in Pivot Reports
What are your favorite Pivot Table tricks?
Now its your turn. Go ahead and share your favorite pivot table tricks in the comments box.
The post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
12 episoder
Del
Manage episode 193605460 series 1836424
Innhold levert av Chandoo. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Chandoo eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.player.fm/legal.
In the 54th session of Chandoo.org podcast, let’s make you awesome in Pivot Tables.
What is in this session?
In this podcast,
- Quick updates
- Top 10 pivot table tricks
- Adding same value field twice
- Tabular layouts
- GETPIVOTDATA & 2 bonus tricks
- Relationships & data model
- One slicer to rule them all
- Show only top x values
- Relative performance
- Show unique count
- Spruce up with conditional formats
- Not so ugly pivot charts
- Resources & Show notes for you
Listen to this session
Click here to download the MP3 file.
Resources for this podcast
Comprehensive guides on,
- Excel Pivot Tables intro – Podcast
- Excel Pivot Tables an introduction
- Excel Slicers what are they, how to use and advanced tips
- GETPIVOTDATA examples & usage
- Relationships & Data model example & downloadable workbook
- Power Pivot introduction and overview
Pivot Table Tips & Tricks
- Use report filters with VBA
- Structured references for Pivot Tables
- Group data in Pivot Tables
- Matching transactions using Pivot Tables
- Highlight quarters / weekends using styles in Pivot Reports
What are your favorite Pivot Table tricks?
Now its your turn. Go ahead and share your favorite pivot table tricks in the comments box.
The post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
12 episoder
Alle episoder
×
Velkommen til Player FM!
Player FM scanner netter for høykvalitets podcaster som du kan nyte nå. Det er den beste podcastappen og fungerer på Android, iPhone og internett. Registrer deg for å synkronisere abonnement på flere enheter.
Lik Chandoo.org Podcast - Become Awesome in Data Analytics
Show notes are at https://stevelitchfield.com/sshow/chat.html
…
continue reading
Android Backstage, a podcast by and for Android developers. Hosted by developers from the Android engineering team, this show covers topics of interest to Android programmers, with in-depth discussions and interviews with engineers on the Android team at Google. Subscribe to Android Developers YouTube → https://goo.gle/AndroidDevs
…
continue reading
We help founders make something people want.
…
continue reading
Developer Tea exists to help driven developers connect to their ultimate purpose and excel at their work so that they can positively impact the people they influence. With over 13 million downloads to date, Developer Tea is a short podcast hosted by Jonathan Cutrell (@jcutrell), co-founder of Spec and Director of Engineering at PBS. We hope you'll take the topics from this podcast and continue the conversation, either online or in person with your peers. Twitter: @developertea :: Email: deve ...
…
continue reading
Stay current on JavaScript, Node, and Front-End development. Learn from experts in programming, careers, and technology every week. Become a supporter of this podcast: https://www.spreaker.com/podcast/javascript-jabber--6102064/support.
…
continue reading
Hanselminutes is Fresh Air for Developers. A weekly commute-time podcast that promotes fresh technology and fresh voices. Talk and Tech for Developers, Life-long Learners, and Technologists.
…
continue reading
The Fragmented Podcast is the leading Android developer podcast started by Kaushik Gopal & Donn Felker. Our goal is to help you become a better Android Developer through conversation & to capture the zeitgeist of Android development. We chat about topics such as Testing, Dependency Injection, Patterns and Practices, useful libraries, and much more. We will also be interviewing some of the top developers out there. Subscribe now and join us on the journey of becoming a better Android Developer.
…
continue reading
Bitcoin pioneer Charlie Shrem peels back the layers on the lives and backgrounds of the world's most impactful innovators. Centering around intimate narratives, Shrem uncovers a detailed, previously unspoken story of the genesis and evolution of bitcoin, cryptocurrency, artificial intelligence, and the web3 movements. Join Shrem as he journeys through the uncharted territories of tech revolutions, revealing the human side of the stories that shaped the digital world we live in today.
…
continue reading
Discover a whole new take on Artificial Intelligence with Squirro's educational podcast! Join host Lauren Hawker Zafer, a top voice in Artificial Intelligence on LinkedIn, for insightful chats that unravel the fascinating world of tech innovation, use case exploration and AI knowledge. Dive into candid discussions with accomplished industry experts and established academics. With each episode, you'll expand your grasp of cutting-edge technologies and their incredible impact on society, and y ...
…
continue reading
How can business help solve society’s biggest challenges? Welcome to Series 3 of Take on Tomorrow, the award-winning podcast from PwC that examines the biggest problems facing society and the role business can—and should—play in solving them. This series, we’re welcoming broadcaster and journalist Femi Oke to the show. She joins podcaster and journalist Lizzie O’Leary, and together with industry innovators, tech trailblazers and visionary leaders from around the globe, they’ll explore timely ...
…
continue reading
Player FM - Podcast-app
Gå frakoblet med Player FM -appen!
Gå frakoblet med Player FM -appen!
