Executive Program in Data Visualization

Explore conditional formatting in Excel, focusing on highlighting cell rules, including greater than and less than, text contains, date occurrences, and duplicate values, with customizable formats.

Apply the top bottom rule under conditional formatting in Excel to highlight top ten, top 10%, bottom ten, and above or below average values.

Learn to apply color scales in conditional formatting to reveal monthly sales patterns across teams, identify max and min months, compare performance, and interpret lack of correlation and seasonality.

Apply data bars in conditional formatting to visualize three-month passive income across channels, customizing min/max values, gradient or solid styles, and color-coded profit and loss for clear comparative presentations.

Learn to visualize dataset completion with icon sets using conditional formatting in Excel, customize red, yellow, and green thresholds, and toggle value visibility for clean dashboards.

Highlight text cells in mixed data using the is text formula and conditional formatting, with a custom rule and font painter for bold white text on a dark fill.

Apply conditional formatting with mixed and absolute references to highlight a selected student's five subject marks using a data validation list, freezing the column and reproducing formatting across rows.

Explore how Excel charts and graphs transform spreadsheet data into intuitive visualizations, distinguishing graphs from charts and using them to identify patterns and trends for informed business decisions.

Develop storytelling with charts by classifying messages into six categories: compare items, compare data over time, relative competition, frequency with histograms, data relationships, and identifying outliers.

Learn five best practices for Excel charts to maximize clarity and impact: remove clutter, choose audience-appropriate themes, place elements logically, use concise text, and clean data before visualization.

Explore the core elements of charts, including chart title, chart area, plot area, grid lines, data labels, cities, legends, categories, and x and y axes.

Show how line charts reveal time-based trends by comparing minutes spent on teaching and research with administrative jobs across May 2020, using markers and formatting to highlight patterns.

Learn to create a pie chart that shows each item’s contribution to the total. The lesson covers inserting the chart, adding data labels, and adjusting fills and legends.

Explore pie of pie and bar of pie charts to highlight small contributions by grouping minor items for clearer visualization.

Learn to create donut charts from pie charts, adjust data labels, and decide when donut charts better visualize multiple contributors than pie of pie or bar of pie charts.

Use bar charts when category text is long and you compare by duration; create from insert tab and sort to align with table, revealing societies with most and fewest flags.

Master cluster bar charts to compare multiple series across categories, visualizing 2018 and 2019 sales for high-rise buildings and drawing insights from chart design and formatting options.

Explore column charts, the same as bar charts, and learn to create column clusters to compare teaching, research, and administrative time across four weeks.

Learn to use column stack charts to show each product's contribution to total sales across years, with data labels and 100% stacked charts.

Learn to use column 100% stacked charts to compare category percentages of the total and how those contributions change over time, with data labels for clarity.

Learn how area charts fill the space under a line chart to illustrate supply and demand for products, with transparency, stacked area options, and data labels for dashboard clarity.

Explore how combo charts fuse two chart types on separate axes to compare sales targets and achievements, offering a clearer visualization than cluster column charts.

Learn how histograms differ from column charts and how to create an Excel histogram with bins and data labels, then explore the Pareto (potato) chart and cumulative frequency.

Explore how to create a tree map to visualize hierarchical data with nested rectangles, where area is sized by sales and product categories, types, and sales form the branches.

Explore heat maps that format data tables with conditional colors to reveal patterns in product sales across days, using color scales and hiding values for clarity.

Create pivot charts from sales data to visualize trends using line charts with markers, apply year and month filters, and add slicers for dynamic dashboards.

Analyze product sales contributions using pivot charts and pivot tables, display percentage of grand total with data labels, and explore dashboard-ready insights across products and salespeople.

Explore pivot pie of pie charts to compare customer contributions across regions and months, using pie charts, adjustable size and weight, and slicers to filter by customers and month.

Demonstrates bar of pie chart, where small contributors are clubbed into one category to reveal significant entries; shows how to create, customize, and use pivot chart for dashboards.

Explore creating a pivot donut chart from region-wise sales data, showing column-total percentages. Adjust size, color, borders, and slice angle for a clean, engaging visualization.

Analyze a pivot column stacked chart of eight salespeople and four products to reveal 100% achievement contributions and territory focus.

Learn to visualize sales target versus achievement with cluster bar charts for four products across two years, using pivot charts and slicers to compare performance and salesperson results in dashboards.

Visualize monthly sales versus targets across two years (18 and 19) using area charts and pivot charts, with slicers for product, sales person, and product types.

Explore a combo line column chart and a pivot chart to visualize target versus achievement for salespeople, using secondary axes, slicers, and dynamic dashboards.

Develop a dynamic sales dashboard with five charts - monthly sales, region Y sales, sales trend, customer wise sales, and sales person performance - adjustable by year.

Design a five-chart sales dashboard with a line chart, bar of pie chart, donut chart, tagged column chart, and area chart to visualize sales by month, customer, region, and person.

Build a dynamic sales dashboard in Excel by linking pivot charts with slicers for year, salesperson, region, customer, and product, then connect slicers via report connections for synchronized filtering.

Learn to summarize large data sets with pivot tables in Excel, analyzing sales by product, salesperson, region, and time (year, month, quarter) using rows, columns, values, and filters.

Learn to use value fields in pivot tables to compute sums, averages, and percentage of grand totals for sales across years and product categories.

Learn to refresh data in pivot tables by updating the source and using refresh options on the table or in analyze, ensuring the pivot reflects current employees and sales figures.

Change the data source in a pivot table when new records are added to the parent table, using the change data source function and refreshing to reflect updates.

Create and customize pivot tables to group dates by month or quarter. Select ranges, generate new worksheets, and use grouping for summing sales.

Explore the timeline function for pivot tables to filter sales by date. Ensure your dataset has date columns to use timeline and compare sales by salesperson and product across months.

Learn to create a pivot table and add slicers to filter region-wise sales by year and salesperson for instant, dashboard-ready insights. Use clear filters and slicer formatting to tailor dashboards.