That all changed when I discovered two features in Excel most people don't know about: Watch Window and Custom Views. Together, they provided me with a way to track the numbers that matter without ...

Q. There are formulas that I am repeatedly having to create in my Excel workbook, and there are no built-in functions in Excel that can do these calculations. Is there a quicker way to reuse the same ...

Microsoft provided an update during this week's Build Conference event for developers regarding custom functions for Excel and related capabilities. The custom functions for Excel feature lets ...

An curved arrow pointing right. Creating an Excel add-in is so useful and actually quite simple. It will allow you to use your custom functions in any workbook seamlessly. If you forgot how to create ...

Tom Warren is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft Excel used to only allow two types of data: text and numbers.