Windows version
CHAPTER 1 Getting Started with Windows 10
[New Features & Shortcuts]
Section 01 First Encounter with Windows 10
01 Things to know before installing!
[Priority 01] 02 Upgrade to Windows 10
03 Check out the new features in Windows 10
04 Learn Windows 10 shortcuts

[Start Menu]
Section 02: A Look at the Convenient and Diverse [Start] Menu
[Priority 02] 01 Start Windows from the [Start] menu!
02 Turning Windows 10 on and off safely
03 Launch the app from the [Start] menu
[Priority 03] 04 Adding and removing apps to the Start screen

[Windows environment]
Section 03 Changing Windows to Suit You
01 Create a dual monitor effect with virtual desktops
[Priority 04] 02 Setting up the taskbar for easy work
[Priority 05] 03 Change the lock screen picture to your liking

CHAPTER 2 Using Web Browsers and Default Apps
[Internet]
Section 01 Using the Web Browser for Its Purpose
[Priority 06] 01 Should I use Edge or Internet Explorer?
02 Examining the Edge browser's screen layout
03 Adding Favorites in Edge Browser
04 Use Reading View to see only the content you need at a glance
05 Take notes and save them on the website
[Priority 07] 06 Pin Internet Explorer to the Start Screen
07 Changing the default browser

[App Usage]
Section 02 Using Windows 10's Default Apps
01 Managing your email account in the 'Mail' app
02 Check the weather forecast with the 'Weather' app
[Priority 08] 03 Purchase game apps from the Windows Store

CHAPTER 3: Becoming a Windows 10 Expert
[Advanced Settings]
Section 01 Learning Advanced Windows 10 Usage
01 Change the default Windows app to your desired app
02 Running the installation file (ISO file) directly in Windows
[Priority 09] 03 Check your computer's specifications accurately.
04 Using Your Laptop Battery Economically
05 Cleaning up unnecessary files in the repository

[Recovery & Security]
Section 02: Learn how to use Windows 10 safely
01 Stop unnecessary startup programs
02 Create a system restore point
03 Find a restore point and restore the system
04 Update Windows
[Priority 10] 05 Protecting My Data with BiltLocker Password
06 Scanning for Spyware with Windows Defender

CHAPTER 4 Office and Windows 10 are a perfect match!
[OneDrive]
Section 01: Using OneDrive, Your Own Online Storage Space
01 Access your data anytime, anywhere with OneDrive
02 Managing folders/files on the OneDrive site
03 Saving Office Files to OneDrive
04 Using Office Files Online

[OneNote]
Section 02 All notes and records in OneNote!
01 Collecting information and taking notes with OneNote
02 Entering content in OneNote
03 Check and edit OneNote on the web

Excel version
CHAPTER 1 Creating a Basic Excel Document
[Document Start]
Section 01 Getting Started with Excel 2019
01 Launch Excel 2019
02 Screen composition overview
03 Check out the new features
04 Add frequently used commands to the Quick Access Toolbar
[Priority 17] 05 Quickly Create Documents Using Templates
06 Setting up the usage environment that is just right for me
Review! Practical Examples / Templates / Personal Preferences

[Document Edit]
Section 02 Handling Excel Data Accurately
[Priority 07] 01 Understanding Excel Data Types
02 Entering text and symbols
03 Entering numbers and date/time data
04 Convert to Chinese characters and specify input format
05 Entering continuous data using the autofill handle
06 Editing and deleting entered data
Review! Practical Examples / Basic Data Entry / Quick Data Entry

Section 03 Freely handling cells and worksheets
[Priority 04] 01 Copy and move cell data
[Priority 12] 02 Quickly Select a Cell Range
03 Move item positions, adjust column widths, change and edit worksheets
Review! Practical Examples / Copying Data and Editing Items / Moving Items and Editing Sheet Tabs

Section 04 Setting the Printing Environment and Saving the Workbook
01 Specifying paper orientation and margins
[Priority 09] Specifying the pages to print and the print title
03 Specifying the header/footer for printing paper
04 Specifying the number of prints and paper size
05 Save the document with a password
06 Create a PDF document and save it to OneDrive
Review! Practical Examples / Entering Headers and Setting Print Settings / Password Protection and Publishing PDF Documents
Key! Practical Notes
Save and edit documents in OneDrive with Excel Online

CHAPTER 2: REPRESENTING DATA VISUALLY
[Format designation]
Section 01 Formatting Cells to Decorate Your Document
01 Formatting the title and text
02 Decorate your report with customization and formatting.
03 Specifying a border for the report
[Priority 10] 04 Specifying display formats for numeric and date data
[Priority 11] 05 Reviewing Custom Display Formats
06 Specifying a custom display format for invoices
Review! Practical Examples / Cell Formatting / Cell Styles and Formatting

Section 02 Highlighting Data with Conditional Formatting
01 Highlighting data that meets specific conditions
02 Formatting the Top/Bottom 20 Sales Quantities
03 Specifying conditional formatting and new rules using formulas
04 Analyze sales by specifying color tones and data bars
Review! Practical Examples / Highlighting Cells with Conditional Formatting / Comparative Analysis of Performance by Specifying Colors and Icon Sets

[chart]
Section 03 Presenting Data with Charts and Sparklines
01 Chart Components and Quick Chart Creation
[Priority 14] 02 Quickly insert charts using recommended charts
03 Chart Types and Editing Chart Data
04 Formatting the chart in detail
05 Using Sparklines to Monitor Sales Trends
06 Expressing Different Charts in One Combo Chart
07 Expressing Data Hierarchy - Sunburst Chart
Review! Practical Examples / Inserting and Decorating Charts / Analyzing Cost Processing Details with Sparklines and Combo Charts
Key! Practical Notes
① Analyzing data using a Pareto chart
② Analyzing the income statement using a waterfall chart

CHAPTER 3: Handling Formula Calculations and Practical Functions
[Function]
Section 01 Learning Formulas and Automatic Functions
[Priority 03] 01 Reviewing Formula Writing and Cell Reference Types
02 Calculating settlement details using basic operators
03 Define a name and calculate a formula
[Priority 15] 04 Calculating the sum/average using the auto-sum function
05 Finding the number of companies and the maximum amount using the function library
Review! Practical Examples / Calculating Sales Plans and Performance Ratios with Operators and Names / Complete Reports with AutoSum and the Function Library

Section 02 Learning Basic Functions
01 Let's take a look at the types of functions and how to use them.
[Priority 16] 02 Calculating sales subtotals and rankings by category - RANK.EQ, SUBTOTAL functions
[Priority 18] 03 Learn about the top 3 commissions and sales - LARGE and ROUND functions
[Priority 01] 04 Evaluating whether an employee has failed a test using nested functions - COUNT, OR, IF, and IFS functions
05 Creating a Customer Complaint Processing Status Table - DATE, LEFT, TEXT Functions
Review! Practical Examples / Creating a Summary Report on Sales Status / Managing Club Membership Lists and Indicating Event Invitations

Section 03 Mastering Advanced Practical Functions
01 Examining frequently used functions in practice
[Priority 19] 02 Creating a Monthly Sales Summary Report - COUNTIFS, SUMIFS Functions
03 Calculating Sales Average and Individual Sales - AVERAGEIFS, IFRROR, and INDIRECT Functions
[Priority 02] 04 Creating a TF team list and address - COLUMN, CONCAT, VLOOKUP functions
[Priority 20] 05 Calculating Project Allowances by Job Level - INDEX, MATCH Functions
Review! Practical Example / Sales Quantity, Total Sales, Average Sales Summary / Complete List with Find/Reference Functions
Key! Practical Notes
① Easily create nested functions
② Replace the function formula for project allowance by rank

CHAPTER 4: DATABASE MANAGEMENT AND DATA ANALYSIS
[Sort and Filter]
Section 01 Handling Databases
01 Insert a table and decorate it nicely
02 Editing the table and specifying summary rows
[Priority 05] Sorting data using field conditions in field 03
04 Sorting data by specifying multiple conditions
05 Creating a Summary Report Using Subtotals
06 Copying the results of a summary report using subtotals
Review! Practical Example / Inserting and Summarizing a Database into a Table / Creating a Summary Report with Sorting and Subtotals

Section 02 Searching and extracting only the desired data
[Priority 06] 01 Extracting Data Using Automatic Filters
02 Understanding Advanced Filters and Conditions
03 Extracting data using advanced filters
04 Extract only data applied with a function formula
05 Sort and extract data by color
Review! Practical Example / Extracting Temporary Employees from a Staff List / Extracting a List Using Functions and Advanced Filters

[Pivot Table]
Section 03 Using Expert Analysis Features
[Priority 08] 01 Specify and decorate the recommended pivot table
02 Adding a Summary Report to a PivotTable Report
03 Summarizing values ​​in a pivot table and changing the display format
04 Creating a Report Using a Pivot Chart
05 Filtering by inserting slicers and timelines
Review! Practical Example / Creating a Summary Report on Customer Status / Analyzing Reports with Pivot Charts and Slicers

[Macro]
Section 04 Automating Documents Using Controls and Macros
01 Adding [Development Tools] tabs and form controls
02 Complete a summary report using form controls
03 Creating a Sparkline Macro
04 Save and run as a macro file
05 Setting up and running a macro on a shape
06 Deleting Unnecessary Macros
Review! Practical Example / Automating Sales Summary Reports / Creating Advanced Filter and Delete Macros
Key! Practical Notes
① Upgrading PivotTable Analysis Capabilities with Conditional Formatting
② Creating a dashboard with slicers and timelines

PowerPoint version
CHAPTER 1: Creating a Basic Presentation Document
[Document writing]
Section 01 Getting Started with PowerPoint 2019
01 Take a look at the start screen
02 Check out the new features
03 Screen composition overview
04 Viewing the presentation format
05 Create a new presentation by selecting a theme
06 Saving the presentation
Review! Practical Example / Selecting a Theme File / Changing Themes and Colors

Section 02 Handling Slides Freely
01 Inserting a new slide
02 Select slides and change layout
03 Duplicate and move slides
04 Delete and reformat slides
05 Organize your slides into logical sections
06 Copy Slide
Review! Practical Examples / Changing and Deleting Slide Layouts / Splitting and Collapse Sections

[Text]
Section 03 Creating a Text Slide
[Priority 01] 01 Enter text
02 Entering Chinese characters and special characters
03 Formatting the font and decorating the text
04 Adjusting the list level of paragraphs
05 Changing the shape and color of bullets
06 Adjusting line spacing between text
07 How to break lines without cutting off Korean words
08 Decorating a Title Using WordArt Quick Styles
Review! Practical Examples / Changing Line Spacing / Customizing Bullet Styles
Key! Practical Notes
① Adjusting bullet and text spacing
② Change the font of a document at once

CHAPTER 2 Creating Visual Presentations with Shapes and Graphic Objects
[Shape/Diagram]
Section 01 Creating an Illustrated Slide Using Shapes
01 Draw and align shapes using [Shift]
[Priority 05] 02 Arrange and group shapes in a balanced manner
[Priority 06] 03 Place shapes accurately with Smart Guides
[Priority 03] 04 Filling shapes with color and changing outlines
05 Changing the shape of a shape
06 Expressing depth and perspective with shadow effects
Review! Practical Examples / Grouping Shapes and Smart Guides / Specifying Shadows

Section 02 Designing Illustration Slides with SmartArt Graphics
[Priority 07] 01 Inserting SmartArt Graphics and Changing the Layout
02 Changing the color and style of SmartArt graphics
03 Converting text to SmartArt graphics
04 Converting SmartArt Graphics to Text
Review! Practical Examples / Converting Text to SmartArt Graphics / Changing SmartArt Graphic Layout and Style

[Figure/Table/Chart]
Section 03 Creating High-Quality Presentations Using Images
01 Insert a picture and adjust spacing and lines
[Priority 02] 02 Change the shape of the picture and specify effects
[Priority 15] 03 Make the background of the picture transparent
04 Correcting faint and dark images to make them clearer
056 Cut out and decorate unnecessary parts of the picture
Review! Practical Examples / Inserting Images and Applying 3D Rotation Effects / Copying Images and Changing Their Colors

Section 04 Creating Powerful Slides with Tables and Charts
[Priority 08] 01 Insert a table and enter text
02 Specifying table styles in the table
03 Changing the layout of the table
04 Specifying borders and shadow effects for cells in a table
[Priority 09] 05 Inserting a chart and switching rows/columns
06 Change chart colors and quickly specify layout
Review! Practical Examples / Adding Shadows and Reflections to Tables / Changing Chart Layouts
Key! Practical Notes
Emphasize text in an image by specifying a shape gradient effect.

CHAPTER 3 Creating a Vibrant Multi-Presentation
[Audio/Video]
Section 01 Creating Multimedia Slides with Audio and Video
[Priority 10] 01 Insert an audio file and specify background music.
02 Stop background music on the desired slide
[Priority 11] 03 Insert a video and run it automatically
04 Applying Styles and Video Effects to Your Video
[Priority 12] 05 Trimming Video Clips
06 Record the screen and record it as a video
Review! Practical Examples / Inserting Background Music and Looping / Inserting and Automatically Playing a Video

[animated movie]
Section 02 Creating dynamic effects on objects with animation
[Priority 18] 01 Specifying the 'Show' animation and changing the direction
02 Specifying and reordering 'emphasis' animations
03 Specifying the 'End' animation and changing the playback time
04 Specifying the 'Movement Path' animation and modifying the path
05 Adding additional effects and animations to text
06 Assigning trigger effects to animations
Review! Practical Examples / Applying Animations / Copying Animations and Changing the Order of Their Execution

[Slideshow]
Section 03 Moving through slides at once using hyperlinks
01 Setting Hyperlinks in Table of Contents Text
02 Setting up a hyperlink to the table of contents page
03 Click on a hyperlink to move to another document
Review! Practical Examples / Complete a Table of Contents with Hyperlinks / Removing and Setting Hyperlinks in Images

Section 04 Specifying cool screen transition effects for slideshows
01 Specifying the 'Page Turning' screen transition effect
[Priority 17] 02 Change the screen transition speed of all slides
03 Creating a presentation that runs automatically
[Priority 04] 046 Present Like a Professional with Presenter Tools
Review! Practical Examples / Setting Screen Transition Effects / Running a Slide Show with Presenter Tools
Key! Practical Notes
Create an event presentation that runs automatically

CHAPTER 4: Mastering Document Management Techniques for Presentations
[Theme Design]
Section 01 Managing Presentation Design with Themes and Masters
01 Understanding Themes and Masters
[Priority 16] 02 Designing a Slide Master
03 Specifying the same background image for all slides
[Priority 14] 04 Inserting a logo on all slides
05 Designing a Cover Slide
[Priority 13] 06 Inserting slide numbers on all slides
07 Specifying layout using multiple masters
09 Changing the default font for a presentation
Review! Practical Examples / Slide Master Design / Slide Number Display

[Save/Print]
Section 02 Saving Presentations in Various Formats
[Priority 19] 01 Save the presentation as a PDF document
02 Saving the presentation as a video file
03 Saving the presentation as a CD package
04 Saving the presentation as a handout
Review! Practical Example / Save as PDF / Save as PowerPoint Show

Section 03 Setting the Printing Environment for Presentations
01 Setting the orientation of the printing paper and slides
[Priority 20] 02 Print only necessary slides in grayscale
03 Print as a 3-slide flyer
04 Select only specific areas and print three copies at a time.
Review! Practical Example / Grayscale Print / Print as a 2-slide Handout

Word edition
[Document writing]
CHAPTER 1: Mastering the Basics of Word 2019
Section 01 Getting Started with Word 2019
01 Take a look at the start screen
02 Screen composition overview
[Priority 02] 03 Change font, font size, and font color
[Priority 04] 04 Inserting symbols and converting them to Chinese characters
05 Selecting a range of text in various ways
[Priority 05] 06 Change to new text all at once
07 Break pages at desired locations
Review! Practical Examples / Editing Title Formats / Inserting Chinese Characters and Symbols

[Format]
Section 02 Formatting and Decorating Documents
01 Paragraph alignment, borders, and shading
[Priority 07] 02 Indent the first line and entire paragraph
[Priority 08] 03 Specifying line and paragraph spacing
[Priority 15] 04 Specify tabs and display fill lines between tabs
05 Auto-align text using equal division
Review! Practical Example / Indenting the First Paragraph / Setting Tab Leaders

Section 03 Creating a list using numbers and bullets
[Priority 06] 01 Create a list of number styles
02 Specifying bullet style
03 Specifying a multi-level list
04 Change the starting number
Review! Practical Examples / List Indentation / Numbering
Key! Practice Notes / Easily Remove Consecutive Blank Spaces Using Find and Replace

CHAPTER 2 Document Management and Inserting Objects
[Document Management]
Section 01 Saving Documents, Setting Up Pages, and Printing
[Priority 19] 01 Save a new document
[Priority 20] 02 Open and edit PDF documents
[Priority 01] 03 Orientation of paper and page division
Specifying margins on page 04
05 Print only the current page
Review! Practical Examples / Editing PDF Documents / Setting Paper Orientation

[Insert object]
Section 02 Easily insert objects whenever needed
[Priority 10] 01 Insert a picture and arrange it to match the text.
[Priority 18] 02 Complete the document cover
03 Set a hyperlink to go to the desired site
[UP] 04 Inserting and Editing Notes
[UP] 05 Inserting and Editing Formulas
[Priority 11] Insert and play online videos
Review! Practical Examples / Inserting Images and Placing Them with Text / Entering Formulas

Section 03 Inserting Tables and Charts
[Priority 12] 01 Inserting and styling a table
02 Adding rows and columns to the table
[Priority 14] 03 Adjusting table size and cell width/height
04 Specifying diagonals and borders in the table
[Priority 13] 05 Inserting a chart and changing its type
Review! Practical Examples / Inserting and Merging Tables / Adding Rows to a Table
Key! Add practice notes/tables to Quick Document elements and use them quickly.

CHAPTER 3: Creating High-Quality, Advanced Documents
[style]
Section 01: Creating Consistent Documents Using Style
01 Specifying the title style
[Priority 03] 02 Specify and apply paragraph styles
03 Change the format and modify the style
04 Specifying outline levels for styles
[Priority 17] Automatically Creating a Table of Contents Using Style 05
Review! Practical Examples / Creating Heading Styles / Creating an Automatic Table of Contents

[Document Elements]
Section 02 Designing Documents for Presentation
01 Inserting a watermark and page border
[Priority 09] 02 Inserting page numbers
[Priority 16] 03 Specifying Headers and Footers
04 Set up multiple stages and divide the stages
05 Divide the parts where the content changes into sections
Review! Practical Examples / Specifying Footers and Watermarks / Dividing Sections

[Form Review]
Section 03 Writing Letters, Reviews, and Forms
01 Editing the main document and source data to be merged
02 Merge letters to complete the certificate
03 Inserting controls and creating a form document
04 Track and apply changes
Review! Practical Examples / Mail Merge / Form Document Creation and Document Protection

Korean version
Chapter 1: Writing a Basic Document
[Document writing]
Section 01 Getting Started with Hangul 2018
01 Starting and ending Hangul 2018
02 Screen composition overview
03 Explore the Toolbox and Menus
04 Creating a new document using the document yard

Section 02 Writing Korean Documents
[Priority 01] 01 Enter text
[Priority 06] 02 Enter and convert Chinese characters
[Priority 05] 03 Enter special characters and overlap letters
04 Revert and redo the work as it was originally done
05 Change the keyboard to input Japanese
Review! Practical Examples / Chinese Character Conversion / Special Character Insertion
[Format]
Section 03 Decorating documents using formatting and editing functions
[Priority 18] 01 Set and edit blocks
[Priority 02] 02 Changing the font and font size
03 Change the font style
[Priority 09] 04 Change paragraph alignment and specify margins
[Priority 07] 05 Edit text at once with Find and Replace
[Priority 04] 06 Decorate paragraph shape and copy shape
[Priority 12] Setting up tab 07
Review! Practical Examples / Setting Margins / Removing and Setting Tabs

Section 04 Setting up and printing editing paper
01 Change the document summary
02 Saving and managing documents by version
03 Setting the editing paper orientation and margins
04 Using different editing papers in the same document
05 Set the printing environment and preview the print appearance
Review! Practical Examples / Print Preview / Save PDF Document
Key! Practical Notes / Creating PDF Documents

Chapter 2: Creating Advanced Documents with Various Features
[Document Edit]
Section 01 Creating an Ordered Document
01 Specifying paragraphs with bullets
[Priority 08] 02 Specifying paragraph numbers and levels
03 Specify and change the starting number of paragraphs
04 Organizing paragraphs using the outline function
05 Create your own outline number shape
Review! Practical Examples / Paragraph Numbering / Outline Designation

[Document organization]
Organizing documents using Section 02 page functions
[Priority 20] Specifying the background and border on page 01
[Priority 14] 02 Specifying Header/Footer
[Priority 11] Page Numbering 03
[Priority 10] 04 Configure document layout by specifying multiple columns
05 Specify different backgrounds for each zone
[Priority 19] 06 Add comments and comments
Review! Practical Examples / Headers/Footers / Page Borders

[Insert object]
Section 03: Inserting Objects to Decorate Your Document
[Priority 15] 01 Inserting a Picture
[Priority 16] 02 Inserting a Text Box on the Map
03 Change the color and shape of a shape and copy it
04 Hyperlinking to a URL Address
05 Insert and play a video
06 Entering complex formulas
Review! Practical Examples / Inserting Images / Entering Formulas

[Table/Chart]
Section 04 Inserting Tables and Charts
[Priority 13] 01 Insert table and enter data
02 Add columns to table and merge cells
03 Adjusting the cell size of the table
04 Specifying background color and diagonal lines for cells in table
[Priority 17] 05 Chart the contents of Table 05
Review! Practical Examples / Merging Table Cells / Inserting Charts
Key! Practice Notes / Changing and Editing Chart Shapes


Chapter 3: Writing Functionally Convenient Documents
[style]
Section 01 Writing Style and Table of Contents
[Priority 03] 01 Specifying paragraph styles and character styles
02 Editing Style
03 Using styles in other documents
04 Save as template file
05 Creating a table of contents using style
Review! Practical Examples / Title Styles / Table of Contents

Section 02 Mail Merge and Creating Label and Form Documents
01 Create an invitation using Mail Merge
02 Creating a Label for Sending DM
03 Complete the label with Excel data
04 Creating a fax cover sheet using a form object
Review! Practical Examples / Using Excel Data / Using Form Objects