Differentiated Excel data analysis and chart visualization exclusively for professionals
This course provides 100% hands-on experience by explaining which functions and features of Excel can be used to solve tasks most quickly and efficiently in these cases through examples used in actual workplaces.
Learn Excel tips and features that you can immediately apply to your real-world projects.
Excel data analysis and chart visualization unique to professionals
Excel is not an optional application for office workers, but an essential one. Excel's proficiency goes beyond simply determining how well or poorly you perform your work. It now determines how easy or difficult your work is. Many Excel users, when learning a new feature, have probably found themselves wishing they'd discovered it sooner.
Excel's most effective users are those who know how to apply and use it, rather than those who simply know a wealth of features. Therefore, rather than learning every single feature, it's far more beneficial to learn a few tips from an Excel expert.This course doesn't simply explain Excel's features; it uses real-world examples to analyze Excel data and demonstrates which Excel features and functions can be used to solve tasks most quickly and efficiently. This course delivers a 100% hands-on experience.
If you are an office worker who wants to analyze Excel data while reducing work hours and increasing efficiency, you will find a solution through this course.
Things to learn
First, we will explain how to quickly and accurately edit RawData downloaded from the system.
Once the data list has been edited, use functions and pivot tables to create the desired analysis table. Finally, apply custom display formats, conditional formatting, and charts to visualize the report.
Helpful people
Anyone who wants to freely manipulate data and easily create desired reports
Someone who spends all day editing data downloaded from the system
Those who need hands-on training on editing and analyzing raw data and creating visualization reports
Those who know the basic functions of Excel but feel they lack the ability to apply them to work
Those who want to learn intermediate/advanced functions, pivot tables, and charts.
People who find the method of learning one by one by reading books frustrating
Note
Prepare a PC with Excel 2010 or later installed
It is based on basic knowledge of Excel.
Introduction of knowledge sharers
Kim Kyung-ja
Comppeople CEO, IT professional instructor, http://blog.naver.com/onwings
While working at the LG Electronics Learning Center, I developed a connection with IT education and am currently teaching for 20 years at LG Electronics, the Korea Standards Association, Korea Land and Housing Corporation, the National Civil Service Human Resources Development Institute, the Land, Infrastructure and Transport Human Resources Development Institute, the Korea Chamber of Commerce and Industry, Seoul National University, and the Central Training Institute, developing business innovation programs utilizing Excel VBA.
엑잘알이 될 수 있는 강의!!
엑셀에 대해 아는 것이라고는 썸 함수와 간단한 수식 뿐이었는데, 이 강의를 통해서 많이 배워갑니다. 특히나 한 강의 내에서 문제 해결을 위한 방법을 수 차례 연습하고, 프로젝트 강의를 통해 다시 한 번 연습하여 강사님의 스킬을 체화시킬 수 있었습니다. 좋은 강의 감사합니다. 다시 한 번 더 듣고 싶습니다.~
처음 시작하면서 오늘은 시작이니 1강만 들어볼까 했는데, 순식간에 2섹션을 다 들었어요! 사실 엑셀강의 보면 기능설명은 잘 되어 있는데, 당장 실무에 쓰기엔 괴리가 있던 경험이 많았는데, 군더더기 없이 설명해주시고, 내용 구성도 실무와 괴리없이 알짜배기로 이루어졌다는 생각이 듭니다.
이제껏 애매하게 시행착오를 하며 쓰던 기능들을 이 기회에 제대로 배우면서 시간낭비를 많이 줄일수 있겠다는 기대감이 들어요.
강사님 특유의 '~랍니다' 말투에 중독된거같아요*_*! 좋은 강의 강사합니다 강사님!
미소
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
