Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Productivity

/

Office

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

25 learners

  • officetutor
Excel
MS-Office

Reviews from Early Learners

What you will learn!

  • 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

2,646

Learners

398

Reviews

19

Answers

4.8

Rating

36

Courses

오피스튜터는 Microsoft Office 관련 프로그램에 대한 콘텐츠 개발 및 교육을 위해 1999년에 설립된 회사로서 오피스 제품별 최고 전문가(Microsoft MVP)들이 쌓아온 노하우를 오피스 사용자에게 전파하는데 노력을 기울이고 있습니다.  

오피스튜터가 운영중인 웹사이트(officetutor365.com)에는 지난 20년간 축적된 30만 페이지가 넘는 오피스 제품의 무료 강좌 및 묻고 답하기, 마이크로소프트 오피스 온라인 동영상 과정 등 오피스 사용자들의 지식포탈이 구축되어 있으며, Microsoft 365 챔피언들을 위한 스터디 멤버십 프로그램인 '퓨쳐리스트' (futourists.kr)를 통해 다양한 교육 프로그램을 매월 정기적으로 개최하고 있습니다.  

Curriculum

All

12 lectures ∙ (2hr 24min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

5.0

5 reviews

  • sychoicas5069님의 프로필 이미지
    sychoicas5069

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    I heard it well

    • seederyj3446
      Instructor

      Thank you!~

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

  • dsjo4973님의 프로필 이미지
    dsjo4973

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    DDDDDDD

    • haewonlee8103님의 프로필 이미지
      haewonlee8103

      Reviews 9

      Average Rating 4.4

      5

      33% enrolled

      This is the lecture I wanted to hear.

    • sungju1015lee0521님의 프로필 이미지
      sungju1015lee0521

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      This was a very informative lecture!

    $34.10

    officetutor's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!