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 in columns of individual date entries.

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

I'm making an accounting workbook with the following criteria: In the first sheet called "Account", all the transactions will be listed on table that goes from C6-H6, and on down for every entry. One ...

Learn the secret to building interactive Excel reports with slicers and disconnected tables—no PivotTable needed for dynamic filtering.

Here's how Excel processes that request. First, the SORT function arranges the entire table by sales amount in descending ...

To activate Power Pivot, go to File > Options, click Add-ins, select COM Add-ins from the dropdown, and check the box for Microsoft Power Pivot for Excel. Once enabled, a new Power Pivot tab appears ...

Your summarizations, analyses, projections, reports and so on, are only as good as your data. It’s important that you use every resource available to protect the validity of the data, which means you ...

A quick script to populate Word contracts (or other similar forms) with data from an existing Excel spreadsheet where each row holds column-separated data for creating a new contract.