by Crispo Mwangi | Jan 27, 2017 | BASIC EXCEL, INTERMEDIATE EXCEL
Finding the Nth or the Last value in a sorted or unsorted list can pose a challenge if you do not understand which functions to use. This article will show you different ways to carry out this sort of find and retrieve an item in a sorted list. How to handle the...
by Crispo Mwangi | Jan 14, 2017 | INTERMEDIATE EXCEL
Learning how to use conditional formatting in excel can save you a lot of time when you need to visually highlight important information in a worksheet. At a basic level, it can be used to highlight duplicates, values within certain thresholds, Top or Bottom N items,...
Recent Comments