Well my friends, the future of Excel is officially here! We can now send prompts to AI from directly within the Excel grid and receive the results right back directly into our worksheet. This changes the game for all of us!! No more complex function writing, difficult data analysis tools, or spending inordinate amounts of time on researching how to perform an Excel task. How is all of this possible?! Meet: AI.ASK 🔥
AI.ASK allows us to ask AI questions that reference data that lives in our spreadsheet. The function itself has five arguments:
- Prompt Argument: the question you’d like to ask AI
- Value Argument: the data you’re asking about
- Temperature Argument: controls the randomness of AI’s response
- Max Token Argument: controls the length of AI’s response
- Model Argument: controls which AI model the prompt is going to
Check out the GIF above to see AI.ASK in action! Let’s say our boss asked us which of our customers gave us the highest value sale, but we don’t know how to calculate this. Rather than panicking, let’s just ask our new, built-in AI assistant. First we’ll enter the AI.ASK function and enter the question we’d like to send to AI as the prompt argument. Since we want AI to reference the data in our table, we’ll select the data table as our value argument to insert it into the end of our prompt. Within seconds of entering our prompt, AI lets us know that Mike Jones has the highest value sale at $250 ⚡A quick double check of our table confirms it - AI got it exactly right!
