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.

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.

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. All you need is one common, unique field. Here's how to set it up with multiple spreadsheets.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

While those default gridlines in Excel might seem helpful, at times, they can actually make your spreadsheet look cluttered. You can create a cleaner, more professional appearance by removing ...

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

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