1. Business
  2. Operations Management
  3. i posted the other part of the homework if you...

Question: i posted the other part of the homework if you...

Question details

I posted the other part of the homework if you guys want to take a look at them in case you need other supporting info from the other parts of the homework

I uploaded the needed info below at the end of the page

USING EXCEL FOR SOLVING REAL WORLD PROBLEMS Part 1 - Learn the LOWER, SUBSTITUTE and CONCATENATE functions for dealing with text. Using the file homework2.csv on the course Moodle page, manipulate the following data: Name, Company (.CSV stands for Comma Separated Values) The goal is to use Excel to convert the textual data from these two columns into a worksheet with the FirstName in a column, LastName in a column and e-mail address in a column. The format for e-mail address is:  Use the LOWER, SUBSTITUTE and CONCATENATE features (along with Data> Text to Columns) to manipulate the provided list of 150 names/companies. Keep the formulas with the data for Part 1 (do not simply re-type the addresses). NOTE: Use as many columns as you want for Part 1. RULES FOR PART 1 . e-mail addresses must be lowercase. (use LoWER(E2) in cell F2 to take the contents from cell E2 and convert them to lower case No spaces allowed in an e-mail address If the Company Name has a space, it must be removed using the SUBSTITUTE function. Hyphens are OK in e-mail addresses Sort this list of people by last name (Select the Last Name column header, then click Data> Sort> Ascending) Use as many columns as you need for Part 1 Save the file as an Excel Spreadsheet (FirstName-Lastname.xlsx) I will check to see formulas in Part 1

COMPANY NAME
Chevron David Reilly
AFLAC Daniel Amos
Applied David Pugh
Charter Neil Smit
Coca-Cola Neville Isdell
Dow Andrew Liveris
Foot Locker Matthew Serra
General-Dynamics Nicholas Chabraja
Humana Michael McCallister
Imation Frank Russomanno
Kimberly-Clark Thomas Falk
3M George Buckley
Public Storage Ronald Havner
Qualcomm Paul Jacobs
Sealy Lawrence Rogers
Steelcase James Hackett
Textron Lewis Campbell
Toll-Brothers Robert Toll
Tractor Supply James Wright
USG William Foote
Valspar William Mansfield
Waste Management David Steiner
Williams-Sonoma Howard Lester
Yahoo Jerry Yang
Union Pacific James Young
Abbott Laboratories Miles White
Advance Auto Parts Darren Jackson
American Express Kenneth Chenault
Alaska Air William Ayer
Allstate Thomas Wilson
Anadarko Petroleum James Hackett
Anheuser-Busch August Busch
Assurant Robert Pollock
ATT Randall Stephenson
Boeing James McNerney
Capital One Richard Fairbank
CBS Leslie Moonves
Citigroup Vikram Pandit
ETrade Jarrett Lilien
El Paso Douglas Foshee
Goodrich Marshall Larsen
Hanesbrands Richard Noll
International Paper John Faraci
Kraft Irene Rosenfeld
LSI Abhijit Talwalkar
Brunswick Dustan McCoy
Meredith Stephen Lacy
Manpower Jeffrey Joerres
NCR William Nuti
Oracle Lawrence Ellison
Pepsi Eric Foss
Pfizer Jeffrey Kindler
Penn Peter Carlino
Prudential John Strangefeld
RadioShack Julian Day
Regal Entertainment Michael Campbell
SanDisk Eli Harari
Scotts James Hagedorn
Sherwin-Williams Christopher Connor
SPX Christopher Kearney
Starwood Hotels Frits VanPaasschen
Target Gregg Steinhafel
Texas Instruments Richard Templeton
Tiffany Michael Kowalski
United Technologies Louis Checevert
Verizon Ivan Seidenberg
Viacom Philippe Dauman
AGEdwards Robert Bagby
Windstream Jeffrey Gardner
Southwest Gary Kelly
Xerox Anne Mulcahy
Ameriprise James Cracchiolo
Delphi Rodney Oneal
Supervalu Jeffrey Noddle
DuPont Charles Holliday
Google Eric Schmidt
Belk Thomas Belk
CSX Michael Ward
Dean Foods Gregg Engles
EMC Joseph Tucci
Intuit Brad Smith
Merck Richard Clark
Saks Stephen Sadove
Raytheon William Swanson
Whirlpool Jeff Fettig
Microsoft Steven Ballmer
Big Lots Steven Fishman
GameStop Richard Fontaine
Live Nation Michael Rapino
OfficeMax Sam Duncan
Smithfield Foods Larry Pope
Principal Financial Larry Zimpleman
Graphic Packaging David Scheible
Coventry Health Dale Wolf
ABM Industries Henrik Slipsager
ACCO Brands David Campbell
Acuity Brands Vernon Nagel
Adobe Systems Shantanu Narayen
AMD Hector Ruiz
Agilysys Arthur Rhein
Airgas Peter McCausland
Aon Gregory Case
Dynegy Bruce Williamson
Aetna Ronald Williams
AIMCO Terry Considine
Alltel Scott Ford
Altria Group Michael Syzmanczyk
Amerco Edward Shoen
Ameren Gary Rainwater
American International Martin Sullivan
Anixter International Robert Grubbs
Apollo Group Brian Mueller
Applera Tony White
Applied Materials Michael Splinter
Arch Coal Steven Leer
Atmel Steven Laub
Atmos Energy Robert Best
Auto-Owners Insurance Roger Looyenga
BBT John Allison
Belden John Stroup
Berry Plastics Ira Boots
BlueLinx Holdings Howard Cohen
Boise Cascade Thomas Stephens
Broadcom Scott McGregor
Cameron International Jack Moore
Career Education Gary McCullough
CenturyTel Glen Post
Chaparral Steel Mario Longhi
Chesapeake Energy Aubrey McClendon
Collective Brands Matthew Rubel
CommScope Frank Drendel
ConAgra Foods Gary Rodkin
Constellation Brands Robert Sands
Core-Mark Michael Walsh
Cummins Theodore Solso
Dana Gary Convis
Dover Ronald Hoffman
DRS Technologies Mark Newman
Enterprise Holdings Ralph Cunningham
Equity Residential David Neithercut
Exide Technologies Gordon Ulsh
Expeditors International Peter Rose
Express Scripts George Paz
Exterran Holdings Stephen Snider
Fairchild Semiconductor Mark Thompson
First American Parker Kennedy
FirstEnergy Anthony Alexander
Flowers Foods George Deese
FM Global Shivan Subramaniam
FMC William Walter
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution