Module 7: End of Module Project 1
Description
Questions covered:
- Tiana Morales is the director of the customer call center for Pierce Software. For the past three months, she has been keeping track of the support calls the center receives, and asks for your help in analyzing the data. Go to the Customer Call Log worksheet, which contains the Calls table where Tiana has been entering support call data. In the Call Type column, she needs to list the type of call corresponding to the code in the Call Code column. In cell E5, enter a formula using the HLOOKUP function to look up the call type according to the call code. Use a structured reference to look up the value in the Call Code column of the Calls table. Retrieve the value in row 2 of the CallTypes table using a structured reference to the entire CallTypes table.
- She wants to calculate the average rating for each call in the Average column. In cell J5, enter a formula using the AVERAGE function and structured references to average the values in the Question 1 to Question 4 columns of the Calls table. Fill the formula into the range J6:J143, if necessary.
- In the range L4:N13, Tiana set up an area to summarize some data about the service representatives handling the customer support calls. First, she wants to count the number of calls each service representative handled. In cell M5, enter a formula using the COUNTIF function and a structured reference to the Service Rep column in the Calls table to count the number of calls Barry (cell L5) handled. Fill the formula into the range M6:M13 without formatting.
- Tiana also wants to average the combined scores for each employee. In cell N5, enter a formula using the AVERAGEIF function and structured references to the Service Rep and Average columns in the Calls table to average the scores Barry (cell L5) received for all the calls he handled. Fill the formula into the range N6:N13 without formatting.
- Go to the Call Type by Rep worksheet. Tiana wants to compare the call data by type for each service rep. In cell A3, insert a PivotTable based on the Calls table. Use RepCalls as the name of the PivotTable. Display the service rep names as column headings, and the call types as both row headings and values.
- Apply Light Yellow, Pivot Style Medium 12 to the PivotTable to coordinate with the table on the Customer Call Log worksheet. Center the data in the range B4:K10 to make it easier to read.
- Tiana notices that Service Rep Bruno has no calls in the How to category, which she knows is incorrect. Return to the Customer Call Log worksheet, and then change the Call Code in cell D10 to 12, which assigns a call to Bruno in the How to category.
- Go to the Scores by Date worksheet. In cell A3, insert another PivotTable based on the Calls table. Use Scores as the name of the PivotTable. Display the Date values as column headings, which automatically groups the data by month. Display the Service Rep names as row headings and the Average score data as values.
- Change the summary function to Average for the data in the Values area and apply the Number number format with 2 decimal places to those values.
- In cell A3, use the text Average Scores to identify the values. In cell B3, use the text Months to identify the column headings. In cell A5, use the text Service Reps to identify the row headings. Apply Light Yellow, Pivot Style Medium 12 to the PivotTable to match the other PivotTable.
- Tiana wants to focus on scores for calls involving technical problems in February. Create a slicer for the Scores PivotTable based on the Call Type field. Resize the slicer to a height of 2.5". Move the slicer so its upper-left corner is in cell F3 and its lower-right corner is in cell G14. Use the slicer to filter the Scores PivotTable by the Tech problem call type.
- Create a timeline slicer based on the Date field in the Scores PivotTable. Resize the timeline slicer to a width of 7". Move the slicer so that its upper-left corner appears within cell A16 and its lower-right corner appears in cell G23. Use the timeline slicer to show data for February only.
- Resize columns B:C to 12.00 and center the data in the range B3:C15.
Support 💖 Buy me a coffee: https://www.buymeacoffee.com/taandar Join Patreon: https://www.patreon.com/Taandar
#cengage #solutions #excel #sam
Disclaimer: Our videos are intended solely for educational purposes, with the goal of assisting students in understanding how to solve problems in various courses. We want to emphasize that any attempt to copy or replicate the solutions shown in these videos may be regarded as a breach of academic integrity policies at your college or university. We strongly recommend that you use these videos as a guide and as a tool to support your learning, but we urge you to complete your assignments independently and refrain from cheating or plagiarism. Please be aware that we are not liable for any consequences resulting from the misuse of these videos in violation of academic integrity policies.
Transcript
1 00:00:03,670 --> 00:00:06,730 [Music]
2 00:00:09,080 --> 00:00:14,340 software and go to the customer called
3 00:00:11,940 --> 00:00:15,719 log worksheet so click here on the
4 00:00:14,340 --> 00:00:19,500 bottom
5 00:00:15,719 --> 00:00:21,779 which contains the call stable so this
6 00:00:19,500 --> 00:00:23,220 must be the call Save Also let's make
7 00:00:21,779 --> 00:00:25,500 sure
8 00:00:23,220 --> 00:00:29,099 travel design so okay so this is the
9 00:00:25,500 --> 00:00:30,720 Constable we can see here table name
10 00:00:29,099 --> 00:00:33,540 and then
11 00:00:30,720 --> 00:00:36,840 to be saying
12 00:00:33,540 --> 00:00:41,460 in call in call type column so in call
13 00:00:36,840 --> 00:00:45,120 type column in cell E5 okay in E5
14 00:00:41,460 --> 00:00:46,680 oops okay including five enter formula
15 00:00:45,120 --> 00:00:48,600 using the answer look of function to
16 00:00:46,680 --> 00:00:53,180 enter any function which will start with
17 00:00:48,600 --> 00:00:56,640 equals to sign and then adds lookup
18 00:00:53,180 --> 00:01:00,860 function to look up the in to look up
19 00:00:56,640 --> 00:01:00,860 the call type according to the call code
20 00:01:07,400 --> 00:01:11,220 value will be
21 00:01:09,840 --> 00:01:14,220 this one
22 00:01:11,220 --> 00:01:18,240 so most people get confused here it is
23 00:01:14,220 --> 00:01:20,159 saying call code call code sorry look up
24 00:01:18,240 --> 00:01:22,439 value in the call code column so much
25 00:01:20,159 --> 00:01:24,060 people select all the column what we
26 00:01:22,439 --> 00:01:26,159 should only select the value it is
27 00:01:24,060 --> 00:01:27,780 saying lookup value so it should be just
28 00:01:26,159 --> 00:01:30,479 one value
29 00:01:27,780 --> 00:01:33,180 and then for the table array it is
30 00:01:30,479 --> 00:01:35,040 saying retrieving the Row 2 so this is
31 00:01:33,180 --> 00:01:37,320 the third third parameter row index
32 00:01:35,040 --> 00:01:39,659 column but before that
33 00:01:37,320 --> 00:01:42,659 where the address
34 00:01:39,659 --> 00:01:45,240 call type stable so Row 2 in the call
35 00:01:42,659 --> 00:01:47,700 types table so called type stable is in
36 00:01:45,240 --> 00:01:49,920 the A3 through F4 of the survey
37 00:01:47,700 --> 00:01:54,540 equations worksheet
38 00:01:49,920 --> 00:01:55,680 so we need to select A3 through F4
39 00:01:54,540 --> 00:01:57,860 okay
40 00:01:55,680 --> 00:02:02,159 so
41 00:01:57,860 --> 00:02:06,119 A3 through F4 call testable and it is
42 00:02:02,159 --> 00:02:08,780 saying in second row so let's close this
43 00:02:06,119 --> 00:02:08,780 and hit enter
44 00:02:14,120 --> 00:02:18,720 reference because it is called type
45 00:02:16,800 --> 00:02:21,660 covers or range of value find and
46 00:02:18,720 --> 00:02:24,060 approximate math so for approximate Mass
47 00:02:21,660 --> 00:02:26,879 we need to add all of the parameter so
48 00:02:24,060 --> 00:02:29,040 just enter through
49 00:02:26,879 --> 00:02:30,959 okay
50 00:02:29,040 --> 00:02:34,200 so it is saying feel the formula to
51 00:02:30,959 --> 00:02:36,360 those Rings it is already filled now
52 00:02:34,200 --> 00:02:38,700 step number two customer can read their
53 00:02:36,360 --> 00:02:41,040 service representative by completing a
54 00:02:38,700 --> 00:02:43,980 four question survey at the end of each
55 00:02:41,040 --> 00:02:46,980 call taina enter these calls his course
56 00:02:43,980 --> 00:02:49,140 in column question one okay question one
57 00:02:46,980 --> 00:02:51,300 two three four of the first level so you
58 00:02:49,140 --> 00:02:53,760 want to calculate the average rating in
59 00:02:51,300 --> 00:02:56,760 cell J5 okay
60 00:02:53,760 --> 00:02:56,760 sign
61 00:02:58,379 --> 00:03:03,540 and then
62 00:03:00,599 --> 00:03:06,060 average function and structure reference
63 00:03:03,540 --> 00:03:08,099 to average the value in question one two
64 00:03:06,060 --> 00:03:11,900 question four columns
65 00:03:08,099 --> 00:03:11,900 of calls table okay
66 00:03:12,239 --> 00:03:16,760 so question one through question four
67 00:03:16,860 --> 00:03:20,459 or close this
68 00:03:18,239 --> 00:03:22,560 and then hit enter
69 00:03:20,459 --> 00:03:24,959 so it is saying fill this range if
70 00:03:22,560 --> 00:03:29,099 necessary it is already filled so let's
71 00:03:24,959 --> 00:03:30,720 go to step three in range L4 through n13
72 00:03:29,099 --> 00:03:33,560 so
73 00:03:30,720 --> 00:03:36,659 yell foreign
74 00:03:33,560 --> 00:03:38,760 area to summarize some data about the
75 00:03:36,659 --> 00:03:40,560 service representative enrolling the
76 00:03:38,760 --> 00:03:44,780 customer first you want to count the
77 00:03:40,560 --> 00:03:44,780 number of each call number of calls
78 00:03:48,739 --> 00:03:53,400 foreignty function
79 00:03:51,000 --> 00:03:54,239 so it starts with equals to sign and
80 00:03:53,400 --> 00:03:57,120 then
81 00:03:54,239 --> 00:03:59,879 count if function so it takes range and
82 00:03:57,120 --> 00:04:02,900 criteria so we should again use the
83 00:03:59,879 --> 00:04:02,900 structured reference
84 00:04:03,480 --> 00:04:07,860 the internal formula and this does the
85 00:04:05,280 --> 00:04:10,620 reference to the service ref column in
86 00:04:07,860 --> 00:04:13,799 the call stable to count the number of
87 00:04:10,620 --> 00:04:16,939 this so we need to reference to service
88 00:04:13,799 --> 00:04:16,939 array column
89 00:04:17,120 --> 00:04:28,020 just select this and then criteria is L5
90 00:04:23,960 --> 00:04:31,080 okay now close this and then enter
91 00:04:28,020 --> 00:04:33,300 now it is saying fill the formula uh
92 00:04:31,080 --> 00:04:36,120 into the range n6 through and thirteen
93 00:04:33,300 --> 00:04:38,400 without formatting so just click on the
94 00:04:36,120 --> 00:04:40,500 corner and then drag it here
95 00:04:38,400 --> 00:04:44,220 so it said without formatting but it
96 00:04:40,500 --> 00:04:47,580 changed the Styles so let's Undo It Ctrl
97 00:04:44,220 --> 00:04:50,639 G and then copy it
98 00:04:47,580 --> 00:04:54,419 and then select it and then right click
99 00:04:50,639 --> 00:04:57,479 and paste formulas okay so step four
100 00:04:54,419 --> 00:05:00,600 Diana also want to average the combined
101 00:04:57,479 --> 00:05:03,900 scores for each employee in cell N5
102 00:05:00,600 --> 00:05:05,580 internal formula okay so N5 you escape
103 00:05:03,900 --> 00:05:09,180 to remove this
104 00:05:05,580 --> 00:05:11,040 uh so N5 internal formula using average
105 00:05:09,180 --> 00:05:14,580 if
106 00:05:11,040 --> 00:05:16,500 so average IF function and standard and
107 00:05:14,580 --> 00:05:18,600 standard reference okay to the service
108 00:05:16,500 --> 00:05:21,120 array and average columns in the call
109 00:05:18,600 --> 00:05:23,340 table to average the score by Alpha
110 00:05:21,120 --> 00:05:27,180 column so range will be
111 00:05:23,340 --> 00:05:30,360 service rape so let's select this range
112 00:05:27,180 --> 00:05:34,800 and then criteria will be L5 and then
113 00:05:30,360 --> 00:05:36,120 average the range will be average column
114 00:05:34,800 --> 00:05:37,919 okay
115 00:05:36,120 --> 00:05:40,139 now
116 00:05:37,919 --> 00:05:42,680 close parenthesis and then hit enter
117 00:05:40,139 --> 00:05:42,680 oops
118 00:05:47,160 --> 00:05:51,259 so this will be actually
119 00:05:52,620 --> 00:05:57,180 let's do it again
120 00:05:54,720 --> 00:05:59,639 so average if and then it is saying
121 00:05:57,180 --> 00:06:01,560 service array column so while selecting
122 00:05:59,639 --> 00:06:04,860 this I might do the mistake you might be
123 00:06:01,560 --> 00:06:08,419 noticing it so service array and then
124 00:06:04,860 --> 00:06:12,479 comma and then criteria is
125 00:06:08,419 --> 00:06:14,000 L5 and then average range is
126 00:06:12,479 --> 00:06:17,100 this one
127 00:06:14,000 --> 00:06:18,600 now close it and then return
128 00:06:17,100 --> 00:06:20,880 so
129 00:06:18,600 --> 00:06:23,819 fill the verbal login without formatting
130 00:06:20,880 --> 00:06:27,600 so copy it and then select these right
131 00:06:23,819 --> 00:06:29,520 click and then paste click formula okay
132 00:06:27,600 --> 00:06:33,180 now it is here
133 00:06:29,520 --> 00:06:34,319 so in step 5 go to call type by rape
134 00:06:33,180 --> 00:06:36,419 worksheet
135 00:06:34,319 --> 00:06:38,940 okay
136 00:06:36,419 --> 00:06:42,000 if
137 00:06:38,940 --> 00:06:44,960 Dinah wants to compare the call data by
138 00:06:42,000 --> 00:06:48,720 type for each service rep in cell A3
139 00:06:44,960 --> 00:06:51,720 okay A3 inside a pivot table based on
140 00:06:48,720 --> 00:06:53,460 the calls table okay so go to insert Tab
141 00:06:51,720 --> 00:06:56,580 and then
142 00:06:53,460 --> 00:06:58,740 here must be pivot table then from table
143 00:06:56,580 --> 00:07:01,400 range
144 00:06:58,740 --> 00:07:01,400 oops
145 00:07:01,860 --> 00:07:06,060 so let's read it first
146 00:07:04,500 --> 00:07:09,479 so
147 00:07:06,060 --> 00:07:12,300 based on calls table
148 00:07:09,479 --> 00:07:15,539 based on Constable good insert click
149 00:07:12,300 --> 00:07:18,600 viewer table front table range
150 00:07:15,539 --> 00:07:21,440 and then call stable is in customer
151 00:07:18,600 --> 00:07:21,440 called law
152 00:07:21,979 --> 00:07:26,220 and then make sure you select this table
153 00:07:25,199 --> 00:07:29,599 okay
154 00:07:26,220 --> 00:07:29,599 now hit OK
155 00:07:29,699 --> 00:07:34,080 after that
156 00:07:31,680 --> 00:07:37,500 it is saying use the rape call as the
157 00:07:34,080 --> 00:07:40,800 name of the pivot table okay so just
158 00:07:37,500 --> 00:07:43,620 copy it and then
159 00:07:40,800 --> 00:07:45,780 click any cell inside pivot table and
160 00:07:43,620 --> 00:07:46,500 then go to Pivot analyze Tab and then
161 00:07:45,780 --> 00:07:49,080 here
162 00:07:46,500 --> 00:07:52,800 just enter rape calls and then hit enter
163 00:07:49,080 --> 00:07:54,720 and here name will be changed
164 00:07:52,800 --> 00:07:57,539 so after that
165 00:07:54,720 --> 00:08:01,560 display the service rate name as column
166 00:07:57,539 --> 00:08:04,020 word heading so service rate so hold it
167 00:08:01,560 --> 00:08:06,479 and drag it in the column section
168 00:08:04,020 --> 00:08:08,880 okay
169 00:08:06,479 --> 00:08:11,580 and then it is saying
170 00:08:08,880 --> 00:08:16,020 and the call type has both row heading
171 00:08:11,580 --> 00:08:17,759 and value so call type and drag it in
172 00:08:16,020 --> 00:08:20,699 row section
173 00:08:17,759 --> 00:08:23,460 and then also in value section
174 00:08:20,699 --> 00:08:26,220 okay so this is done apply light yellow
175 00:08:23,460 --> 00:08:28,319 pivot install medium 12 to the people
176 00:08:26,220 --> 00:08:31,979 table okay
177 00:08:28,319 --> 00:08:34,440 so light yellow puberty style medium 12
178 00:08:31,979 --> 00:08:37,140 so just select on any cell inside pivot
179 00:08:34,440 --> 00:08:41,159 table go to design and then here is our
180 00:08:37,140 --> 00:08:43,140 Styles so light yellow
181 00:08:41,159 --> 00:08:44,880 this is Dan
182 00:08:43,140 --> 00:08:46,940 this helps again
183 00:08:44,880 --> 00:08:49,500 applied I love your business so this is
184 00:08:46,940 --> 00:08:52,200 click here
185 00:08:49,500 --> 00:08:55,320 and then it is saying and center the
186 00:08:52,200 --> 00:08:58,260 data in the range B4 through K10
187 00:08:55,320 --> 00:09:00,000 so B4
188 00:08:58,260 --> 00:09:02,880 through
189 00:09:00,000 --> 00:09:06,120 K10
190 00:09:02,880 --> 00:09:08,040 and then go to Home tab and then here is
191 00:09:06,120 --> 00:09:10,380 the center option in the alignment group
192 00:09:08,040 --> 00:09:14,700 so just click here
193 00:09:10,380 --> 00:09:17,700 okay after that it is saying
194 00:09:14,700 --> 00:09:17,700 in
195 00:09:19,200 --> 00:09:25,040 how to category which she knows in is
196 00:09:22,260 --> 00:09:25,040 incorrect okay
197 00:09:25,080 --> 00:09:29,820 so
198 00:09:26,580 --> 00:09:32,600 here there is the local probably
199 00:09:29,820 --> 00:09:32,600 over here
200 00:09:33,360 --> 00:09:37,279 oh here
201 00:09:34,860 --> 00:09:37,279 yeah
202 00:09:38,880 --> 00:09:43,800 okay
203 00:09:40,680 --> 00:09:46,560 so where are we here go to the call type
204 00:09:43,800 --> 00:09:48,600 by refworks it and refresh the data and
205 00:09:46,560 --> 00:09:51,360 before releasing change the call code in
206 00:09:48,600 --> 00:09:56,220 cell d10 so in the customer call log
207 00:09:51,360 --> 00:09:59,459 worksheet in cell detail
208 00:09:56,220 --> 00:10:02,160 to 12 okay
209 00:09:59,459 --> 00:10:03,540 now go to this tab and then it is saying
210 00:10:02,160 --> 00:10:06,480 refresh
211 00:10:03,540 --> 00:10:09,779 so go to pivot table analyze and here is
212 00:10:06,480 --> 00:10:11,580 the refresh refresh so yeah here value
213 00:10:09,779 --> 00:10:13,980 popped up okay
214 00:10:11,580 --> 00:10:16,920 okay so in this step here it is saying
215 00:10:13,980 --> 00:10:20,820 go to the scores by date worksheet so
216 00:10:16,920 --> 00:10:23,760 okay it scores by date in cell A3 okay a
217 00:10:20,820 --> 00:10:26,040 three insert another pivot a table based
218 00:10:23,760 --> 00:10:27,660 on the course table same thing and use
219 00:10:26,040 --> 00:10:30,360 each course as the name of the viewer
220 00:10:27,660 --> 00:10:32,580 table okay so go to the insert and then
221 00:10:30,360 --> 00:10:36,360 tables pivot tables
222 00:10:32,580 --> 00:10:38,700 and then from the calls table
223 00:10:36,360 --> 00:10:41,519 and then here this is
224 00:10:38,700 --> 00:10:43,560 costable and then hit OK
225 00:10:41,519 --> 00:10:45,959 so it is saying is course as the table
226 00:10:43,560 --> 00:10:48,240 name
227 00:10:45,959 --> 00:10:50,880 so then click on this drop down and then
228 00:10:48,240 --> 00:10:53,279 change this to its course it enter
229 00:10:50,880 --> 00:10:57,000 ing this way the date value as the
230 00:10:53,279 --> 00:11:00,300 column headings so drag it to the column
231 00:10:57,000 --> 00:11:02,459 okay and column heading which
232 00:11:00,300 --> 00:11:04,860 automatically groups the date by month
233 00:11:02,459 --> 00:11:07,740 display the service rate name as row
234 00:11:04,860 --> 00:11:11,519 heading okay service rate name as
235 00:11:07,740 --> 00:11:12,540 row heading and average square data has
236 00:11:11,519 --> 00:11:16,380 value
237 00:11:12,540 --> 00:11:18,540 okay so every score as value
238 00:11:16,380 --> 00:11:21,060 and anything change the summary function
239 00:11:18,540 --> 00:11:22,019 to average for the data and the value
240 00:11:21,060 --> 00:11:24,899 area
241 00:11:22,019 --> 00:11:28,019 so we should change this to
242 00:11:24,899 --> 00:11:32,700 Embrace okay embrace
243 00:11:28,019 --> 00:11:36,180 and then hit OK so after it is saying
244 00:11:32,700 --> 00:11:38,279 and apply number format with two decimal
245 00:11:36,180 --> 00:11:40,260 places okay so again value setting
246 00:11:38,279 --> 00:11:42,779 number format
247 00:11:40,260 --> 00:11:45,120 and then click number and then two
248 00:11:42,779 --> 00:11:47,760 decimal places and then hit OK
249 00:11:45,120 --> 00:11:51,420 and then okay
250 00:11:47,760 --> 00:11:53,820 so in cell A3 use the text average score
251 00:11:51,420 --> 00:11:56,040 so in A3
252 00:11:53,820 --> 00:11:58,620 so average
253 00:11:56,040 --> 00:12:00,060 this course to identify initial B3 use
254 00:11:58,620 --> 00:12:03,440 the text month
255 00:12:00,060 --> 00:12:03,440 so B3
256 00:12:03,660 --> 00:12:12,660 months and then in cell if I use the
257 00:12:06,720 --> 00:12:15,060 text service reps so here A5 and then it
258 00:12:12,660 --> 00:12:19,380 is saying
259 00:12:15,060 --> 00:12:22,200 service reps 25 the routing so apply
260 00:12:19,380 --> 00:12:24,060 light yellow fever distance medium 12 to
261 00:12:22,200 --> 00:12:26,640 the favorable to mass or the Vivo table
262 00:12:24,060 --> 00:12:29,700 so same thing
263 00:12:26,640 --> 00:12:32,160 go to the design tab when you click any
264 00:12:29,700 --> 00:12:35,220 sale inside we go table this this tab
265 00:12:32,160 --> 00:12:37,200 will appear so now this is the these tab
266 00:12:35,220 --> 00:12:39,779 are not there so when you click here
267 00:12:37,200 --> 00:12:42,600 this table app here go to design Tab and
268 00:12:39,779 --> 00:12:45,720 then same thing as you did before so
269 00:12:42,600 --> 00:12:48,260 write down low pivot table install video
270 00:12:45,720 --> 00:12:48,260 okay
271 00:12:48,660 --> 00:12:54,060 and then kind of want to focus on score
272 00:12:51,779 --> 00:12:56,639 for calls involving technical problem
273 00:12:54,060 --> 00:12:58,860 and favorable create a slicer for this
274 00:12:56,639 --> 00:13:02,100 course payment table based on call type
275 00:12:58,860 --> 00:13:05,579 field so again click here and then
276 00:13:02,100 --> 00:13:10,019 insert and then there must be slicer
277 00:13:05,579 --> 00:13:13,260 somewhere that expanded okay slicer and
278 00:13:10,019 --> 00:13:16,139 it was saying call type field
279 00:13:13,260 --> 00:13:19,620 selected and it okay
280 00:13:16,139 --> 00:13:23,100 so after that it is saying resize the
281 00:13:19,620 --> 00:13:26,880 slicer to the height of 2.5 inch
282 00:13:23,100 --> 00:13:29,519 so height of 2.5 inch
283 00:13:26,880 --> 00:13:31,260 oops so this is the height for buttons
284 00:13:29,519 --> 00:13:34,320 so
285 00:13:31,260 --> 00:13:38,899 we need to fix the height of this size
286 00:13:34,320 --> 00:13:38,899 size group so 2.5
287 00:13:39,380 --> 00:13:44,160 and then move the slicer to its uh F3
288 00:13:42,660 --> 00:13:46,940 through G14
289 00:13:44,160 --> 00:13:51,240 so select here and triangle until
290 00:13:46,940 --> 00:13:54,540 F3 through G14
291 00:13:51,240 --> 00:13:56,760 okay let's make sure G14
292 00:13:54,540 --> 00:13:59,160 use the Sizer to filter the score table
293 00:13:56,760 --> 00:14:01,920 by take problem type so just click here
294 00:13:59,160 --> 00:14:03,839 and then this is done as then cleared
295 00:14:01,920 --> 00:14:07,500 our timeline slicer based on the date
296 00:14:03,839 --> 00:14:09,720 field in scores pivot table okay again
297 00:14:07,500 --> 00:14:14,100 go to insert
298 00:14:09,720 --> 00:14:16,920 and then the slicer timeline slicer just
299 00:14:14,100 --> 00:14:18,720 click here interesting by date field so
300 00:14:16,920 --> 00:14:19,920 this is the only field available click
301 00:14:18,720 --> 00:14:21,660 ok
302 00:14:19,920 --> 00:14:24,839 and then
303 00:14:21,660 --> 00:14:26,880 it is saying resize the timeline slicer
304 00:14:24,839 --> 00:14:30,959 to the width of 7 inch
305 00:14:26,880 --> 00:14:32,760 okay so width of seven inch
306 00:14:30,959 --> 00:14:35,420 I'll write
307 00:14:32,760 --> 00:14:39,600 and then it is saying move the slicer
308 00:14:35,420 --> 00:14:41,040 a16 through z23
309 00:14:39,600 --> 00:14:44,540 so
310 00:14:41,040 --> 00:14:44,540 a 16
311 00:14:44,959 --> 00:14:48,959 through z23
312 00:14:49,199 --> 00:14:52,560 thank you
313 00:14:50,399 --> 00:14:55,880 that is 24
314 00:14:52,560 --> 00:14:59,420 make sure they started here
315 00:14:55,880 --> 00:14:59,420 43 okay
316 00:14:59,779 --> 00:15:06,660 now it is saying use the timeline sensor
317 00:15:02,519 --> 00:15:09,480 to show data for February only so just
318 00:15:06,660 --> 00:15:13,440 click oops
319 00:15:09,480 --> 00:15:15,680 here let's create favorable
320 00:15:13,440 --> 00:15:19,380 all right
321 00:15:15,680 --> 00:15:21,720 and then it is saying resize column B to
322 00:15:19,380 --> 00:15:25,199 C to 12 points
323 00:15:21,720 --> 00:15:28,920 so V to C and then right click column
324 00:15:25,199 --> 00:15:31,079 width and then enter 12 and okay and
325 00:15:28,920 --> 00:15:33,260 then Center the data in the range B3
326 00:15:31,079 --> 00:15:36,899 through C15
327 00:15:33,260 --> 00:15:40,019 so B3
328 00:15:36,899 --> 00:15:44,040 through C 15
329 00:15:40,019 --> 00:15:45,480 oops let me maximize it so B3 through
330 00:15:44,040 --> 00:15:50,360 C15
331 00:15:45,480 --> 00:15:50,360 interesting Center the data so Center it
