![[Pass ITQ Excel A in One Go] in 3 daysCourse Thumbnail](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.
Basic
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.
.jpg?w=736)
.jpg?w=736)
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
Career Verified
525
Learners
62
Reviews
1
Answers
4.9
Rating
20
Courses
I am teaching office certification courses to help students preparing for employment with their self-development.
And I teach practical Excel classes for office workers to help them improve their job competencies
CEO of Eunhee-ssam Class
■ Professional Qualifications
Vocational Training Teacher Level 2 (General Administration & Office Work) Ministry of Employment and Labor
Vocational Training Instructor (Information Technology Operation & Management) Level 3 Ministry of Employment and Labor
Vocational Training Teacher Level 3 (General Administrative Affairs) Ministry of Employment and Labor
Computer Literacy Level 1 Korea Chamber of Commerce and Industry
ITQ Professional Training Instructor (PTI) Korea Productivity Center
ITQ Hangul A, Excel A, PowerPoint A, Internet A Korea Productivity Center
Computer Utilization Ability Level 2 Korea Chamber of Commerce and Industry
Industrial Engineer Information Processing Human Resources Development Service of Korea
■ Publications
85 Excel Functions to Pick and Use Like a Dictionary & Everything About Analysis Tasks (Bookk 2020)
■ Teaching Experience
Taught OA and ITQ certification courses at the Daechi 4-dong Information Education Center in Gangnam-gu as a member of GIT Academy, commissioned by Gangnam-gu Office 2009.03
Lectured on OA and ITQ certifications for people with disabilities and seniors at Gunpo Welfare Center for the Disabled, March 2011
Conducted OA lectures at the Geumcheon-gu Office Computer Training Center as part of Hanbit Computing, entrusted by Geumcheon-gu Office, 2012.03
Taught OA and ITQ certification courses for people with disabilities and seniors at Seodaemun Welfare Center for the Disabled 2013.03
Taught Computer Literacy Level 2 and ITQ OA Master courses for office workers and the general public at the Hwaseong U&I Center (Women's Vision Center) 2015.01
Taught Computer Literacy Level 2 and ITQ OA Master courses as part of the vocational training program for the unemployed at the Gyeonggi Vocational Education Center, 2015.03
Lectured Computer Literacy Level 1 and 2, and ITQ OA Master courses as vocational training programs for the unemployed at Green Computer Academy 2016.04
Obtained "A" grade in Office Administration Trainee Evaluation, Dec 2018
Awarded Star Instructor at Green Computer Academy 2020.10
Selling practical Excel and certification courses on Inflearn 2022.03
[Teacher Eunhee's Class] Launch of an online lecture site specializing in employment certifications, September 2022
[Mapo Youth Naru] Youth Employment Competency ITQ Excel Special Lecture
All
17 lectures ∙ (2hr 48min)
Course Materials:
All
2 reviews
5.0
2 reviews
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.
Reviews 1
∙
Average Rating 5.0
Check out other courses by the instructor!
Explore other courses in the same field!