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

We explain how to make a Lollipop Chart in Excel. A Lollipop Chart resembles a Bar Chart but with a line on a point at the end.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.

Create a Column Column Chart by combining a clustered column chart for individual category data with a totals series using Excel’s combination chart feature.

Making a floating bar chart in Microsoft Excel is a great way to visually represent distribution between entities. Susan Harkins will show you how.

Learn how to create a risk assessment matrix in Excel with this step-by-step guide. Automate, visualize, and simplify risk management with a ...

In the Status column, I want to create a drop-down menu to add the current status for each task quickly. I will use Excel’s data validation to get the job done. Here’s how.

There are tough problems that every business faces, and they can slow things down, make budgets stretch, or put off decisions ...

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.

To take a snapshot of a range not formatted as an Excel table using the Linked Picture tool, select the data, press Ctrl+C to copy it, and click "Linked Picture" in the Paste drop-down menu.