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 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 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.

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.

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.

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.

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.

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.

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 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 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 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.

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.

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.