Excel & Data Visualization, creating impactful dashboards

Apply a three-step methodology for Excel dashboards: clean the database, build the magic pool table from the people table, and create interactive dashboards based on pivot tables.

Customize your Excel dashboard with a personal color palette and consistent color codes, using Adobe Color and Color Hunt for ideas and quick menu bar access.

Analyze a Google Analytics dataset from an e-commerce site, featuring 42 rows and 10 columns, including six numeric columns, to create dashboards with basic and advanced Excel functions.

Download data from Google Analytics, create a custom report, select dimensions and metrics in a flat table, and export an Excel file for the case study.

Format and clean analytics data in Excel by freezing the top row, hiding gridlines, applying a color palette, and adding thousand separators and decimals for clear dashboards.

Master basic Excel functions to create data dimensions from existing data. Extract year, month, day, weekday, and week number, calculate page views per session, and format columns for date-based dashboards.

Learn to clean data by removing duplicates and applying vlookup to map device categories to clear names, then build ready-to-use pivot tables with slicers for dashboards.

Create a pivot table (people table) to automatically organize, summarize, and analyze data; build a bar chart of users by date for an interactive dashboard.

Learn to use slicers with pivot tables to filter a people table, connect a slicer to multiple pivot tables from the same source data, and format slicers for a dashboard.

Create an interactive Excel dashboard with column, stacked column, and 100 percent stacked bar charts to compare users by date and device, add slicers, and finalize a clean, connected visualization.

Create an interactive Excel dashboard using line and area charts to visualize daily users and device‑level trends, with 100 percent stacked charts and slicers for year, week, and country.

Create an interactive Excel dashboard using two pivot tables to power a pie chart of users by day and a donut chart of page views by device, with percentage formatting.

Create and format pie and doughnut charts in Excel, apply a monochromatic color scheme, add data labels and legends, and connect slicers to pivot-table dashboards for interactive visualization.

Use a pivot table to create a combo chart with two axes, showing sessions (line) and transactions (columns) to reveal trends. Build an interactive dashboard with slicers to explore data.

Create an Excel dashboard with a combo chart showing transactions as clustered columns and sessions as a line, using primary and secondary axes.

Learn to build a waterfall chart from a pivot table that highlights continent contributions to turnover for 2019 and 2020, with slicers for an interactive, zoomed view.

Link a waterfall chart to a pivot table; format colors and fonts, set axis display units, adjust data labels to four decimals, and add slicers for device and months.

Create an interactive dashboard by building pivot tables to drive treemap and sunburst charts, displaying hierarchical page views by continent and country with slicers for year and month.

Learn to build an interactive Excel dashboard with treemap and sunburst charts, format data labels, and link slicers to pivot tables for clear, actionable insights.

Compare continents’ turnover over years using radar charts and a color coded pivot table, with baseline zero percent to reveal positive and negative evolution in the dashboard.

Master radar charts in Excel by renaming series, applying colors, and formatting the chart and legend, then build an interactive dashboard with two radar charts and slicers.

Apply a three-step methodology to analyze the French names dataset (INSEE), building an interactive dashboard that explores top names, their evolution, and age distributions with slicers.

Convert a CSV dataset to XLSX or XLSB to access all Excel functions, using UTF-8 with a semicolon delimiter, then transform the data and save as XLSX.

Format the data by renaming the worksheet, applying a personalized color, removing gridlines, clearing formats, and coloring the first row differently from the rest.

Identify and remove useless values in your dataset using Excel filters and selecting visible cells, ensuring hidden rows stay intact. This cleanup improves accuracy for the dashboard and faster analysis.

Learn to enrich data with six new Excel columns using if, left, and len functions to classify gender, extract initials, count characters, and segment ages with nested ifs.

Learn to build pivot tables for an interactive dashboard: analyze top 50 names by births and the evolution of births by year and gender using slicers and top-n filters.

Create an interactive Excel dashboard that ranks births and shows evolution over time using bar and stacked area charts, slicers, and pivot tables.

Explore an interactive dashboard to rank names and trace their evolution over time using slicers, uncovering trends and the impact of filters on popularity.

Create a pivot-table based second dashboard showing age-group births as a percentage and a linked bar chart. Use slicers and pivot formatting for dynamic visuals.

Create a second interactive dashboard by leveraging the pivot table, formatting charts, displaying age group percentages in data labels, and adding slicers while handling missing data with iferror.

Explore how slicers and filters in Excel dashboards reveal insights by age range, with charts showing births by age group and name trends across years.

Analyze a cryptocurrencies dataset from Yahoo Finance using advanced Excel features like conditional formatting and sparklines. Create interactive dashboards that switch among prices and volumes and map codes to names.

Download cryptocurrency data from Yahoo Finance for prices and volumes. Export CSV and use Excel text to columns to split by comma, adding a left column with the file name.

Remove grid lines and freeze the top row, then highlight column titles in yellow and center data with a white border. Differentiate two worksheets with code color for slicers.

Learn to enrich an excel dataset by cleaning data, extracting year and month, and retrieving cryptocurrency names using search, mid, and vlookup for building interactive dashboards.

Analyze the final dashboard to define pivot table needs, then create a pivot table showing monthly volume traded with year-on-year slices, name and color-code the worksheet, and apply conditional formatting.

Master conditional formatting and color scales in Excel to create readable dashboards, link tables to pivot data with the get pivot data formula, and visualize trends with sparklines.

Create another interactive Excel dashboard using conditional formatting and sparklines to visualize monthly trading volume across cryptocurrencies, apply and manage rules, add data bars, and rank totals.

Create a final dashboard using a pivot table to show dynamic metrics by year, month, pricing, and volume, using average pricing and total volume.

Develop a dynamic dashboard by building a three-column data matrix with year, close price, and volume, and enable a dropdown to switch metrics and a variable chart title.