[PART 01 Excel]

CHAPTER 01 Getting Started with Excel: Screen Configuration and Data Entry

000 Examining Excel's Basic Screen Layout
001 Open and save the workbook as an Excel template file
002 Save as PDF file
003 Show/Hide Screen Component Gridlines and Ribbon Menu
004 Add commands to the Quick Launch Toolbar and execute them with shortcut keys ★Priority
005 Specifying a range with the keyboard
006 Specifying a range by defining a name
007 Adjusting row height and column width
Paste and paste special while maintaining column width 008
009 Paste by connecting to a picture
010 Changing the worksheet name and tab color ★Priority
011 Move/copy/delete worksheet
012 Protecting Worksheets
013 Entering character/number data ★Priority
014 Enter date/time ★Priority
015 Entering Chinese characters/symbols
016 Inserting and Editing Notes
017 Modifying data and inserting/deleting rows ★Priority
018 Filling data with the fill handle
019 Quickly fill columns of data with Quick Fill
020 Setting Korean/English mode with data validation
021 Setting up a list with data validation

CHAPTER 02 Editing and Printing Documents

022 Applying table format and cell styles
023 Change the design of the table and convert it to a range
Formatting in the 024 Font Group ★Priority
025 Formatting in the Customize, Display Format group ★Priority
026 Customizing the display format of character and numeric data ★Priority
Formatting numbers to display in Korean
028 Formatting positive/negative/zero numbers in numeric data display format
029 Truncate numbers below million and display commas every four digits
030 Setting custom display formats for days of the week and cumulative time
031 Conditional Formatting with Cell Highlighting and Top/Bottom Rules ★Priority
032 Conditional formatting with color tones and icons
033 Conditional formatting and editing rules with bars
034 Conditional formatting with formulas ★Priority
035 Formatting Tables and Conditional Formatting Using the Quick Analysis Tool
036 Fixing the frame ★Priority
037 Working with documents arranged in a tiled layout
038 Setting the print selection area and margins in print preview ★Priority
039 Specifying the title row to be printed repeatedly ★Priority
040 Previewing page breaks and specifying print scale
041 Editing page break lines
042 Setting the Header/Footer ★Priority
043 Inserting a background image in the header ★Priority

CHAPTER 03 Writing Formulas and Using Functions

044 Creating formulas with relative references ★Priority
045 Creating formulas with absolute references ★Priority
046 Creating formulas with mixed references ★Priority
047 Specifying a range by defining a name
048 Creating a formula by referencing cells in another sheet
049 Calculating formulas with the Auto Sum feature
Calculating formulas at once using structured references in Table 050
Displaying summary rows in table 051
052 Finding the sum and maximum value using the SUM, MAX, and LARGE functions
053 Calculating attendance and absence dates using COUNTA and COUNTBLANK functions ★Priority
054 Rounding down and up with INT and ROUND functions
055 Displaying the quotient and remainder using the QUOTIENT and MOD functions
056 ROW, SUMPRODUCT function to get row number and total amount
057 Finding the rank using the RANK.EQ and RANK.AVG functions
058 Finding course completion and education scores using the IF function ★Priority
059 Finding departmental rewards and department ranks using nested IF and IFS functions
060 Classifying Corporate Credit Ratings with IF, AND, and OR Functions
061 Finding the average with the AVERAGE and AVERAGEIF functions
062 Finding the minimum value using the MIN and MINIFS functions
063 Finding the number of people who meet the conditions using the COUNTIF and COUNTIFS functions ★Priority
064 Get a sum that meets conditions using UNIQUE, SUMIF, SUMIFS functions and structured references ★Priority
065 Finding gender from resident registration number using the CHOOSE and MID functions
066 Modifying text using the LEFT, FIND, SUBSTITUTE, and TEXTJOIN functions
067 Calculating date of birth using DATE, LEFT, and MID functions
068 Calculating the length of service and retirement payment date using the DATEDIF and EOMONTH functions
069 Displaying product information using VLOOKUP, XLOOKUP, and HLOOKUP functions ★Priority
070 Handling errors with the IFERROR function
071 Selecting the Lowest Price Vendor with INDEX and MATCH Functions
072 Extracting and Sorting Data with FILTER, SORT Array Functions and Structured References
073 Loading images using the IMAGE array function

CHAPTER 04 Creating a Chart

074 Creating a chart suitable for data and changing the chart type ★Priority
075 Change chart layout, color, style, and filter chart data ★Priority
076 Adjusting the tick marks on the chart and displaying labels and legends
077 Set the chart background and remove gridlines
078 Pie Chart 3D Format and Theme Change ★Priority
079 Creating a Dual Axis Combo Chart
080 Sunburst Chart: A Glance at Business Areas
081 Inserting a Sparkline Chart and Changing Its Type
082 Changing Sparkline Chart Style and Design

CHAPTER 05 Database Management/Analysis and Using ChatGPT

083 Creating a database from a text file
084 Split text by delimiter ★Priority
085 Remove duplicate data and create a product list ★Priority
086 Consolidate data with the same items and apply quick formatting ★Priority
087 Sort by cell value ★Priority
088 Sort by user-specified order
089 Calculating subtotals with the SUBTOTAL function
090 Extracting data with automatic filters ★Priority
Extracting data by average and top 10 criteria
092 Creating multiple subtotals with multiple groups ★Priority
093 Copy only the summarized results of the partial sum
094 Creating a Recommended Pivot Table
095 Creating a New Custom Pivot Table ★Priority
096 Grouping/Ungrouping Pivot Tables and Filtering Fields
097 Changing the Pivot Table Layout and Design
098 Inserting/Removing PivotTable Slicers and Time Bars
099 Ask questions about Excel functions and get help on ChatGPT ★Priority
100 Fix Functional Errors and Ask Functional Questions with ChatGPT ★Priority
101 Passing data to ChatGPT and asking functional questions ★Priority
102 Analyzing Data with ChatGPT, Extracting Keywords, and Classifying Them ★Priorities

[PART 02 PowerPoint]

CHAPTER 01 Creating a Basic Presentation

000 A look at PowerPoint's basic screen layout
001 Setting basic options to improve work efficiency
002 Customizing the Quick Launch Toolbar
003 Create your own ribbon menu
004 Displaying grid lines, guide lines, and rulers
005 Rename objects and show or hide objects
006 Create a new presentation with background formatting applied
007 Change slide size ★Priority
008 Adding Slides and Changing Layouts ★Priority
009 Move, copy, paste, and delete slides ★Priority
010 Apply quick styles after entering text ★Priority
011 Entering text with WordArt with Quick Style applied ★Priority
012 Applying a quick style after drawing a shape ★Priority
013 Applying a quick style after inserting a picture ★Priority
014 Apply quick style after inserting table ★Priority
015 Applying quick styles after inserting a chart ★Priority
016 Opening and Saving Presentation Documents ★Priority

CHAPTER 02 Creating Presentation Slide Background Formats

017 Creating a new theme font ★Priority
018 Creating a new theme color ★Priority
019 Change the slide background format
020 Change only the title slide background format
021 Using a changed layout as a slide
022 Inserting slide numbers
023 Save new theme

CHAPTER 03 Writing and Formatting Your Presentation

Entering text on slide 024
025 Change font, font size, and font color ★Priority
026 Setting bullets and changing format
027 Change bullets to numbers
028 Adjusting line and paragraph spacing
029 Adjusting the list level
030 Change the font of the entire presentation at once

CHAPTER 04 Visualizing and Formatting Your Presentation

031 Won and Format ★Priority
032 Create a new shape by merging multiple shapes
033 Resize and copy shapes horizontally
034 Aligning shapes at even intervals
035 Extracting a color with an eyedropper and applying it to a shape
036 Applying the same shape format to other shapes
037 Creating a three-dimensional figure from a flat figure
038 Entering text after inserting a SmartArt graphic ★Priority
039 Changing the format of a SmartArt graphic
040 Adding Shapes to a SmartArt Graphic
041 Converting Text to SmartArt Graphics
042 Converting a Picture to a SmartArt Graphic
Designing Table 043
044 Designing a Chart
045 Saving and Reusing Well-Made Chart Formats
046 Inserting an online picture
047 Create slides quickly and easily with Designer
048 Highlighting only a specific part of the picture
049 After changing the picture format, keep the format and change only the picture.
050 Removing unnecessary parts from the picture
051 Crop the image to the desired shape and reduce the size
052 Creating a Presentation with a Photo Album
053 Insert and edit icons
054 Inserting a 3D Model
055 Drawing with digital ink and replaying
056 Capture a portion of the screen and add it to a slide

CHAPTER 05 Inserting and Formatting Multimedia Elements
057 Run to a specific slide after inserting audio ★Priority
058 Smooth the beginning and end of audio after trimming
059 Apply quick styles after inserting a video ★Priority
060 Change the appearance and format of a video
061 Keep only the desired part of the entire video
062 Specifying a specific point in a video
063 Creating a Video Cover
064 Compressing media files

CHAPTER 06 Organizing and Saving Presentation Slides

065 Organize slides into sections
066 Creating an auto-save file
067 Creating a PDF Document
068 Creating a video file
069 Creating a Picture Presentation
070 Save each slide as a JPEG file
071 Setting a password for a presentation file

CHAPTER 07 Preparing and Presenting a Presentation

072 Applying animation to objects
073 Add animation and apply it to other objects ★Priority
Applying a screen transition effect to slide 074
075 Applying Morphing Transition Effect ★Priority
076 Creating slides that advance automatically
077 Reconfiguring the Slideshow
078 Creating a table of contents using the zoom function
079 Write and print your presentation with slide notes
080 Create and print audience flyers
081 Practice before your presentation
082 Start Slideshow ★Priority
083 Presenting using the Presenter Tool ★Priority
Adding a Presenter Live to Slide 084
085 Recording a Slideshow

CHAPTER 08 Creating Presentation Slides Using AI Tools

086 Creating an Illustrated Slide with Napkins ★Priority
087 Creating Mockup Slides with Shots ★Priorities
088 Creating an image slideshow with Midjourney ★Priority

[PART 03 Word]

CHAPTER 01 Setting up Word for a better and more convenient viewing experience

A look at the basic screen layout of Word 000
001 Create a new document and save it
002 Save as Adobe PDF distribution document ★Priority
003 Learn about various screen viewing features

CHAPTER 02 Input and Basic Editing

004 Enter Chinese characters and register frequently used characters.
005 Enter special symbols ★Priority
006 Entering a formula
Enter the 007 unit symbol and use autocorrect ★Priority
008 Find and Replace
009 Using the Clipboard and Smart Tags
010 Importing Excel Tables into Word ★Priority
011 Tracking Changes

CHAPTER 03 Font and Paragraph Decoration

012 Specifying font, font color, font size, underline, and shading
013 Changing letter spacing and length ★Priority
014 Setting superscripts and annotations
015 Insert paragraph numbers and set tabs ★Priority
Inserting bullets in paragraph 016 ★Priority
017 Indentation of the first line and indentation of the second line and below ★Priority
018 Creating a menu using multi-column and tabs
019 Create a style and organize your document ★Priority
020 Format and add to style ★Priority

CHAPTER 04 Using Shapes and Objects

021 Adding a signature to the payment field ★Priority
022 Insert a picture and crop it to fit the shape (insert caption)
023 Creating a title box using shapes ★Priority
024 Importing charts from Excel ★Priority

CHAPTER 05 Decorating the Table

Insert table 025 and edit it as you like
026 Merge and split cells and enter text ★Priority
027 Specifying cell borders and shading ★Priority
028 Split the table and set the column widths to the same ★Priority
029 Sort table contents and enter functions ★Priority

CHAPTER 06 Page Management and Printing
030 Set different page orientations for each zone ★Priority
031 Writing Headers/Footers ★Priority
032 Create a header by section ★Priority
Insert page number 033 ★Priority
034 Inserting footnotes and endnotes
035 Merging multiple documents into one

CHAPTER 07 Creating a Report Using ChatGPT
036 Writing a Business Trip Report Using ChatGPT
037 Organizing paper receipts for business trip expenses ★Priority
038 Inserting a cover page into a document ★Priority
Creating a title box using Table 039 ★Priority
040 Print on one page ★Priority
041 Setting Pages and Margins
Creating a table of contents based on the 042 style ★Priority

[PART 04 Korean]

CHAPTER 01 Establishing Basic Korean Skills

000 Take a look at the Korean start screen and basic screen layout.
001 Create a new document and save it
002 Loading documents and assigning and decrypting passwords ★Priority
003 Setting up auto-save ★Priority
004 Converting PDF files to Hangul ★Priority
005 Installing fonts using Hancom Assets ★Priority

CHAPTER 02 Input and Basic Editing

006 Entering and converting Chinese characters
007 Register frequently used words directly in the Chinese character dictionary
008 Entering special characters using the character table ★Priority
Enter the 009 unit symbol
Using 010 Memo
011 Using bookmarks/hyperlinks ★Priority
012 Check spelling
013 Find and Replace ★Priority

CHAPTER 03 Document Editing and Font Decoration

014 Using the Clipboard ★Priority
015 Change font, font color, and font size
016 Specifying underline, shading, border/background
017 Applying shadows, highlights, and strikethroughs
018 Adjusting letter spacing and length
019 Copy the font shape ★Priority
020 Change the font type in a document at once ★Priority

CHAPTER 04 Decorating Paragraphs Using Styles

021 Apply indentation and outdentation and create styles ★Priority
Applying outline numbers using the 022 style ★Priority
Modifying paragraph numbers in a document with style 023 applied ★Priority

CHAPTER 05 Page Decoration

024 Setting up editing paper ★Priority
025 Applying Header/Footer ★Priority
Page 026 Enter page number ★Priority
Page 027 Start with a new number ★Priority
028 Decorating Paragraphs in Multiple Columns ★Priority
029 Creating a document with a different document orientation
030 Writing supplementary explanations with footnotes/endnotes

CHAPTER 06 Using Shapes and Objects

031 Inserting a picture and setting its position ★Priority
032 Decorating the Picture ★Priority
033 Add my signature to document ★Priority
034 Creating a title box using shapes ★Priority

CHAPTER 07 Decorating the Table

035 Inserting, resizing, and positioning a table ★Priority
036 Inserting and deleting lines/columns
037 Merge and divide cells (change border) ★Priority
038 Set cell height and width to be the same (distribution alignment) ★Priority
039 Using the Split, Paste, and Multi-Page Support Features
040 Specifying table cell properties (diagonal, fill) ★Priority
041 Sort table contents and display thousands separator commas
042 Flipping Tables and Using Table Yards

CHAPTER 08 Creating and Printing Documents Using ChatGPT

043 Writing a business trip report using ChatGPT ★Priority
044 Creating a table of strings ★Priority
Creating a title box using Table 045 ★Priority
046 Creating a Plan Cover
047 Inserting documents and creating a table of contents ★Priority
048 Organizing Paper Receipt Expenses
049 Print Report (Select, Collect) ★Priority
050 Printing a Watermark (Printing Document Information in the Footer)

Easy concepts, quick functions, and immediate practical application!
A practical introductory book designed to enable even beginners to get started in practice in a short period of time.

1.
Finished in one volume
You can learn Excel, PowerPoint, Word, and Hangul all in one book.
The core functions of each program are well-balanced, so even beginners can get started without any burden!

2.
All versions available
It is structured so that you can learn in all versions of Excel, PowerPoint, Word, and Hangul.
It includes versions widely used in practice, from 2010 to Office 365, as well as the latest version 2024.
You can learn the same thing regardless of which company or version.

3.
Faster and easier learning
We've simplified the hands-on process to make learning quick and intuitive.
With a structure that can be followed right away rather than complicated explanations, you can learn the core functions of each program in a short period of time!

4.
Selecting core functions
It consists of practical examples that can be used right away in companies, carefully selected by experts.
You can learn 101 core functions of Excel, 88 core functions of PowerPoint, 50 core functions of Hangul, and 42 core functions of Word.
Just this practical example alone can be put to use in your work right away.


5.
Priority learning
You can mark the features you need to learn first so you can learn them first if you need to learn them quickly.
You can learn only the necessary functions first, and it is optimized for taking them out and looking them up whenever you have time while working.

6.
Includes tips on using ChatGPT & AI
We'll guide you through how to apply ChatGPT and AI to your work to improve efficiency.
You can learn automation techniques to reduce repetitive tasks and work smarter.


7.
Written by professional instructors
Written by a team of professional instructors who have provided practical training to numerous companies and institutions.
It is full of examples and explanations that are immediately helpful for practical work that practitioners need.