Become Awesome in Excel by Chandoo.org - A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.
https://chandoo.org/wp/category/podcast/
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
Click here to download the MP3 file.
Resources to save timeDealing 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
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.