Excel Dashboard Masterclass -From Zero to Hero

Learn to apply conditional formatting in Excel to highlight top 25 percent, top 10, bottom 15, and values above 10000 or below 500, and to manage rules for dashboards.

Explore how data bars in Excel's conditional formatting visualize a data range, compare values, and handle negative and positive data with customizable color rules.

Learn to visualize performance with icon sets using conditional formatting in Excel, applying rules to reflect green, yellow, and red indicators based on targets, percentages, and thresholds.

Apply color scales in conditional formatting to create heat maps that reveal max, min, and trends in sales data, while avoiding totals.

Learn how to apply logical functions in Excel, using if, nested if, and, and or tests to automate dashboards and apply conditional formatting.

Use conditional formatting to format dataset: highlight woodworks in green, Delhi in red, units above 25 in blue, and total sales above 2500 in orange with yellow font.

Learn to create and customize bar and column charts in Excel, using data labels, chart elements, designs, and sorting to build clear dashboards.

Explore line charts to compare two revenue items across a year, customize axes, add data labels and markers, reorder series, and choose designs to highlight trends.

Explore creating pie and doughnut charts in Excel, add percentage data labels, adjust angle and explosion, compare with bar charts, and learn when to use them in dashboards.

Area charts fill the area under a line to show trends over time and cumulative values, including stacked flavors and basic design tips.

Explore sunburst and tree map charts in Excel 2016 to visualize hierarchical data with circular rings and proportional rectangles, while sorting the first column and choosing banner options for clarity.

Learn to build combination charts by blending bars and lines in a single visualization, switch chart types, add data labels, and use a secondary axis when needed.

Learn how scatterplots visualize relationships between two variables, add trendlines and axis labels, and interpret upward or downward trends using examples like hours studied vs marks and temperature vs hardness.

Master sparklines, miniature spotlights that fit in a single cell to show trends, highs and lows, using line and column sparklines for quick, micro chart insights.

Master bullet charts in Excel to display target, actual achievement, and range categories (bad, average, good) for multiple data points, and see how changing the actual value shifts the chart.

Create a waterfall chart in Excel 2016 that shows how production and sales drive a running inventory total, with positives and negatives for variance analysis.

Explore how Excel pivot tables analyze, sort, filter, and present data for clear insights. Create dashboards with dynamic pivot tables that update as source data changes.

Learn to apply conditional formatting to pivot tables with data bars, tailor rules for categories and subcategories, and highlight total revenue and profit while avoiding grand total distortion.

Master filtering pivot table data using field lists and slicers, learn to filter by location or city, enable multi-select, clear filters, and connect slicers to multiple pivot tables.

Pull specific figures from pivot tables using get pivot data. Use category slicers and report connections to filter, and fix errors with if error by creating a constant reference table.

Create pivot charts from pivot tables, apply conditional formatting, add slicers and styles, and design dynamic bar and line charts to build interactive dashboards.

Learn how to use vlookup and hlookup to look up values and return related data from a table, enabling dynamic dashboards.

Explore match and index functions for two-way lookups in Excel, retrieving item names or prices from a data array with exact matches.

Learn to create dropdown lists using Excel data validation, restrict inputs to a list, and use stop, warning, or information alerts to improve dashboards.

Identify the dashboard’s purpose and audience to guide data from sources and visualization choices. Choose the right visuals, keep the layout concise and visually appealing, and ensure it drives action.

Create a dynamic Excel dashboard using a dropdown to filter weekly sales by employee, employing vlookup and index and match to drive a live 3d bar chart and line chart.

Learn to build an enterprise level, one page Excel dashboard that visualizes revenue distribution, sales by channel, product lines, location sales, and inventory using a pivot table and charts.

Build a complete Excel dashboard by crafting a bullet chart for profit achievement percentage, using a pivot table with slicers, and linking pictures to keep visuals dynamic.