![[핵집] 2025 빅데이터 분석기사(필기)_과목 3~4Course Thumbnail](https://cdn.inflearn.com/public/courses/328527/cover/903bde69-6401-4d0d-b47f-daa23610fc55/231130_34_v1.jpg?f=avif&w=420)
[핵집] 2025 빅데이터 분석기사(필기)_과목 3~4
소확성
오롯이 전문 영역을 파고든 유일한 강의! 철저한 출제 경향 분석으로 합격을 위한 가장 빠른 길을 과목별 현업 전문가가 알려 드립니다!
Basic
빅데이터
Office Excel that finishes in one room!
You know how to use Excel, but what if you keep doing similar tasks over and over again, and it takes a long time, but the results don't seem to improve? What you need is speed and quality! The engineering girl's function and data analysis tips will neatly solve the Excel worries of office workers. (*Can be learned with Excel 2013 or later versions)
What you will gain after the course
Excel functions and data analysis skills for a work life without overtime
100% practical examples to increase work usability by 200%!
Data management tips that are highly useful in the field, regardless of the Office version!
Starting today, I'm a Excel pro! 📊
Master your office Excel skills in one go.
.jpg?w=960)
What is Excel for office workers?
Excel is a tool that easily 'structures' the data that is essential for a company.
People who are good at analytical thinking and work well tend to be good at Excel.
Excel helps you gain a sense of inner accomplishment and recognition from those around you, as well as a good reputation.
It's a very useful tool, and above all, it's a very important work skill that calls for a timely dismissal.
.jpg?w=960)
Does that mean I need to know every shortcut and function in Excel? No way!
'Engineering Girl Excel Genius' is the most used in practice to improve office Excel skills of office workers.
We will teach you the core functions of Excel for office use through practical examples.
Introduction to the main curriculum
1. Do not manually enter data one by one.
The habit of manually entering data one by one is a very inefficient method.
Not only does this increase work time, but it can also lead to typos, which can reduce the reliability of your data.
We'll show you how to enter data quickly and easily without having to type it in manually.
(Creating shortcuts, Excel preferences, paste options, fill, formatting)
2. Check if you are finding the data correctly.
There's a quick and easy way to find the data you want.
You can extract various data by setting the scope and search location, and quickly find and replace specific data.
You can extract data under various conditions and edit it in a filtered state!
3. Use Excel functions effectively
No matter how many types of functions you know, it's useless if you can't apply them to different situations, right?
Each function has its own rules, and it is important to know how to apply these rules to each situation.
4. Do not share the results of the pivot table without permission.
However, if you carelessly share a pivot table, you could end up giving the other person all of the raw data . Let's explore these aspects through examples and learn about pivot tables.
Recommended for
these people
Who is this course right for?
For those who want efficient data organization
An office worker who works overtime every day because he doesn't know Excel
Anyone who wants to learn Excel know-how for the office
Need to know before starting?
If you know what Excel is, that's enough.
1,073
Learners
94
Reviews
165
Answers
4.4
Rating
8
Courses
소소하지만 확실한 성장 : 소확성
어제보다 조금 더 성장한 오늘의 나를 위해, 소확성이 함께 합니다.
경쟁과 성공, 성과만을 쫓는 경쟁적 자기계발에 지친 현대인을 위해,
일과 삶, 생활을 업그레이드하는 진정한 나만의 성장을 위한 콘텐츠를 제공합니다.
* 온라인교육전문기업 (주)알엠피 홈페이지 www.thermp.co.kr
Curriculum
All
20 lectures ∙ (5hr 34min)
Course Materials:
Lecture resources
Published:
Last updated:
$34.10
lmy0016004's other courses
Check out other courses by the instructor!
![[핵집] 2025 빅데이터 분석기사(필기)_과목 1~2Course Thumbnail](https://cdn.inflearn.com/public/courses/328520/cover/b95e2ee9-cb49-45b6-9d6a-039eb6530812/231130_12_v1.jpg?f=avif&w=420)
Similar courses
Explore other courses in the same field!
![상사에게 인정받는 [알아두면 쓸모 있는 엑셀 팁(1)]Course Thumbnail](https://cdn.inflearn.com/public/courses/329430/cover/2672867b-3832-4d62-b4e9-9904c723e7d0/엑셀팁(인프런).jpg?f=avif&w=420)
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]Course Thumbnail](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
![[에피소드] 엑셀+파이썬(기초)Course Thumbnail](https://cdn.inflearn.com/public/courses/332174/cover/4bff11a1-9859-43f4-8e17-6374ee50e6d6/332174-eng.png?f=avif&w=420)
![[입문자를 위한] Power BI로 시작하는 데이터 시각화Course Thumbnail](https://cdn.inflearn.com/public/courses/327055/cover/455b54c1-3e63-439b-9b60-5d12e12bc303/PowerBI-001)
