![[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?w=420)
[Pass ITQ Excel A in One Go] in 3 days
dmsgml1030
Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.
초급
ITQ, Excel, MS-Office
Are you using Excel well in your work? Small tips for Excel can help you reduce mistakes and increase work efficiency! In this course, we will carefully select 16 useful Excel tips and explain them in detail.
You can learn the correct way to enter various data into a sheet.
Create professional-looking tables using custom formats
You can change incorrectly entered data to correct one.
You can use it in formulas by defining names.
Learn the text splitting function and use it in tables.
You can also learn useful Excel tips and apply them to your work.
It's so useful to know
Learn various Excel tips 🍯
While it's good to know a lot, it's equally important to apply that knowledge effectively. We'll share a variety of useful Excel tips, so apply them to your work to increase efficiency! This course will help you gain confidence in Excel.
When working at the company
People who work a lot with Excel
In addition to the features you already know,
For those who want to know other features
Use Excel tips for your work
Those who want to increase efficiency
1. Why do I get a #Value error when calculating a formula?
Data in a cell may appear as numbers, but it may actually be text. This can cause the #Value error to appear and prevent formula calculations. In this case, you can convert the data to numeric data.
2. Can I set a separate format even when a cell contains positive numbers, negative numbers, 0, characters, etc.?
Yes, you can. You can format it separately with a custom format like positive; negative; 0; character.
3. Is there a way to quickly enter data into cells all at once according to the rules?
Among the fill handle functions, you can use the 'Quick Fill' function to quickly input according to the rules.
4. I want to divide the cell data into multiple fields.
The Split Text feature allows you to split data in a cell into multiple fields.
When data such as positive, negative, and 0 are mixed, custom formatting is used.
You will learn how to format data that meets your conditions.
Incorrectly entered numbers or date data
You can easily change it all at once.
You can divide the data entered in a cell into multiple fields.
This feature allows you to skip the process of inserting/entering new columns.
Tip #1
Tip #2
Tip #3
Tip #4
Tip #5
Tip #6
Tip #7
Tip #8
Tip #9
Tip #10
Tip #11
Tip #12
Tip #13
Tip #14
Tip #15
Tip #16
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 is useful for anyone to know it, regardless of their major or non-major.
Q. Why should I learn useful Excel tips?
This course will help you feel confident in Excel and improve your work efficiency by utilizing Excel tips that others don't know about.
Q. Are there any notes regarding the course (environment requirements, other precautions, etc.)?
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 wants to improve work efficiency by using Excel tips in their work
For those who want to know other useful functions in addition to the Excel functions they know
People who work a lot with Excel
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 엑셀 특강
All
17 lectures ∙ (2hr 48min)
Course Materials:
All
2 reviews
5.0
2 reviews
Reviews 1
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
5
You explain it so well and logically.
Thank you ^-^ I'm glad you understood it well I hope the Excel tips will help you with your work. If you have any questions while working with Excel, please ask at any time.
$12.10
Check out other courses by the instructor!
Explore other courses in the same field!