This portfolio includes four Excel spreadsheets designed to demonstrate advanced data analysis and business intelligence techniques. The first utilizes XLOOKUP to determine the youngest, oldest, and average ages of U.S. Senators, accompanied by a structured table aligning each senator with the calculated age metrics. The second spreadsheet showcases the use of pivot tables to organize, summarize, and interpret sales data from a Canadian company. The third file features a comparative statistical analysis of MLB players Nolan Arenado and Trevor Story, illustrating through data that both achieved stronger offensive performance with the Colorado Rockies at Coors Field than with their subsequent teams. The final spreadsheet highlights large-scale data filtering, reducing a dataset of over 100,000 job listings to three targeted entries identifying physicians in Connecticut, Massachusetts, and Rhode Island.