How to Create Pipe Delimited Files in Excel 2010. Microsoft Excel allows you to export spreadsheet data to a number of common formats for use with other applications. If you need to export data to ...

Excel 2010 and Outlook 2010 do not have the ability to create the document you use to perform a mail merge, so you will use Word 2010 during the process.

As you use Microsoft Excel more and more, you'll find that the VLOOKUP function is a very popular tool for dealing with large Excel directories or databases. It allows the user to quickly find ...

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

If you don’t want to spend money on Word and Excel, there are options for getting these programs for free—options that are legal and above board, and offered by Microsoft.

You can use Excel, Microsoft's spreadsheet program, to store, organize, and analyze data in a number of ways.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Regular expressions aren't just for use in Excel. In fact, you can use REGEX to automate other tasks on your computer, like fixing copy-pasted PDF text, bulk-renaming downloaded files, formatting ...

The ramifications of missing a due date can range from simply adjusting the date to getting fired. Don't take chances with deadlines when a simple conditional format can remind you.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.