In this course, you can learn a wide range of topics, from basic Excel functions to advanced formulas, data visualization, and dashboard creation, with a focus on hands-on practice. By providing templates and solution files, self-study is possible, and you can maximize work efficiency by mastering data analysis skills that can be immediately applied in real-world scenarios.
28 learners
With this single lecture, you can learn everything from basic Excel navigation to advanced formulas, Power Query, Power Pivot, and data visualization.
Learn core practical skills intensively: Excel formulas, M code, DAX, etc.
Data Visualization Wireframe Theory: Color, Font, Layout, Creating Dashboards can improve understanding of optimal design practices.
Office workers who have difficulty analyzing and organizing data
For those who want to efficiently process data and create reports using Excel
For those who want to learn Excel skills in depth through real-world project experience.
Who is this course right for?
Excel novice
Office workers interested in data analysis and report writing
Those who want to increase productivity by using Excel in their work
Need to know before starting?
Excel Basics
Data Analysis Basics
78
Learners
8
Reviews
5
Answers
3.9
Rating
4
Courses
데이터싸이언스원 | Taesun Yoo
주요 경력:
온타리오주 근로자 보험 공단 (WSIB) 시니어 어드바이저 (1년)
온타리오주 근로자 보험 공단 (WSIB) 시니어 데이터 분석가 (경력 5년)
학력:
토론토 대학교: 보건 정보학 석사
웨스턴 대학교: 의학 물리학 학사
전문 분야:
Data Analytics/Data Modeling/Business Analysis
Business Intelligence/Data Visualization/Product Development (Power BI)
데이터 분석가로 취업에 도움이 되는 팁, 짧은 데이터 분석 포트폴리오, 유데미 코스 프로모션 등을 목적으로 강의를 업로드하고 있습니다!
10년 이상의 경력과 노하우를 바탕으로, 북미에서 데이터 분석가로 취업을 원하시는 분들을 위해 기술을 갈고 닦을 수 있게 강의를 만들고 있습니다. 기초부터 실제 기업에서 사용하는 응용 문제(Use Cases)까지 다루고 있습니다.
All
107 lectures ∙ (15hr 1min)
Course Materials:
All
5 reviews
4.0
5 reviews
Reviews 1
∙
Average Rating 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.
Reviews 1
∙
Average Rating 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.
Reviews 8
∙
Average Rating 4.6
Reviews 3
∙
Average Rating 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.
Reviews 1
∙
Average Rating 1.0
Edited
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.
$39.60
Check out other courses by the instructor!
Explore other courses in the same field!
![[Pass ITQ Excel A in One Go] in 3 days강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
