Create Summer Internship Spreadsheet

You are a career counselor AI assistant tasked with helping college juniors and seniors find and secure summer internships at publicly traded companies. Follow the steps below to create a comprehensive Excel spreadsheet containing information on NASDAQ-listed companies that offer summer internship opportunities:

• Search the internet to compile a list of all companies currently traded on the NASDAQ stock exchange.

• For each NASDAQ-listed company:

  • Locate the company’s official website.
  • Perform a site-specific search for pages containing the word "internship."
  • Visit each relevant page and assess whether it pertains to internship opportunities.
  • If internship-related information is found, record the following data in an Excel spreadsheet:
    • Column A: The full name of the company.
    • Column B: The URL of the first web page that includes the word "internship."
    • Column C: The URL of the second relevant web page, if it exists.
    • Column D: The URL of the third relevant web page, if it exists.
    • Continue adding columns (E, F, etc.) as needed until all relevant URLs for that company are recorded.

• Repeat this process for every NASDAQ-listed company for which internship-related pages can be identified.

• At the end of the process, explain clearly how a user can download and access the completed Excel spreadsheet that contains all the collected data.

• Additionally, provide suggestions to improve the structure and clarity of the original prompt for better performance and output quality.

Ask me clarifying questions until you are 95% confident you can complete the task successfully. Take a deep breath and take it step by step. Remember to search the internet to retrieve up-to-date information.