1.

Clean the data set

2. Find and retype all missing data if there is a data that has no reference put NA by using if error
3. separate the location and department
3. Put a grid and change the color of the labels into black and white font
Date Client Contact DepartmenPayment Revenue Profit Profit Margin
### Cook, Hendwesley FRAOperationsCash ### ### 24.00%
### Alvarez Inccory WESTIT_Cabuya Paypal ### ₱850,000 18.89%
### Marquez, Vfaith SMIT IT_BacolodGcash ### ### 20.97%
### Rasmussen,cynthia DUNCAN Mobile Pa ### ### 21.43%
### kimberly Sales_MakaCheque ### ### 24.21%
8/3/2024 Wright, Fl joshua RO HR_MakatiCredit Card ### ### 21.95%
2/2/2022 Long, Marttara GOMEMarketing_Cebu ### ### 25.00%
### Freeman, Hsheri COL Marketing Cheque ### 0.00%
### IT_Makati Cheque ### ### 22.22%
Stark Groucindy NEL Finance_TaBank Trans ### ### 20.37%
1/7/2021 Washington michelle A Customer SCheque ### ### 25.00%
### Meyers, Wu alyssa MU Customer SCredit Card ### ### 25.00%
6/8/2021 Spencer, Rjennifer BECustomer SPaymaya ### 0.00%
### Peters LLC colleen BR Sales_Pasi Credit Card ### ### 24.62%
### Phillips, W sydney JE Operations_Makati ### ### 22.86%
2/1/2024 wayne ESTHR_TaguigCash ### ### 23.57%
### Pierce, Norjames GRASales_Cab Paymaya ### ### 23.68%
3/3/2025 Nielsen-Lucero (Smit Customer SCheque ### #DIV/0!
### Nguyen-Hilkatherine Sales_Pasi Paypal ### ### 23.17%
### Mills-Kemppatricia G Operation Gcash ### ### 22.61%
### Peters LLC colleen BR Sales_Pasi Credit Card ### ### 24.62%
### Ortiz-Muellduane MORCustomer SPaypal ### ### 23.70%
### Harris, No donna SC Customer SPaypal ### ### 23.68%
### Mccoy, Rusjason BRO Sales_Sta. Mobile Pa ### ### 23.33%
### Collins PLCmonica LEEMarketing_Mobile Pa ### ### 23.08%
9/5/2022 Montoya Ganne BERRHR_BacoloCheque ### ### 23.91%
### Peters LLC colleen BR Sales_Pasi Credit Card ### ### 24.62%
### Young, Casrobert GAYMarketing_Bank Trans ### ### 20.00%
6/9/2025 Yoder, Sanrobert BUTMarketing_Paymaya ### ### 23.33%
### Stokes-Co elizabeth HOperation Cheque ### ### 23.97%
### Parker Inc amanda WH OperationsBank Trans ### ### 23.64%
3/3/2022 Farley-Comb heather S HR_CalambCredit Card ### ### 21.05%
Lee Ltd (L shane FIEL Operation Credit Card ### ### 23.45%
### Edwards-Franklin HR_Davao Cheque ### ### 24.35%
### Butler LLC raven FISC Operation Cheque ### ### 24.16%
9/5/2025 Ferrell, Wajames SU HR_TaguigCheque ### ### 23.81%
9/9/2025 Orozco-Milkimberly MIT_Davao Credit Card ### ### 24.55%
### Johnson-Jobryan GAROperationsCash ### ### 22.37%
### Wood, Olsojudy AUSTIIT_Davao Cash ### ### 0.23
### Webb Ltd rachel IRWIT_Davao Paypal ### ### 0.23
4/5/2022 Hart-Frankamy JIMENMarketing Gcash ### ### 0.23
### Boyd LLC nicole SIM Marketing Paymaya ### ### 0.25
### Garcia-Rowe (Phillips IT_CalambMobile Pa ### ### 0.23
### Tucker, Th angela SO IT_Davao Mobile Pa ### ### 23.53%
Mcclure Grsarah MOSIT_BacolodCredit Card ### ### 23.89%
9/1/2023 Johnson Inthomas W Sales_Pasi Cash ### ### 23.60%
### Frazier-Becmary FOX Customer SCredit Card ### ### 25.00%
7/5/2020 Dorsey Ltdsara HERN Sales_TaguMobile Pa ### ### 23.75%
### Parker-Swerichard S Sales_BacoPaypal ### ### 24.00%
### Greene-Ayaandrea WACustomer SBank Trans ### ### 24.32%
### Wilson-Coxbrian NEALFinance_QuCheque ### #DIV/0!
### Armstrong,tiffany H HR_BacoloCredit Card ### ### 21.51%
4/5/2025 steve KNIGMarketing_Paymaya ### ### 22.41%
### Ramsey, Ma amanda PEMarketing_Cheque ### ### 24.71%
3/1/2022 Lynch-Pitt steven MILLER Gcash ### ### 22.73%
### Smith-Granandrea KE Finance_Cebu ### ### 24.55%
### Parker, Baianna LAMBOperationsBank Trans ### ### 22.89%
### Peters LLC colleen BR Sales_Pasi Credit Card ### ### 24.62%
### Mann, Hic connie B Customer SCheque ### ### 24.44%
### Mercer-Mitmichael M Marketing Paypal ### ### 24.00%
### Rhodes-Salcharles BR Customer SCheque ### ### 0.23
8/6/2023 Allen, Jon amanda G Customer SMobile Payment ### #DIV/0!
2/1/2025 Randolph Lleah BARR IT_Makati Gcash ### ### 0.22
### Stanley PL lauren HE Marketing Paypal ### ### 0.24
### Taylor-Wil alicia MEJI Sales_MakaGcash ### ### 0.24
### Barber and Sons HR_Cebu Paymaya ### ### 0.22
### Nelson Ltd jeremy SH Finance_Ma Credit Card ### ### 0.24
### Mills-Marticraig MCDOWELL Paymaya ### ### 0.24
### Rodgers Grtracey ED HR_TaguigCheque ### ### 24.00%
### Johnson, S benjamin Finance_C Cheque ### ### 22.73%
### Carpenter Lmichael DYOperationsCheque ### ### 23.48%
### Castro PLC andrew HOMarketing Cash ### 0.00%
### Sullivan, O peter DANIEL Paymaya ### ### 22.08%
### Solis, Spea jane LEE OperationsCredit Card ### ### 22.83%
1/3/2024 mariah B HR_TaguigPaypal ### ### 23.08%
### Hays, Donasean JONE Marketing_Cheque ### #DIV/0!
### Briggs Gro susan LOPEIT_QuezonBank Trans ### ### 25.00%
### michelle T Customer SGcash ### ### 23.16%
### Byrd-Washwilliam JENSEN Mobile Pa ### ### 24.29%
### James Ltd danielle L Sales_Sta. Credit Card ### 0.00%
### abigail ME Customer SMobile Pa ### ### 25.00%
### Simpson-Mo brooke VA HR_Sta.Ro Bank Trans ### ###
### Taylor andraymond KIT_Taguig Paymaya ### ### 22.62%
### Smith-Bradfkurt HARREMarketing Bank Trans ### ### 22.22%
### Larson, Jo chase MASCustomer SGcash ### #DIV/0!
### Evans-Strondanny CRUCustomer SCredit Card ### ### 23.70%
5/6/2022 Hicks Inc keith WAL OperationsGcash ### ### 23.86%
### Wilson-Evamatthew WCustomer SPaypal ### ### 24.00%
### Poole-Smitmaria WIL IT_Davao Cheque ### ### 25.00%
### Stewart-Josamantha HR_TaguigPaypal ### ### 22.97%
### Peters LLC colleen BR Sales_Pasi Credit Card ### ### 24.62%
### Peters LLC colleen BR Sales_Pasi Credit Card ### ### 24.62%
### Peters LLC colleen BR Sales_Pasi Credit Card ### ### 24.62%
Date Client Contact
5/22/2023 Cook, Henderson and Rivera (Parker, Bowen and Ramos) wesley FRAZIER
9/24/2024 Alvarez Inc (Drake-Robbins) cory WEST
5/23/2022 Marquez, Vargas and Fox (Todd Group) faith SMITH
10/13/2024 Rasmussen, Parrish and Davis (Simmons-Thompson) cynthia DUNCAN
3/29/2020 Thornton, Greene and Lopez kimberly GOMEZ
8/3/2024 Wright, Fleming and Braun joshua RODRIGUEZ
2/2/2022 Long, Martinez and Zimmerman tara GOMEZ
5/20/2021 Freeman, Hatfield and Hardy (Johnson Inc) sheri COLEMAN
1/15/2022 Davies-Hatfield (Smith, Brown and Hale) connor WHITE
3/17/2023 Stark Group cindy NELSON
1/7/2021 Washington and Sons (Smith, Santos and Anderson) michelle ADKINS
10/27/2023 Meyers, Wu and Smith (Douglas, Luna and Santiago) alyssa MUNOZ
6/8/2021 Spencer, Roy and Johnson jennifer BEST
4/21/2025 Peters LLC (Robinson-Ward) colleen BRYANT
4/10/2020 Phillips, Walker and Evans (Brown Ltd) sydney JEFFERSON
2/1/2024 Wright-Warner (Dougherty PLC) wayne ESTES
2/22/2025 Pierce, Norman and Hill (Harrington-Stewart) james GRAY
3/3/2025 Nielsen-Lucero (Smith-Moore) mary SNOW
12/14/2024 Nguyen-Hill katherine RUIZ
10/6/2023 Mills-Kemp patricia GRAY
8/31/2023 Hernandez Ltd (Smith and Sons) jason TURNER
9/27/2023 Ortiz-Mueller duane MORRIS
8/26/2025 Harris, Norman and Gallegos (Allen-Lawson) donna SCHWARTZ
8/29/2022 Mccoy, Russell and Wallace jason BROOKS
2/21/2026 Collins PLC monica LEE
9/5/2022 Montoya Group anne BERRY
11/24/2021 Garner, Palmer and Huang marie HARRIS
5/18/2025 Young, Castro and Schmidt (Smith-Steele) robert GAY
6/9/2025 Yoder, Sanchez and Daniels robert BUTLER
12/24/2021 Stokes-Cowan elizabeth HILL
3/10/2020 Parker Inc (Lin PLC) amanda WHITE
3/3/2022 Farley-Combs (Grant, Larson and Kline) heather SMITH
12/13/2021 Lee Ltd (Lewis, Mccoy and Moore) shane FIELDS
12/29/2025 Edwards-Franklin michael PATRICK
4/28/2025 Butler LLC raven FISCHER
9/5/2025 Ferrell, Watts and Crawford (King Inc) james SUMMERS
9/9/2025 Orozco-Mills kimberly MILES
10/5/2024 Johnson-Jones (Martinez LLC) bryan GARCIA
11/19/2022 Wood, Olson and Cohen (Brennan and Sons) judy AUSTIN
8/14/2025 Webb Ltd rachel IRWIN
4/5/2022 Hart-Frank amy JIMENEZ
11/8/2024 Boyd LLC nicole SIMS
6/10/2025 Garcia-Rowe (Phillips and Sons) christopher BROWN
6/29/2025 Tucker, Thomas and Edwards (Davis-Walls) angela SOLOMON
9/25/2023 Mcclure Group (Mcdonald-Harding) sarah MOSS
9/1/2023 Johnson Inc (Smith PLC) thomas WATSON
7/24/2023 Frazier-Becker mary FOX
 7/5/2020 Dorsey Ltd (Hardin, Turner and Edwards) sara HERNANDEZ
11/7/2020 Parker-Sweeney (Brock, Hamilton and Johnson) richard STEWART
3/15/2024 Greene-Ayala andrea WADE
6/21/2025 Wilson-Cox (Smith, Sullivan and English) brian NEAL
10/29/2021 Armstrong, Cherry and Garcia tiffany HERNANDEZ
4/5/2025 Brennan and Sons (Sharp-Dean) steve KNIGHT
3/14/2022 Ramsey, Mata and Castro (Allen-Roberson) amanda PETERSON
3/1/2022 Lynch-Pittman (Smith, Blanchard and Watson) steven MILLER
10/20/2022 Smith-Grant andrea KENNEDY
11/7/2023 Parker, Bailey and Johnson anna LAMB
8/7/2023 Burch-Adkins beth GRAHAM
1/24/2023 Mann, Hickman and Townsend connie BOWMAN
12/5/2024 Mercer-Mitchell (Hernandez LLC) michael MCCONNELL
10/21/2021 Rhodes-Salazar charles BRIGHT
8/6/2023 Allen, Jones and Moore amanda GOODMAN
2/1/2025 Randolph Ltd (Powers LLC) leah BARRERA
1/15/2024 Stanley PLC lauren HENRY
9/13/2022 Taylor-Wiley alicia MEJIA
2/21/2021 Barber and Sons lori JIMENEZ
8/11/2020 Nelson Ltd (Scott Group) jeremy SHAW
11/9/2022 Mills-Martin craig MCDOWELL
8/16/2021 Rodgers Group (Dunn Ltd) tracey EDWARDS
2/15/2023 Johnson, Sanchez and Harris benjamin WALSH
12/13/2021 Carpenter Ltd (Miller Inc) michael DYER
10/28/2025 Castro PLC (Franklin, Gutierrez and Wolfe) andrew HOUSE
1/26/2021 Sullivan, Olson and Peters peter DANIEL
3/20/2021 Solis, Spears and Evans jane LEE
1/3/2024 Marshall Inc (Richards-Evans) mariah BROWN
7/19/2022 Hays, Donaldson and Brown sean JONES
10/19/2024 Briggs Group susan LOPEZ
12/11/2022 Gregory Group (Malone, Mcdonald and Jordan) michelle TODD
12/6/2022 Byrd-Washington william JENSEN
9/19/2020 James Ltd (Hunter, Owen and Thornton) danielle LYONS
10/3/2022 Walsh-Chan abigail MELTON
3/21/2022 Simpson-Moreno (Young and Sons) brooke VASQUEZ
12/22/2025 Taylor and Sons (Hines, Martinez and Johnson) raymond KELLEY
3/23/2024 Smith-Bradford (Jackson Ltd) kurt HARRELL
2/16/2021 Larson, Jones and Wilson chase MASON
2/21/2026 Evans-Strong (Jenkins-Collins) danny CRUZ
5/6/2022 Hicks Inc keith WALTER
3/14/2020 Wilson-Evans (Cobb PLC) matthew WILLIAMS
6/14/2022 Poole-Smith maria WILSON
9/15/2020 Stewart-Johnson samantha STANLEY
Department Payment
Operations_Taguig Cash
IT_Cabuyao Paypal
IT_Bacolod Gcash
Customer Service_Bacolod Mobile Payment
Sales_Makati Cheque
HR_Makati Credit Card
Marketing_Cebu Gcash
Marketing_Cebu Cheque
IT_Makati Cheque
Finance_Taguig Bank Transfer
Customer Service_Cebu Cheque
Customer Service_Taguig Credit Card
Customer Service_Quezon City Paymaya
Sales_Pasig Credit Card
Operations_Makati Bank Transfer
HR_Taguig Cash
Sales_Cabuyao Paymaya
Customer Service_Calamba Cheque
Sales_Pasig Paypal
Operations_Cabuyao Gcash
IT_Cabuyao Bank Transfer
Customer Service_Makati Paypal
Customer Service_Cabuyao Paypal
Sales_Sta.Rosa Mobile Payment
Marketing_Pasig Mobile Payment
HR_Bacolod Cheque
Finance_Cebu Bank Transfer
Marketing_Quezon City Bank Transfer
Marketing_Taguig Paymaya
Operations_Cabuyao Cheque
Operations_Quezon City Bank Transfer
HR_Calamba Credit Card
Operations_Cebu Credit Card
HR_Davao Cheque
Operations_Cebu Cheque
HR_Taguig Cheque
IT_Davao Credit Card
Operations_Bacolod Cash
IT_Davao Cash
IT_Davao Paypal
Marketing_Cabuyao Gcash
Marketing_Davao Paymaya
IT_Calamba Mobile Payment
IT_Davao Mobile Payment
IT_Bacolod Credit Card
Sales_Pasig Cash
Customer Service_Pasig Credit Card
Sales_Taguig Mobile Payment
Sales_Bacolod Paypal
Customer Service_Quezon City Bank Transfer
Finance_Quezon City Cheque
HR_Bacolod Credit Card
Marketing_Pasig Paymaya
Marketing_Quezon City Cheque
Finance_Sta.Rosa Gcash
Finance_Cebu Paymaya
Operations_Taguig Bank Transfer
IT_Sta.Rosa Gcash
Customer Service_Davao Cheque
Marketing_Makati Paypal
Customer Service_Sta.Rosa Cheque
Customer Service_Bacolod Mobile Payment
IT_Makati Gcash
Marketing_Cabuyao Paypal
Sales_Makati Gcash
HR_Cebu Paymaya
Finance_Makati Credit Card
IT_Quezon City Paymaya
HR_Taguig Cheque
Finance_Cebu Cheque
Operations_Makati Cheque
Marketing_Cebu Cash
Sales_Cabuyao Paymaya
Operations_Sta.Rosa Credit Card
HR_Taguig Paypal
Marketing_Sta.Rosa Cheque
IT_Quezon City Bank Transfer
Customer Service_Pasig Gcash
Operations_Davao Mobile Payment
Sales_Sta.Rosa Credit Card
Customer Service_Sta.Rosa Mobile Payment
HR_Sta.Rosa Bank Transfer
IT_Taguig Paymaya
Marketing_Cabuyao Bank Transfer
Customer Service_Quezon City Gcash
Customer Service_Bacolod Credit Card
Operations_Sta.Rosa Gcash
Customer Service_Makati Paypal
IT_Davao Cheque
HR_Taguig Paypal