Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

CP043: My favorite time saving features of Excel, Revealed.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

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

Read This »

August 27, 2015

How to use GETPIVOTDATA with Excel Pivot Tables

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

Read This »

August 26, 2015

Summarize only filtered values using SUBTOTAL & AGGREGATE formulas

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

Read This »

August 25, 2015

Dynamic Print Areas

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.

Read This »

August 24, 2015

Save time & paper with print areas in Excel

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.

Read This »

August 23, 2015

How to import web data to Excel using Power Query

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]

Read This »

August 21, 2015

Dashboard best practice: Highlight user selection

Here is a best practice to improve your dashboard usability. If you have an interactive dashboard, highlight user selections thru conditional formatting.

Check out below quick video to understand what this means.