Microsoft Excel Intermediate - Creating a Dashboard

Create an Excel dashboard to analyze five years of sales data, showing sales results, return percentage, product ratings, and channel performance with year, product, channel, and area breakdowns.

Turn data into a named table, then build pivot tables to analyze sales by area and year with filters and value settings.

Create an Excel dashboard by building charts from pivot tables—line, area map, doughnut, waterfall, and 100 percent stacked charts—linking data with get pivot data and formatting currency and percentages.

Create an Excel dashboard by adding a dashboard tab, removing gridlines, applying a background image, and assembling a color-coordinated tile layout with sections for sales results, channels, returns, and ratings.

Assemble an Excel dashboard by copying charts, formatting areas and backgrounds, and applying gradient line and donut charts with linked data and labeled sales visuals.

Create and link custom slicers to a dashboard in Excel, connecting years, areas, products, and channels to pivot charts so all visuals filter in unison.

Automatically refresh pivot tables with a VBA macro triggered by worksheet changes, refreshing all pivot caches, including enabling the developer tab and saving as a macro-enabled workbook.