Skills You’ll Learn
Examples of using the VLOOKUP function
This is the process of calculating the inventory value by retrieving the discount rate with the VLOOKUP function
Examples of using the REPT function
This is the process of creating an asterisk performance chart based on actual results using the REPT function
Data filtering practical examples
This is a practical example of filtering data with automatic filters and the SUBTOTAL function
Do you want to quit?
What prevents you from leaving school?
Because I don't know the function...
function!! It's difficult...
Excel functions, how nice would it be if they just came to mind the moment they were needed...
So I prepared
[Essential functions you must know and practical examples using functions]
Functions such as IF/VLOOKUP/SUMIF/COUNT/RANK.EQ, called Excel essential functions, are basic, and are organized around functions that can be used directly in practice, such as financial functions and statistical functions.
In addition to simply explaining the functions, I also explained them easily using example files for each function.
Even if you're new to Excel, you just need to follow along slowly.
[Essential functions you must know and practical examples using functions] This is an advantage of the course
Here's a selection of 30 essential functions you must know
I explained 5 practical examples using functions in detail
This is a practical example of data filtering
It will definitely be different before and after listening to this course!!
It will take your Excel skills to the next level
▶ You can have confidence in Excel
▶ You can learn exactly about Excel function rules
▶ Excel functions can be used in the right place
▶ Learn what functions can be applied to practical examples
This course also provides function example files, practical example files, and an e-book PDF with function descriptions and practical example explanations
Frequently asked questions Q&A
Hesitation leaves nothing but regret!... Get started right away!
Class Curriculum1
Class details
Creator
은희쌤
We teach administrative certifications to students preparing for employment that help them develop themselves, and we give practical Excel lectures to office workers to improve their job competencies
[Lecture history]
Current) Green Computer Academy Vocational Training Course Office Administration (Comboo Level 1, Comboo Level 2) Lecture
Current) CEO of Eun-hee Tutor Class In-Kang Site
Current) VOD lecture on Excel functions that are easy to use (infrastructure)
Current) Data Analysis Course for Practitioners (Weaver)
Mapo Youth Naru, practical Excel lecture for young people in Cheongnyeon-dong, Gwangmyeong-si
Gyeonggi Jobs Foundation, Seodaemun Life Care Lifelong Learning Center, TMCK practical Excel lectures for employees
Gyeonggi Siheung Education Office, Gyeonggi Gapyeong Education Support Office Administrative Practitioner Lectures on Hangul & Hansel
[book]
85 Excel functions that are easy to use like a dictionary & everything about Excel analysis work
(https://www.yes24.com/Product/Goods/92854818)
dmsgml-1030
