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

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

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.

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.