Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
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

28 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

602

Learners

60

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

  • 최수정님의 프로필 이미지
    최수정

    Reviews 7

    Average Rating 5.0

    5

    100% enrolled

    • keh님의 프로필 이미지
      keh

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      • 김소연님의 프로필 이미지
        김소연

        Reviews 2

        Average Rating 4.5

        5

        98% enrolled

        쉽게 설명해 주십니다.

        • 김영승님의 프로필 이미지
          김영승

          Reviews 8

          Average Rating 5.0

          5

          76% enrolled

          감사합니다.

          • dnsgnk87님의 프로필 이미지
            dnsgnk87

            Reviews 2

            Average Rating 5.0

            5

            98% enrolled

            유익한 교육이었습니다.

            $62.70

            ubob's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!