Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Productivity

/

Task Automation

Excel Crawling: Starting Without Coding. From WEB to ChatGPT API

You can easily learn how to collect and process data using Excel's Power Query feature, even if you don't know coding. You will learn Excel crawling skills by practicing the project below together.

(4.7) 10 reviews

70 learners

  • huhjuang5228
3시간 만에 완강할 수 있는 강의 ⏰
데이터수집
Excel PowerQuery
Web Crawling
Web Scraping
openAI API
RPA

Reviews from Early Learners

What you will learn!

  • 1. Movie Ranking Collection (Web)

  • 2. Daum News Gathering (Web)

  • 3. Google Alert Collection (RSS)

  • 4. Naver Finance Daily Price (Web)

  • 5. Public Data Portal Apartment Actual Transaction Price (API)

  • 6. Collection of Naver Shopping and Blog Search Results (API)

  • 7. Excel and ChatGPT Connection (API)

If you only have basic knowledge of Excel,
Easy crawling that anyone can succeed at 🧑‍💻

I recommend this to these people

People who find coding difficult

Even if you want to be good at coding but are still new to it, you can still succeed.

For those who want to upgrade their work skills

You can crawl various data using Excel that you use for work.

Excel is still good though...

Now you need to derive insights from your data. Challenge yourself.

After class

  • You can web crawl data provided from various web pages and APIs in real time into your Excel file.

  • You will gain confidence in data collection and data analysis without having to learn Python or VBA.

  • You can utilize Power Query in various ways, such as with Power BI.

  • You can use Excel to automate business processes (RPA).

Features of this course

Let's start from the perspective of non-development and no coding.

pq_in-gang-yong-002

I only use Excel.

From start to finish, we collect data using only Excel (Excel Power Query). Using web scraping technology, we not only do simple web crawling, but also collect complex structured web pages and APIs.

8 different case projects. Including ChatGPT API.

Starting from the second lecture, we will start with 8 projects. You can apply it to your work after taking the course through various case projects that can be used in practice. We will also introduce how to do repetitive processing (RPA) of ChatGPT API connection.

Not only web pages but also APIs

GET, POST method web pages and header processing. You can experience Naver, public data portal, ChatGPT API (OpenAI API) that are widely used in Korea through hands-on projects. It is not a case that ends after testing, but an in-depth project that can actually be used.

Multi-keyword, paging processing for big data collection

We will introduce a method for collecting large amounts of data (web scraping) so that you can use the data right away in practice. We will practice case projects corresponding to each case to prepare for cases where you need to integrate and process multi-keyword search results and integrate and process content from multiple pages and content from multiple periods.

Who created this course

Things to note before taking the class

Practice environment

  • Operating System and Version (OS): Windows

  • Excel version: 2016 or later recommended. 2010 and 2013 require additional plugin installation.


Learning Materials

Player Knowledge and Notes

  • Anyone who knows how to use Excel's basic menus and copy and paste or drag can get started.

  • If you have any other suggestions or comments, please feel free to send me a message at any time.

Recommended for
these people

Who is this course right for?

  • Want to freely crawl data in Excel

  • Excel: Handle big data without limits

  • Want to automate Excel data processing

  • Those who want to experience diverse data sets

  • Those who find Python crawling difficult

Need to know before starting?

  • Excel Beginner

Hello
This is

191

Learners

18

Reviews

20

Answers

4.8

Rating

2

Courses

실전형 인공지능 분석, 빅데이터 분석, 앱 개발에 대해 경험한 내용을 여러분과 공유하고 싶습니다.

부족한 점이 있더라도 많이 응원해주시면, 더 열심히 노력해보겠습니다. 감사합니다.

Curriculum

All

36 lectures ∙ (2hr 51min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

10 reviews

4.7

10 reviews

  • choerge0599님의 프로필 이미지
    choerge0599

    Reviews 5

    Average Rating 4.4

    4

    31% enrolled

    • taehyoungkang6562님의 프로필 이미지
      taehyoungkang6562

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      • ktbae9916님의 프로필 이미지
        ktbae9916

        Reviews 4

        Average Rating 5.0

        5

        100% enrolled

        実務に役立つExcelの活用法について学ぶことができました。 Excelを使う業務の方は受講すれば大いに役立つと思います。

        • huhjuang5228
          Instructor

          こんにちは。実務にお役に立てたとのこと、私も嬉しいです。一層努力いたします。

      • seongyounchoi5044님의 프로필 이미지
        seongyounchoi5044

        Reviews 18

        Average Rating 4.7

        5

        31% enrolled

        • jihae612196님의 프로필 이미지
          jihae612196

          Reviews 2

          Average Rating 5.0

          5

          31% enrolled

          $53.90

          huhjuang5228's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!