Excel comes loaded with lots of tools to help you work smarter and easier. Today we’ll look at three tools — Reports, Views and Outlining — that can make a big impact on your day-to-day work in Excel.

If you use Microsoft Excel at all to make and edit spreadsheets, you have probably heard of Excel worksheets and workbooks. An Excel workbook is an Excel file that can contain multiple, somewhat ...

Q. Is there a list of standard Excel design rules we should be following as we create new Excel worksheets? A. By following a common set of spreadsheet design rules, companies can produce more ...

Regular users of Microsoft Excel know about Workbooks and Worksheets, but do they know the differences? You see, many people confuse the terms Workbooks and Worksheets more often than not, and that is ...

Stacking data from multiple worksheets manually can be painfully time-consuming and could easily lead to copying errors. What's more, this process becomes even more burdensome if you need to regularly ...

The Excel Workbooks, Excel Add-ins, and screencasts on this site will be updated and corrected regularly so head there if you are merely looking for the latest versions of a file. As far as mistakes ...

Excel grays out menu commands for unavailable features or functions. To unlock the grayed-out menus, first review the most common causes, then take the steps necessary make the menu active. By default ...

How to create a VBA procedure that closes all open workbooks in Excel Your email has been sent Some of us work with several Microsoft Excel workbooks open at the same time. Either we open them and ...

When an Excel file goes haywire, don't give up hope. Using one of these recovery tricks, you may still be able to salvage the data. When an Excel file goes haywire, don’t give up hope. Using one of ...