# All articles with 'sort' Tag

## Which Excel Formulas should you learn first?

Published on Nov 14, 2022 in Learn Excel

Let’s face it. You already know how to use SUMs, COUNTs and IFs and want to level up. But there are 100s of functions in Excel and you are not sure which ones to focus on.

In this article, let me reveal the top 10 important functions in Excel for data analysis work.

Continue »

## Dynamic Arrays Live Masterclass – Replay

Published on Feb 23, 2021 in Learn Excel

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

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

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 »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.