Please note: This item is from our archives and was published in 2016. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Our company creates ...

Q. Is there a list of standard Excel design rules we should be following as we create new Excel worksheets? A. By following a common set of spreadsheet design rules, companies can produce more ...

As a small business owner, you will often have to work with others on an Excel worksheet. For example, if you have hired a sales or marketing consultant, you can give them an interactive worksheet for ...

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

Picture this: you've created an all-singing-all-dancing Microsoft Excel workbook, but when you share it with others, they have no idea where to start. That's why you need a homepage worksheet that ...

Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables, nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature, let alone ...

Excel is a powerful tool that can help you manage, analyze, and present data effectively. However, many users only scratch the surface of its capabilities, often relying on manual processes and basic ...

An ordinal variable is a number that shows the position of an object within a series of objects with the use of a suffix, for example, "1st" or "453rd." When preparing a worksheet in Excel for your ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros. Recently, Microsoft has introduced the ability to add ...

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 ...

Hide everything but the working area in an Excel worksheet Your email has been sent If you’ve ever opened a Microsoft Excel workbook to find no columns, rows and/or scrollbars, this is probably why: ...

Track stocks like a pro with a free Excel add-in Your email has been sent Retrieving up to date stock market prices for Excel is a snap with the free Stock Connector add-in. Here's a walkthrough of ...