Easy-to-follow Excel 2016 data adjustment and processing

You can learn various ways to use Excel to adjust, clean, and collate data brought in from outside, as well as how to extract, separate, and transform data from a single cell.

(5.0) 5 reviews

26 learners

Level Basic

Course period 12 months

Excel
Excel
MS-Office
MS-Office
Excel
Excel
MS-Office
MS-Office
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

Reviews from Early Learners

Reviews from Early Learners

5.0

5.0

sychoi.cas

100% enrolled

I heard it well

5.0

kye-won.seo

100% enrolled

I was able to learn that there are ways to process data using various functions. It was good that I was able to learn tips for actual execution through demos one by one.

5.0

ds.jo

100% enrolled

DDDDDDD

What you will gain after the course

  • How to transform raw data into the desired format

  • Various tips for adjusting and processing Excel data

  • How to manipulate and process data using Excel functions

Level up with more confidence using Excel data!

Current freelancer

👩‍🏫 Teaching experience

KAIST, SKC, Seoul National University Hospital , National Human Resources Development Institute , Gyeonggi Province Human Resources Development Institute , Seoul Human Resources Development Institute , Legal Research and Training Institute , Korea Regional Information Development Institute , Presidential Security Service , National Forest Healing Center , Korea National University of Transportation , Kangwon National University , Shinsung University , GS Caltex , Financial Supervisory Service , LG Electronics , LG Chem , Korean Standards Association , Microsoft Korea , National Rehabilitation Center , Pyeongchang Youth Training Center , Korea Tax Association , Seoul Metropolitan Council , Korea Coast Guard , Dongduk Women's University , Kyung Hee University , Gimpo City Hall, etc.

📖 Written book

- Excel 2019 Guide for Beginners ( Information Culture Publishing )

- Excel 2013+2016 for immediate use at work ( Korea Regional Information Development Institute )

- Co-authored with Microsoft Power BI: Data Makes a Difference ( BJ Republic )

- Excel 2016 Guide ( Information Culture Publishing )

- Excel 2010 for immediate use at work ( Korea Regional Information Development Institute )

- Excel 2007 Basics + Practical Techniques ( Seongandang )

- Excel Functions + Function 135 Co-authored ( Seongandang )

Recommended for
these people

Who is this course right for?

  • People who work a lot with data in Excel

  • Anyone interested in data manipulation and processing

  • For those who want to learn functions related to data manipulation and processing

Hello
This is officetutor

2,747

Learners

410

Reviews

19

Answers

4.7

Rating

36

Courses

Officetutor was established in 1999 for content development and training on Microsoft Office-related programs, and is dedicated to sharing the expertise accumulated by top experts for each Office product (Microsoft MVPs) with Office users.

Officetutor's official website (officetutor365.com) serves as a knowledge portal for Office users, featuring over 300,000 pages of free tutorials and Q&A accumulated over the past 20 years, along with Microsoft Office online video courses. Additionally, it regularly hosts various educational programs every month through 'Futourists' (futourists.kr), a study membership program for Microsoft 365 champions.  

More

Curriculum

All

12 lectures ∙ (2hr 24min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

5.0

5 reviews

  • kyewonseo3015님의 프로필 이미지
    kyewonseo3015

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    I was able to learn that there are ways to process data using various functions. It was good that I was able to learn tips for actual execution through demos one by one.

    • seederyj3446
      Instructor

      Your detailed course review is encouraging! Thank you.

  • haewonlee8103님의 프로필 이미지
    haewonlee8103

    Reviews 9

    Average Rating 4.4

    5

    33% enrolled

    This is the lecture I wanted to hear.

    • seederyj3446
      Instructor

      Thank you.

  • dsjo4973님의 프로필 이미지
    dsjo4973

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    DDDDDDD

    • sungju1015lee0521님의 프로필 이미지
      sungju1015lee0521

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      This was a very informative lecture!

      • seederyj3446
        Instructor

        Thank you!~

    • sychoicas5069님의 프로필 이미지
      sychoicas5069

      Reviews 2

      Average Rating 5.0

      5

      100% enrolled

      I heard it well

      • seederyj3446
        Instructor

        Thank you!~

    officetutor's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!

    $34.10