fbpx

All articles with 'sort' Tag

Dynamic Arrays Live Masterclass – Replay

Published on Feb 23, 2021 in 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

Continue »

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

Published on Nov 17, 2020 in Charts and Graphs, Learn Excel
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.

Continue »

Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs

Published on Apr 11, 2020 in Learn Excel
Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs

Excel Dynamic Array Functions are a true game changer. These newly introduced DA functions can filter, sort, remove duplicates and do much more. The output of these functions can go to a range of cells. Hence the name – dynamic array functions.

Continue »

Excel Basics: How to add drop down list to validate data

Published on Sep 27, 2019 in Learn Excel
Excel Basics: How to add drop down list to validate data

Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, excel has the right tools to do it. Excel drop down list can assist you in picking up a value from a valid list to enter in a cell. Here is a short how-to […]

Continue »