Please help create these functions (Concat, match, vlookup, etc) to solve this prompt:

Lab Deliverable The deliverable for this lab should be a single word document that explains BOTH the errors/exceptions identified within the user access data provided in Excel AND a description of how the Excel commands listed above were used to identify errors/exceptions within the dataset. Do not submit your excel document, but feel free to include any screenshots that help to explain how you used the described functions. They say a picture is worth 1,000 words so hopefully this helps cut down the need to over document. Upload your completed Word document to the assignment folder on Canvas by the stated due date. Case Description You are an IT Auditor and have been assigned by your senior to test IT controls at a large data center. One of the controls you are testing is management's review over authorized user accounts for one of their database systems. Due to the confidential nature of this database, management is required to review and update the authorized users list periodically and to issue quarterly reports on the authorized users. As the IT Auditor, you must test the quarterly reports of authorized users maintained by management against both the new employee lists and the terminated employee lists received from Human Resources. To test these documents, you must verify the following:

1) All new hires have an account created with access to the database within the same quarter that they were hired. 2) All terminated employees are removed from the authorized users list within the same quarter they are terminated

I need these functions formatted with the info from the data sets:

CONCAT https://www.techonthenet.com/excel/formulas/concat.php 2. TEXT TO COLUMNS https://www.howtogeek.com/407217/how-to-use-text-to-columns-like-an-excel-pro/ 3. RIGHT and LEFT https://exceljet.net/excel-functions/excel-right-function https://exceljet.net/excel-functions/excel-left-function 4. LOWER and UPPER https://www.lifewire.com/convert-text-to-upper-lower-case-3123710 5. TRIM https://exceljet.net/excel-functions/excel-trim-function 6. VLOOKUP https://www.lifewire.com/vlookup-function-excel-4843186 7. INDEX and MATCH https://www.lifewire.com/index-match-functions-excel-4843446 Lab Requirements Use the Excel commands above to complete the following lab assignment. I would like you to try and use as many of the commands described above that you can. This may require you to develop multiple approaches to attacking aspects of the assignment. There are multiple ways that this assignment is completed but a successful deliverable will BOTH identify errors/exceptions within the access data provided in accompanying Excel worksheets AND provide a description of how the commands above were used to identify errors/exceptions within the dataset. One additional thing to keep in mind. The assignment asks you to do the same calculations multiple times in one tab, and then similar calculations over four quarters of data.

DATA SETS:

Q2 2014
New Hires
First Name	Last Name	Hire Date
Santiago	Maldonado	4/14/14
Fernando	Herring	4/20/14
Hanna	Villarreal	4/28/14
Ronald	Pace	5/7/14
Fatima	Brock	5/11/14
Duncan	Mullen	5/15/14
Jazlyn	Graves	5/27/14
Yaritza	Steele	6/1/14
Micah	Henson	6/8/14
Tyshawn	Frey	6/15/14
John	Pinse	6/19/1014

Q2-June 2014 Authorized User Access List
Username	Employee Name
laguirr	Libby Aguirre
aallen	Alisa Allen
malvare	Mya Alvarez
aandrew	Arturo Andrews
datkins	Danielle Atkins
catkins	Cassius Atkinson
aballar	Alexis Ballard
abarnet	Atticus Barnett
gbarton	Giovanny Barton
nbaxter	Nathalie Baxter
hbeasle	Hector Beasley
kberger	Kara Berger
nberry	Nigel Berry
bblack	Brayan Black
eblair	Elisha Blair
bblanch	Braylon Blanchard
gbowen	Gideon Bowen
dbrandt	Damian Brandt
mbraun	Mitchell Braun
kbrenna	Kayla Brennan
fbrock	Fatima Brock
jbryant	Jewel Bryant
abuckle	Angel Buckley
wcalhou	Willie Calhoun
ncampbe	Nia Campbell
acantu	Allie Cantu
mcarlso	Micah Carlson
jchan	Julio Chan
jchavez	Jordyn Chavez
hclay	Hanna Clay
gcobb	Gabriela Cobb
rcook	Reid Cook
scowan	Shirley Cowan
acummin	Ana Cummings
vdavies	Valentina Davies
bdonald	Barrett Donaldson
mdunlap	Maximillian Dunlap
jeaton	James Eaton
jfiguer	Jaylen Figueroa
aflower	Aedan Flowers
sflynn	Saige Flynn
hfoster	Hugo Foster
tfrey	Tyshawn Frey
xgarcia	Xander Garcia
rgentry	Reyna Gentry
ggiles	Gabrielle Giles
mgordon	Marcelo Gordon
jgraves	Jazlyn Graves
dgreene	Davin Greene
ahansen	Alena Hansen
zharrin	Zaria Harrington
thender	Titus Henderson
mhenson	Micah Henson
jhernan	Jarrett Hernandez
fherrin	Fernando Herring
ghines	Gracelyn Hines
ahodges	Alexa Hodges
bhoward	Benjamin Howard
ahubbar	Abigayle Hubbard
shuber	Sebastian Huber
ejohns	Essence Johns
cjones	Caden Jones
rjoseph	Rose Joseph
kkeith	Khloe Keith
cklein	Conner Klein
ykrause	Yandel Krause
kliu	Katelynn Liu
clowe	Carlos Lowe
smaldon	Santiago Maldonado
amannin	Aimee Manning
jmartin	Jace Martinez
gmccart	Gregory Mccarty
rmcpher	Robert Mcpherson
dmorgan	Donovan Morgan
dmullen	Duncan Mullen
rpace	Ronald Pace
zpachec	Zoey Pacheco
zpayne	Zayne Payne
kpena	Kale Pena
bperkin	Brennen Perkins
dpittma	Darwin Pittman
mpotts	Marissa Potts
dprice	Davion Price
mprocto	Miguel Proctor
trichar	Trenton Richards
drios	Davian Rios
jrowe	Jaylin Rowe
lsantos	Luka Santos
wschnei	Wendy Schneider
sshah	Sonia Shah
asmall	Angela Small
ysteele	Yaritza Steele
tstrick	Tianna Strickland
zterry	Zoe Terry
avargas	Anika Vargas
avazque	Alberto Vazquez
hvillar	Hanna Villarreal
hwagner	Harley Wagner
hwaller	Hayden Waller
swatts	Sydney Watts
dwebb	Daniella Webb
jweiss	Jakayla Weiss
iwyatt	Irene Wyatt
azavala	Alondra Zavala

Q1 2014
New Hires
First Name	Last Name	Hire Date
Angel	Buckley	1/14/14
Zoey	Pacheco	1/20/14
Giovanny	Giovanny	1/28/14
Nathalie	Baxter	2/7/14
Trenton	Richards	2/11/14
Khloe	Keith	2/15/14
Damian	Brandt	2/27/14
Darwin	Pittman	3/1/14
Zoe	Terry	3/8/14
Miguel	Proctor	3/15/14
Alexis	Ballard	3/17/14

Q1-March 2014 Authorized User Access List
Username	Employee Name
laguirr	Libby Aguirre
aallen	Alisa Allen
malvare	Mya Alvarez
aandrew	Arturo Andrews
datkins	Danielle Atkins
catkins	Cassius Atkinson
aballar	Alexis Ballard
abarnet	Atticus Barnett
gbarton	Giovanny Barton
nbaxter	Nathalie Baxter
hbeasle	Hector Beasley
kberger	Kara Berger
nberry	Nigel Berry
bblack	Brayan Black
eblair	Elisha Blair
bblanch	Braylon Blanchard
gbowen	Gideon Bowen
dbrandt	Damian Brandt
mbraun	Mitchell Braun
kbrenna	Kayla Brennan
jbryant	Jewel Bryant
abuckle	Angel Buckley
wcalhou	Willie Calhoun
ncampbe	Nia Campbell
acantu	Allie Cantu
mcarlso	Micah Carlson
jchan	Julio Chan
jchavez	Jordyn Chavez
hclay	Hanna Clay
gcobb	Gabriela Cobb
rcook	Reid Cook
scowan	Shirley Cowan
acummin	Ana Cummings
acurtis	Autumn Curtis
vdavies	Valentina Davies
bdonald	Barrett Donaldson
mdunlap	Maximillian Dunlap
jeaton	James Eaton
jfiguer	Jaylen Figueroa
aflower	Aedan Flowers
sflynn	Saige Flynn
hfoster	Hugo Foster
xgarcia	Xander Garcia
rgentry	Reyna Gentry
ggiles	Gabrielle Giles
mgordon	Marcelo Gordon
dgreene	Davin Greene
cguerra	Catherine Guerra
ahansen	Alena Hansen
zharrin	Zaria Harrington
thender	Titus Henderson
jhernan	Jarrett Hernandez
ghines	Gracelyn Hines
ahodges	Alexa Hodges
bhoward	Benjamin Howard
ahubbar	Abigayle Hubbard
shuber	Sebastian Huber
ejohns	Essence Johns
cjones	Caden Jones
rjoseph	Rose Joseph
kkeith	Khloe Keith
cklein	Conner Klein
ykrause	Yandel Krause
kliu	Katelynn Liu
clowe	Carlos Lowe
amannin	Aimee Manning
jmartin	Jace Martinez
gmccart	Gregory Mccarty
lmcgee	Lana Mcgee
rmcpher	Robert Mcpherson
dmorgan	Donovan Morgan
cmorse	Clark Morse
lolsen	Leyla Olsen
zpachec	Zoey Pacheco
zpayne	Zayne Payne
kpena	Kale Pena
bperkin	Brennen Perkins
dpittma	Darwin Pittman
mpotts	Marissa Potts
dprice	Davion Price
mprocto	Miguel Proctor
rrangel	Regan Rangel
trichar	Trenton Richards
drios	Davian Rios
jrowe	Jaylin Rowe
lsantos	Luka Santos
wschnei	Wendy Schneider
sshah	Sonia Shah
asmall	Angela Small
tstrick	Tianna Strickland
zterry	Zoe Terry
avargas	Anika Vargas
avazque	Alberto Vazquez
hwagner	Harley Wagner
hwaller	Hayden Waller
swatts	Sydney Watts
dwebb	Daniella Webb
jweiss	Jakayla Weiss
iwyatt	Irene Wyatt
azavala	Alondra Zavala