I put the link in the comment.

EA4-A1 Edit an Inventory Listing and Create A PivotTable for Educational Endeavors

In this exercise, you will compile summary data based on an inventory listing for Educational Endeavors. Then you will determine the inventory balance for a product category using three methods. Last, you will create an PivotTable and a PivotChart.

A B C D E F G H J K L M N 1 Educational Endeavors - Inventory Listing Total Categories= W N Country of Product Ending Inventory Ending Inventory Ending Inventory Ending Inventory Ending Inventory Number Average Inventory Maximum Inventory |Minimum Inventory 4 Product Category Manufacture Department Online Rating Balance - Year 1 Balance - Year 2 Balance - Year 3 Balance - Year 4 Balance - Year 5 of Years Balance Balance Balance 5 Construction Paper Canada Arts & Crafts 3 of 5 11,480 $ 14,350 $ 9,450 $ 6,860 6 Crayons United States Arts & Crafts 2 of 5 24,108 26,978 $ 25,256 $ 24,682 Markers United States Arts & Crafts 3 of 5 12,710 $ 11,480 $ 17,220 8 Glue United States Arts & Crafts 5 of5 9,184 17,794 $ 9,758 $ 8,036 9 Adhesives Canada Arts & Crafts 2 of 5 4,018 $ 5,166 $ 3,444 $ 1,148 5 1,722 10 Clay, Dough, and Tools Ireland Arts & Crafts 5 of 5 6,314 $ 5,740 $ 5,740 $ 5,740 5 6,027 11 Craft Kits & Projects Canada Arts & Crafts 5 of 5 6,765 $ 7,462 $ 5,453 12 Craft Materials United States Arts & Crafts 2 of 5 2,009 $ 1,148 $ 2,296 13 Drawing reland Arts & Crafts 2 of 5 35,588 $ 32,718 $ 28,126 $ 30,422 $ 37,884 14 Paint Ireland Arts & Crafts 3 of 5 40,754 42,476 $ 43,050 $ 40,754 $ 34,440 15 Paint Brushes & Accessories Australia Arts & Crafts 3 of 5 28,700 $ 28,700 31,570 $ 30,422 $ 30,135 16 Paper New Zealand Arts & Crafts 1 of 5 20,664 21,525 22,386 $ 20,951 $ 19,516 17 Racks & Storage New Zealand Arts & Crafts 3 of 5 16,072 15,498 14,350 $ 14,924 $ 15,211 18 Stamp Pads & Stampers Canada Arts & Crafts 5 of 5 26,978 $ 7,462 $ 14,924 19 Soft Active Play Canada Active 5 of 5 2,009 2,181 $ 5,166 $ 5,453 $ 1,305 20 Active Kits United States Active 3 of 5 6,429 4,879 6,314 $ 6,084 $ 5,625 21 Balls United States Active 3 of 5 1,722 $ 1,779 22 Gross Motor Skills United States Active 3 of 5 35,588 30,422 17,220 $ 2,870 23 Indoor Play Equipment Canada Active 2 of 5 26,404 27,552 28,126 $ 26,404 26,404 24 Play Structures United States Active 2 of 5 13,202 14,924 $ 15,211 $ 12,628 $ 10,906 25 Sand & Water New Zealand Active 2 of 5 22,960 24,108 24,969 $ 25,256 27,552 26 Teacher's Resources Australia Active 2 of 5 10,332 $ 27 Trikes & Riding Australia Active 2 of 5 18,655 17,220 22,099 $ 20,664 $ 15,498 28 Alphabet Knowledge Ireland Language 3 of 5 24,108 23,247 22,099 $ 22,386 $ 25,256 29 Games & Puzzles Australia Language 3 of 5 35,875 35, 014 $ 33,292 $ 28,126 $ 30,709 30 Grammar Ireland Language 3 of 5 3,444 $ 20,090 31 Interactive Books & Software United States Language 3 of 5 2,296 2,583 1,722 32 Journals & Paper United States Language 5 of 5 37,310 S 34,440 35,588 36,162 35,875 33 Language Easels Ireland Language 3 of 5 54,530 $ 58,548 $ 59,983 50,512 $ 34 Reading Comprehension Ireland Language 3 of 5 78,064 $ 80,360 75,768 79,499 $ 65,780 35 Rhyming Ireland Language 5 of 5 49,364 5 47,068 44,772 36 Sentence Building Australia Language 2 of 5 22,960 S 24,108 24,969 $ 27,839 37 Sight Words New Zealand Language 2 of 5 17,220 5 16,072 $ 12,054 38 Addition & Subtraction New Zealand Mathematics 1 of 5 32,144 5 29,848 30,422 $ 29,274 $ 28,126 39 Counting & Numeracy Canada Mathematics 3 of 5 4,879 6,601 8,151 $ 8,553 5,510 40 Curriculum Resources New Zealand Mathematics 1 of 5 1,837 2,583 918 3,157 34,440 41 Exploring Manipulatives Australia Mathematics 5 of 5 42 Geometry Ireland Mathematics 5 of 5 45,920 $ 48,216 46,494 7,462 12 Moacuramant 9. Alacrifuina Alow Znaland Mathematice SE 101 12 203 Inventory Listing Construction Paper +B C 21 Balls D E United States G H 22 Gross Motor Skills Active 3 of 5 United States $ $ K L Active 23 Indoor Play Equipment 3 of 5 1,722 $ 1,779 Canada 35,588 $ Active 30,422 $ 17,220 $ 24 Play Structures 2 of 5 United States 26,404 $ 2,870 $ Active 27,552 $ 28,126 $ 26,404 5 25 Sand & Water 2 of 5 New Zealand 13,202 $ 14,924 $ 15,211 5 26,404 Active 12,628 $ 10,906 26 Teacher's Resources 2 of 5 Australia 22,960 $ Active 24,108 24,969 25,256 $ 27,552 27 Trikes & Riding 2 of 5 Australia $ Active 2 of 5 10,332 5 28 Alphabet Knowledge Ireland 18,655 $ Language 17,220 $ 22,099 3 of 5 20,664 $ 29 Games & Puzzles Australia 24,108 $ 15,498 Language 23,247 $ 22,099 3 of 5 22,386 $ 25,256 30 Grammar 35,875 $ Ireland 35, 014 $ 33,292 Language 3 of 5 28,126 $ 30,709 31 Interactive Books & Software United States Language 3,444 $ 20,090 3 of 5 32 Journals & Paper 2,296 $ United States 2,583 $ Language 5 of 5 1,722 33 Language Easels 37,310 $ Ireland 34,440 $ 35,588 $ 36,162 $ Language 35,875 3 of 5 54,530 $ 34 Reading Comprehension 58,548 $ Ireland 59,983 $ 50,512 $ Language 3 of 5 78,064 5 35 Rhyming 80,360 $ 75,768 5 Ireland 79,499 $ 65,780 Language 5 of 5 49,364 $ 47,068 $ 36 Sentence Building 44,772 5 Australia Language 2 of 5 22,960 $ 24, 108 $ 24,969 27,839 5 37 Sight Words New Zealand Language 2 of 5 17,220 $ $ 16,072 $ 12,054 38 Addition & Subtraction New Zealand Mathematics 1 of 5 32,144 $ 29,848 $ 30,422 5 29,274 5 28,126 39 Counting & Numeracy Canada Mathematics 3 of 5 4,879 $ 6,601 $ 8,151 $ 8,553 5 5 , 510 40 Curriculum Resources New Zealand Mathematics 1 of 5 $ 1,837 $ 2,583 $ 918 $ 3 , 157 41 Exploring Manipulatives Australia Mathematics 5 of 5 $ $ 34,440 42 Geometry Ireland Mathematics 5 of 5 45,920 $ 48,216 $ 46,494 $ 7,462 43 Measurement & Classifying New Zealand Mathematics 3 of 5 55,104 $ 13,202 $ S 44 Operations United States Mathematics 3 of 5 43,624 $ 40,754 $ 42,476 $ 45,346 $ 24,682 45 Algebraic Thinking Australia Mathematics 1 of 5 32,144 $ 7,462 $ 1,722 $ 15,498 46 Carts & Storage Australia Block Play 2 of 5 $ 55,104 47 Jumbo Blocks New Zealand Block Play 2 of 5 5,510 $ 5,051 $ 1,994 $ 3,444 $ 4,190 48 Novelty Blocks New Zealand Block Play 2 of 5 35,014 $ 30,422 $ 33,292 31,857 5 23,534 49 People & Animals Ireland Block Play 5 of 5 19,184 $ 10,332 $ 6,601 $ 6,027 $ 6,888 50 Rugs & Mats United States Block Play 2 of 5 10,906 $ 13,202 14,924 $ 16,072 $ 20,377 51 Tabletop Blocks Ireland Block Play 3 of5 20,664 $ 20,090 $ 17,794 $ 2 of 5 10,619 $ 14,924 $ 13,202 52 Unit Blocks Ireland Block Play 10,332 $ 11,193 $ New Zealand Block Play 5 of 5 4,305 $ 5, 166 $ 5,510 $ 4,707 $ 2,296 53 Vehicles 5 of 5 $ 3,731 $ 9,414 $ 16,072 54 Chalk & Dry Erase Australia School Supplies Canada School Supplies 3 of 5 21,812 $ 22 , 386 $ 20,090 $ 20,664 17,794 55 Crayons School Supplies 3,731 $ 3,559 Canada 2 of 5 3,674 $ 4,420 4,190 56 Folders & Binders School Supplies 40,180 $ 43,624 $ 36,162 $ Canada 3 of 5 42,476 $ 28,126 57 Notebooks & Paper 7.462 58 Office Supplies Ireland School Supplies 3 of 5 32,144 $ 50,512 $ 49,364 $ 44,485 $ 41,902 59 Paint United States School Supplies 3 of 5 52,234 $ 24,682 $ 31,283 29,848 60 Pens & Pencils Australia School Supplies 2 of 5 28,413 $ 23,534 $ 15,785 Ireland School Supplies 2 of 5 6,888 $ 16,072 $ 15,211 $ 13,776 61 Scissors S 36, 162 5 33,292 5 22,673 62 Storage New Zealand School Supplies 5 of 5 63 Totals: 64 +