이 강의에서는 Excel의 기본 기능부터 고급 수식, 데이터 시각화, 대시보드 제작까지 폭넓은 내용을 실습 위주로 배울 수 있습니다. 템플릿과 해법 파일을 제공하여 자가 학습이 가능하며, 실무에서 즉시 활용할 수 있는 데이터 분석 기술을 마스터하여 업무 효율성을 극대화할 수 있습니다.
이 강의 하나로 Excel의 기본 탐색부터 고급 수식, 파워 쿼리, 파워 피벗, 데이터 시각화까지 모든 것을 배울 수 있습니다.
Excel 수식, M 코드, DAX 등 실무에 필요한 핵심 기술을 집중적으로 학습합니다.
데이터 시각화 와이어프레임 이론: 색상, 글꼴, 레이아웃, 대시보드 만들기 최적 디자인 관행에 대한 이해를 높일 수 있습니다.
데이터 분석과 정리에 어려움을 느끼는 직장인들
Excel을 활용하여 데이터를 효율적으로 처리하고 보고서를 작성하고 싶은 분들
실제 프로젝트 경험을 통해 Excel 기술을 깊이 있게 배우고 싶은 분들
학습 대상은
누구일까요?
Excel 사용이 처음인 초보자
데이터 분석 및 보고서 작성에 관심 있는 직장인
업무에서 Excel을 활용하여 생산성을 높이고 싶은 분들
선수 지식,
필요할까요?
Excel 기본 개념
데이터 분석 기초
79
명
수강생
8
개
수강평
5
개
답변
3.9
점
강의 평점
4
개
강의
데이터싸이언스원 | Taesun Yoo
주요 경력:
온타리오주 근로자 보험 공단 (WSIB) 시니어 어드바이저 (1년)
온타리오주 근로자 보험 공단 (WSIB) 시니어 데이터 분석가 (경력 5년)
학력:
토론토 대학교: 보건 정보학 석사
웨스턴 대학교: 의학 물리학 학사
전문 분야:
Data Analytics/Data Modeling/Business Analysis
Business Intelligence/Data Visualization/Product Development (Power BI)
데이터 분석가로 취업에 도움이 되는 팁, 짧은 데이터 분석 포트폴리오, 유데미 코스 프로모션 등을 목적으로 강의를 업로드하고 있습니다!
10년 이상의 경력과 노하우를 바탕으로, 북미에서 데이터 분석가로 취업을 원하시는 분들을 위해 기술을 갈고 닦을 수 있게 강의를 만들고 있습니다. 기초부터 실제 기업에서 사용하는 응용 문제(Use Cases)까지 다루고 있습니다.
전체
107개 ∙ (15시간 1분)
해당 강의에서 제공:
전체
5개
4.0
5개의 수강평
수강평 1
∙
평균 평점 4.0
4
Each lecture is short, which is great. There was some noise or echo in the audio at the beginning that made some parts hard to hear.
Thank you for leaving a course review. I will optimize the microphone settings to improve the audio quality.
수강평 1
∙
평균 평점 5.0
5
It was a great course that was filled with the passion and expertise of the instructor from A to Z in Excel.
Hello, thank you for taking the time to leave a review. It was a great help and we will come back with better content in the future.
수강평 8
∙
평균 평점 4.6
수강평 4
∙
평균 평점 5.0
5
The lecture seems to be well-structured with content necessary for practical work, covering the entire process from beginner to intermediate and advanced levels. I'm really looking forward to and excited about the PivotTable and Power Query courses! From the very beginning, I'm learning a lot about how to easily solve tasks that I used to click on inconveniently and cumbersomely with keyboard shortcuts. Thank you.
수강평 1
∙
평균 평점 1.0
수정됨
1
The explanation was not smooth and I kept thinking that the lecture was prepared without any prior preparation. He kept saying, "Just a moment, I'm sorry," and in his own example using the round function, he said, "Why is the value automatically dropped to a decimal point? This is unnecessary," and in the part where the output data he wrote was different from the value that came out, he said, "Why is this? Anyway, let's move on," which lowered my trust. Even if the value is exact and the round function is not needed, if he put it out as an example of use, shouldn't he have modified the example value so that it could be used? I think he should have modified/reflected that before putting it out as a lecture. There were many other parts like this. The lecture content and explanation were based only on English, which was inconvenient, and even though it was a paid lecture and not a free lecture, the quality of the lecture was not as good as a free lecture. The only good thing was that the lecture part was divided into sections, so I could skip all the parts I knew.
Hello, thank you for taking the time to leave honest feedback about the lecture. I sincerely apologize for the parts of the lecture that were not smooth, and I plan to re-shoot the lecture video and replace it to improve this. I will actively reflect on what you have said. However, I cannot agree with the opinion that the lecture quality is worse than the free lecture. I admit that there were some shortcomings in the delivery method, but I can be confident in the depth of the content and practical application examples included in the lecture. In addition, I did not consider that explaining based on the English version of Excel might inconvenience some students. However, the lecture video and practice files are all provided in Korean, and I will clearly state this in the lecture outline. I will continue to improve to provide better lectures in the future. Thank you again for your feedback.
₩50,600
![[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutesCourse Thumbnail](https://cdn.inflearn.com/public/courses/331717/cover/a395d468-0688-4908-88c2-4d087f24d7b7/thumbnail.jpg?f=avif&w=420)
![[Pass ITQ Excel A in One Go] in 3 daysCourse Thumbnail](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
