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

Latest Tips & Tutorials

Learn Excel

Dynamic Arrays Live Masterclass – Replay

Excel Dynamic Array functions are going to change the way to you work your data forever. Watch the replay of the event here and learn about…

* What is so different about Excel’s dynamic array functions
* The new # operator
* 6 important dynamic array functions – FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
* 25 practical examples of dynamic array functions for business analysis
* Your questions & answers

Read This »

February 23, 2021

Learn Excel

5 Simple & Useful Conditional Formatting Tricks

Oh, I *LOVE* conditional formatting. It is such a powerful feature. In this post, let me share 5 of my favorite CF secrets with you all.

Read This »

February 15, 2021

personal

Merry Christmas & Happy New Year 2021

On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2021. Here is a small holiday card from Chandoo.org HQ. The kids school had a cultural festival a month ago and we got this beautiful picture at a photo booth. So much better than timer controlled DSLR on dining table I must say.

Read This »

December 24, 2020

image lookup in Excel - vlookup but for images

Learn Excel

Image Lookup – How-to show dynamic picture in a cell [Excel Trick]

Do you ever want to have an image or picture lookup in Excel? Something like the depiction above.

In this article, learn how to set up an image lookup using Excel. You can use this to display staff details, product images or machine parts etc.

Read This »

December 16, 2020

9 box grid - talent map in Excel - template video

Charts and Graphs

9 Box grid for talent mapping – HR for Excel – Template & Explanation

9 box grid is a popular method for talent mapping. Download this free excel template for tracking and visualizing your employee performance & potential data.

In this article, I explain about powerful excel features like FILTER(), SORT() and CONCATENATEX() to create a similar 9 box talent map grid for your data.

Read This »

November 17, 2020

6 must know line charts for business data analysis

Charts and Graphs

6 Must Know Line Chart variations for Data Analysis

Line charts in Excel are essential for trend analysis, spotting distribution and outliers. Use these 6 variations to get more out your line chart.

Indexed Line Chart
Sparklines
Spaghetti Line Chart
Smoothed Line Chart
Forecast Line Chart
Line Chart Combinations

Read This »

October 1, 2020

two level data validation drop down excel

Excel Howtos

Two-level Data Validation [Excel Trick]

Ever wanted to create a two-level data validation list? You can use this simple trick to make two-level or cascading drop-down validation lists in Excel. You need some data, a pivot table and simple IF formulas to get this. Read on to understand the process and create your own two-level drop down lists in Excel.

Read This »

September 23, 2020