강의

멘토링

커뮤니티

BEST
AI Technology

/

Deep Learning & Machine Learning

Deep Learning with Excel

Let's visually learn the principles of deep learning using Excel.

(4.8) 18 reviews

519 learners

Level Beginner

Course period Unlimited

  • hjk1000
딥러닝
딥러닝
엑셀
엑셀
Excel
Excel
Deep Learning(DL)
Deep Learning(DL)
VBA
VBA
딥러닝
딥러닝
엑셀
엑셀
Excel
Excel
Deep Learning(DL)
Deep Learning(DL)
VBA
VBA

Reviews from Early Learners

Reviews from Early Learners

4.8

5.0

753kg

100% enrolled

Most introductory deep learning courses focus on using functions and looking at the resulting data, so I was curious about the process of creating and training models. This lecture was exactly what I wanted. It was fun to visually see the Excel implementation with easy examples. Thank you!

5.0

박언상

100% enrolled

Understanding machine learning concepts was easy with the explanation using Excel.

5.0

이승진

60% enrolled

It was a bit difficult for me as a liberal arts major in terms of mathematics, but I think it's the best for understanding deep learning concepts! Thank you!

What you will gain after the course

  • Deep Learning Basics

  • Excel Usage

Let's learn the basics of deep learning using Excel.

Deep learning, a core component of artificial intelligence technology, is a model capable of autonomously learning and predicting patterns within complex data. However, this powerful technology ultimately operates through mathematical calculations and iterative optimization processes. Experiencing this process through hands-on experience provides a much deeper understanding than simply learning the theory. Excel, one of our most familiar tools, allows us to visually represent and directly manipulate formulas and data, making it an ideal tool for experiencing the deep learning learning process.

The purpose of this lesson is to implement directly in Excel how a deep learning model processes input data, calculates the difference between the predicted result and the actual value, and then adjusts the parameters to reduce this error. To do this, we will first start with the simplest form of deep learning model, the linear regression model. For example, the output value yyy follows the formula y=wx+by = wx + by=wx+b for the input value xxx, or y=w1x1+w2x2+by = w_1x_1 + w_2x_2 + by=w1​x1​+w2​x2​+b in multivariate expansion. The difference between the value predicted by this model and the actual value is measured through the 'loss function', and the model's parameters www and bbb are adjusted in a way that minimizes this loss.

This parameter adjustment utilizes an optimization algorithm called "gradient descent." Gradient descent works by calculating the gradient of the loss function and gradually adjusting the parameters based on that gradient. Mathematically, this process involves differentiation and matrix operations, and in deep learning, the "backpropagation" algorithm, which automatically handles this process, is at the core.

In Excel, each step (input, weight multiplication, output calculation, loss calculation, gradient calculation, parameter update) can be configured cell by cell. For example, input values and weights can be entered into separate cells, then multiplied to obtain a predicted value. The loss can then be calculated as the difference between the predicted value and the actual value. The gradient can then be calculated based on the loss, and the weights can be adjusted based on this, allowing the model to be gradually optimized.

Furthermore, by directly structuring these processes using Excel formulas, you can implement the core logic of deep learning by hand, without the need for frameworks like Python's TensorFlow or PyTorch. This goes beyond simple implementation; it greatly contributes to a deeper understanding of the internal structure and operating principles of deep learning.

In conclusion, we will utilize the familiar tool of Excel to directly implement and visualize core elements of deep learning, including basic concepts, learning structures, loss functions, gradient descent, and backpropagation. This will allow us to go beyond theoretical understanding and gain practical insights and intuition. Let's work through this process step by step and develop a fundamental understanding of deep learning together. Now, let's fully enter the world of deep learning!

Recommended for
these people

Who is this course right for?

  • Those new to deep learning and curious about its principles

  • Anyone interested in implementing Deep Learning basics using Excel

Hello
This is

1,575

Learners

44

Reviews

10

Answers

4.7

Rating

11

Courses

안녕하세요

비전공자로 딥러닝을 열심히 공부하는 직장인입니다.

공부하면서 느낀 점들을 여러분들과 함께 공유하고 싶습니다

감사합니다.

Curriculum

All

10 lectures ∙ (1hr 25min)

Published: 
Last updated: 

Reviews

All

18 reviews

4.8

18 reviews

  • jadeyoonlee6615님의 프로필 이미지
    jadeyoonlee6615

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    • hjk1000
      Instructor

      Thank you

  • kbjun224137님의 프로필 이미지
    kbjun224137

    Reviews 5

    Average Rating 5.0

    5

    60% enrolled

    • hjk1000
      Instructor

      Thank you for the course review

  • gwangyang2435897님의 프로필 이미지
    gwangyang2435897

    Reviews 3

    Average Rating 5.0

    5

    30% enrolled

    • hjk1000
      Instructor

      Thank you for the course review

  • chunsun2님의 프로필 이미지
    chunsun2

    Reviews 3

    Average Rating 4.0

    4

    30% enrolled

    • hjk1000
      Instructor

      Thank you for the evaluation

  • zzanggu6820님의 프로필 이미지
    zzanggu6820

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    • hjk1000
      Instructor

      Thank you so much!

$4.40

hjk1000's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!