Data Analysis with ChatGPT in Excel

Leverage code interpreter to boost productivity in data analysis with ChatGPT, uploading data and engaging with data analysis, including exploratory data analysis, preprocessing, and visualizations, without Python or Excel formulas.

Evaluate how Code Interpreter reshapes data analysis without replacing data science education. Show how non-data experts can perform basic analyses and fuel demand for advanced data skills.

Explore the limitations of ChatGPT's code interpreter in data analysis with Excel, including no database connections, no internet or api access, and file size or time limits.

Explore exploratory data analysis as the first step to turn raw data into patterns and insights, using real-world transaction data and pre-processing to reveal patterns, anomalies, and relationships.

Explore exploratory data analysis with descriptive statistics for every column across two sheets in Excel using ChatGPT, including count, mean, standard deviation, min, quartiles, median, max, and next steps.

Identify outliers through exploratory data analysis to reveal data collection errors, distortions in central tendency, and anomalies, offering unique business insights from course count, sign in count, and unsubscribe data.

Explore correlation analysis and hypothesis formulation with ChatGPT in Excel, uncovering how variables relate and generating feature ideas to inform business decisions.

Craft a 5W1H-based prompt and a seasoned data analyst persona to guide ChatGPT in analyzing a 365 data science dataset, identifying missing values and territorial insights.

Fix inconsistent company names in a sales transactions dataset through preprocessing and code-assisted cleaning in ChatGPT code interpreter, producing a cleaned Excel file with standardized, correctly named entries.

Learn how to verify data for errors in Excel using ChatGPT, spotting missing values, duplicates, data type mismatches, and city country pairs, with prompt refinement guidance.

Use ChatGPT in Excel to detect duplicate rows and clean data. Identify inconsistencies and data entry errors to prevent distorted analysis; next lectures cover further preprocessing tasks.

Learn how to fix unit discrepancies by using ChatGPT code interpreter to convert heights from feet and inches to centimeters, adjust the header, and generate an Excel output in centimeters.

Explore how ChatGPT code interpreter aids data preprocessing in Excel by separating country and city from a single cell, tackling delimiter challenges and prompt design.

Organize messy data in Excel using the ChatGPT code interpreter to pre-process, clean, and standardize datasets. Add brand and manufacturer details so each row represents a unique product for analysis.

Map a list of financial items to P&L categories using ChatGPT in Excel, covering revenue, COGS, operating expenses, depreciation and amortization, interest, and taxes, while refining prompts to improve outputs.

Classify each student’s grade from 0 to 100 into poor, fair, good, or brilliant using an Excel-based workflow and Code Interpreter automation, ensuring accurate classifications on the student grades sheet.

Learn how to order data in excel using chatgpt by sorting salespeople by country across two sheets, with prompts that specify country and contact columns, and preserve the original structure.

Learn how to use ChatGPT to generate and apply countifs and sumifs formulas in Excel, to compute total sales per country across two sheets.

Explore how to use lookup functions with ChatGPT data analysis to populate city data in Excel, comparing hardcoded results with vlookup and index-match formulas for email-based lookups.

Rank the top five selling agents by sales, populate the rank sheet from the database, and apply Excel formulas such as IFS, rank, and Index and Match.

Explore how to use ChatGPT to fill brand data in Excel by propagating values down until the next non-blank cell, using well-structured prompts and formulas for efficient data analysis.

Explore using ChatGPT to translate logic into Excel formulas for data analysis, including a two-condition example that marks 'yes' when cars or trucks are sold out, boosting productivity.

Pre-process text data with ChatGPT to correct inverted names in the contact column, comparing Excel's text to columns tool and a prompt-driven approach that fixes names efficiently.

Learn how to preprocess text data by detecting and removing leading and trailing spaces in Excel datasets with ChatGPT, adjusting the data frame, and producing a cleaned file.

Standardize city name capitalization in Excel by applying the standard practice of capitalizing the first letter of each word, demonstrated through a preprocessing workflow with ChatGPT prompts.

Translate multilingual text in an Excel column with ChatGPT, showing how prompt structure affects results, then load data, translate titles to English, and save a new file.

Learn to run multiple find and replace operations in Excel in one pass using ChatGPT's code interpreter, replacing abbreviations with full company names from the database sheet.

Perform criteria-based duplicate removal in Excel by using two columns (name and ID) to treat same name with different IDs as unique, with ChatGPT in Excel and case sensitivity.

Use ChatGPT to derive a single list of unique names from both incoming and outgoing students columns, demonstrating multi-column deduplication in Excel and achieving 74 unique names.

Discover how to obtain the day and month from a date in Excel using ChatGPT prompts and date time conversions. Load data, apply simple formulas, and verify results.

Convert hours to decimals in Excel using ChatGPT for hours minutes seconds formats. See how 1 hour 30 minutes becomes 1.5 and how a formula converts column b to decimals.

Calculate ages from birth dates in an Excel file using ChatGPT, outputting ages in years, months, and days for a quick, accurate preview before download.

Learn to use ChatGPT to sort an Excel table chronologically by the order received date, and optionally save the sorted results to a new file.

Discover how to pre-process data with ChatGPT in Excel, including cleaning, handling missing values, feature engineering, outlier checks, date formatting, and country-level encoding.

Preprocess the free plan users sheet in Excel by handling missing values, dropping src, encoding unsubscribe as 1/0, and extracting active duration and date parts.

Learn how to preprocess the free plan users sheet in Excel with ChatGPT, including handling missing values, feature engineering, and converting 0 to 6 day codes to names.

Analyze the transactions sheet by adding a monthly or annual subscription column, group multiple transactions per user, divide monetary values by 100, and map coupons to reveal sales drivers.

Map country abbreviations to full names and continents in Excel using remove duplicates and a ChatGPT mapping table for the transactions sheet.