This shape represents TechDelta Nig.
Ltd
a slicer. Slicers are
supported in Excel
2010 or later.
Total Sales Total Units
If the shape was
modified in an earlier $1,388 Sold173
version of Excel, or if
the workbook was
saved in Excel 2003 or Sales by Product
earlier, the slicer
cannot be used. $686.95
$449.10
$251.72
This shape represents
Dell Lenovo HP
a slicer. Slicers are
supported in Excel
2010 or later.
If the shape was Total
modified in an earlier 2014 2015
version of Excel, or if
the workbook was
saved in Excel 2003
or earlier, the slicer
This shape represents
cannot be used.
50% 50%
a slicer. Slicers are
supported in Excel
2010 or later.
If the shape was
modified in an earlier
version of Excel, or if
the workbook was
saved in Excel 2003
or earlier, the slicer
cannot be used.
>>> White Dashboard Sales Dashboard: 2014 / 2015
nits Avg Amt Spent No. of Staff Type of Items
3 $462.59 1
Sales by Branch Sales by Weekday
$0.00
0
$0.00
0
$0.00
0
Woji
$0.00
0
Tuesday $686.95
Wednesday $449.10
$1,387.77 Sunday $251.72
Total Sales by Manager by Branch
George
Column Labels Woji
4 / 2015
e of Items
3
This shape represents a
slicer. Slicers are Total Sales Amt Spent Units Sold
supported in Excel 2010 or
later.
$1,388 $462.59 173
If the shape was modified
in an earlier version of
Excel, or if the workbook Sales by Product
This shape in
was saved represents a
Excel 2003
slicer. Slicers are
or earlier, the slicer cannot $686.95
supported
be used. in Excel 2010 or
later.
If the shape was modified $449.10
in an earlier version of
Excel, or if the workbook $251.72
was saved in Excel 2003
or earlier, the slicer cannot
be used.
This shape represents a
slicer. Slicers are supported Dell Lenovo HP
in Excel 2010 or later.
If the shape was modified Sales by Each Rep
in an earlier version of
Excel, or if the workbook
was saved in Excel 2003 or
earlier, the slicer cannot be
used.
George
Units Sold
TECHPH Sales Dashboard, 2014/2015
173 >>> Dark Dashboard
Sales by Branch Sales by Weekday
Tuesday $686.95
Woji
Wednesday $449.10
Sunday $251.72
Branch Managers
Sales per Year
Column Labels Woji
George
/2015
$686.95
9.10
Sales per Year
2014
2015
Row Labels Sum of Amount
Dell $686.95
Lenovo $449.10
HP $251.72
Sales by Product
$686.95
$449.10
$251.72
Dell Lenovo HP
t
$251.72
HP
Row Labels Sum of Amount
Woji $1,387.77 Lagos $1,387.77
PH $0.00
Abuja $0.00
Sales by Branch
Woji
Woji
Row Labels Sum of Amount
George $1,387.77 Sales by Each Rep
George $1,387.77
$1,387.77
Row Labels Sum of Amount $858.69
Sunday $251.72 Sunday $251.72 $606.97
Wednesday $449.10 Wednesda $449.10 $409.59
Tuesday $686.95 Tuesday $686.95 $171.74
$0.00 $0.00 $858.69
$0.00 $0.00 $858.69
$0.00 $0.00 $858.69
$0.00 $0.00 $858.69
Sales by Weekday
Tuesday $686.95
Wednesday $449.10
Sunday $251.72
Chart Title
$0.00
0
$0.00
0
$0.00
0
$0.00
0
Tuesday $686.95
Wednesday $449.10
Sunday $251.72
Sum of Amount Column Labels
Row Labels Woji
George $1,387.77
George
Woji
Column Labels Woji
George
Sum of Amount Average of Amount2 Sum of Units Distinct Count of Rep Distinct Count of Item
$1,387.77 $462.59 173 1 3
$1,388 $462.59 173 1 3
Row Labels Sum of Amount Sum of Amount2 $876.03
2014 $700.82 50% 2014 $700.82 $175.21
2015 $686.95 50% 2015 $686.95 $189.08
-$13.87 -2% 2014
Tot
Row Labels Sum of Amount
2014
Qtr2
Jun $449.10
Qtr4
Oct $251.72
2015
Qtr3
Jul $686.95
Grand Total $1,387.77
2014 Qtr2 Jun Qtr4 Oct
Sales per Year
2015
Total
Sales per Year
20
20
Qtr2 Jun Qtr4 Oct 2015 Qtr3 Jul Grand Total
Sales per Year
2014
2015
Sales per Year
2014
2015
Date Region Rep Item Units Price Day Name Amount Index
9/1/2014 Woji Chinedu Apple 2 125 Monday 250 1
6/17/2015 Woji Emeka Apple 5 125 Wednesday 625 2
9/10/2015 Woji Ibrahim Lenovo 7 1.29 Thursday 9.03 3
11/17/2015 Woji Tolu HP 11 4.99 Tuesday 54.89 4
10/31/2015 Woji Tonye Lenovo 14 1.29 Saturday 18.06 5
2/26/2014 Woji Ibrahim Compaq 27 19.99 Wednesday 539.73 6
10/5/2014 Woji George HP 28 8.99 Sunday 251.72 7
12/21/2015 Woji Tonye HP 28 4.99 Monday 139.72 8
2/9/2014 Woji Tolu Lenovo 36 4.99 Sunday 179.64 9
8/7/2015 Woji Emeka Dell 42 23.95 Friday 1005.9 10
1/15/2015 Woji Ibrahim HP 46 8.99 Thursday 413.54 11
1/23/2014 Woji Emeka HP 50 19.99 Thursday 999.5 12
3/24/2015 Woji Tolu Dell 50 4.99 Tuesday 249.5 13
5/14/2015 Woji Ibrahim Lenovo 53 1.29 Thursday 68.37 14
7/21/2015 Woji George Dell 55 12.49 Tuesday 686.95 15
4/10/2015 Woji Tonye Lenovo 66 1.99 Friday 131.34 16
12/12/2014 Woji Chinedu Lenovo 67 1.29 Friday 86.43 17
4/18/2014 Woji Tonye Lenovo 75 1.99 Friday 149.25 18
5/31/2015 Woji Ibrahim HP 80 8.99 Sunday 719.2 19
2/1/2015 Woji Chinedu HP 87 15 Sunday 1305 20
5/5/2014 Woji Tolu Lenovo 90 4.99 Monday 449.1 21
6/25/2014 Woji George Lenovo 90 4.99 Wednesday 449.1 22
12/4/2015 Woji Tolu HP 94 19.99 Friday 1879.06 23
11/25/2014 Woji Emeka Dell 96 4.99 Tuesday 479.04 24
2/18/2015 GRA Blessing HP 4 4.99 Wednesday 19.96 25
11/8/2014 GRA Chioma Compaq 15 19.99 Saturday 299.85 26
9/18/2014 GRA Blessing Dell 16 15.99 Thursday 255.84 27
7/12/2014 GRA Torbari HP 29 1.99 Saturday 57.71 28
8/15/2014 GRA Blessing Lenovo 35 4.99 Friday 174.65 29
4/1/2014 GRA Blessing HP 60 4.99 Tuesday 299.4 30
6/8/2014 GRA Blessing HP 60 8.99 Sunday 539.4 31
7/4/2015 GRA Blessing Dell 62 4.99 Saturday 309.38 32
10/22/2014 GRA Blessing Compaq 64 8.99 Wednesday 575.36 33
12/29/2014 GRA Chioma Dell 74 15.99 Monday 1183.26 34
7/29/2014 GRA Chioma HP 81 19.99 Tuesday 1619.19 35
1/6/2014 GRA Blessing Lenovo 95 1.99 Monday 189.05 36
4/27/2015 GRA Torbari Compaq 96 4.99 Monday 479.04 37
8/24/2015 Town Uche Apple 3 275 Monday 825 38
3/7/2015 Town Uche HP 7 19.99 Saturday 139.93 39
5/22/2014 Town Tunde Lenovo 32 1.99 Thursday 63.68 40
3/15/2014 Town Uche Lenovo 56 2.99 Saturday 167.44 41
10/14/2015 Town Tunde HP 57 19.99 Wednesday 1139.43 42
9/27/2015 Town Uche Compaq 76 1.99 Sunday 151.24 43