![[Đạt ITQ Excel A chỉ trong một lần] Hoàn thành sau 3 ngày강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
[Đạt ITQ Excel A chỉ trong một lần] Hoàn thành sau 3 ngày
dmsgml1030
Ngay cả những người mới bắt đầu không biết gì về Excel cũng được! Có thể đạt điểm A trong ITQ Excel chỉ bằng cách làm theo các bài giảng.
초급
ITQ, Excel, MS-Office
Work Automation [Everything About Excel Analysis]
You use 'pivot tables' a lot for data analysis, right? However, Excel provides various analysis tasks that are suitable for the situation in addition to pivot tables. In this lecture, we will organize Excel analysis tasks in 10 ways (sorting, subtotals, pivot tables, pivot charts, target value search, data tables, scenario managers, integration, advanced filters, conditional formatting)
.jpg?f=avif)
What you will learn!
Data analysis and summary using pivot tables and pivot charts
Comparative analysis of data groups using partial sums
Predicting the future of data using virtual analysis
Integrate distributed data using functions
Extract and visualize data that meets conditions using conditional formatting
10 ways to have fun
Excel analysis work! 🌌
A little more detail
If you want to learn Excel! 📖
At work, you often need to summarize or analyze large amounts of data. While manually analyzing and summarizing data is an option, doing it manually every time is not only time-consuming, but also reduces accuracy. Through this course, I hope you'll master a variety of analytical tasks in Excel and increase your efficiency.
Among Excel's various functions, we'll select 10 functions related to data analysis, learn them with appropriate examples and detailed explanations, and then use them to analyze the large amounts of data generated at work, appropriately and appropriately.
I recommend this to these people 🙋♂️
In writing plans or reports
Anyone who needs data analysis
Excel data management
For those who want to do it efficiently
100% Excel functionality
Anyone who wants to use it
Students' concerns and solutions 😎
- I want to use a pivot table, but I don't know how to create one.
👉 This guide details the process of creating a pivot table. Furthermore, creating a pivot chart allows you to analyze your data visually. - I want to group and analyze large amounts of data.
👉 The subtotal function allows you to summarize large amounts of data into groups and compare/analyze them using functions. - I want to predict what the outcome will be when the data changes.
👉 In Excel, you can use what-if analysis to predict what results will change when current data changes. - I want to consolidate branch data into one.
👉 You can combine scattered data into one using the integration function. - I want to extract only the data that satisfies the conditions and create a chart.
👉 Advanced filters are a way to extract data that satisfies certain conditions. You can use the extracted data for other purposes and even visualize it using conditional formatting.
What you'll learn 📚
1. Summarizing and analyzing large amounts of data
When analyzing large amounts of data to create reports or plans, you can utilize pivot tables, pivot charts, sorting, subtotals, and consolidation features . By following this course, you'll be able to master these features and utilize them effectively. 
2. Predicting the resulting values when data changes
What-if analysis can be used to predict how results will change by changing current data.
You can learn about target value finding, which examines changing values to find the desired target value , data tables, which display the results in a table format when data changes, and scenario managers , which create virtual situations and examine how the results change. 
3. Extract and visualize data that satisfies the conditions.
If you want to extract data that satisfies the conditions and use it for other purposes, you can use advanced filters . If you want to color-code the extracted data to distinguish it from other data, you can use conditional formatting . 
After attending the lecture
Student Changes 📜
1. Using Excel's pivot table function, you can easily organize data as desired, such as by item sum or average, without having to manually analyze large amounts of data. 
2. When you need to group a large amount of data and perform a comparative analysis by group, you can use subtotals. 
3. If you want to predict the future using current data, you can use target value finder, scenario manager, data table, etc. to virtually derive prediction results. 
4. You can also use the merge function to combine multiple tables into one. For example, you can calculate the total amount of receipts, sales, and inventory for each branch and combine them into a single table. 
5. When analyzing and organizing data using advanced filters, conditional formatting, etc., you can extract the data you want more precisely and easily. 
Expected Questions Q&A 💬
Q. Is this a course that non-majors can also take?
Yes, Excel is a program that is widely used in all types of work, so it would be useful for anyone, regardless of major or non-major, to know it.
Q. Why should I learn Excel analysis?
As you work, you'll inevitably accumulate large amounts of data. By utilizing pivot tables and subtotals to analyze this data, you'll not only save time but also become an Excel expert.
Q. Are there any notes regarding course registration?
Please prepare MS Office Excel 2016 or higher.
Introducing the Knowledge Sharer ✒️
Hello, I'm Eunhee. I hope that my knowledge of office administration, which I enjoy and excel at, can be of help to others in need. I currently teach practical office administration (Excel, PowerPoint) and office-related certifications (Computer Skills Level 1/2, ITQ) at a vocational training institute.
Recommended for
these people
Who is this course right for?
Anyone who needs data analysis for planning or report writing
For those who want to utilize Excel's functions 100%
For those who want to manage Excel data efficiently
356
Learners
23
Reviews
5.0
Rating
10
Courses
취업을 준비하는 학생들에게 자기계발에 도움을 주는 사무자격증을 강의하고 있습니다
그리고 직무 역량을 향상시키기 위해 직장인 대상 실무엑셀 강의를 합니다
은희쌤 클래스 대표
■ 전문 자격
직업훈련교사2급(일반총무사무) 고용노동부
직업훈련교사(정보기술운용관리)3급 고용노동부
직업훈련교사3급(일반총무사무) 고용노동부
컴퓨터활용능력 1급 대한상공회의소
ITQ정보기술전문강사(PTI) 한국생산성본부
ITQ 한글 A, 엑셀 A, 파워포인트 A, 인터넷 A 한국생산성본부
컴퓨터활용능력 2급 한국상공회의소
정보처리산업기사 한국산업인력관리공단
■ 저서
사전처럼 쏙쏙 뽑아쓰는 엑셀함수 85선 & 분석작업의 모든것(부크크 2020)
■ 강의 이력
강남구청에서 위탁한 GIT아카데미 소속으로 강남구 대치4동 정보화교실에서 OA, ITQ자격증 강의 2009.03
군포장애인복지관에서 장애인, 어르신 대상으로 OA, ITQ자격증 강의 2011.03
금천구청에서 위탁한 한빛전산 소속으로 금천구청 전산교육장에서 OA 강의 2012.03
서대문장애인복지관에서 장애인, 어르신 대상으로 OA, ITQ자격증 강의 2013.03
화성유앤아이센터(여성비젼센터)에서 컴퓨터활용능력2급, ITQ OA 마스터 과정을 직장인, 일반인 대상으로 강의 2015.01
경기직업교육센터에서 실업자 직업훈련과정으로 컴퓨터활용능력 2급, ITQ OA 마스터과정 강의 2015.03
그린컴퓨터아카데미에서 실업자 직업훈련과정으로 컴퓨터활용능력 1급, 2급, ITQ OA 마스터과정 강의 2016.04
사무행정부문 이수자 평가 "A" 취득 2018. 12
그린컴퓨터아카데미 스타 강사 수상 2020.10
인프런에서 실무엑셀, 자격증 강의 판매 2022.03
[은희쌤 클래스] 취업 자격증 전문 인강사이트 개설 2022.09
[마포청년나루] 청년 취업 역량 ITQ 엑셀 특강
Curriculum
All
11 lectures ∙ (2hr 1min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
1 reviews
$8.80
dmsgml1030's other courses
Check out other courses by the instructor!
![Tiếp thu nhanh chóng [Đạt kỹ năng thực hành máy tính cấp 2 trong 5 ngày]강의 썸네일](https://cdn.inflearn.com/public/courses/330613/cover/820dc36f-c51d-4917-9eab-2fa9d5a291e5/330613-eng.png?f=avif&w=420)
![[Đậu ITQ PowerPoint A trong một lần] Hoàn thành chỉ sau 2 ngày강의 썸네일](https://cdn.inflearn.com/public/courses/330108/cover/a0a7ac8c-cbd6-4acf-9cad-494ee28e1faf/파워포인트)
![Chỉ 2 ngày thôi!! [ITQ Hàn Quốc A trong một lần bắn]강의 썸네일](https://cdn.inflearn.com/public/courses/330083/cover/776d0ef6-1cf9-40c6-bb01-969283a0ee5e/ITQ한글썸네일(인프런).jpg?f=avif&w=420)
![Được cấp trên công nhận [Các mẹo Excel hữu ích cần biết (1)]강의 썸네일](https://cdn.inflearn.com/public/courses/329430/cover/2672867b-3832-4d62-b4e9-9904c723e7d0/엑셀팁(인프런).jpg?f=avif&w=420)
![Bạn có muốn bỏ việc không? Nếu vậy thì bạn nên học bài [Từ điển hàm Excel].강의 썸네일](https://cdn.inflearn.com/public/courses/328591/cover/e6c500ab-3346-48df-84a8-b7c0876eea16/함수사전(인프런).jpg?f=avif&w=420)
Similar courses
Explore other courses in the same field!
![[Tự động hóa công việc bằng MS RPA miễn phí] Power Automate Desktop - Tự động hóa Excel강의 썸네일](https://cdn.inflearn.com/public/courses/330201/cover/8adc841c-39de-4770-98d3-2439ed8881a3/330201-eng.png?f=avif&w=420)
![[Tự động hóa công việc bằng MS RPA miễn phí] Power Automate Desktop Essentials강의 썸네일](https://cdn.inflearn.com/public/courses/329655/cover/8364da63-535b-4613-9b02-3dcdfc21791d/329655-eng.png?f=avif&w=420)
![[Tập] Excel + Python (cơ bản)강의 썸네일](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?f=avif&w=420)
