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
• Tables
• Pivot Tables
• Auto fill
• Format Painter
• Find & Replace
• VBA / Macro Recorder
• Auto save
• Auto complete / Intellisence
• Recap & Conclusions

Listen to this session

Podcast: Play in new window | Download

Subscribe: RSS

Click here to download the MP3 file.

Resources to save time

Dealing with duplicates

• Remove duplicates button – explained
• Remove duplicate combinations

Tables & Pivot Table concepts:

• Introduction to Excel Tables
• Introduction to Excel Pivot Tables
• Structural References & how to use them

Auto fill & flash fill:

• Fill up patterns with Auto-fill
• Flash fill in Excel – a quick intro

Format Painter and how it can save time for you:

• Format faster with format painter & double click
• Format all charts in same way using format painter

Find & Replace:

• Use find / replace to change formats quickly
• Change formulas with find / replace

VBA & Macro Recorder

• Introduction to VBA & Macros
• What is a macro and how to get started – podcast

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).