강의

멘토링

로드맵

BEST
Productivity

/

Office

Excel Training for New Employees Who Stand Out

This is a course that allows you to quickly learn the essential Excel tasks that office workers must encounter, using the latest features.

(4.8) 44 reviews

398 learners

  • 엑셀디자인
3시간 만에 완강할 수 있는 강의 ⏰
Excel
Excel PowerQuery

Reviews from Early Learners

What you will learn!

  • 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!

👩🏻‍💻 What you will learn in this course

1. Understand the types and characteristics of files frequently seen in the company.


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

2. Converting Uncleared Data in One Go with Power Query


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'!!!

3. Use PowerQuery instead of Vlookup


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.

4 Reporting with a standout Dashboard


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 .

※ Required specifications
Excel 2010 or later

Recommended for
these people

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

Hello
This is

8,935

Learners

343

Reviews

219

Answers

4.9

Rating

6

Courses

안녕하세요, 반갑습니다.

VBA 강사 및 개발자 배영자입니다.

유튜브 '엑셀디자인' 채널 운영 중.

Curriculum

All

9 lectures ∙ (2hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

44 reviews

4.8

44 reviews

  • cowdkek2323님의 프로필 이미지
    cowdkek2323

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    I'm really glad I was able to use Excel smarter.

    • 엑셀디자인
      Instructor

      Excel will be happy to meet a smart learner ♪(^∇^*)

  • ahnrk70738님의 프로필 이미지
    ahnrk70738

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    It was a useful lecture~^^

  • shinhwang9097님의 프로필 이미지
    shinhwang9097

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    Thank you. This is a new world.

  • seeya06116889님의 프로필 이미지
    seeya06116889

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    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 :)

    • 엑셀디자인
      Instructor

      I'm starting to want to see Baranim's evolved work data. Fighting! ( ̄︶ ̄)↗

  • yoon9907011610님의 프로필 이미지
    yoon9907011610

    Reviews 1

    Average Rating 5.0

    5

    89% enrolled

    I feel confident because I have successfully automated my work.

    • 엑셀디자인
      Instructor

      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

엑셀디자인's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!