엑셀로 끝내는 보고서 차트 실무 강의
일잘러탐구생활
직장인이라면 누구나 한번쯤 차트를 만들 때 고민해본 경험이 있을 겁니다. 언제 어떤 차트를 써야하는지, 어떻게 만들어야 하는지 헷갈리다면 속시원한 해답을 드리겠습니다.
입문
Excel, MS-Office
From Excel Basics to Practice
This course is useful for everyone, from beginners to those who use Excel at work.
Reviews from Early Learners
From Excel Basics to Practice
Excel is the most widely used program among office workers. It offers features for easily handling complex calculations and efficiently managing and analyzing data, enabling rapid processing of large amounts of data. Furthermore, it allows you to create tables and charts to effectively present analysis results, allowing you to present data intuitively and clearly.The Excel Basics to Practice course is designed for everyone, from beginners to professionals who use Excel at work. It consists of 16 sections and 1 mission.
=============================================================================
0. Excel Basics, Data Entry and Management
1. Database - Easy to manage with proper input
2. Data Management - What Makes Excel Special for Professionals
3. Excel's Flowers: Formulas and Functions
4. Logic and Conditions - Basic Skills for Smart Excel Use
5. Text - How to handle character data
6. Date and Time - Excel is fast and accurate for time calculations.
7. Data Aggregation - The First Step to Creating a Report
8. Filtering - How to Find Values
9. Charts - Easy-to-read charts are also easy to understand.
10. PivotTables and PivotCharts - Summarize Complex and Large Data
11. Mission (from 0 to 10)
12. Power Query New
13. Everything you need to know about dynamic range usage
14. Array formulas
15. Practical Use of Excel
16. Excel Tips
17. Developing Excel skills
18. Macros & VBA
=============================================================================
If you're new to Excel, study Lessons 1 through 10 in order. You'll soon feel confident using Excel.
Anyone familiar with the basics of Excel can select and learn only the courses they need. Each course is concise, making it easy to learn.
7-Day Practical Excel If you're learning from a book, you can study Sections 0 through 11 in order. I've listed the book pages below the video.
And for the material that couldn't be included due to the length of the book, I've marked it with " Useful to Know ." The lecture notes are linked to the blog address below the video.
Rather than just watching the video, I recommend that you download the practice files and practice them yourself .
I hope this course will be helpful to everyone who needs a course on Excel, from basics to practical use .
Learning Objectives
- You can learn the basics of Excel and acquire skills that can be applied in the workplace.
Helpful people
- For those new to Excel
- Those who have learned the basics of Excel but find it difficult to apply it in practice
- Those preparing for employment or office certification
Introduction of knowledge sharers
Short lecture- Short lecture YouTube channel (youtube.com/@hantip), blog operation (hantip.net)
- Lectures at government offices, public corporations, and universities
- CLASS101, Teacherville, Suwon District Prosecutors' Office, Daegu Education and Training Institute e-learning production (Teacherville)
- EBS Computer Proficiency Levels 1 and 2 Practical Proofreading, Proofreading, and Excel Practical Appendix Writing
- Book: 7-Day Practical Excel | 7-Day Practical Excel, PowerPoint, Word, and Hangul
.jpg?w=960)
Curriculum
All
191 lectures ∙ (25hr 11min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
167 reviews
4.9
167 reviews
Free
Similar courses
Explore other courses in the same field!
![3일만에 끝내는 [ITQ 엑셀 A 한방에 합격하기]강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)