This is a course that allows you to quickly learn the essential Excel tasks that office workers must encounter, using the latest features.
1. Types and characteristics of Excel files encountered in the workplace
2. Converting uncleared data to Power Query
3. Power Query instead of Vlookup
4. Report with a standout Dashboard
Even a newbie who is completely clueless can do his job well.
Excel training course that will make you a super rookie!
The files we have seen in the book so far are clear files that have been refined.
But the Excel files you encounter after joining the company are dizzying as soon as you see them.
Why does the vlookup function, which used to work so well, only return errors when applied to company files?
Pivot table aggregate values sometimes come out as strange values.....😢.😢
If you know in advance the types and characteristics of Excel files you will encounter at work,
When you join the company, you will be able to handle it much better :D
The biggest characteristic of the files that could not be cleared is that the data types are mixed up.
To change this properly, seniors are using functions or various features of Excel.
When there is a lot of data, the screen often turns white during conversion.
Time is running out, Excel isn't working...
In times like this,
Excel, which is evolving into a Business Intelligence Platform, has ambitiously released
If you convert using 'Power Query' , you will be recognized as a '5G new employee'!!!
What on earth can't 'Power Query' do?
As the data increases, the speed also slows down, and errors pop up even if the environment changes a little.
The Vlookup function that's burning me up...
I can't abandon you, it's really a love-hate relationship.
But now I have to say goodbye to you.
I've come across a much, much more capable Power Query.
When I analyze the data and report monthly, I break out in a cold sweat...😢.😢
They ask me to create a report that is easy to read at a glance using a pivot table.
After creating it with pivot, all you see is a table full of numbers.
What on earth did my friend make it out of?
With just one click of a button, the table changes and the bar graph flies around???
Just use pivot + conditional formatting + slicer + pivot chart.
You will become a popular new employee who is praised by your superiors .
Who is this course right for?
1. People preparing for employment
2. New employees
3. Office workers who want to use Excel reminders
Need to know before starting?
Excel Basics
8,935
Learners
343
Reviews
219
Answers
4.9
Rating
6
Courses
안녕하세요, 반갑습니다.
VBA 강사 및 개발자 배영자입니다.
유튜브 '엑셀디자인' 채널 운영 중.
All
9 lectures ∙ (2hr 26min)
Course Materials:
All
44 reviews
4.8
44 reviews
Reviews 3
∙
Average Rating 5.0
5
Thật tuyệt vời khi có thể sử dụng Excel một cách thông minh.
Excel sẽ rất vui khi được gặp một người học thông minh ♪(^∇^*)
Reviews 2
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 3
∙
Average Rating 5.0
5
Tôi nghĩ nó sẽ giúp ích rất nhiều cho công việc của tôi! Tôi có rất nhiều băn khoăn khi làm việc với Excel vì còn nhiều thiếu sót nhưng nhờ đó tôi nghĩ mình có thể dễ dàng tìm hiểu, nắm vững và áp dụng vào công việc của mình. Bất kể tôi gặp phải loại dữ liệu nào, tôi nghĩ mình sẽ có thể phân tích, xử lý và hình dung nó tốt bằng những kỹ năng tôi đã học được lần này! Cảm ơn:)
Tôi mong muốn được xem dữ liệu công việc đã phát triển của Bara. Đánh nhau （￣︶￣）↗
Reviews 1
∙
Average Rating 5.0
5
Tôi có được sự tự tin vì tôi đã thành công trong việc tự động hóa công việc của mình.
Wow~ Siyun, bạn ngầu quá＼(((￣(￣(￣▽￣)￣)￣)))／ Tôi tò mò không biết bạn đã áp dụng tự động hóa vào những nhiệm vụ nào.
Limited time deal
$538,310.00
24%
$26.40
Check out other courses by the instructor!
Explore other courses in the same field!
![[Đạt ITQ Excel A chỉ trong một lần] Hoàn thành sau 3 ngày강의 썸네일](https://cdn.inflearn.com/public/courses/329652/cover/b44e11b6-a47e-4993-86ea-a85da9836bb5/329652-eng.png?f=avif&w=420)
