{"product_id":"138931","title":"Copilot + Excel Work Automation Essentials ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jXPeMCkm9ENW3OQz7qfRYzRnk3AKl.png?v=1765070692\" style=\"max-width:100%;max-height:10px\"\u003e\u003c\/div\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\n\n\u003cdiv style=\"width:95%\"\u003e\n\n\u003cdiv style=\"text-align:center;font-size:30px;font-weight:bolder;line-height:1.6em\"\u003e Copilot + Excel Work Automation Essentials \u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"border-bottom:1px;border-bottom-style:dotted;border-color:;padding-bottom:20px\"\u003e\u003ccenter\u003e\u003ctable align=\"center\" width=\"100%\"\u003e\u003ctbody style=\"border:0px\"\u003e\n\n\u003ctr\u003e\u003ctd align=\"center\" style=\"line-height:1.2em;text-align:center;font-size:18px;color:black;font-weight:bold;padding-bottom:20px;\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\u003ctr\u003e\u003ctd style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/image.yes24.com\/goods\/129445293\/XL\" style=\"max-width:100%;height:auto\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\u003c\/table\u003e\u003c\/center\u003e\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;{split_style6}padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e Description \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;word-break:break-all;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eBook Introduction\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003ctable\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd\u003e\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eEverything you need to know about task automation using Copilot, for every office worker!\u003cbr\u003e “Get off work early with Copilot AI Assistant!”\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Microsoft Office and Excel are essential tools for office workers, and effectively utilizing Excel's functions, formats, VBA, macros, etc. can greatly improve work productivity.\u003cbr\u003e However, Excel is complex and tricky and takes a lot of time to master.\u003cbr\u003e But if you use Microsoft's AI productivity tool, Copilot, difficult reports and finishing work on time can become a little more accessible. \u003cbr\u003eCopilot, based on OpenAI's GPT-4 model, is user-friendly and helps make task automation easier to implement.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e By using Copilot and Excel together with 『Copilot + Excel Work Automation Essentials』, written by the author who is a Microsoft MVP and Excel expert, you can not only master complex and difficult Excel functions, but also experience Copilot's amazing ability to turn VBA beginners into VBA experts in an instant.\u003cbr\u003e This book will guide you into the world of task automation using Excel and Copilot.\u003cbr\u003e Now, let's unleash the power of Excel with Copilot.\u003cbr\u003e This book will help you take your Excel work to the next level.\u003cbr\u003e\u003cbr\u003e\n\u003c\/div\u003e\u003c\/div\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/tbody\u003e\u003c\/table\u003e\n\u003cdiv\u003e\u003cul\u003e\u003cli\u003e You can preview some of the book's contents.\u003cbr\u003e \u003cspan\u003ePreview\u003c\/span\u003e\n\n\u003c\/li\u003e\u003c\/ul\u003e\u003c\/div\u003e\n\u003c\/div\u003e \",\"\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003eintroduction\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter.\u003cbr\u003e 01 Microsoft Copilot Basics\u003c\/b\u003e \u003cbr\u003eSection 01 Basic Co-Pilot Knowledge You Need to Know\u003cbr\u003e Section 02 Why should I use Copilot?\u003cbr\u003e Section 03 10 Essential Terms Related to Artificial Intelligence\u003cbr\u003e Section 04: A Complete Guide to the Differences Between the Confusing \"Co-Pilot 3 Brothers\"\u003cbr\u003e Section 05: 3 Ways to Access Copilot\u003cbr\u003e Section 06 What does a copilot look like?\u003cbr\u003e Section 07 What is the difference between the chat window and the sidebar?\u003cbr\u003e Section 08: 10 Tips and Tricks for Writing Prompts\u003cbr\u003e Section 09: Four Prompt Engineering Case Studies\u003cbr\u003e Section 10: Writing Long and Complex Prompts in an Electronic Notebook\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter.\u003cbr\u003e 02 Automating Basic Excel Functions with Copilot\u003c\/b\u003e\u003cbr\u003e Section 01 How to create a concise table of results\u003cbr\u003e Section 02 Using Advanced Filters with Copilot\u003cbr\u003e Section 03 Converting data entered in multiple lines into a single line\u003cbr\u003e Section 04 [Bonus Example] An Easy Way to Merge Multiple Cell Contents into One Cell\u003cbr\u003e Section 05 Easily Find Duplicate Data in Two Tables \u003cbr\u003eSection 06 Sorting data by your own criteria\u003cbr\u003e Section 07 [Bonus Example] Adding Pre-Entered Data to a Custom List\u003cbr\u003e Section 08 Adding specific characters to the beginning or end of data\u003cbr\u003e Section 09 [Bonus Example] Understanding and Using Custom Formats\u003cbr\u003e Section 10 Converting Won to Thousands or Millions\u003cbr\u003e Section 11 How to enter a 16-digit card number\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter.\u003cbr\u003e Automating Excel Formulas with 03 Copilot\u003c\/b\u003e\u003cbr\u003e Section 01 How to use Excel functions you don't know well\u003cbr\u003e Section 02 How to Understand Data Characteristics You See for the First Time\u003cbr\u003e Section 03 [Bonus Example] How to Easily Analyze Descriptive Statistics\u003cbr\u003e Section 04 Finding the information you want in the large table\u003cbr\u003e Section 05 How to obtain the necessary information in continuation of the previous question\u003cbr\u003e Section 06 How to extract only the necessary parts from a long string\u003cbr\u003e Section 07 [Bonus Example] Another way to extract only the necessary parts\u003cbr\u003e Section 08 Finding the sum that satisfies various conditions \u003cbr\u003eSection 09 Writing Complex Multiple IF Formulas at Once\u003cbr\u003e Section 10 How to Create a Clean Report\u003cbr\u003e Section 11 [Bonus Example] Two Tips for Writing a Clean Report\u003cbr\u003e Section 12 Calculating Special Averages\u003cbr\u003e Section 13 Hide the last digits of your resident registration number by marking them with ***\u003cbr\u003e Section 14 Displaying all materials that meet the conditions\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter.\u003cbr\u003e 04 Excel Macros and VBA Automation with Copilot\u003c\/b\u003e\u003cbr\u003e Section 01 Understanding Macros and VBA Basics\u003cbr\u003e Section 02: Understanding the Copilot VBA Coding Process with Multiplication Tables\u003cbr\u003e Section 03 Deleting Blank Rows in Bulk\u003cbr\u003e Section 04 Automatically inserting rows as many times as the number entered\u003cbr\u003e Section 05 Creating a summary table with automatically added formats\u003cbr\u003e Section 06 Merge cells at once if they have the same values\u003cbr\u003e Section 07 Implementing Functions Not Found in Excel - Data Swapping\u003cbr\u003e Section 08 Automatically Summarizing Weekly Performance\u003cbr\u003e Section 09 Consolidating Multiple Sheets into One\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter.\u003cbr\u003e 05 Automate Word tasks with Pilot\u003c\/b\u003e\u003cbr\u003e Section 01 Creating an Education Satisfaction Questionnaire \u003cbr\u003eSection 02 Creating a Service Contract\u003cbr\u003e Section 03 Adjusting the contract table format all at once\u003cbr\u003e Section 04 Creating a Neat Word Table\u003cbr\u003e Section 05 Batch highlighting of titles within a document\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter.\u003cbr\u003e 06 Automate PowerPoint tasks with Copilot\u003c\/b\u003e\u003cbr\u003e Section 01 Creating a Presentation Outline\u003cbr\u003e Section 03 Creating multiple slides at once\u003cbr\u003e Section 04 How to easily design all slides\u003cbr\u003e Section 05 Unifying Slide Title Formats\u003cbr\u003e Section 06 Aligning the Position of All Slide Titles\u003cbr\u003e\u003cbr\u003e \u003cb\u003eChapter.\u003cbr\u003e 07 Useful Copilot Usage Tips You Should Know\u003c\/b\u003e\u003cbr\u003e Section 01: 3 Ways to Use the Copilot Notepad\u003cbr\u003e Section 02 Two Ways to Use Copilot PDF Documents\u003cbr\u003e Section 03 How to Create Attractive Characters with Co-Pilot\u003cbr\u003e Section 04 Creating images in the style of master painters\u003cbr\u003e Section 05: Analyzing Images and Creating Instagram Posts\u003cbr\u003e Section 06 Summarizing Web Pages and YouTube Videos\u003cbr\u003e Section 07 Creating K-POP Style Songs \u003cbr\u003eSection 08 Creating a Personal Fitness Trainer\u003cbr\u003e Section 09 Creating a Company Logo Using a Designer\u003cbr\u003e Section 10: 6 Tips for Getting the Most Out of Your Copilot App\u003cbr\u003e\u003cbr\u003e \u003cb\u003eSpecial Appendix [1] New Microsoft Excel Function Utilization Collection\u003c\/b\u003e\u003cbr\u003e Section 01 Complete List of New Excel Functions (2019 Version and Later)\u003cbr\u003e Section 02 17 New Excel Functions to Take Your Work Productivity to the Next Level\u003cbr\u003e\u003cbr\u003e \u003cb\u003eSpecial Appendix [2] Co-Pilot Prompt Utilization Collection\u003c\/b\u003e\u003cbr\u003e Section 01 Business Writing Prompts (28)\u003cbr\u003e Section 02 Marketing-Related Prompts (35)\u003cbr\u003e Section 03 Market Research Prompts (23)\u003cbr\u003e Section 04 Prompts for Idea Generation (34)\u003cbr\u003e Section 05 Sales \u0026amp; Promotion Prompts (28)\u003cbr\u003e Section 06 Prompts for Writing Emails (27)\u003cbr\u003e Section 07 Prompts for Effective Communication (24)\u003cbr\u003e Section 08 Prompts for Creating Various Content (24)\u003cbr\u003e Section 09 Prompts for Various Learning Activities (27)\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e \",\"\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eDetailed image\u003c\/b\u003e \u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cdiv\u003e\n\u003cimg src=\"https:\/\/image.yes24.com\/momo\/TopCate4714\/MidCate004\/471339924.jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e  \u003c\/div\u003e\u003c\/div\u003e\",\"\u003cdiv\u003e\u003ch5\u003e \u003cb\u003ePublisher's Review\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003eExceler Kwon Hyun-wook, an Excel expert\u003cbr\u003e The second book in the \"Excel Automation Essentials\" series has been published!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 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.\u003cbr\u003e 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.\u003cbr\u003e 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. \u003cbr\u003eThis 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.\u003cbr\u003e\u003cbr\u003e 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.\u003cbr\u003e This book will be a useful guide for anyone interested in automating tasks using Excel and Copilot.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eExcel, of course, but also Word, PowerPoint, image creation, and audio creation.\u003cbr\u003e It contains everything you need to co-pilot.\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 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. \u003cbr\u003eThis book covers all the above, as well as many more ways to fully utilize Copilot.\u003cbr\u003e 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.\u003cbr\u003e\u003cbr\u003e \u003cb\u003e[Contents included in this book]\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e ㆍ Chapter 01 covers things you need to know to use Copilot properly.\u003cbr\u003e We'll look at the basics of Copilot, how to use it, and the differences between the chat window and the sidebar.\u003cbr\u003e 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.\u003cbr\u003e \u003cbr\u003eㆍ In Chapter 02, we will learn how to use Excel's basic functions using Copilot.\u003cbr\u003e Copilot teaches you how to use Excel's basic features, including filters, conditional formatting, custom formatting, and sorting.\u003cbr\u003e We also included [Bonus Examples] of know-how that can improve productivity when used with Copilot.\u003cbr\u003e\u003cbr\u003e ㆍ Chapter 03 covers how to automate various useful but complex Excel functions and formulas with Copilot.\u003cbr\u003e 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.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e ㆍ In Chapter 04, we will learn how to automate macro and VBA tasks through copilot coding. \u003cbr\u003eYou can perform various automated processing, such as automatically aggregating data, summarizing weekly performance data, and automatically inserting\/deleting specific rows.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e ㆍ Chapter 05 introduces how to create various questionnaires and contracts using Copilot, and then automate several tasks using Word VBA.\u003cbr\u003e 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.\u003cbr\u003e\u003cbr\u003e ㆍ Chapter 06 introduces the process of creating PowerPoint slides using Copilot (free version).\u003cbr\u003e Create an outline with Copilot and identify the information you need to design your slides.\u003cbr\u003e Then, we'll show you how to use VBA to batch create slides and format them all at once.\u003cbr\u003e \u003cbr\u003eㆍ In Chapter 07, we will summarize PDF documents and analyze images using Copilot to create Instagram posts.\u003cbr\u003e You can use the Copilot plugin and GPT to create New Jeans-style songs and even use it as a personal fitness trainer.\u003cbr\u003e Here's how to use the accessible Copilot app.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e ㆍ 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.\u003cbr\u003e 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.\u003cbr\u003e\n\n\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e \"]\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e GOODS SPECIFICS \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eDate of issue:\u003c\/strong\u003e August 20, 2024\u003c\/div\u003e\n\n \u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e- \u003cstrong\u003ePage count, weight, size:\u003c\/strong\u003e 272 pages | 698g | 188*257*13mm\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN13:\u003c\/strong\u003e 9788960884618\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN10:\u003c\/strong\u003e 8960884618 \u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cspan\u003e\u003c\/span\u003e\n\n\u003c\/center\u003e\n\n\n\u003c\/center\u003e","brand":"LIBRAIRIE COREENNE","offers":[{"title":"Default Title","offer_id":43893331394602,"sku":"138931","price":32.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/80d4e3c30205b712e6382bad19e6d28e.jpg?v=1765396528","url":"https:\/\/librairie.coreenne.fr\/en\/products\/138931","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}