CP043: My favorite time saving features of Excel, Revealed.
Chandoo.org Podcast - Become Awesome in Data Analytics
Audio is streamed directly from the publisher (traffic.libsyn.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
In the 43rd session of Chandoo.org podcast, let’s talk about top time saving features of Excel.
What is in this session?
In this podcast,
- Quick announcement about Awesome August
- My 9 favorite time saving features of Excel
- Remove Duplicates
- Tables
- Pivot Tables
- Auto fill
- Format Painter
- Find & Replace
- VBA / Macro Recorder
- Auto save
- Auto complete / Intellisence
- Recap & Conclusions
Listen to this session
Click here to download the MP3 file.
Resources to save time
Dealing with duplicates
Tables & Pivot Table concepts:
- Introduction to Excel Tables
- Introduction to Excel Pivot Tables
- Structural References & how to use them
Auto fill & flash fill:
Format Painter and how it can save time for you:
Find & Replace:
VBA & Macro Recorder
Transcript of this session:
Download this podcast transcript [PDF]
Which Excel feature is the most time saving one?
I’ve revealed my secrets. Now it’s your turn. Tell me your favorite time saving feature of Excel.
And if you have a few minutes time, Please write a review for Chandoo.org podcast on iTunes. Please click here to do that (see the instructions if you don’t know how to write a review on iTunes).
The post CP043: My favorite time saving features of Excel, Revealed. appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.