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

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

How to Create an Excel Spreadsheet to Figure Out Sick Leave. Your company allots employees a specific amount of sick leave per year, quarter or month.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.