## HOW TO SUM THE TOP or BOTTOM n VALUES; 5 Methods

Learning how to sum the top or bottom n values in excel requires one to first be familiar with the LARGE & SMALL functions. The LARGE function returns the “nth largest” Value in a list…=LARGE( list, n) The SMALL function returns the “nth...

## WHY FOCUS ON HR ANALYTICS? HERE ARE 9 REASONS

TheÂ HumanÂ ResourcesÂ fieldÂ is witnessing the rise in the use of HR analytics. The power ofÂ HR analytics is enabling practitioners to ditch their â€śgut feelingâ€ť for any decision to makeÂ â€”Â which was the trend earlierÂ â€”Â andÂ take more informed and data-backed decisions for...

## How To Create a Dynamic Waterfall Chart in Excel

Waterfall charts are used to explain the +ve and -ve components of a change in value between two points. It reveals the contribution per factor affecting the item being analyzed. For example, If you had Budgeted \$ 66M but ended up spending \$ 72M, you can easily tell...

## How to Allow Only UPPERCASE, lowercase Or Proper case Entries in Excel

Accurate data entry saves tonnes of time in data clean up & analysis. Below is how to Allow Only UPPERCASE, lowercase, Or Proper case Entries in Excel. How it Works The EXACT Function compares two text strings and returns TRUE if they are the same else FALSE. This...

## How To SUMIF Excluding Weekends & Holidays

Summing data based on weekdays or weekends is easy, but what if you are required to SUMIF Excluding Weekends & Holidays? There are 2 ways of doing this: Using SUM, IF & WORKDAY FUNCTION =SUM(IF ( WORKDAY(tbls[Sales Date]-1,1,Holidays) = tbls[Sales...