Mellon Training

DOWNLOAD THE PROJECT FILES

Identify different Chart Elements

Deal with Empty and Hidden Cells

Camera Tool

Charts with Tables

Sharing Charts

❓QUIZ 1: Charting Techniques

Introduction

Line Chart: Multiple Lines

Column Chart with Upper and Lower Limits

(NEW 2024) Pies and Doughnuts

(NEW 2024) Area Charts

DEMO: Emphasizing & Mark Significant Events

TreeMap Chart (Office 365 / Excel 2016+)

Histogram Chart (Office 365 / Excel 2016+)

Box and Whisker Chart (Office 365 / Excel 2016+)

Pareto Chart (Office 365 / Excel 2016+)

Sunburst Chart (Office 365 / Excel 2016+)

Waterfall Chart (Office 365 / Excel 2016+)

Funnel Chart (Office 365 / Excel 2016+)

Map Charts based on Geographic Data (Office 365 / Excel 2016+)

Sparklines and Win/Loss Charts

❓QUIZ 2: Mastering Basic Charts

Identifying the Difference between a Formula and a Function

Relative vs Absolute Cell Reference

Commonly Used Functions - SUM, MAX, MIN, and AVERAGE

IF and Nested IF Formulas

Advanced Chart Formatting Options

Advanced Charting Techniques

Advanced Custom Number Formatting

❓QUIZ 3: Essential Functions & Advanced Charting Techniques

Introduction

Trend-based Conditional Formats

Value-based Conditional Formats

Small Multiples

Mini In-Cell Charts (using REPT Function)

Representing trends with Icon Sets, Data Bars and Symbols

Pictograph

Comparisons and Data Bars (with Conditional Formatting)

Heat Map with Color-Scales

Chart Up and Down Arrow Symbols

❓QUIZ 4: Visualizing with Conditional Formatting, Custom Number Formats and Shapes

Introduction

People Graph

Progress Doughnut Chart

Tube Chart

3D Donut Chart

Dynamic Overlay Custom Image Chart

Waffle Charts for KPIs (Better than Pie Charts)

PROJECT: Dynamic Heat Map using Scroll Bar & Formulas