Microsoft Excel Data Analysis - Build Excel Dashboards

Create a dynamic excel dashboard using pivot tables to categorize revenue and customer satisfaction by month, product, country, gender, and payment method, then visualize insights with pivot charts and dashboards.

Create a dynamic Excel dashboard by building pivot charts and revenue-focused visuals, and apply max/min formulas and vlookup to identify top and bottom revenue months and products.

Create an interactive sales dashboard in Excel by combining pivot charts and tables with design styles, slicers, and a timeline, including a gender chart and performance insights.

Create a dynamic sales dashboard by building pivot tables across product, country, age group, and payment method, then visualize with pivot charts to reveal revenue, top sellers, and monthly performance.

Create pivot charts and sparklines for sales by product and country, then design a polished dashboard with slicers, labels, and color styles to enable quick filtering and insights.

Learn to build a dynamic Excel dashboard analyzing two brands' sales over time using tables, pivot tables, slicers, sparklines, and charts.

Learn to build an interactive Excel dashboard using pivot tables and charts, including line and bar charts for sales by brand and product, with currency formatting and dashboard design.

Build interactive Excel dashboards by creating pivot tables for sales by gender, brand, geography, then insert bar and map charts, format data labels as percentages, and color code for dashboards.

Create an interactive Excel dashboard by adding shapes and text, designing and using slicers, connecting them to data tables, refreshing data, and protecting the worksheet for dynamic reporting.

Build a dynamic Excel dashboard using a pivot table and pivot chart to display employees by gender and department, with metrics like total expense, sick leave, and rating.

Create and format a pivot table and pivot chart to display employees by department, map values, and move the chart to the dashboard sheet, adding a shape for visual emphasis.

Learn to build an Excel dashboard using a pivot table and pivot chart to display employee hire types, and customize a bar chart with shapes for emphasis.

Use a pivot table and pivot chart to display employee status (active, medical leave, and on notice), and build a dashboard ready bar chart with data labels.

Explore creating a pivot table and pivot chart to display employee designation types, build a bar chart, customize with data labels, and integrate into a dashboard sheet.

Create a pivot table and pivot chart to display employee expenses by department, including salary, bonus, and overtime, and visualize it with a bar chart on a dashboard sheet.

Create an excel pivot table and pivot chart to show department-wise employee expenses, including salary, bonus, and time, then build a bar chart on the dashboard with data labels.

Explore how to build a pivot table and pivot chart to display average sick leaves across departments, then visualize the data with a speedometer-style dashboard in Excel.

Create a pivot table and pivot chart to display the average employee rating by department. Build a dashboard using speedometer and combo charts along with pie and donut charts.

Learn to make dashboards interactive by adding slicers to filter charts and tables in Excel, connect slicers to charts, and hide no-data items for dynamic, real-time updates as you filter.

Build a dynamic and interactive Excel dashboard for web analytics, linking visitors, unique visitors, traffic sources, devices, countries, and popular pages using formulas, spot lines, and slices.

Format data as a structured Excel table, the first step in building your dashboard; ensure dates are text and numbers are numeric, so charts and formulas refresh automatically.

Create your first Excel pivot table and pivot chart to build a dynamic dashboard, grouping dates, counting visitors, and visualizing data on a dedicated dashboard sheet.

Create a second Excel pivot table and pivot chart to build a dynamic dashboard by adding device type fields, formatting data, applying colors, and integrating icons for a polished view.

Create your third pivot table and pivot chart for a dashboard by building from the people table, adding data labels and colors, and placing the chart on the dashboard sheet.

Create your fourth pivot table and pivot chart to build a dynamic Excel dashboard, using a monthly bonus rate and a line chart with markers.

Create your fifth Excel pivot table and pivot chart to build a dynamic dashboard that visualizes the monthly bonus rate percentage, using calculated fields and formatting for clarity.

Create your sixth Excel pivot table and pivot chart to build a dynamic dashboard that maps website visitors by country using a map chart, conditional formatting, and dashboard sheet techniques.

Create your seventh Excel pivot table and pivot chart to build a dynamic dashboard, visualizing monthly trends by category using line charts and sparklines on the dashboard sheet.

Explore creating a pivot table and pivot chart in Excel to build a dynamic dashboard, including arranging fields, inserting charts, and assembling the dashboard sheet.

Create your ninth Excel pivot table and pivot chart for a dynamic dashboard. Explore visitor types, distinguishing new residents from returning visitors, and place results on the dashboard sheet.

Create a dynamic dashboard by building a pivot table and a pivot chart from traffic sources, then insert a cluster bar chart and sort values from large to small.

Make your Excel dashboards dynamic by adding shapes, icons, and text boxes, linking shapes to table filters with formulas, and styling fonts and colors for clear, interactive insights.

Learn to build interactive Excel dashboards by adding slicers, linking them to charts, and adjusting design to display year-specific data while hiding empty items.

Learn to build a dynamic, interactive Excel HR dashboard using formulas, report tables, slicers, and charts to analyze expenses, salaries, headcount, and performance metrics from a 100+ row dataset.

Learn to build your first pivot table and pivot chart for an interactive Excel dashboard, using dynamic labels, formulas, and visual elements like donor chart and icons.

Create a second pivot table and pivot chart to show growth in total salary, total bonus, and total all-time expenses on the interactive dashboard.

Create a third pivot table and pivot chart to show department-wise expenses, including salary, bonus, and overtime, for an interactive dashboard.

Create a pivot table to analyze review status—completed, in progress, pending approval, and to start—and visualize it with a pivot chart for an interactive Excel dashboard.

Create your fifth pivot table and pivot chart to build an interactive dashboard, using promotion eligibility, gender, and dynamic labels to visualize eligible and non eligible data.

Create a pivot table and pivot chart to analyze average salary by age group, grouping ages in five-year intervals, and visualize results on your interactive dashboard with a bar chart.

Create your seventh pivot table and pivot chart for an interactive dashboard by grouping salary by two years, showing US average, and placing a column chart on the dashboard sheet.

Create a pivot table and pivot chart to build an interactive dashboard that analyzes employees over time with a running total line chart.

Create your ninth pivot table and pivot chart for an interactive dashboard, visualizing employee average ratings by efficiency, behavior, innovation, and colleagues feedback with a column chart.

Learn to build dynamic, interactive dashboards in Excel by using slicers to filter charts and tables, apply design and style options, and connect slicers to charts.

Master a new skill tree in Excel dashboards and apply the essential skill you learned to your projects in a simple way.

Create an interactive product metrics dashboard in excel to analyze mau and dau, online engagement, sales, and promotions across platforms and countries using treemap and clustered bar visuals with slicers.

Create a product metrics dashboard in Excel by building pivot tables to show monthly active users for website and app, adding averages, percentage differences, and slicers for interactive visuals.

Create a multi-visual excel dashboard by adding website, monthly and daily active users charts, using vlookup for data, pivot tables for trends, and grouped blue visuals with outlines.

Create a product metrics dashboard by adding pivot tables and visuals, including a monthly sales analysis treemap and charts for sales by country, products, and age group using vlookup.

Create a product metrics dashboard in Excel by building multiple pivot tables, switching fields, and adding clustered column charts to visualize country-wise clicks, subscriptions, trials, and conversions.

Create a product metrics dashboard in Excel by building pivot tables to display average click, subscription, trial, and conversion percentages, adding slicers to drive dynamic, interactive visuals.

Build an interactive, two-page Excel personal finance dashboard with income, expenses, investments, and cash in hand, using slicers to slice and dice data and analyze debits, categories, and monthly trends.

Create a personal finance dashboard in Excel by building pivot tables, applying formulas and vlookup, and visualizing category type data with dynamic totals and percentages.

Create a personal finance dashboard in Excel by building visuals with shapes, icons and text boxes, using pivot tables and charts to display income, expenses, investments, and cash in hand.

Create a personal finance dashboard in Excel by building debit and credit category analyses with pivot tables and clustered column charts, linked by slicers on a dashboard sheet.

Enhance an Excel dashboard by adding visuals, slicers, and text boxes with icons for debits, then build pivot tables and charts to analyze subcategories and monthly debits with dynamic updates.

Create an interactive Excel sales dashboard with pivot tables, pivot charts, and formulas to visualize monthly revenue, profit, expenses, and revenue by products, countries, and gender.

Create a dynamic Excel sales dashboard by building pivot tables and visuals to track monthly revenue, profit, and expenses using a 2023 data set.

Create pivot tables showing revenue by country and by products, add clustered bar charts, and format visuals to build a dynamic, polished Excel dashboard.

Create two visuals for revenue by gender and revenue by payment type using pivot tables and stacked column charts, format the charts, and assemble a dashboard in Excel.

Create a dynamic sales dashboard by adding a donut chart for customer satisfaction and a pivot table showing revenue, expenses, profit, and average profit percentage, with vlookup references.

Build a Microsoft Excel sales dashboard by crafting pivot tables, treemap and area charts, and connecting slicers for month, product, sales type, country, payment type, and gender to enable filtering.