Here is an awesome way to enhance your website and impress clients. Embed an Excel calculator on your webpage. Check out below demo and if this is what you want, read on.Continue »
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
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.Continue »
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.Continue »
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.Continue »
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.Continue »
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
- Spaghetti Line Chart
- Smoothed Line Chart
- Forecast Line Chart
- Line Chart Combinations