introduction

Chapter.
01 Microsoft Copilot Basics
Section 01 Basic Co-Pilot Knowledge You Need to Know
Section 02 Why should I use Copilot?
Section 03 10 Essential Terms Related to Artificial Intelligence
Section 04: A Complete Guide to the Differences Between the Confusing "Co-Pilot 3 Brothers"
Section 05: 3 Ways to Access Copilot
Section 06 What does a copilot look like?
Section 07 What is the difference between the chat window and the sidebar?
Section 08: 10 Tips and Tricks for Writing Prompts
Section 09: Four Prompt Engineering Case Studies
Section 10: Writing Long and Complex Prompts in an Electronic Notebook

Chapter.
02 Automating Basic Excel Functions with Copilot
Section 01 How to create a concise table of results
Section 02 Using Advanced Filters with Copilot
Section 03 Converting data entered in multiple lines into a single line
Section 04 [Bonus Example] An Easy Way to Merge Multiple Cell Contents into One Cell
Section 05 Easily Find Duplicate Data in Two Tables
Section 06 Sorting data by your own criteria
Section 07 [Bonus Example] Adding Pre-Entered Data to a Custom List
Section 08 Adding specific characters to the beginning or end of data
Section 09 [Bonus Example] Understanding and Using Custom Formats
Section 10 Converting Won to Thousands or Millions
Section 11 How to enter a 16-digit card number

Chapter.
Automating Excel Formulas with 03 Copilot
Section 01 How to use Excel functions you don't know well
Section 02 How to Understand Data Characteristics You See for the First Time
Section 03 [Bonus Example] How to Easily Analyze Descriptive Statistics
Section 04 Finding the information you want in the large table
Section 05 How to obtain the necessary information in continuation of the previous question
Section 06 How to extract only the necessary parts from a long string
Section 07 [Bonus Example] Another way to extract only the necessary parts
Section 08 Finding the sum that satisfies various conditions
Section 09 Writing Complex Multiple IF Formulas at Once
Section 10 How to Create a Clean Report
Section 11 [Bonus Example] Two Tips for Writing a Clean Report
Section 12 Calculating Special Averages
Section 13 Hide the last digits of your resident registration number by marking them with ***
Section 14 Displaying all materials that meet the conditions

Chapter.
04 Excel Macros and VBA Automation with Copilot
Section 01 Understanding Macros and VBA Basics
Section 02: Understanding the Copilot VBA Coding Process with Multiplication Tables
Section 03 Deleting Blank Rows in Bulk
Section 04 Automatically inserting rows as many times as the number entered
Section 05 Creating a summary table with automatically added formats
Section 06 Merge cells at once if they have the same values
Section 07 Implementing Functions Not Found in Excel - Data Swapping
Section 08 Automatically Summarizing Weekly Performance
Section 09 Consolidating Multiple Sheets into One

Chapter.
05 Automate Word tasks with Pilot
Section 01 Creating an Education Satisfaction Questionnaire
Section 02 Creating a Service Contract
Section 03 Adjusting the contract table format all at once
Section 04 Creating a Neat Word Table
Section 05 Batch highlighting of titles within a document

Chapter.
06 Automate PowerPoint tasks with Copilot
Section 01 Creating a Presentation Outline
Section 03 Creating multiple slides at once
Section 04 How to easily design all slides
Section 05 Unifying Slide Title Formats
Section 06 Aligning the Position of All Slide Titles

Chapter.
07 Useful Copilot Usage Tips You Should Know
Section 01: 3 Ways to Use the Copilot Notepad
Section 02 Two Ways to Use Copilot PDF Documents
Section 03 How to Create Attractive Characters with Co-Pilot
Section 04 Creating images in the style of master painters
Section 05: Analyzing Images and Creating Instagram Posts
Section 06 Summarizing Web Pages and YouTube Videos
Section 07 Creating K-POP Style Songs
Section 08 Creating a Personal Fitness Trainer
Section 09 Creating a Company Logo Using a Designer
Section 10: 6 Tips for Getting the Most Out of Your Copilot App

Special Appendix [1] New Microsoft Excel Function Utilization Collection
Section 01 Complete List of New Excel Functions (2019 Version and Later)
Section 02 17 New Excel Functions to Take Your Work Productivity to the Next Level

Special Appendix [2] Co-Pilot Prompt Utilization Collection
Section 01 Business Writing Prompts (28)
Section 02 Marketing-Related Prompts (35)
Section 03 Market Research Prompts (23)
Section 04 Prompts for Idea Generation (34)
Section 05 Sales & Promotion Prompts (28)
Section 06 Prompts for Writing Emails (27)
Section 07 Prompts for Effective Communication (24)
Section 08 Prompts for Creating Various Content (24)
Section 09 Prompts for Various Learning Activities (27)

Exceler Kwon Hyun-wook, an Excel expert
The second book in the "Excel Automation Essentials" series has been published!

Excel expert Kwon Hyun-wook, who runs the YouTube channel 'Excel TV', which Microsoft MVPs and Excel instructors often watch and refer to, has published a book called 'Copilot + Excel Work Automation Essentials', which utilizes Copilot and Excel.
The same author's previous work, "ChatGPT + Excel Work Automation Essentials," published in April 2023, presented a method for efficiently implementing work automation using ChatGPT and Office programs.
In addition to automating Excel tasks, we also provided methods for efficiently performing various tasks such as product planning, contract writing, and presentation material format automation.
This book, which contains the expertise of author Kwon Hyun-wook, has received positive reviews from readers who say it has reduced work hours and revitalized their work by applying AI.

His latest work, "Copilot + Excel Work Automation Essentials," continues the strengths of his previous work while also presenting methods for more efficient work automation by leveraging the compatibility of Microsoft's Copilot program.
This book will be a useful guide for anyone interested in automating tasks using Excel and Copilot.

Excel, of course, but also Word, PowerPoint, image creation, and audio creation.
It contains everything you need to co-pilot.

If you think that this book only teaches you how to use Excel using Copilot because the title is 'Excel Work Automation Essentials', then you only know half of Copilot.
This book covers all the above, as well as many more ways to fully utilize Copilot.
This book will teach you everything you can do with Copilot, including how to use Word and PowerPoint, which are other programs that make up Excel and MS Office; how to create Instagram posts that increase reach; how to create music that incorporates the latest trends; and how to create images without the help of an illustrator or difficult image tools.

[Contents included in this book]

ㆍ Chapter 01 covers things you need to know to use Copilot properly.
We'll look at the basics of Copilot, how to use it, and the differences between the chat window and the sidebar.
We'll cover essential information, including prompt writing know-how, real-world examples of prompt engineering, and how to create long, complex prompts using an electronic notebook.

ㆍ In Chapter 02, we will learn how to use Excel's basic functions using Copilot.
Copilot teaches you how to use Excel's basic features, including filters, conditional formatting, custom formatting, and sorting.
We also included [Bonus Examples] of know-how that can improve productivity when used with Copilot.

ㆍ Chapter 03 covers how to automate various useful but complex Excel functions and formulas with Copilot.
As long as you properly convey the problem situation, Copilot will understand unfamiliar data characteristics, write confusing Excel formulas, and create long, complex array formulas without any problems.


ㆍ In Chapter 04, we will learn how to automate macro and VBA tasks through copilot coding.
You can perform various automated processing, such as automatically aggregating data, summarizing weekly performance data, and automatically inserting/deleting specific rows.


ㆍ Chapter 05 introduces how to create various questionnaires and contracts using Copilot, and then automate several tasks using Word VBA.
Let's create a VBA code that will adjust the table format of a contract all at once and change all the headings in the document to the desired format.

ㆍ Chapter 06 introduces the process of creating PowerPoint slides using Copilot (free version).
Create an outline with Copilot and identify the information you need to design your slides.
Then, we'll show you how to use VBA to batch create slides and format them all at once.

ㆍ In Chapter 07, we will summarize PDF documents and analyze images using Copilot to create Instagram posts.
You can use the Copilot plugin and GPT to create New Jeans-style songs and even use it as a personal fitness trainer.
Here's how to use the accessible Copilot app.


ㆍ Special Appendix [1] 'New Microsoft Excel Function Utilization Collection' collects all the functions newly added after Excel 2019 version, and carefully selects 10 functions with high utilization and organizes how to use them.
Special appendix [2] 'Copilot Prompt Utilization Collection' contains 250 field-specific prompts that will allow you to utilize Copilot 100%, and organizes prompts that can be used in major areas such as business writing, marketing, sales, and communication.