Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Want to delete or truncate numbers to the left in Excel? Learning how to remove numbers in Excel from the left is a neat trick to automate subtracting unwanted digits.

If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.

When you think about serial communications, Microsoft Excel isn’t typically the first program that springs to mind. But this spreadsheet has a rather powerful scripting language hidden away i… ...