To activate Power Pivot, go to File > Options, click Add-ins, select COM Add-ins from the dropdown, and check the box for ...

These five Excel tools—Quick Analysis Tool, Flash Fill, Fill Handle Options, Menu Key Shortcuts, and Navigation Pane—are designed to enhance your productivity and simplify data management.

The Camera tool —available in most desktop versions of Excel, including the earliest—is commonly known as the "hidden Camera tool," as it's not immediately accessible on the ribbon.

The Camera tool captures images of data and charts and paste the data in the selected location. Learn how to add the Camera tool in Excel.

Stop guessing! Susan Harkins shows you how to use Excel's Goal Seek what-if analysis tool to achieve your goals.

However, you eventually may find that you want to again use the default shortcuts. In this case, you can reset the shortcut keys in the Microsoft Excel "Tools" menu.

You may have used Excel for years without delving into Styles (or stylesheets). We’re going to cover Cell Styles, and Smart Art, Drawing, Graphics, Picture, and Chart Tools.

Choose Macro from the Tools menu, select Security, and choose the High option. In Excel 2007, click the Office button, click Excel Options, and choose Trust Center in the left panel.