Create a Menu — In this brief tutorial, I explain how to create a menu that contains a handful of frequently used commands. (I use Word in this tutorial; the procedure is nearly identical with Excel ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

You can use a menu command to create a hyperlink to a named range or you can use a simple drag-and-drop trick.

This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report.