Module 6 - End of Module Project 1 #part3
Description
Topics covered in the video: 9. Padma asks you to make it easy to filter the table based on the contractor's specialty and starting year. Insert two slicers, one based on the Specialty field and the other based on the Start Year field. 10. Resize both slicers to a height of 2.2" and a width of 1.5". Move the Specialty slicer so its upper-left corner is in cell I4 and its lower-right corner is in cell I14. Move the Start Year slicer so its upper-left corner is in cell J4 and its lower-right corner is in cell J14. 11. Use the slicers to filter the Contractors table to show contractors who started in 2021 or 2022 with specialties of Electronics and Movies and music. 12. Since Padma is using slicers to filter the data, hide the filter buttons in the Contractors table.
#sam #spreadsheet #excel Buy us a coffee: https://www.buymeacoffee.com/taandar ---
Disclaimer: This video is intended for educational purposes only. The purpose of this video is to help students understand how to solve problems in the Cengage business spreadsheet course. However, please note that any attempt to copy or replicate the solutions shown in this video may be considered a violation of academic integrity policies at your college or university. We strongly encourage you to use this video as a guide and to complete the assignments on your own, without resorting to cheating or plagiarism. We are not responsible for any consequences that may result from the use of this video in violation of academic integrity policies.
Transcript
1 00:00:00,000 --> 00:00:04,259 so continuing from the slicer part
2 00:00:02,100 --> 00:00:06,720 question number nine it is saying Palma
3 00:00:04,259 --> 00:00:08,400 ask you to make it easy to filter the
4 00:00:06,720 --> 00:00:11,519 table based on the contractor's
5 00:00:08,400 --> 00:00:14,160 specialty and starting here insert two
6 00:00:11,519 --> 00:00:17,100 slices one based on specialty field and
7 00:00:14,160 --> 00:00:19,199 another based on study are field so to
8 00:00:17,100 --> 00:00:22,140 install slicer click on any cell inside
9 00:00:19,199 --> 00:00:24,000 the table and table design to tab will
10 00:00:22,140 --> 00:00:26,519 appear just click here and then click on
11 00:00:24,000 --> 00:00:30,300 insert slicer and one is based on
12 00:00:26,519 --> 00:00:33,239 specialty hit OK and then again click on
13 00:00:30,300 --> 00:00:37,079 any cell of the table and then it's a
14 00:00:33,239 --> 00:00:40,379 slicer another is start here then hit OK
15 00:00:37,079 --> 00:00:41,899 so they are stacked just like this
16 00:00:40,379 --> 00:00:44,820 now
17 00:00:41,899 --> 00:00:47,640 resize the both slicer to a height of
18 00:00:44,820 --> 00:00:50,420 2.2 and width of 1.5
19 00:00:47,640 --> 00:00:50,420 so
20 00:00:51,180 --> 00:00:56,340 here is the in the size group 2.2 oops
21 00:00:55,079 --> 00:00:59,520 2.2
22 00:00:56,340 --> 00:01:01,800 and then 1.5
23 00:00:59,520 --> 00:01:02,810 so same for this
24 00:01:01,800 --> 00:01:04,019 2.2
25 00:01:02,810 --> 00:01:05,280 [Music]
26 00:01:04,019 --> 00:01:07,439 oops
27 00:01:05,280 --> 00:01:10,439 2.2
28 00:01:07,439 --> 00:01:10,439 1.5
29 00:01:11,040 --> 00:01:17,159 all right and now it is saying uh
30 00:01:13,560 --> 00:01:19,560 special ID slicer so the upper left
31 00:01:17,159 --> 00:01:22,500 corner is I4 and lower right corner is
32 00:01:19,560 --> 00:01:25,939 i14 and then start your slicer upper
33 00:01:22,500 --> 00:01:30,060 left is j4 and j14 so especially
34 00:01:25,939 --> 00:01:32,220 specialty is I4 and i14
35 00:01:30,060 --> 00:01:35,579 so let's move it
36 00:01:32,220 --> 00:01:39,020 uh where is I4 I4
37 00:01:35,579 --> 00:01:39,020 so here is the I4
38 00:01:40,740 --> 00:01:47,759 okay and for this it is saying j4
39 00:01:44,759 --> 00:01:47,759 2014
40 00:01:49,259 --> 00:01:51,860 all right
41 00:01:53,220 --> 00:01:57,000 now
42 00:01:54,659 --> 00:01:59,340 uh use the slicer to filter the
43 00:01:57,000 --> 00:02:03,180 contactor table to show contractors we
44 00:01:59,340 --> 00:02:04,920 started in 2021 or 2022. so for
45 00:02:03,180 --> 00:02:09,179 contractors
46 00:02:04,920 --> 00:02:11,819 now we start in 2021 or 2022 just hold
47 00:02:09,179 --> 00:02:15,180 Ctrl or command and then click on here
48 00:02:11,819 --> 00:02:17,340 and it will select both and with the
49 00:02:15,180 --> 00:02:19,620 specialty of electronics and movies and
50 00:02:17,340 --> 00:02:22,260 music so click on electronics
51 00:02:19,620 --> 00:02:23,520 and then hit Ctrl and then movies and
52 00:02:22,260 --> 00:02:25,620 music
53 00:02:23,520 --> 00:02:29,760 and this is done
54 00:02:25,620 --> 00:02:32,160 so uh since pogma is using slicer to
55 00:02:29,760 --> 00:02:34,140 filter the data add the filter button in
56 00:02:32,160 --> 00:02:36,480 the contractors table so just click on
57 00:02:34,140 --> 00:02:39,060 any cell of the table and then go to
58 00:02:36,480 --> 00:02:41,940 table design and then check off this
59 00:02:39,060 --> 00:02:44,580 filter button so this is enough now
60 00:02:41,940 --> 00:02:47,459 let's just take the answer
61 00:02:44,580 --> 00:02:50,340 so Blake uh oh
62 00:02:47,459 --> 00:02:51,840 I think we should
63 00:02:50,340 --> 00:02:53,879 so
64 00:02:51,840 --> 00:02:55,800 the arrangement is not correct so let's
65 00:02:53,879 --> 00:02:59,280 quickly fix this bring back the filter
66 00:02:55,800 --> 00:03:01,860 button and then on start here do in
67 00:02:59,280 --> 00:03:04,800 ascending under in VPS HD which has told
68 00:03:01,860 --> 00:03:06,540 us to uh convert this start here and
69 00:03:04,800 --> 00:03:09,360 last name in ascending order I think we
70 00:03:06,540 --> 00:03:12,060 missed up in that so let's do it again
71 00:03:09,360 --> 00:03:15,180 now check the answer so black exactly
72 00:03:12,060 --> 00:03:20,580 this is done and then oh this is from
73 00:03:15,180 --> 00:03:22,620 54. so just select it and then cut it
74 00:03:20,580 --> 00:03:26,760 Ctrl X or command X
75 00:03:22,620 --> 00:03:31,379 and then from 54 to 60 select here and
76 00:03:26,760 --> 00:03:36,080 then Ctrl V hit OK so this is done
77 00:03:31,379 --> 00:03:36,080 now yeah everything seems to be right
