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

In this tutorial, I’ll show you how to create a sheet view in a shared Excel workbook and then add groups as well as hidden rows and columns.

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

Here's how to use it to save time and create better spreadsheets. How to use the Camera button in Excel for linked snapshots ...