Identifying duplicate data & extracting unique values
There are several ways to identify duplicate data in Excel. We can either use helper functions, or Excel's own inbuilt options such as conditional formatting or pivot tables. We will…
There are several ways to identify duplicate data in Excel. We can either use helper functions, or Excel's own inbuilt options such as conditional formatting or pivot tables. We will…
TRIM and CLEAN both help remove unwanted characters from our text in Excel, but are used to achieve two distinct outcomes...
Given a date in Excel we can calculate it's Quarter End date easily using one of a number of inbuilt functions in a formula. Find the one which fits your circumstances best...
Excel provides at least 3 options for calculating the first day of any month. Either using the DATE function, the EOMONTH function or the DAY function. Read on to find out how...
Excel functions are either built-in or can be user defined In total there are about 500 hundred built-in Excel functions. Just 10% of the available Excel functions should be enough for most standard use cases.