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)
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! 🌌
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.
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 😎
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 . 
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. 
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.
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.
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
390
Learners
37
Reviews
4.9
Rating
14
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 엑셀 특강
All
11 lectures ∙ (2hr 1min)
Course Materials:
All
2 reviews
5.0
2 reviews
Reviews 1
∙
Average Rating 5.0
5
I hope the Excel analysis work will be helpful for practical analysis Thank you✨
Reviews 1
∙
Average Rating 5.0
$8.80
Check out other courses by the instructor!
Explore other courses in the same field!
![[Pass the Level 2 Computer Utilization Skills Practical Test in 5 Days]강의 썸네일](https://cdn.inflearn.com/public/courses/330613/cover/820dc36f-c51d-4917-9eab-2fa9d5a291e5/330613-eng.png?f=avif&w=420)
![[Pass ITQ PowerPoint A in One Go] in just 2 days강의 썸네일](https://cdn.inflearn.com/public/courses/330108/cover/a0a7ac8c-cbd6-4acf-9cad-494ee28e1faf/파워포인트)
![Just 2 days!! [Pass ITQ Korean A in one go]강의 썸네일](https://cdn.inflearn.com/public/courses/330083/cover/776d0ef6-1cf9-40c6-bb01-969283a0ee5e/ITQ한글썸네일(인프런).jpg?f=avif&w=420)
![[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)
![[Useful Excel Tips to Know (1)] that will get you recognized by your boss강의 썸네일](https://cdn.inflearn.com/public/courses/329430/cover/2672867b-3832-4d62-b4e9-9904c723e7d0/엑셀팁(인프런).jpg?f=avif&w=420)
![Do you want to quit your job? If so, you should take the [Excel Function Dictionary] course.강의 썸네일](https://cdn.inflearn.com/public/courses/328591/cover/e6c500ab-3346-48df-84a8-b7c0876eea16/함수사전(인프런).jpg?f=avif&w=420)
![[Beginner] Basic and Strong Excel Conquer Course강의 썸네일](https://cdn.inflearn.com/public/courses/330002/cover/df3f7dab-c60e-4bd8-80ad-ad4d9cea63dc/330002.png?f=avif&w=420)
![[Episode] Excel + Python (Basic)강의 썸네일](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?f=avif&w=420)
