Data Entry / Excel Projects
- AR AGING REPORT — This contains the AR Aging Report, which features the calculation of days past due using the "IF" formula, the Aging Category using "VLOOKUP," and how I use pivot tables to extract data from the main data source. The Pivot tab makes it understandable how much is past due and groups it according to the Aging Category. (Kindly Click "AR AGING REPORT" to open the file)
- DATA SCRAPING- I extracted data from different websites of Hotels in Los Angeles, CA. It gives information like business name, hotel category, contact number, address, and website. (Kindly Click "DATA SCRAPING" to open the file)
