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.

What is a pivot table, and why should you create one? Before we dive into pivot tables in Excel, letâ s have a quick word about it. A pivot table is a powerful tool in Excel to summarize and ...

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

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.

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

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.