How to Auto Populate the Date in Excel. When you're setting up a Microsoft Excel spreadsheet that contains date information, you'll speed your task if you let Excel do the tedious work of filling ...

How to Automatically Insert the Date Onto a Spreadsheet. Microsoft Office Excel offers many tools and processes for automating actions in spreadsheets.

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

Do you use Excel spreadsheets to keep track of your weekly, monthly or annual expenses but find yourself updating all relevant date and content information manually? There is an easier, more effective ...

Using Structured References in Excel Tables Excel tables offer a powerful feature called structured references, which allow you to create formulas that automatically expand and contract with your ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

If you need a monthly or yearly balance for revenue transactions in Microsoft Excel, you're in luck because both are easy! Here's how to find the totals you need.

If you are using Excel and would like to automatically transfer data from a master sheet to specified sub sheets when a certain condition is met, this article will explain how to use VBA (Visual Basic ...