How to Unlock the Power of AI in Excel

AI IN EXCEL

In this step-by-step tutorial, learn how to use Artificial Intelligence or A.I. in Microsoft Excel to easily and to quickly analyze your data.

Analyze Data in Excel enables you to ask questions about your data with natural language without having to write complicated formulas or code. It provides visual summaries, trends, and patterns for a great starting off point for you to dive into your data to understand insights. It provides great suggested questions or you can use it to ask your own questions.

  1. AI IN EXCEL
  2. ANALYZE DATA IN EXCEL WITH AI
  3. VIDEO STEPS
  4. RESOURCES

ANALYZE DATA IN EXCEL WITH AI

  1. Open Microsoft Excel.
  2. Open the Sample Excel workbook to follow along with this example. Alternatively, you can use your own dataset.
  3. On the Ribbon, click the Home tab -> Analyze Data
  4. This opens the Analyze Data pane where you can ask Excel your questions.
  5. Type in the question you have about the data set, for example, “How many units sold per day as a line chart”. Alternatively, you can use one of the pre-canned questions, like Percentage of total ‘Units Sold’ for each ‘Product‘.
  6. Press Enter.
  7. Excel generates a chart and PivotTable showing the answer to the question. Double-clicking on it will populate the chart and PivotTable in the Excel workbook.
  8. You can also ask Excel to come up with its own analysis by selecting Are there any date trends? Excel will then show you some interesting insights about the data. In the case with the worksheet provided, it will show outliners in the data.
  9. You can continue to refine your questions to have Excel build out interesting reporting and insights on your data.

VIDEO STEPS

  • 0:00 Introduction
  • 1:03 Analyze Data to use AI
  • 1:53 Ask questions about data
  • 3:35 Get insights and see trends
  • 4:52 Refine questions
  • 5:39 Shortcomings
  • 6:32 Automatic insights
  • 7:17 Best practices
  • 7:33 Wrap up

RESOURCES

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s