
Practical Excel for office workers - from data processing to analysis
엑셀디자인
This is the process of becoming the 'standard' for efficiently and scientifically processing and analyzing data using the most trendy method in Excel.
중급이상
Excel, MS-Office
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
I'm really glad I was able to use Excel smarter.
Excel will be happy to meet a smart learner ♪(^∇^*)
Reviews 2
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 3
∙
Average Rating 5.0
5
I think it will be a great help to my work! I had a lot of concerns because I had many shortcomings when working with Excel, but thanks to this, I think I can easily learn, acquire, and apply it to my work. I think I will be able to analyze, process, and visualize any data I come across with the skills I learned this time! Thank you :)
I'm starting to want to see Baranim's evolved work data. Fighting! ( ̄︶ ̄)↗
Reviews 1
∙
Average Rating 5.0
5
I feel confident because I have successfully automated my work.
Wow~ Siyoon, you're amazing\((( ̄( ̄( ̄▽ ̄) ̄) ̄)))/ I'm curious to know what kind of work you applied automation to.
Limited time deal
$19.80
25%
$26.40
Check out other courses by the instructor!
Explore other courses in the same field!