강의

멘토링

로드맵

Productivity

/

Office

Excel 2016 saves time and improves work efficiency

From basic functions to high-level practical documents used in the field, to new features exclusive to Excel 2016! Give wings to your documents with Excel 2016!

(5.0) 5 reviews

30 learners

  • ubob
Excel
MS-Office

Reviews from Early Learners

What you will learn!

  • Basic functions of Excel

  • Improved features in Excel 2016

  • Automating Documents with Excel

Improve your fundamentals! Improve your work efficiency!
Excel A to Z for Office Workers

Excel, the basics for office workers

The latest Excel 2016 lecture for beginners!
Reduce working hours and increase work efficiency.

Excel makes your work easier and reduces your work time. Are you using it effectively? Everyone uses Excel, but mastering it can be challenging.

Even if you're new to Excel, it's okay! This course covers everything from basic concepts to mastering the latest features through practical examples, making it accessible to anyone interested in learning Excel. Gather the essentials from our vast knowledge of Excel and improve your work skills!

✔️ You can get these things through the lecture.

  • You can save time by automating your documents using Excel.
  • High performance can be achieved through efficient use of work.
  • You can leverage the enhanced features of Excel 2016 to create a variety of documents and gain a competitive edge.

✔️ For office workers
We'll teach you everything from the basics to practical skills.

Excel 2016
Key Reveal 💡

From new features in Excel 2016 that save time and increase efficiency to basic functions and various practical document creation methods, we provide practical Excel skills for office workers.

learner-centered
Lecture 💻

We have enhanced learner accessibility through 16:9 wide demonstration videos and instructor-led lectures, and provided practice example files before learning so that you can watch the instructor's practice videos and follow along.

MS Excel MVP
Direct lecture by instructor Jang Mi-hee 🙋‍♀️

Let's learn Excel with instructor Jang Mi-hee, who teaches Excel and Excel VBA at leading domestic corporations, universities, and foreign companies, and has written various books on the subject, including "Practical Excel VBA Automation for Office Workers"!

✔️ What will you learn?


#1 Excel 2016 Features and Workbooks

  • Key Features and New Features in Excel 2016
  • Screen elements and working environment in Excel 2016
  • Workbooks and File Formats

#2 Data Entry and Editing

  • Data types and editing entered data
  • Efficient data entry features


#3 Formatting and Creating Formulas Using Worksheets

  • Worksheets and data
  • Formulas and Functions

#4 Worksheets and Trend and Visual Analysis

  • Worksheets and cells
  • Data trend analysis
  • Visualization of data analysis


#5 Creating and Editing Charts

  • Charts that fit your data
  • Create and edit charts

#6 Print Settings and Data Management

  • Basic print settings
  • Print settings with various functions
  • Data integration and deduplication


#7 Managing External Data and Writing Functions

  • Managing external data & writing various functions
  • Calculate date ranges and extract specific data
  • Extract values using IF, AND, OR, and VLOOKUP

#8 Functions that calculate various values and numeric functions

  • Functions that find various values
  • Formulas that apply numeric functions



#9 Analysis via PivotTable

  • Table insertion function
  • Pivot Table

#10 Worksheet and Data Management Tips

  • Various tips about worksheets
  • Various know-how regarding data
  • Useful Tips for Working with Excel

Expected Questions Q&A 💬

Q. Will people without basic knowledge of Excel be able to listen without any problems?

A. Yes! Our lectures and explanations are designed to be easy to understand, even for those lacking basic Excel knowledge!

Q. Are there any practical materials that I can study along with the lecture?

A. Yes! Separate practice materials are provided for each section of the course :)

Recommended for
these people

Who is this course right for?

  • General public or office workers who want to learn Excel 2016 version

  • Office worker who handles a lot of Excel work documents at work

Hello
This is

621

Learners

61

Reviews

2

Answers

4.8

Rating

32

Courses

Curriculum

All

46 lectures ∙ (6hr 24min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

5 reviews

5.0

5 reviews

  • soojungchoi6149님의 프로필 이미지
    soojungchoi6149

    Reviews 7

    Average Rating 5.0

    5

    100% enrolled

    • keh7124님의 프로필 이미지
      keh7124

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      • soyeon3kim0317님의 프로필 이미지
        soyeon3kim0317

        Reviews 2

        Average Rating 4.5

        5

        98% enrolled

        Please explain it easily.

        • youngskim5226님의 프로필 이미지
          youngskim5226

          Reviews 9

          Average Rating 5.0

          5

          76% enrolled

          thank you

          • dnsgnk875939님의 프로필 이미지
            dnsgnk875939

            Reviews 2

            Average Rating 5.0

            5

            98% enrolled

            It was a useful education.

            $62.70

            ubob's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!