How to do a good job with Excel: basics, functions, and how to use ChatGPT

This course is divided into 2 parts

For those new to Excel, the first one starts with very basic content such as the Excel screen layout, how to edit rows and columns, and how to enter data into cells according to the data type

Also, by applying various formats to the input data, you can create tables that are easy to understand by intuitively representing the data, and explain functions that are difficult in Excel but are essential in an easy-to-understand manner

Functions are essential for working with Excel

A function I know in my head, but it's hard to learn!!

With Eun-hee Sam, functions become easier and more fun. If you don't give up, you can conquer functions if you keep studying little by little

Second, when I need to apply a function to my work, I can get help from Chat Gpt when I'm not sure what function to use

I will explain how to ask Chat Gpt questions about my work and how to apply the answers Chat Gpt gives to my work

You can go one step further and finish tasks quickly by turning repetitive Excel tasks into macros

The macro used at this time will use VBA code

The VBA code is a bit difficult for us to create, so we can ask Chat Gpt for the VBA code

I will explain how to turn the VBA code that Chat Gpt told me into a macro in my Excel work and execute it with a macro button

How to do a good job with Excel: Those who need to take courses on basics, functions, and how to use ChatGPT

• Those who have just joined the company and are struggling with Excel

• Those who want to learn Excel systematically from the beginning

• Those who are out of breath just by opening the Excel program on my computer

• Those who need to write a function in Excel but don't know what function to use

• Those who are unable to proceed with their work due to frequent errors when working with Excel functions

• Those who need to use Excel advanced features (macro VBA code)

• People who use lots of repetitive tasks on large amounts of data

• Those who need a friend who knows Excel well

My changes after listening to this lecture

• Excel looks formidable and makes me feel confident

• I can ask ChatGPT questions about the functions I need and apply them to my work

• If my work has repetitive tasks, I can ask ChatGPT to create vba code. I can quickly finish the task by turning the code created in this way into a macro

A better me than I am now

I have become an Excel expert

Imagine!!!