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
Pivot tables are very powerful analysis tools. They can summarize vast amounts of data with just few clicks. But they are lousy when it comes to output. Imagine the horror of putting a pivot table right inside your beautiful dashboard. One refresh could ruin the layout and create half-an-hour extra work for you.
How to combine the power of pivot tables with elegance of your dashboards?
The answer is: GETPIVOTDATA()Continue »
We all know the good old SUM() formula. It can sum up values in a range. But what if you want to sum up only filtered values in a range? SUM() doesn’t care if a value is filtered or not. It just sums up the numbers. But there are other formulas that can pay attention […]Continue »
Yesterday, you learned about Print Areas – a time & paper saving feature of Excel. While print areas are great, you can only set up one print area per sheet. What if you want to print either report or data based on user selection?
In such cases, you can set up dynamic print areas.
That is right. See above demo to understand how it looks. Read on to learn how to set up dynamic print areas.Continue »
Here is a very simple but effective tip: use print areas. Oh.. but what is a print area? Imagine looking at a report or dashboard worksheet. Now, that sheet also has few calculations, some extra stuff to the right of the report. When you print, you don’t need those extra elements. Just the report will do. This […]Continue »
Filtering a list is a powerful & easy way to analyze data. But filtering requires a lot of clicks & typing. Wouldn’t it be cool if Excel can filter as you type, something like above.
Let’s figure out how to do this using some really simple VBA code.Continue »
Power Query offers many ways to get data to Excel. One of them is to Web Data import feature. Let’s understand how this works by importing world stock exchange closing data from Google Finance website.
[Related: Introduction to Power Query]Continue »