Excel Steady Steady

It can be difficult for one to focus on a spreadsheet when it contains hundreds or thousands of rows and columns. Sometimes, you may only...

Have you ever wondered if there is a function in Excel similar to the word count function of Microsoft Word? Unfortunately, Excel does n...

Have you ever encountered a situation where your boss threw you a task to correct the formatting on a spreadsheet just 15 minutes befo...

Have you been in a situation where you spend hours trying to add up values of multiple columns in excel? Have you ever wonder of ways you ...

There are five common functions that you can use to count rows or columns that contain data. The functions are COUNT(), COUNTA(), COUNTIF(...

There are two similar functions in Excel that allow one to search for the position of a character in a text string. The function are the FI...

Upper, Lower and Proper function allow us to deal with messy letter case in Excel. The Upper() function allows us to convert all lowercas...