Basics of Excel
Using AI to enhance your Data Analysis Workflow in Excel
Excel Formula Bot: https://excelformulabot.com/
This AI uses GPT3 (Generative Pre-trained Transformer 3) which is an autoregressive language model that uses deep learning to produce human-like text, so you can input the problem you’re trying to solve and the AI will decipher that as a conditional input in order to provide the desired output/solution.
This tool is fantastic if you’re trying to create a complex formula on your data but can’t quite get the syntax working correctly.
Excel Analyze (previously known as Ideas)
Excel for Microsoft 365 now has built in AI functionality allowing you to ask questions about your data.
Find out more information here:
https://support.microsoft.com/en-us/office/analyze-data-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4
Analyze Data/Ideas is an amazing tool that quickly enhance your day to day workflow when working with data, especially if you’re trying to analyse a certain problem very quickly, or get answers from the data for specific questions and gain different insights on your datasets.
Learning Excel in Depth
Another great resource to learn fundamental concepts of excel is https://excel-practice-online.com/
They provide interactive tutorials built into the browser to learn by doing actual problems to reinforce the skills you’re learning.