by Crispo Mwangi | May 27, 2022 | INTERMEDIATE EXCEL
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...
by Joan Tonui | May 22, 2022 | HR
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...
by Crispo Mwangi | May 18, 2022 | ADVANCED EXCEL, CHARTS
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...
by Crispo Mwangi | May 13, 2022 | INTERMEDIATE 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...
by Crispo Mwangi | May 4, 2022 | ADVANCED EXCEL
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...
Recent Comments