You are an HR analyst at a company. You have been given a spreadsheet containing the performance data of salesmen and their respective line managers. Your task is to analyze the data to determine incentives for the salesmen.

Data Provided:

1. Salesmen Data (SalesmenData.xlsx):

   • Salesmen Sheet:
     • SalesmanID
     • Name
     • Region
     • LineManagerID

2. Performance Data (PerformanceData.xlsx):

   • Performance Sheet:
     • SalesmanID
     • Month
     • SalesAmount

3. Line Managers Data (LineManagersData.xlsx):

   • LineManagers Sheet:
     • LineManagerID
     • Name
     • Department

Tasks:

1. VLOOKUP:

   • Use VLOOKUP to create a combined report that includes each salesman’s name, region, line manager’s name, and their total sales for the year.

2. COUNT:

   • Count the number of salesmen managed by each line manager.

3. Conditional Formatting:

   • Apply conditional formatting to highlight salesmen who achieved sales above a certain threshold (e.g., $100,000).

4. Chart:

   • Create a chart showing the total sales per region.

5. Pivot Table:

   • Create a pivot table to summarize the total sales by line manager and by region.