Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

An Excel Spreadsheet is a file that contains columns and rows. All the rows are numbered (row 1, row 2, row 3, etc) and the columns are listed alphabetically (column A, column B, etc.) Each cell is ...

If you want to create a dashboard in Microsoft Excel, this post will help you. A dashboard is a type of graphical representation that depicts the key performance indicators for a particular topic or ...

Excel's Linked Picture tool lets you take a snapshot of some data and paste it as an image—handy if you're compiling a dashboard of the key metrics from across your workbook. Unlike normal images, ...