Excel API Data Integration

I'm seeking a proficient Excel developer to create a customizable call for extracting comprehensive data from the Companies House Public Data API directly into an Excel spreadsheet. The data will include company profiles, officer details, persons with significant control, and financial information when available, such as filing history, insolvency details, turnover, and employee numbers.

Key Requirements:
- Competency in Excel's Power Query and VBA programming.
- Experience with API integration, specifically the Companies House Public Data API.
- Proficiency in structuring diverse data sets within a single Excel worksheet, ensuring all related data is linked appropriately.
- Capability to configure manual data updates via inputting a list of company IDs.

The final product should provide a cohesive data overview within Excel, allowing for easy manual invocation of the API call and subsequent data update. Freelancers interested should highlight relevant experience with Excel and API data extraction projects.

Ideal Skills:
- Microsoft Excel expertise
- Power Query utilization
- VBA coding
- Strong understanding of data structures
- API integration experience
- Attention to detail
- Problem-solving capabilities