CP043: My favorite time saving features of Excel, Revealed.
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
- Pivot Tables
- Auto fill
- Format Painter
- Find & Replace
- VBA / Macro Recorder
- Auto save
- Auto complete / Intellisence
- Recap & Conclusions
Listen to this session
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:
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.
Introducing our Online Power BI Class:
Would you like to join me on a date with Power BI? In this comprehensive online class, learn all about Power BI so you can create beautiful, insightful & interactive reports. Join me and rest of the play mates for our first ever Power BI Play Date.Click here to know more and join us.
Leave a Reply
|Use GETPIVOTDATA to integrate pivot tables with dashboards||Monthly Planner Template [downloads]|