KPI BOARD

This is a free version of the "KPI Dashboard

Spreadsheet." To download the complete resource,
join You Exec Plus, and gain access to our entire
library of spreadsheet models and business
resources and receive new ones each week.

Start today

SYNOPSIS
How do you analyze and report your top KPI metrics? Use the KPI Board to
input up to a million rows of raw data. Then filter a subset to view and the
board automatically generate premade charts to visualize the data for reports
and analysis. This could be sales data, bug or issues data, a project do list,
features to implement, or even stock market analysis. Rename and
customize up to two date ranges, two numeric values, and five drop-down
values to filter and compare against each other. Then create beautiful KPI
charts for analysis and reports.

EXPLAINER

Watch video
We value your input. If you have any comments,
questions, or suggestions on how to improve this
business resource please let us know.

Feedback

Errors and omissions liability (E&O): You Exec LLC makes no guarantee that the formulas, models, analysis, financial projections,
estimates, graphs, reports, numbers, and any derivatives sourcing from this model are free of errors and omissions. Our financial
modelers have audited this model to the best of their capabilities, yet You Exec LLC assumes no liability for erroneous outcomes derived
from this financial model.

Copyright © You Exec LLC. All rights reserved.

TABLE OF CONTENTS

Sheet 1 Cover

Sheet 2 Table of Contents

Sheet 3 Inputs

Sheet 4 Dropdowns

Sheet 5 Raw Data

Sheet 6 Filter

Sheet 7 Dashboard
Sheet 8 Analysis (Hidden)

Sheet 9 Benefits

COLOR KEY
Types Example Description
User inputs $3,400 Inputs to the model
Calculations $3,400 When a formula is used
Results
Good results $3,400 Favorable outcomes
Bad results $3,400 Unfavorable outcomes
INPUTS
Corporate Overview

CUSTOMIZABLE FIELDS NOTES

STATIC INPUTS VALIDATED

Report name Corporate Overview ✘

Start year 2020

Company name You Exec ✘

Event Tracked Ads Spent ✘

The noun to help explain what data you will a

DATE FIELDS
"Date 1" name Date Sold Enter the first range of dates you want to ass
✘

From range from

To range to

"Date 2" name Date Closed Enter the

From range from
To range to

NUMERIC FIELDS
"Numeric 1" name Total Sales Enter the first numeric field you want to asse
From range from
To range to

Numeric 2 name Total Profit

✘

From range from Enter the second numeric field you want to a
To range to
DROPDOWN FIELDS
Dropdown 1 Website Enter the three miscellaneous dropdown field
Dropdown 2 Platform
Dropdown 3 Products
NOTES

The noun to help explain what data you will assess. For example: "sales" or "births" or "deliveries"

Enter the first range of dates you want to assess. For example: "Puchase date" or "issue date" or "order placed"

Enter the second range of dates you want to assess. For example: "Close date" or "issue resolved" or "order received"

Enter the first numeric field you want to assess. For example: "Buying price" or "estimated labor" or "order price"

Enter the second numeric field you want to assess. For example: "Sale price" or "labor costs" or "delivery costs"
Enter the three miscellaneous dropdown fields you want to assess. For example: "Continent" or "Region" or "Salesperson"
DROPDOWNS
Corporate Overview

DROPDOWN VALUES NOTES

Website Platform Products The five dropdown fields and their values to be used in the
All Website All Platform All Products
Google Ads Google Grocery
FB Ads DuckDuckGO Beverages
LinkedIn Ads Yahoo Wines
Bags
Fruits
their values to be used in the "Raw Data" and "Filter" tabs
Marketing (start year)

Operations (start year)

RAW DATA
Corporate Overview
ADS SPENT DATA FOR YOU EXEC

Date Sold Date Closed Total Sales Total Profit Website

08/14/2020 11/22/2022 $90 $35 FB Ads
08/15/2020 11/23/2022 $45 $33 FB Ads
08/16/2020 11/24/2022 $60 $29 FB Ads
08/17/2020 11/25/2022 $60 $27 FB Ads
08/18/2020 11/26/2022 $45 $24 FB Ads
08/19/2020 11/27/2022 $15 $22 FB Ads
08/20/2020 11/28/2022 $90 $25 FB Ads
08/21/2020 11/29/2022 $45 $20 FB Ads
08/22/2020 11/30/2022 $60 $22 FB Ads
08/23/2020 12/01/2022 $60 $23 FB Ads
08/24/2020 12/02/2022 $45 $26 FB Ads
08/25/2020 12/03/2022 $15 $15 FB Ads
08/26/2020 12/04/2022 $90 $22 FB Ads
08/27/2020 12/05/2022 $45 $19 FB Ads
08/28/2020 12/06/2022 $90 $22 FB Ads
08/29/2020 12/07/2022 $45 $15 FB Ads
08/30/2020 12/08/2022 $45 $22 FB Ads
08/31/2020 12/09/2022 $30 $19 FB Ads
09/01/2020 12/10/2022 $45 $22 FB Ads
09/02/2020 12/11/2022 $60 $15 FB Ads
09/03/2020 12/12/2022 $15 $22 FB Ads
09/04/2020 12/13/2022 $90 $18 FB Ads
09/05/2020 12/14/2022 $60 $16 FB Ads
09/06/2020 12/15/2022 $45 $17 FB Ads
09/07/2020 12/16/2022 $15 $24 FB Ads
09/08/2020 12/17/2022 $45 $26 FB Ads
09/09/2020 12/18/2022 $15 $15 FB Ads
09/10/2020 12/19/2022 $30 $22 FB Ads
09/11/2020 12/20/2022 $45 $18 FB Ads
09/12/2020 12/21/2022 $15 $16 FB Ads
09/13/2020 12/22/2022 $45 $17 FB Ads
09/14/2020 12/23/2022 $15 $24 FB Ads
09/15/2020 12/24/2022 $30 $26 FB Ads
09/16/2020 12/25/2022 $45 $19 FB Ads
09/17/2020 12/26/2022 $15 $18 FB Ads
09/18/2020 12/27/2022 $45 $19 FB Ads
09/19/2020 12/28/2022 $15 $22 FB Ads
09/20/2020 12/29/2022 $30 $23 FB Ads
09/21/2020 12/30/2022 $30 $15 FB Ads
09/22/2020 12/31/2022 $30 $17 FB Ads
09/23/2020 01/01/2023 $45 $24 FB Ads
09/24/2020 01/02/2023 $45 $22 FB Ads
09/25/2020 01/03/2023 $30 $26 FB Ads
09/26/2020 01/04/2023 $60 $22 FB Ads
09/27/2020 01/05/2023 $90 $20 FB Ads
09/28/2020 01/06/2023 $45 $19 FB Ads
09/29/2020 01/07/2023 $45 $17 FB Ads
09/30/2020 01/08/2023 $30 $17 FB Ads
10/01/2020 01/09/2023 $60 $24 FB Ads
10/02/2020 01/10/2023 $90 $22 FB Ads
10/03/2020 01/11/2023 $45 $26 FB Ads
10/04/2020 01/12/2023 $45 $22 FB Ads
10/05/2020 01/13/2023 $30 $20 FB Ads
10/06/2020 01/14/2023 $60 $19 FB Ads
10/07/2020 01/15/2023 $90 $17 FB Ads
10/08/2020 01/16/2023 $45 $19 FB Ads
10/09/2020 01/17/2023 $45 $24 FB Ads
10/10/2020 01/18/2023 $30 $22 FB Ads
10/11/2020 01/19/2023 $60 $26 FB Ads
10/12/2020 01/20/2023 $90 $22 FB Ads
10/13/2020 01/21/2023 $15 $17 FB Ads
10/14/2020 01/22/2023 $120 $19 FB Ads
10/15/2020 01/23/2023 $15 $27 FB Ads
10/16/2020 01/24/2023 $30 $22 FB Ads
10/17/2020 01/25/2023 $45 $29 FB Ads
10/18/2020 01/26/2023 $15 $30 FB Ads
10/19/2020 01/27/2023 $120 $32 FB Ads
10/20/2020 01/28/2023 $15 $31 FB Ads
10/21/2020 01/29/2023 $40 $15 FB Ads
10/22/2020 01/30/2023 $45 $17 FB Ads
10/23/2020 01/31/2023 $100 $18 FB Ads
10/24/2020 02/01/2023 $120 $13 FB Ads
10/25/2020 02/02/2023 $90 $19 FB Ads
10/26/2020 02/03/2023 $30 $13 FB Ads
10/27/2020 02/04/2023 $45 $14 FB Ads
10/28/2020 02/05/2023 $15 $19 FB Ads
10/29/2020 02/06/2023 $45 $15 FB Ads
10/30/2020 02/07/2023 $100 $18 FB Ads
10/31/2020 02/08/2023 $120 $21 FB Ads
11/01/2020 02/09/2023 $90 $15 FB Ads
11/02/2020 02/10/2023 $30 $16 FB Ads
11/03/2020 02/11/2023 $45 $16 FB Ads
11/04/2020 02/12/2023 $15 $17 FB Ads
11/05/2020 02/13/2023 $45 $16 FB Ads
11/06/2020 02/14/2023 $100 $17 FB Ads
11/07/2020 02/15/2023 $120 $13 FB Ads
11/08/2020 02/16/2023 $90 $22 FB Ads
11/09/2020 02/17/2023 $30 $19 FB Ads
11/10/2020 02/18/2023 $45 $18 FB Ads
11/11/2020 02/19/2023 $15 $18 FB Ads
11/12/2020 02/20/2023 $120 $19 FB Ads
11/13/2020 02/21/2023 $15 $27 FB Ads
11/14/2020 02/22/2023 $30 $22 FB Ads
11/15/2020 02/23/2023 $45 $29 FB Ads
11/16/2020 02/24/2023 $15 $30 FB Ads
11/17/2020 02/25/2023 $120 $32 FB Ads
11/18/2020 02/26/2023 $15 $31 FB Ads
11/19/2020 02/27/2023 $40 $15 FB Ads
11/20/2020 02/28/2023 $45 $17 FB Ads
11/21/2020 03/01/2023 $120 $19 FB Ads
11/22/2020 03/02/2023 $15 $27 FB Ads
11/23/2020 03/03/2023 $30 $22 FB Ads
11/24/2020 03/04/2023 $45 $29 FB Ads
11/25/2020 03/05/2023 $15 $30 FB Ads
11/26/2020 03/06/2023 $120 $32 FB Ads
11/27/2020 03/07/2023 $15 $31 FB Ads
11/08/2020 02/16/2023 $90 $22 FB Ads
11/09/2020 02/17/2023 $30 $19 FB Ads
11/10/2020 02/18/2023 $45 $18 FB Ads
 NOTES

Platform Products Copy and paste user data here

Yahoo Fruits
Yahoo Fruits
Yahoo Fruits
Yahoo Fruits
Yahoo Fruits
Yahoo Fruits *When adding new data to your initial data set, go to the last cell in COL L
Yahoo Fruits *After new data is added, always press REFRESH ALL on DATA tab unde
Yahoo Fruits
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Grocery
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Google Beverages
Google Beverages
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Bags
Google Bags
Google Fruits
Google Fruits
Google Fruits
Google Fruits
Google Fruits
Google Fruits
Google Fruits
Google Fruits
Google Fruits
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Grocery
Google Beverages
Google Beverages
Google Beverages
Google Beverages
Google Beverages
 Google Beverages
Google Beverages
Google Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Yahoo Beverages
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
Google Wines
DuckDuckGO Wines
Google Beverages
Google Beverages
Google Beverages
ata set, go to the last cell in COL L and hit TAB, then paste the additional data
EFRESH ALL on DATA tab under QUERIES & CONNECTIONS
Purchase date Close date
Buying price Selling price Continent Region Salesperson Status Department
FILTER
Corporate Overview
FILTER INPUTS

DATES from to
Date Sold between 01/01/2020 and 01/02/2025

and

from to
Date Closed between 01/01/2020 and 01/02/2025

NUMERICS from to
Total Sales between $1.00 and $50,000,000.00

and

from to
Total Profit between $1.00 and $500,000,000.00

SLICER FIELDS

This shape represents a slicer. This shape represents a slicer. This shape represents a slicer.
Slicers are supported in Excel Slicers are supported in Excel Slicers are supported in Excel
2010 or later. 2010 or later. 2010 or later.

If the shape was modified in If the shape was modified in If the shape was modified in
an earlier version of Excel, or an earlier version of Excel, or an earlier version of Excel, or
if the workbook was saved in if the workbook was saved in if the workbook was saved in
Excel 2003 or earlier, the Excel 2003 or earlier, the Excel 2003 or earlier, the
slicer cannot be used. slicer cannot be used. slicer cannot be used.
 This shape represents a slicer. This shape represents a slicer. This shape represents a slicer.
Slicers are supported in Excel Slicers are supported in Excel Slicers are supported in Excel
2010 or later. 2010 or later. 2010 or later.

If the shape was modified in If the shape was modified in If the shape was modified in
an earlier version of Excel, or an earlier version of Excel, or an earlier version of Excel, or
if the workbook was saved in if the workbook was saved in if the workbook was saved in
Excel 2003 or earlier, the Excel 2003 or earlier, the Excel 2003 or earlier, the
slicer cannot be used. slicer cannot be used. slicer cannot be used.

FILTER RESULTS

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
NOTES

Enter the range you want to filter and alayze for the two date fields

Enter the range you want to filter and analyze from the first numeric field

Enter the range you want to fileter and analyze from the second numeric field

Select the dropdown fields you want to filter

Your filter results appear here
DASHBOARD
Corporate Overview

DATE SOLD

Count of "Ads Spent" per "Date Sold"

From "Jan 2020" to "Jan 2025"

12

10

0
Total Result
DATE CLOSED

Count of "Ads Spent" per "Date Closed"

From "Jan 2020" to "Jan 2025"

12

10

0
Total Result

DROPDOWN FIELDS

Count of "Ads Spent" per "Products"

 Total Result #NAME?
50% 50%

Count of "Ads Spent" per "Website" Count of "Ads Spent" per

#NAME?
100%

Total Result
50%
TOTAL SALES

Sum of "Total Sales" per "Products"

From "1" to "50,000,000"

$12

$10

$8

$6

$4

$2

$0
(empty) #NAME? Total Result

Sum of "Total Sales" per "Website" Sum of "Total Sales" per "Pl
From "1" to "50,000,000" From "1" to "50,000,000"
 $12 $12

$10 $10

$8 $8

$6 $6

$4 $4

$2 $2

$0 $0
(empty) #NAME? (empty)

TOTAL PROFIT

Sum of "Total Profit" per "Products"

From "1" to "500,000,000"

$12

$10

$8

$6

$4
 $8

$6

$4

$2

$0
(empty) #NAME? Total Result

Sum of "Total Profit" per "Website" Sum of "Total Profit" per "Pla
From "1" to "500,000,000" From "1" to "500,000,000"
$12 $12

$10 $10

$8 $8

$6 $6

$4 $4

$2 $2

$0 $0
(empty) #NAME? (empty)
NOTES

Counts the data that appears in

Counts the data that appears in

This section counts the number

 #NAME?
50%

unt of "Ads Spent" per "Platform"

Total Result
50%

#NAME?
50%
 This section sums the total of n

Add columns as you need spac

m of "Total Sales" per "Platform"

m "1" to "50,000,000"
12

10

$8

$6

$4

$2

$0
(empty) #NAME? Total Result

This section sums the total of n

 Add columns as you need spac

m of "Total Profit" per "Platform"

m "1" to "500,000,000"
$12

$10

$8

$6

$4

$2

$0
(empty) #NAME? Total Result
nts the data that appears in your filter per the first date range field
nts the data that appears in your filter per the second date range field

section counts the number of occurences of each dropdown in your filter

section sums the total of numeric range 1 per each dropdown value according to your filter

columns as you need space for additional values

section sums the total of numeric range 2 per each dropdown value according to your filter
columns as you need space for additional values
BENEFITS

Below are all the benefits included in the complete

version of this spreadsheet. Join today and access
our entire library of business resources.
Start today

Free version contains only three

dropdowns, but the paid version includes
all five dropdowns.
These additional dropdown fields provide
a wider range of inputs to assess for
deeper analysis.

With additional fields, you can include

more values from your raw data to
analyze.

The complete version provides additional

charts and graphs to analyze these
dropdowns in the Dashboard tab.
The complete Dashboard provides
additional charts to analyze the number
of "Numeric1" and "Numeric2" values
that occur in the "Date1" range of your
filter.

Additional charts are provided to sum the

number of "Numeric1" and "Numeric2"
occurences in the "Date2" range of your
filter.

Additional "Numeric1" charts analyze the

sum total of "Dropdown4" and
"Dropdown5" occurences in your filter.
The same calculations are provided for
"Numeric2" values so you can track and
compare how five separate categories of
data stack up against each other.

Gain all these benefits when you join today... Get spreadsheet

Errors and omissions liability (E&O): You Exec LLC makes no guarantee that the formulas, models, analysis, financial projections,
estimates, graphs, reports, numbers, and any derivatives sourcing from this model are free of errors and omissions. Our financial
modelers have audited this model to the best of their capabilities, yet You Exec LLC assumes no liability for erroneous outcomes derived
from this financial model.

Copyright © You Exec LLC. All rights reserved.