Although Microsoft Excel is a powerful spreadsheet out of the box, macros make it even more useful. You can create and record macros within the app.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

How to create an automated list of worksheet names in Excel -- and add a table of contents.

The Only Create Connection radio button in Excel's Import Data dialog box is selected. A table named Vegetables is listed in Excel's Queries And Connections pane.