Go_To__Go_To_Special_Empty

Go To & Key Terms: Windows/Macs Shortcut Keys: Go To = CTRL G Additional Resources: Summary : Find and select the location of a cell or a specific named cell/cell criteria within a worksheet. Go To - Use this command to find cell locations or named cells/ranges. Go To Special - Use this to find & select all cells that fit a specified criteria. S Link 1

& Go To Special ll range. Using the Go To Special, you can find and select all cells that fit a specific Some criteria include cells that contain formulas, data validations or cells that are blank.

General Electric John Samuelson $ 400,000 25% Q1 Daimler Bill Wiatrowsky $ 600,000 25% Q1 Cargill Jennifer Hanrieder $ 625,000 50% Q1 CVS Health Luke Newsweek $ 250,000 25% Q2 AT&T Kristen Ferruzza $ 900,000 25% Q2 Tata Group Tyler Kuntz $ 875,000 50% Q2 Tesco Jeffrey Knack $ 300,000 75% Q3 Carrefour Allison Boss $ 650,000 25% Q3 Time Warner Cable Grace Choo $ 925,000 50% Q3 General Motors Tom Andrews $ 100,000 25% Q4 Citigroup Chris Hoss $ 250,000 75% Q4 Apple Andrew O'hara $ 475,000 50% Q4 Aetna Inc. Sarah Lemessurier $ 625,000 75% Q1 KPMG Consulting Inc. Collin Herold $ 100,000 50% Q1 Newell Rubbermaid Inc. Natalie Favretto $ 400,000 50% Q2 Oracle Corp. Ashley Dalgarno $ 450,000 25% Q2 Avon Products, Inc. Melanie Bronars $ 675,000 25% Q4 Intel Corporation Tim Haworth $ 700,000 75% Q4 Saks Inc. Shirley Chadbourn $ 250,000 50% Q4 Microsoft Corporation Paul Rosania $ 800,000 25% Q2 Sysco Corp. Will Hood $ 250,000 50% Q2 Bank of America Corporation Anthony Greenwal $ 375,000 25% Q3 Fortune Brands Inc. Lisa Jamentz $ 200,000 75% Q3 Manpower Inc. Amanda Daynard $ 550,000 50% Q3 Total $ 11,625,000 Cumulative total by quarter Instructions: Use the Go To function to find the cell labeled Value1 . Replace the cell amount Hint: This function is considered a “Finding” tool in Microsoft Excel Lead name Lead source Potential opportunity Chance of sale Forecast close

$ 100,000 $ 100,000 $ - $ - $ - $ 150,000 $ 150,000 $ - $ - $ - $ 312,500 $ 312,500 $ - $ - $ - $ 62,500 $ - $ 62,500 $ - $ - $ 225,000 $ - $ 225,000 $ - $ - $ 437,500 $ - $ 437,500 $ - $ - $ 225,000 $ - $ - $ 225,000 $ - $ 162,500 $ - $ - $ 162,500 $ - $ 462,500 $ - $ - $ 462,500 $ - $ 25,000 $ - $ - $ - $ 25,000 $ 187,500 $ - $ - $ - $ 187,500 $ 237,500 $ - $ - $ - $ 237,500 $ 468,750 $ 468,750 $ - $ - $ - $ 50,000 $ 50,000 $ - $ - $ - $ 200,000 $ - $ 200,000 $ - $ - $ 112,500 $ - $ 112,500 $ - $ - $ 168,750 $ - $ - $ - $ 168,750 $ 525,000 $ - $ - $ - $ 525,000 $ 125,000 $ - $ - $ - $ 125,000 $ 200,000 $ - $ 200,000 $ - $ - $ 125,000 $ - $ 125,000 $ - $ - $ 93,750 $ - $ - $ 93,750 $ - $ 150,000 $ - $ - $ 150,000 $ - $ 275,000 $ - $ - $ 275,000 $ - $ 5,081,250 $ 1,081,250 $ 1,362,500 $ 1,368,750 $ 1,268,750 $ 1,081,250.00 $ 2,443,750.00 $ 3,812,500.00 $ 5,081,250.00 to 250000. Weighted forecast Q1 weighted forecast Q2 weighted forecast Q3 weighted forecast Q4 weighted forecast

General Electric John Samuelson $ 400,000 25% Q1 Daimler Bill Wiatrowsky $ 600,000 25% Q1 Cargill Jennifer Hanrieder $ 625,000 50% Q1 CVS Health Luke Newsweek $ 250,000 25% Q2 AT&T Kristen Ferruzza $ 900,000 25% Q2 Tata Group Tyler Kuntz $ 875,000 50% Q2 Tesco Jeffrey Knack $ 300,000 75% Q3 Carrefour Allison Boss $ 650,000 25% Q3 Time Warner Cable Grace Choo $ 925,000 50% Q3 General Motors Tom Andrews $ 100,000 25% Q4 Citigroup Chris Hoss $ 250,000 75% Q4 Apple Andrew O'hara $ 475,000 50% Q4 Aetna Inc. Sarah Lemessurier $ 625,000 75% Q1 KPMG Consulting Inc. Collin Herold $ 100,000 50% Q1 Newell Rubbermaid Inc. Natalie Favretto $ 400,000 50% Q2 Oracle Corp. Ashley Dalgarno $ 450,000 25% Q2 Avon Products, Inc. Melanie Bronars $ 675,000 25% Q4 Intel Corporation Tim Haworth $ 700,000 75% Q4 Saks Inc. Shirley Chadbourn $ 150,000 50% Q4 Microsoft Corporation Paul Rosania $ 800,000 25% Q2 Sysco Corp. Will Hood $ 250,000 50% Q2 Bank of America Corporation Anthony Greenwal $ 375,000 25% Q3 Fortune Brands Inc. Lisa Jamentz $ 200,000 75% Q3 Manpower Inc. Amanda Daynard $ 550,000 50% Q3 Total $ 11,625,000 Cumulative total by quarter Instructions: Using the Go To Special function, find and select all the cells that contain a form Hint: This function is considered a “Finding” tool in Microsoft Excel Lead name Lead source Potential opportunity Chance of sale Forecast close

$ 100,000.00 $ 100,000.00 $ - $ - $ - $ 150,000.00 $ 150,000.00 $ - $ - $ - $ 312,500.00 $ 312,500.00 $ - $ - $ - $ 62,500.00 $ - $ 62,500.00 $ - $ - $ 225,000.00 $ - $ 225,000.00 $ - $ - $ 437,500.00 $ - $ 437,500.00 $ - $ - $ 225,000.00 $ - $ - $ 225,000.00 $ - $ 162,500.00 $ - $ - $ 162,500.00 $ - $ 462,500.00 $ - $ - $ 462,500.00 $ - $ 25,000.00 $ - $ - $ - $ 25,000.00 $ 187,500.00 $ - $ - $ - $ 187,500.00 $ 237,500.00 $ - $ - $ - $ 237,500.00 $ 468,750.00 $ 468,750.00 $ - $ - $ - $ 50,000.00 $ 50,000.00 $ - $ - $ - $ 200,000.00 $ - $ 200,000.00 $ - $ - $ 112,500.00 $ - $ 112,500.00 $ - $ - $ 168,750.00 $ - $ - $ - $ 168,750.00 $ 525,000.00 $ - $ - $ - $ 525,000.00 $ 75,000.00 $ - $ - $ - $ 75,000.00 $ 200,000.00 $ - $ 200,000.00 $ - $ - $ 125,000.00 $ - $ 125,000.00 $ - $ - $ 93,750.00 $ - $ - $ 93,750.00 $ - $ 150,000.00 $ - $ - $ 150,000.00 $ - $ 275,000.00 $ - $ - $ 275,000.00 $ - $ 5,031,250.00 $ 1,081,250.00 $ 1,362,500.00 $ 1,368,750.00 $ 1,218,750.00 $ 1,081,250.00 $ 2,443,750.00 $ 3,812,500.00 $ 5,031,250.00 mula in the worksheet. Change the selected cells to an "Accounting" number format. Weighted forecast Q1 weighted forecast Q2 weighted forecast Q3 weighted forecast Q4 weighted forecast

Product Number Item Code Product Category Aisle Location 251422828 ANKFAIT Aunt Jemima Pancakes Breakfast Aisle 3 205354762 8F4VGDB Aveeno Body Wash Toiletries Aisle 7 837183525 YB5MCPK Axe Body Wash for Men Toiletries Aisle 7 689011081 CFBTHH6 Barilla Pasta Penne Pasta & Sauce Aisle 4 759319248 GQWZTCF Bertolli Alfredo Sauce Pasta & Sauce Aisle 4 492598931 EYI3GML Betty Crocker Cookie Mix Baking Aisle 1 477160124 CVHMUSM Bush's Baked Beans Pasta & Sauce Aisle 4 510196830 WLSPFTB Cheez-It Snack Crackers Snacks Aisle 2 163654148 WJGV5FT Chef Boyardee Beef Ravioli Pasta & Sauce Aisle 4 423155746 UIPH25I Coca-Cola Soda 12 pack Beverages Aisle 6 299057864 NMDSM3E Colgate Max Fresh Toothpaste Toiletries Aisle 7 880261361 IOSBGE3 Coppertone Sunscreen Toiletries Aisle 7 654315612 RGQXD4F Crest Complete Toothpaste Toiletries Aisle 7 914733936 SOP3QFZ DiGiorno Pizza Pepperoni Freezer Aisle 5 348544599 QVCR9WQ Dove White Bar Soap Toiletries Aisle 7 308354560 2UKQEQP Duncan Hines Brownie Mix Baking Aisle 1 274644254 NZQYAPT Duncan Hines Classic Yellow Mix Baking Aisle 1 549377964 TNDPRF5 Folgers Ground Coffee Beverages Aisle 6 866820933 ZPHOM8S Frozen Cod Fillets Freezer Aisle 5 184303082 YCSMPRM Great Value Apple Juice Beverages Aisle 6 781882466 EZWBCCV Hawaiian Punch Beverages Aisle 6 331615657 BYW9HUG Hershey's Chocolate Syrup Baking Aisle 1 535154688 TSBYZVV Honey Nut Cheerios Breakfast Aisle 3 525422546 GMQPAVY Hungry-Man Boneless Chicken Freezer Aisle 5 371219851 9YSPJ9L Hunt's Diced Tomatoes Pasta & Sauce Aisle 4 721855742 OHQ8TVZ Instant Ramen Chicken Flavor Pasta & Sauce Aisle 4 120626691 LOJXJSB Jif Creamy Peanut Butter Breakfast Aisle 3 593576321 WDDU4SJ Kellogg's Pop-Tarts Breakfast Aisle 3 323536740 QTJEVPX Kool-Aid Jammers Beverages Aisle 6 755146373 ME3DBS3 Kraft Macaroni & Cheese Pasta & Sauce Aisle 4 733721509 3QL443G Lay's Potato Chips Snacks Aisle 2 309663038 U5GF4MM Listerine Mouthwash Toiletries Aisle 7 352059863 CKGQSRU Nabisco Chips Ahoy Snacks Aisle 2 376270412 LCXWR9T Nature Valley Oats 'N Honey Breakfast Aisle 3 969556389 CD2SEMR Nature Valley Protein Bars Breakfast Aisle 3 321375593 IFSM8ZZ Nestle Pure Life Water Beverages Aisle 6 703549751 ZYRMWVQ Nilla Wafers Snacks Aisle 2 405722157 BSTW9DA Oreo Cookies Snacks Aisle 2 130052932 QTJMZ5D Prego Italian Sauce Pasta & Sauce Aisle 4 380570915 9GGE9J5 Quaker Chewy Granola Bars Snacks Aisle 2 713210290 RIFYJC5 Quaker Oats Oatmeal Breakfast Aisle 3 300532544 MCVDQE9 Ragu Traditional Sauce Pasta & Sauce Aisle 4 880530644 EEGQIPT Reese's Puffs Cereal Breakfast Aisle 3 295688058 BTZSCRF Snack Pack Pudding Snacks Aisle 2 280048599 3IYMFHZ Stouffer's Lasagna Freezer Aisle 5 707653870 GGXO3Z7 Suave Body Wash Toiletries Aisle 7

422788814 HO4DWHT Thai Kitchen Coconut Milk Beverages Aisle 6 881753850 YDJJCYG Tostitos Scoops Snacks Aisle 2 249217007 RNUJIF7 Totino's Pepperoni Pizza Freezer Aisle 5 466746147 U4UJZYZ Tyson Chicken Strips Freezer Aisle 5 564875263 NBIKUGX Welch's Fruit Snacks Baking Aisle 1

166 1.74 491 854.34 No 164 3.48 380 1322.4 No 97 1.06 167 177.02 Yes 166 6.16 471 2901.36 No 97 6.98 107 746.86 Yes

Aisle Location Category Aisle 1 Baking Aisle 2 Snacks Aisle 3 Breakfast Aisle 4 Pasta & Sauce Aisle 5 Freezer Aisle 6 Beverages Aisle 7 Toiletries ctions : A table with a list of products are listed to the left. the Current Inventory column, there are a number of cells that need to be filled in. Using "Go To Special", fill in blank cells with "Sold Out".