DeepSeek AI + Excel VBA Automation Masterclass

“Hi and welcome back. In today’s video, we’re going to learn two very important things. First, how to activate the Developer tab in Excel. And second, how to run your very first VBA script, where we will copy data from a CSV file into a new Excel workbook and save it as a proper Excel file. This is one of the simplest VBA tasks, but it’s the foundation for everything you will learn later. So let’s get started.

Right now, I have a blank Excel workbook open, and as you can see, the Developer tab is not activated. To enable it, I’ll click on the File menu, then click on Options. The Excel Options window appears. On the left side, I’ll select ‘Customize Ribbon’. On the right side, there are many checkboxes. If I scroll down, I can see the option called ‘Developer’. I’ll check this box and press OK. Now the Developer tab is visible at the top of Excel, and we’re ready to begin working with VBA.

Next, I have a CSV file that contains some sample data. My goal is to copy all the data from this CSV file, paste it into a new blank Excel workbook, and save it as a proper Excel file. To automate this, I wrote a simple prompt and pasted it into DeepSeek AI. Once I hit the Send button, DeepSeek started generating the VBA code. This prompt is available in the course resources section, along with the VBA code. You can change the file name and file path based on your own requirements.

Once DeepSeek finished generating the code, I copied it and returned to my blank Excel workbook. I clicked on the Developer tab, and on the top-left side, there is a button called ‘Visual Basic’. When I click it, the VBA editor window opens.

Inside the VBA editor, I clicked on the Insert menu and selected ‘Module’. A Module is simply a container where we write or store our VBA code. Think of it as a blank page inside Excel where you can type instructions. Every time you want to create a new macro or paste AI‑generated code, you place it inside a Module. Without a Module, Excel has no place to store your script.

After selecting Module, a blank white screen appeared. This is where I pasted the VBA code that DeepSeek generated. Once the code was pasted, I closed the VBA window.

Now, back in Excel, I clicked the ‘Macro’ button. A Macro is basically a stored action or a small program that performs a task. When you click the Macro button, Excel shows you a list of all the macros available in your workbook. You can select the macro name and click Run to execute the code. In simple words, the Macro button is how you tell Excel to start the automation.

So I clicked Run, and the script started processing. Within a moment, a pop‑up message appeared saying: ‘CSV successfully converted to Excel and saved at…’ followed by the file path. I opened the file, and the data was copied perfectly. The CSV content was now saved as a clean Excel file.

This was a simple copy‑and‑paste automation, but it’s an important first step. In the next section, you will learn how to convert the same data into a professional‑looking dashboard using VBA and AI.

Until then, I hope you enjoyed this video, and I’ll see you in the next one.”

“Hello and welcome back. In today’s tutorial, we’re going to learn how to transform a raw CSV file into a clean, professional‑looking dataset using AI and Excel VBA. This is a very common real‑world task, especially when you receive daily or weekly CSV exports from systems that don’t format data properly. So let’s get started.

Here I have a single CSV file containing raw data. As you can see, the dates are displayed in Excel’s number format, the numeric figures are not comma‑separated, and the percentage values do not have percentage signs. In short, the dataset is completely raw and not ready for reporting. Our goal is to convert this messy CSV file into a polished, readable, and professional dataset automatically using DeepSeek AI and VBA coding.

I prepared a detailed prompt for this automation, and you can download it from the tutorial resources section. You can modify the prompt based on your file paths, sheet names, or formatting requirements. Once the prompt is ready, I copied it and pasted it into DeepSeek AI. DeepSeek immediately started generating the VBA code, and once the code was complete, I copied it.

Next, I opened the same CSV file and clicked the Visual Basic button. Inside the VBA editor, I selected Insert and then Module. A blank white screen appeared, and I pasted the VBA code there. After closing the window, the macro was ready to run.

One important note: because this is a CSV file, any VBA code you add will not be saved permanently. CSV files cannot store macros. If you want to reuse the macro in the future, you must save the file as a macro‑enabled workbook. For this demonstration, we will run the macro directly from the CSV file.

Now I clicked the Macro button and pressed Run. A pop‑up message appeared saying “Formatting complete. File saved.” I clicked OK, and instantly the CSV file was transformed. The dates were converted into proper date format, the numbers were formatted with commas, the percentages were displayed correctly, and the entire dataset looked clean and professional. It’s amazing how quickly VBA can process and clean raw data.

This automation saves a huge amount of time, especially if you work with CSV files regularly. I hope you enjoyed this tutorial, and I’ll see you in the next one.”

“Hello and welcome back. In today’s tutorial, we’re going to learn how to convert numeric values into words inside Excel using AI and VBA. This is extremely useful when preparing invoices, purchase orders, quotations, payment vouchers, or any document where both numbers and numbers‑in‑words are required. So let’s get started.

Here in my Excel sheet, I have several different numbers prepared for testing. I want to make sure the solution works for whole numbers, decimal values, and larger figures. To generate the VBA function, I prepared a detailed prompt that explains exactly what I need. The prompt is available in the tutorial resources section, and you can modify it based on your own requirements.

The prompt says: ‘Create an Excel VBA function to convert the number in cell E3 into words. Example: 15430.75 → USD Fifteen Thousand Four Hundred Thirty & Cents Seventy Five Only. The function should use USD as the currency, convert the whole number into words, convert the decimal portion into cents, return the result as text, handle whole numbers and decimal amounts correctly, and be usable directly in Excel as a formula, for example: =NumberToWords(E3).’

I copied this prompt and pasted it into DeepSeek AI. DeepSeek immediately started generating the VBA code, and once the code was complete, it also provided the formula that we will use inside Excel.

Next, I opened my Excel file, clicked the Developer tab, and opened the Visual Basic editor. Inside the editor, I clicked Insert and then Module. A blank screen appeared, and I pasted the VBA code there. After closing the window, the function was ready to use.

This time, we don’t run a macro. Instead, we use the formula that DeepSeek provided. I copied the formula and pasted it into the cell next to my number. Instantly, the number was converted into words. I copied the formula down to the remaining cells to test different values, and every result was accurate. The function correctly converted whole numbers, decimal values, and larger figures into proper currency wording.

Before finishing, make sure to save your Excel file as a Macro‑Enabled Workbook so you can use this function again in the future.

I hope you enjoyed this tutorial, and I’ll see you in the next one.”

“Hello and welcome back. In today’s tutorial, we’re going to learn how to copy specific columns from an Excel file, create new region‑wise Excel files, paste the selected data, and save them automatically. The best part is that the VBA script will first ask you to browse and select the source file, and then it will generate all the required output files in just a few seconds. This automation is extremely useful for repeated office tasks, especially when working with pricing, product uploads, or region‑based reporting.

This example comes directly from my real office workflow. I often need to upload pricing into our system region by region. Every time we receive a new shipment or a price update, I used to manually copy the SKU and pricing columns for each region, create separate files, and save them one by one. Since we have six regions, this repetitive work used to take more than ten minutes every time. So I created an AI‑generated VBA solution that completely eliminates the manual effort and reduces the entire process to just a few seconds. In this tutorial, you will learn exactly how to build the same automation.

Here in my Excel file, I have a dump sheet containing SKUs and region‑wise pricing. Imagine that for each region, I need a separate file ready for upload. That means copying the same two columns six times, creating six new files, and saving each one individually. Instead of doing this manually, we will automate everything using AI and VBA.

I prepared a detailed prompt that explains all the steps. The prompt also includes an instruction that the macro should first ask the user to browse and select the source file before starting the process. You can download this prompt from the tutorial resources section and modify it based on your own file paths and region names.

I copied the prompt and pasted it into DeepSeek AI, then pressed the Send button. DeepSeek started generating the VBA code, and once the code was complete, I copied it.

Next, I opened my Excel file, clicked the Developer tab, and opened the Visual Basic editor. Inside the editor, I clicked Insert and then Module. A blank screen appeared, and I pasted the VBA code there. After closing the window, the macro was ready to run.

Now I clicked the Macro button and pressed Run. Immediately, a browse window appeared asking me to select the source file. I selected the dump file, and the automation started processing. Within seconds, it created six region‑wise files. I opened each file to verify the results, and everything was perfect. The correct columns were copied, the correct regions were separated, and all files were saved automatically.

This automation is incredibly fast. A task that normally takes more than ten minutes manually was completed in less than five seconds using VBA. This is the power of combining AI with Excel automation.

I hope you enjoyed this tutorial, and I’ll see you in the next video.”

“Hello and welcome back to another exciting tutorial. Today, we’re going to learn how to automate a complete daily routine task using AI and Excel VBA coding. So let’s get started.

This example comes directly from my real office workflow. Every day, I prepare a sales report for management. Normally, I copy the dump data into the sales report, update the dashboard, and then send everything by email. In this tutorial, you’ll learn how to perform all of these steps with one single click. Sounds interesting, right?

Here I have two Excel files. The first file is the Dump file, where I store my raw sales data. The second file is the Daily Sales Report, where I need to paste the dump data. As you can see, both files contain similar columns such as Date, Country, Location, Category, and more. The dashboard sheet inside the Daily Sales Report updates automatically once the dump data is refreshed.

Now, I’ll open DeepSeek AI and paste my prompt. I wrote: “Create an Excel VBA macro to automate the following process…” Then I listed all the steps required for the automation. At the end of the prompt, I added: “The macro should include proper error handling, ensure the required workbooks and Outlook are handled correctly, and complete the entire process automatically with one button click.”

This same prompt is available in the course resources. You can update your file paths and use it directly.

Once I clicked the Send button, DeepSeek started generating the VBA code.

I copied the code, opened my Daily Sales Report, clicked the Developer tab, and selected Visual Basic. A new window opened. From the menu, I clicked Insert → Module, and a blank screen appeared. I pasted the VBA code there and closed the window.

Next, I clicked the Macro button. A small window appeared showing the macro name we just created. I clicked Run, and the automation started.

Within seconds, the process was completed. VBA copied the dump data, pasted it into the Daily Sales Report, updated the dashboard, opened Outlook, wrote the email address, subject line, and email body, pasted the dashboard image, saved the Daily Sales Report, and closed it. All automatically. It’s impressively amazing.

To make this even easier, I created a button for one‑click automation. On a blank sheet, I clicked the Developer tab, selected Insert, and chose the Button (Form Control) option. I dragged the button onto the sheet, and the Assign Macro window appeared. I selected the macro we created and clicked OK. Then I renamed the button to “Click” — or any name you prefer.

Now, instead of multiple steps, I simply click the button and the entire process runs automatically.

I hope you enjoyed this tutorial, and I’ll see you in the next one.”

“Hello and welcome back. In today’s tutorial, we’re going to create a Location‑Wise Inventory Health Report in Excel, and then build a VBA automation that automatically selects all Low Inventory items and emails a professional report to the inventory team.

This workflow is extremely useful in real office environments, especially in retail, warehouse, and supply‑chain operations.

Let’s get started.

Here I have my main DUMP report, which contains columns such as Date, Country, Location, Category, Sub‑Category, Sale Quantity, GP%, Mall Ranking, and Inventory. Using this data, I created a Pivot Table on the next sheet. The pivot highlights all Low Inventory items in red. These red cells indicate locations where inventory coverage is below the required threshold.

Our goal in this tutorial is simple: Identify all red‑highlighted low‑inventory lines Extract them into a clean, professional‑looking report Automatically email that report to the inventory team All done with one single click using VBA and AI

To generate the VBA code, I prepared a detailed prompt that explains every step of the automation. This prompt is available in the tutorial resources section. You can modify it with your own folder paths, file names, and sheet names.

I copied the prompt and pasted it into DeepSeek AI. DeepSeek started generating the VBA script. Once the code was ready, I copied it and opened my report file.

Next, I clicked the Developer tab, opened Visual Basic, went to the Insert menu, and selected Module. A blank screen appeared, and I pasted the VBA code there. Then I closed the window.

Now I clicked the Macro button and ran the script.

Within a second, the automation completed the entire job. When I opened the attached report, it looked amazing. It selected only the Low Inventory items, organized them into a clean, professional layout, and prepared the email automatically.

This is the power of combining Excel VBA with AI. Tasks that normally take several minutes — or even hours — can now be completed instantly.

I hope you enjoyed this tutorial, and I’ll see you in the next one.”

“Hello and welcome back to this exciting tutorial. Today, you’re going to learn how to copy data from multiple Excel files and paste everything into one dump file automatically, without doing any manual work. Sounds amazing, right? Let’s get started.

This workflow is based on my real‑world office experience. I created it using DeepSeek AI and Excel VBA, and it saved me hours of repetitive work.

Here you can see my folders. Each folder contains an Excel file with shipment details. The headers are the same, but the data inside each file is different. My goal is simple: copy the data from every Excel file and combine it into one master dump file.

To achieve this, I wrote a simple prompt describing what I needed. I asked ChatGPT to convert it into a professional VBA prompt. Then I copied that prompt into DeepSeek AI because DeepSeek is free and generates VBA code very quickly.

DeepSeek started generating the VBA script. Once the code was ready, I copied it and opened a blank Excel workbook. I clicked the Developer tab, then clicked “Visual Basic.” A new window opened. From the menu, I clicked Insert → Module. A blank screen appeared, and I pasted the VBA code I copied from DeepSeek. Then I closed the window.

Next, I clicked the Macro button. A small window popped up showing the macro name we just created. That means the macro is ready to run. I clicked Run, and the automation started processing all the files.

Once it finished, a message popped up: “All files have been successfully combined.” It also showed that 223 rows were copied and saved into the dump file. This is impressive and amazing — imagine doing this manually, opening each file one by one. It would take hours. But VBA did it in less than a minute.

I hope you enjoyed this tutorial, and I’ll see you in the next one.”

“Hello and welcome to this exciting tutorial. Today, you’re going to learn how to copy data from one Excel sheet to another just by pressing Ctrl + S, without clicking any macro buttons. This is a real workflow I recently built for my office, and it saved me hours of manual work.

My manager asked me to create a single dump file for every shipment. Normally, I had to open more than 100 Excel files one by one, copy specific data, and paste it into a master dump file. It was extremely time‑consuming. But with the help of AI DeepSeek and Excel VBA, I automated the entire process and completed the task in minutes.

In this tutorial, I’m sharing the exact real‑world solution that saved me a huge amount of time.

Let’s get started.

Here I have my sample shipment file. It contains details like Shipment Reference Number, Barcode, SKU, and more. And this is my Dump Excel file, where all shipment data is collected. I also have another tutorial where I show how to open each folder, read every file, extract data, and dump it automatically.

While working on this, I got a new idea: Instead of manually copying data every time, why not modify the Allocation file so that whenever my manager finishes the file and presses Save, the data automatically gets copied into the dump file? Sounds amazing, right? That’s exactly what we’re going to learn now.

First, we convert the Allocation file from a normal Excel file into a Macro‑Enabled Workbook. This ensures that any VBA code we add will be saved permanently. Normal Excel files cannot store macros.

So, click File → Save As → choose “Excel Macro‑Enabled Workbook” and rename the file. I usually add “MAC” at the end of the file name to indicate it contains macros.

Next, I prepared a simple prompt and asked ChatGPT to convert it into a professional VBA prompt. This prompt is available in the course resources section, along with the VBA code. You only need to update your folder path.

I copied the prompt and pasted it into DeepSeek. It generated the main VBA code. However, it didn’t include the part that triggers the macro automatically when pressing Ctrl + S. So I asked another short prompt:

“Thanks. Can I also have the option that when I save this source file using Ctrl + S, the macro should run automatically?”

DeepSeek generated the additional code. I saved both pieces of code in separate Notepad files.

Now I opened my Allocation MAC file, clicked the Developer tab, and opened Visual Basic. Inside the VBA editor, I clicked Insert → Module and pasted the main VBA code.

Then I clicked “ThisWorkbook” on the left panel and pasted the second code that triggers the macro when saving the file.

After closing the VBA window, I clicked File → Save. You can also press Ctrl + S, but I want to show you what happens.

A message popped up: “Do you want to update the master file with current data?” I clicked Yes, and it started processing. Another message appeared: “Master file updated successfully!” It also showed how many rows were processed.

When I opened the master dump file, the new data was already pasted correctly. Perfect.

Sometimes AI doesn’t give 100% correct code in one attempt. It may give 70–80%. But if you keep refining your prompt, you will get the correct code in two or three tries.

I hope you enjoyed this tutorial, and I’ll see you in the next one.”

“Congratulations — you’ve reached the end of the DeepSeek AI + Excel VBA Automation Masterclass.

Throughout this course, you’ve learned how to combine the power of AI with the flexibility of Excel VBA to automate real office workflows. You started with the basics, activating the Developer tab and running your very first VBA script. From there, you progressed into formatting raw CSV files automatically, converting numbers into words, generating region‑wise pricing files, automating daily sales reports, creating inventory health dashboards, consolidating multiple files into a master dump, and even triggering VBA automation automatically when saving a file.

Each tutorial was built from real office scenarios — tasks that normally take minutes or even hours — and you transformed them into instant, one‑click or zero‑click automations. You’ve seen how DeepSeek AI can generate complete VBA scripts simply by describing your workflow clearly. And you’ve also learned that you don’t need any prior coding experience. AI handles the logic; your job is simply to explain what you want.

Along the way, you may have noticed that AI sometimes produces errors or incomplete results. That’s completely normal. Even I face the same thing. But every time you refine your prompt, add more details, or clarify your steps, the AI improves its output. This process of prompt refinement is part of becoming an automation expert, and you’ve now experienced it firsthand.

By completing all eight tutorials, you’ve built the confidence to generate VBA scripts, paste them into Excel, run them, fix small issues, and automate repetitive tasks with ease. You now have the skills to take any workflow from your office — whether it’s reporting, inventory, pricing, or data consolidation — and turn it into a smart automation that saves time, reduces errors, and boosts productivity.

This is the future of Excel. And now, you’re ready to be part of it.

Thank you for joining this course. I hope you enjoyed the journey, and I look forward to seeing you in the next tutorial or advanced automation series.”