inflearn logo

Build an AI-Powered Excel Macro Real Estate Analysis Tool Without Knowing How to Code

No coding experience needed! In this hands-on project course, you’ll use ChatGPT and Excel VBA to collect real estate data, analyze actual sale and rental prices, and build your own real estate analysis program. Let AI handle the complex code so you can focus on analyzing the data and using the program.

1 learners are taking this course

Level Beginner

Course period Unlimited

Excel
Excel
AI
AI
ChatGPT
ChatGPT
VBA
VBA
Business Productivity
Business Productivity
Excel
Excel
AI
AI
ChatGPT
ChatGPT
VBA
VBA
Business Productivity
Business Productivity

What you will gain after the course

  • You can create Excel VBA macro programs with ChatGPT, even without any coding experience.

  • You can collect real estate transaction data and organize it in Excel using the Public Data Portal API.

  • You can analyze apartment sales and lease data and compare transaction trends and price movements by region.

  • You can intuitively understand the collected real estate data by visualizing it in charts and analysis tables.

  • You can use AI to modify the features of existing Excel programs and add new analysis capabilities.

With ChatGPT and Excel VBA

Build Your Own Real Estate Transaction Price Analysis Program

It's okay if you don't know how to code.


Get help from ChatGPT with complex VBA code, and

Build a program that analyzes real estate data and runs directly in Excel.

Using real estate transaction data from the Public Data Portal

This is a course on creating a macro program to analyze sales and rental market trends by region.

Dashboard Creation Screen

Are you still analyzing real estate transaction prices by hand?

To analyze real estate data, you need to review transaction records across multiple regions, download the necessary data, and organize it.

Comparing prices by region and tracking changes in transaction volumes also require repetitive Excel work.

Now automate repetitive data organization and analysis with Excel macros.

This course is not about memorizing VBA syntax from scratch.

Describe the functionality you need to ChatGPT, then apply the generated code in Excel.

You’ll learn how to create a program that actually works.

Plan the functionality → Generate code with AI → Apply it in Excel → Run and refine

Reduce the burden of writing code yourself and focus on the experience of implementing the features you want.


Are you putting off analysis because you have to look up actual transaction prices one by one and transfer them to Excel?

To check actual real estate transaction data, you have to search across multiple websites, download the data you need, and organize it in Excel.

Comparing transaction volumes or price trends across regions also requires repetitive data organization and calculations.

Now automate repetitive tasks and focus on data analysis!

In this course, you’ll build a program using ChatGPT and Excel VBA to collect and analyze actual real estate transaction data.


This course is for people like you!


① Office workers who want to automate tasks in Excel

  • Those who want to cut down on repetitive data collection and organization work

  • Those who want to try creating Excel macros without any coding experience

  • Anyone who wants to improve their work efficiency using ChatGPT

② People who want to analyze real estate data themselves

  • Those who want to use actual transaction price data from the Public Data Portal

  • Those who want to compare sales and rental transaction trends by region

  • Those who want to track monthly transaction volumes and price trends firsthand.

  • For those who want to analyze collected data using tables and charts

③ For those who want to create their own programs with AI

  • For those with no programming experience who want to try creating an automation program

  • People who want to ask ChatGPT for the features they need and generate VBA code

  • People who want to apply AI-generated code in Excel and try running it.

  • Those who want to complete a hands-on project from start to finish.


What You’ll Learn in This Course


1. Creating Excel VBA Programs with ChatGPT

Learn how to request the features you want from ChatGPT and apply the generated VBA code in Excel.

2. Collecting Real Estate Transaction Data Using the Public Data Portal API

Learn how to retrieve actual real estate transaction data and organize it into a format suitable for analysis.

3. Regional Real Estate Transaction Data Analysis

Learn how to use sales and rental data to compare transaction trends and price movements by region.

4. Visualizing Analysis Results

Present transaction volume and price data in tables and charts so that the analysis results can be easily reviewed.

5. Integrating and Completing the Automation Program

Integrate the functions for data collection, organization, analysis, and reviewing results into a single Excel program.



Even if you don’t know how to code, you can create your own analysis program!

The goal of this course is not simply to copy and run VBA code.

Ask ChatGPT for the functionality you want,

an experience in understanding and using the generated code to complete a working program

Automate repetitive data collection and organization, and spend more time understanding and analyzing the data.

Start automating your Excel tasks with AI alongside the Early Leave Automation Lab!


Notes Before Taking the Course


Practice Environment

  • A PC with the Windows operating system installed is required.

  • Microsoft Excel desktop application is required.

  • An internet connection that allows you to use ChatGPT is required.

  • Basic settings are required to run Excel macros (VBA).

Prerequisites and Important Notes

  • You can take this course even without coding experience.

  • Basic knowledge of how to use Excel is sufficient.

  • You may need to sign up for the Public Data Portal and apply to use its API.

  • Code generated by ChatGPT may need to be modified depending on the execution environment, and the course covers this process as well.

Learning Materials

  • You will learn using the practice materials and example files used in the course.

  • Implement real estate data collection and analysis capabilities through step-by-step exercises.

  • You can apply what you learn in the course and expand it into analysis features that meet your needs.


Recommended for
these people

Who is this course right for?

  • An office worker who wants to create their own Excel automation program without learning to code

  • A beginner real estate investor looking to collect and analyze actual property transaction prices in Excel

  • An AI beginner who wants to try creating a working program with ChatGPT.

  • Professionals who want to automate repetitive data collection and organization tasks

  • Learners who want hands-on experience with real-world projects using Excel VBA

Need to know before starting?

  • No programming experience, such as Python or VBA, is required.

  • A basic understanding of how to use Excel (opening files, entering data in cells, and managing sheets) is sufficient.

  • Microsoft Excel must be available in the Windows environment.

  • I need an environment where I can use ChatGPT.

  • You may need to sign up for the Public Data Portal and apply to use its API.

Hello
This is fasthome

Career Verified

93

Learners

7

Reviews

4.6

Rating

10

Courses

Automate repetitive tasks and focus on what matters.

Hello. This is the Early-Leave Automation Lab.

Based on problem-solving methods developed through approximately 15 years of hands-on software experience, I teach AI and office automation that anyone can apply to their work.

What you can learn here

  • Automating repetitive tasks using Excel, VBA, and Python

  • Creating practical programs with ChatGPT to reduce the burden of coding

  • Automation of stock and real estate data collection and analysis

  • Business process automation connecting Word, PowerPoint, and Outlook

We focus not merely on learning functions, but on creating results that you can execute yourself.

Automation you can use, not just automation you learn.

This is the On-Time Departure Automation Lab.


YouTube: https://www.youtube.com/@fasthome8282

Blog: https://blog.naver.com/fasthome

More

Curriculum

All

24 lectures ∙ (4hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

fasthome's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal

$17,820.00

70%

$46.20