Automate repetitive data entry and fix broken sorting hierarchies using Excel's powerful, hidden Custom Lists tool.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...

Whether you employ a single part-time consultant or a dozen full-time workers, the people who work for you are your most important -- and often your most expensive -- resources. Appraising and ...

There are several ways to create maps in Microsoft Excel 2007. While you can always paste map images into a worksheet or even draw your own maps using the shape and line tools, most businesses need ...

Create a table of contents in an Excel sheet using hyperlinks Your email has been sent Hyperlinks have been around for a long time, but some Excel users just don’t use them. One way your users can put ...

We can create a master sheet in a Workbook and link other sheets to it, and create links to access them instantly. This gives us a lot of convenience in managing data and multiple sheets. It makes it ...

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

Can Excel send Alerts? Yes, but with some limitations. Excel cannot email an alert to you automatically unless you write a macro in the Visual Basic (VBA) editor to perform this function. And, the ...