Microsoft Excel isn't just for work. In fact, by leveraging just three single, powerful formulas, I use the popular ...

The simplest use of the FORMULATEXT function is straightforward formula auditing.

Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate business check numbers that haven't been logged into a balance ...

Every now and then you come across something that Excel doesn’t have a function for which requires you to get fancy and figure out some tricky way to get the job done. While coding up a solution in ...

The ways to easily remove numbers from the left in Excel are not unique to numbers. You can use this same formula to remove other characters from a string of values in Excel. You can also use the ...

Ideally, any Microsoft Excel spreadsheet that contains names and addresses breaks up each category of information into separate columns for each significant part. That means, for example, that an ...

Is Apple’s iWork a viable alternative to Microsoft Office? To find out, we asked Rob Griffiths—our go-to expert on spreadsheets—to use Excel 2008 and Numbers ‘08 to create the same project, ...