Excel Data Analysis with Claude AI (Step-by-Step Tutorial)

Excel, will never be the same again. Now, Claude lives inside Excel. You ask a question, Claude does the work. No formulas, no Python, no plugins. Today, I'll show you how it works. We'll use the famous penguin data set. Why this data set? It's small, clean, and easy to learn. Perfect for beginners. We will load it, clean it, explore it, and build charts. All with simple questions, no code. By the end of this video, you can analyze any data set in Excel. Ready? Let's go. Let's open a blank Excel spreadsheet. To use Claude in Excel, we need to install the add-in first. Go to home tab, click on add-ins, search for Claude by Anthropic for Excel, and click add. A quick note, you need the Claude Pro, Max, Team, or Enterprise plan to use this. After installing, you will see the Claude icon in the home ribbon. Let's click on it to open the chat panel. Sign in with your Claude account, and that's it. Claude is ready to help. Now, let's load our data set. For this video, I am using the Opus 4.7 model. You can see it here. We will use the famous penguin data set from GitHub. Load it. We just share the link with Claude. Load the penguin data set into this sheet from this link. Now, let's paste the GitHub link like this. Watch what happens. Claude fetch the data from the link, then adds it to our sheet, and there it is. Our data set is loaded as a table. Quick tip, Claude loaded the data as a table. This is important. Why? Because Claude works much better with tables than with plain cells. Tables have clear column names, types, and structure. The rule is simple. Always use tables when working with Cloud. You can also download the file and open it in Excel yourself. But with Cloud, it's just one prompt. Our data is ready. Let's start exploring it. Now, our data is loaded. Let's clean it. This step is called data pre-processing and it's very important. You know the saying, "Garbage in, garbage out." If our data is not clean, our analysis will be wrong. So, let's fix that. First, let's check for missing values. We just ask Cloud with this prompt, "Check for missing values in this data set." And here we go. Cloud found some missing values. Some columns also have missing values. Now, let's handle them. There are two simple ways to do this. One, remove the rows with missing values. Two, fill them with the mean or the most common value. In this video, we will remove them. A quick note, when you remove rows, you also lose data. In real project, filling values is often better. But for this video, we keep it simple. Let's use this prompt, "Remove the rows that have missing values and save the new data to a new sheet." And just like that, Cloud cleaned our data. Now, our data is clean. Let's explore it. This step is called data exploration. The goal, understand the data before we create any charts. Let's start with the basics. First, the shape of our data set. How many rows and columns does this data set have? Now, we know the size of our data. Next, let's look at the column names and their types. Show me the column names and data types. The kinds of columns, categorical and numeric. Let's get a quick summary of the numeric ones. Give me a basic statistics for the numeric columns. Mean, minimum, maximum, very useful for a first look. Now, the categorical columns. How many penguins of each species? Count the number of penguins for each species. And there we go. Three species, Adelie, Chinstrap, and Gentoo. Now, we know our data. Time to make it visual. Let's create some charts. Now, comes the fun part, data visualization. Charts help us see pattern that numbers alone cannot show. Let's create four charts to understand our penguins better. Let's start simple. How many penguins do we have for each species? Let me write, create a bar chart showing the number of penguins for each species. Nice. Adelie is the most common species in our data set. Next, let's see the distribution of body mass. Create a histogram of the body mass column. Here you go. Most penguins weigh between 2,000 and 4,500 g. Let's go one step further. A scatter plot is perfect for comparing two numeric columns. Let's check the relationship between flipper length and body mass. Create a scatter plot of flipper length versus body mass and color the points by species. Hmm, the chart looked a bit small. And this is important. If you don't like the result, just ask again. Claude works like a real assistant. Let's make it bigger and easier to read. Resize the scatter plot to fit the data better and make it larger. Look at this. There is a clear pattern. Penguins with longer flippers usually have more body mass. And look, gentoo penguins are the largest of all three species. Finally, let's create a box plot to compare bill length across species. Let me write, create a box plot of bill length for each species. Our plot is ready. Each species has a different bill length range. Adelie penguins have shorter beaks. Chinstrap and gentoo have longer ones. And that's it. With just a few prompts, we created four powerful charts. No code, no formulas, no struggle. This is the magic of Claude in Excel. So, let's recap what we did today. We loaded the penguin data set into Excel with just a simple prompt. Then, we cleaned the data by removing missing values. After that, we explored the data set to understand its structure. And finally, we created four powerful charts. A bar chart, a histogram, a scatter plot, and a box plot. All of this without writing a single line of code. This is the power of Claude in Excel. Now, here's the best part. You can use the same workflow with any data set. Sales data, customer data, finance data, any project you're working on. Just load, clean, explore, and visualize. That's it. If you found this video helpful, like the video. It really helps the channel grow. And subscribe for more AI tutorials like this one. Now, I have a question for you. What data set do you want to see next? Sales, marketing, finance, something else. Drop it in the comments. I read every single one, and your idea might be in the next video. Thanks for watching. See you in the next video.