Tracking the time your employees take off needn't cause you a headache. With Microsoft Excel you can set up a workbook that can organize all sick days, personal days and any other days you need to ...

If you have a Microsoft Office Excel 2010 spreadsheet, you can easily create a hyperlink to a Word document and place it anywhere in the spreadsheet. However, clicking the hyperlink opens the Word ...

Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time compared to manually entering such data into a given spreadsheet ...

While Excel is a powerful tool for organizing data and performing complex calculations, it’s easy to get lost in a sea of ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it's as easy as creating a table. In earlier versions, you'll need the formula method.

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