Mini Byte: Hello, Gemini. Help me write my formula - Mastering Data Cleaning, Numerical Analysis and Text Manipulation in Google Sheets
Event Description
Learn how to prompt AI to help clean datasets and write formulas in Google Sheets.
When you have a messy dataset, it can take a lot of time to clean it up before you can start analyzing. Can AI help? In this workshop, we'll collect live data and then use Gemini AI (the stand alone tool) to help clean up the data. Then, we'll use it to help do some analysis. Because we'll be working with live data live in Gemini, we don't know exactly what will happen, but that's the reality of data and data cleaning!
In this session, you will
- Craft effective AI prompts to generate Google Sheets formulas for data analysis and manipulation
- Utilize Gemini to develop regular expression formulas to extract, reformat, clean text-based data
- Develop formulas for numerical analysis using Gemini AI
https://stonybrookuniversity.co1.qualtrics.com/jfe/form/SV_dht1o3rNzlZhHka?source=event+manager&session=0815250900sheets
