[Excel]

CHAPTER 01 From data preprocessing to writing practical reports!

SECTION 01 Editing Data Faster
01 Learn how to quickly select data
02 Find cells containing special characters and enter '0' at once
03 Quickly Fix Incorrect Date Data
Enter data at regular intervals
04 Modify the unit price table without a formula by applying a discount rate
05 Remove line break characters at once

SECTION 02 Formatting Cells to Create a Clean Report
01 Learn frequently used shortcut keys
02 Align the title neatly and evenly
03 Aligning the title in the center of the range without merging cells
04 Creating a border to emphasize content

SECTION 03: Specifying the display format to complete an accurate report
01 Learn frequently used custom display formats
02 Displaying digits in millions
03 Displaying the date as a day of the week
04 Display ▲ symbol only on items that increased compared to the previous month
05 Filling in the gaps between entries and pages in the table of contents

CHAPTER 02: The Essentials of a Capable Worker! Mastering Functions

SECTION 04 Learning basic functions frequently used in practice
01 Calculating Costs Based on Working Hours - IF Function
02 Calculating the number of projects and research costs - COUNTA, COUNTIF, and SUMIF functions
03 Calculating the quarter value from the sales date - IFS function
04 Calculating price using unit price by product code - VLOOKUP function

SECTION 05 Handling advanced functions to improve work efficiency
01 Calculating the number of items sold - SUMPRODUCT function
02 Calculating incentives based on department and achievement rate - VLOOKUP, INDIRECT functions
03 Get the information you want at once using the employee number - VLOOKUP, MATCH functions
04 Get employee number and date of employment from the left column based on name - XLOOKUP function
05 Finding Export Partners by Rank - INDEX, MATCH, LARGE Functions

CHAPTER 03 Analyzing Data and Visualizing Reports

SECTION 06 Excel Visualization and Reporting Techniques for Practical Data
01 Linking Summary Reports and Charts
02 Create a combo chart with two series with different values
03 Create a chart that analyzes sales averages using error bars.
04 Highlight only the top-selling items in the entire row
05 Highlight only reorder items by marking them with a flag
06 Edit Rule to Adjust Negative Data Bar Values
07 Creating Production Index Statistics Trends with Sparklines

SECTION 07: Sorting and Filtering Data to Manage Data
01 Sorting the housing supply rate from the metropolitan area
02 Sort all fields at once in the desired order
03 Extracting data that meets multiple conditions
04 Extracting data using OR conditions among multiple items
05 Extracting data only for specific days and above-average sales - Advanced Filters and Formulas

SECTION 08 Quickly Summarizing Data with PivotTables Without Calculations
01 Create and name a table
02 Summarizing broadcast frequency and sales by host using a pivot table
03 Analyze the top 3 companies by quarterly sales
04 Changing the layout and design of a pivot table
05 Changing the summary function in the pivot table and displaying the sales ratio
06 Filter reports by MD in charge
07 Transferring Pivot Table Values ​​to Form Form
08 Setting up relationships and creating pivot tables

CHAPTER 04: Improving Work Efficiency with ChatGPT and Excel Copilot

SECTION 09: Writing Advanced Formulas and Functions with ChatGPT and Copilot
01 Explain and generate complex formulas in natural language
02 Creating a Sales Report with Multiple Conditions
03 Easily create conditional and nested functions
04 Optimizing Functions

SECTION 10 ANALYZING DATA AND DEVELOPING INSIGHTS
01 Automatically create and modify pivot tables
02 Identifying Data Trends and Patterns
03 Automatically summarize data and generate key statistical indicators
04 Deep-dive into the results with Python

SECTION 11: Visualizing Data and Creating Charts with Generative AI
01 Get recommendations for chart types suitable for your data
02 Create and customize charts using natural language.
03 Creating and Applying Conditional Formatting Rules

SECTION 10 Getting Help with VBA and Macros
01 Writing and Explaining VBA Code with ChatGPT
02 Create and apply macros for repetitive tasks

[PowerPoint Edition]

CHAPTER 01: Mastering Practical Secrets to Improve Your Design

SECTION 01 Upgrading Your Designs with Shape Graphics
01 Using theme colors effectively
02 Using gray to naturally emphasize shapes
03 Quickly select only the desired color with the eyedropper
04 Expressing light effects with gradation
05 Quickly change shape format by copying the format
06 Create a picture by filling multiple shapes

SECTION 02 Creating Visual Materials Using SmartArt Graphics
01 Converting Text to SmartArt Graphics
02 Designing a 7-piece pie with SmartArt graphics
03 Changing the number of inputs and outputs in a funnel design

CHAPTER 02 Visualizing Information with Images and Graphs

SECTION 03 Using Images to Enhance the Design
01 Create a PNG image with a transparent background
02 Removing image backgrounds from utility sites
03 Reduce file size by deleting cropped image areas
04 Change pictures easily and quickly with 'Change Picture'
05 Change the color of only some areas of the map with an SVG image
06 Freely crop images using the shape merge function

SECTION 04 Designing Tables and Charts to Emphasize Data
01 Create a table that emphasizes data by minimizing borders
02 Creating a Progress Chart with Pie Charts and Shapes
03 Create an icon chart that displays the ratio by duplicating icons
04 Create an infographic chart by cutting out the image.

CHAPTER 03 Managing Designs with Themes and Utilizing Social Media

SECTION 05 Managing Designs with Themes and Masters
01 Applying the same background image to all slides
02 Changing the background design in the master
03 Copy the format of the original document to the slide
04 Apply your favorite theme design to the current file
05 Setting a custom file as the default theme
06 Apply design ideas to design like a pro

SECTION 06 Creating a Presentation Document for Social Media
01 Create a Facebook cover design
02 Creating Card News for SNS
03 Creating YouTube Thumbnails
04 Creating a Naver Blog Thumbnail

CHAPTER 04 Creating Smart Presentations with Generative AI

SECTION 07 Easily Draft Presentations Using AI
01 Turn your ideas into slides! Use AI to draft.
02 Review and revise the AI-suggested slide outline.
03 Automatically create a presentation document from a Word file
04 Automatically Create Slide Summary and Presenter Notes

SECTION 08: Visualizing Data and Content Easily and Effectively with AI
01 Easily visualize charts and data with ChatGPT
02 Automatically visualize text analysis
03 Quickly summarize video data with AI

[Word Edition]

CHAPTER 01 Mastering Essential Word Skills

SECTION 01 Formatting and Decorating Your Document
01 Change text and formatting together
02 Change the spacing between letters and copy the format
03 Specifying line and paragraph spacing
04 Specifying tab spacing
05 Split text evenly and automatically align it

SECTION 02 Freely handling documents containing objects
01 Insert a picture and arrange it to match the text.
02 Decorate the title with a text box
03 Inserting and editing formulas

SECTION 03 Inserting Tables and Charts
01 Calculating the average of table data
02 Split the table and merge the consecutive tables into one.
03 Inserting a chart and changing its type

CHAPTER 02: Creating Documents Systematically Using Convenient Features

SECTION 04 Writing a Document with Order
01 Creating a Number Style List
02 Specifying bullet style
03 Specifying a multi-level list
04 Changing the starting number for numbering
05 Adjusting bullet and text spacing

SECTION 05 Organizing documents using page functions
01 Inserting headers and footers
02 Inserting page numbers
03 Divide into zones
04 Merge separate areas into one
05 Specify different headers for each zone

SECTION 06 Applying Styles to a Document
01 Create a new style and apply it to all documents
02 Editing styles and applying them automatically
03 Specifying outline levels for styles
04 Automatically create a table of contents using style

CHAPTER 03: Using AI to Create Documents Efficiently

SECTION 07 Get AI-powered Document Creation and Editing Assistance
01 Quickly draft documents using AI
02 Edit text in natural language and create a detailed table of contents
03 Automatically correct grammar and spelling
04 Rewriting documents in different styles and tones

SECTION 08: Enhancing Document Design and Visualization with AI
01 Automatically create and modify tables and charts
02 Recommending and Inserting Images and Graphic Elements
03 Summarizing the document and supplementing the content

100% realism!
Reduce work hours and increase efficiency with AI!

[Practical Master 1] Work faster! Significantly reduce work hours.
It reflects the latest versions of Microsoft 365 as well as Office 2013 to 2024.
We'll give you only the essential tips to get your work done quickly with our work time-saving skills.

[Practical Master 2] Essential tools for office workers in one volume! Includes Excel, PowerPoint, and Word.
This book contains the core office tool features that office workers encounter every day.
The author's practical, on-site examples, packed with his expertise, will help you increase your work efficiency by 200%.

[Practical Master 3] Get smarter with AI! Provides prompts tailored to your work.
Reduce repetitive tasks with practical examples and work automation tips leveraging AI, such as ChatGPT and Copilot, and create a smarter work environment with customized prompts tailored to your work goals and situations.

[Practical Master 4] Easier with video lectures! Free online direct lectures available!
We provide free YouTube online lectures and practical templates.
By following along with the video lectures, you will learn how to resolve various errors and variables that may occur in the workplace.