When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, they serve a different purpose altogether. In fact, they can help you ...

Q. I often use watermarks in Microsoft Word to indicate that the document is a “Draft” or “Confidential.” However, the options to create a watermark are not in Microsoft Excel. I want to indicate that ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Income and expense spreadsheets can be useful tools to help you see where your personal or business finances stand. After you've assembled all your financial data and created a worksheet to contain ...

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. This data validation helps prevent mistakes, such as misspellings. Drop-down lists are also useful ...

Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time compared to manually entering such data into a given spreadsheet ...