Excel’s SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions came to mind as I was watching a 1969 film called If It’s Tuesday, This Must Be Belgium, about American tourists on a whirlwind tour of ...

Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy. Here's an Excel automation scenario that reflects solutions that I've ...

This post explains what is IFERROR function and how to use the function in Microsoft Excel. The IFERROR function was introduced in Excel as a logical function to handle errors that may occur within ...

If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others identify data quickly, recognize trends and even spot ...

Combo boxes are a useful way of entering data into an Excel spreadsheet, combining the flexibility of a text field with the convenience of a list box. Combo boxes provide you with a list of choices ...

Have you ever wondered if Microsoft Excel was invented by a sadist? Trying to edit multiple files at one time becomes a game of “Find the worksheet.” You know that the feature you need is on one of ...

Using Excel’s fill handle to create an alphabetic list Your email has been sent Microsoft Excel's fill handle tool won't create an alphabetic list by default, but there are a few tricks you can use to ...

Data is rarely properly formatted and structured when you import it. Try these eight tips for fast data cleanup in Microsoft Excel. Data comes in from an increasing number of sources these days. For ...

Microsoft Windows may get all the press coverage, but when you want to get real work done, you turn your attention to the applications that run on it. And if you use spreadsheets, that generally means ...

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Amy is an ACA and the CEO and founder of ...