{"product_id":"128647","title":"AI Practical Excel, PowerPoint, and Word for Office Workers ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jX1PGI1SYmXHDV6tigUiZ34xgJlup.png?v=1765059120\" 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 AI Practical Excel, PowerPoint, and Word for Office Workers \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\/153663553\/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\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eMaster your work with AI!\u003cbr\u003e AI Practical Excel, PowerPoint, and Word for Office Workers\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e ■ One step closer to becoming a successful person!\u003cbr\u003e Increase work efficiency by 200% with AI and shortened work hours!\u003cbr\u003e\u003cbr\u003e ■ Problem solved in one breath!  \u003cbr\u003eComplete solutions with practical examples from the field and tips from office experts!\u003cbr\u003e\u003cbr\u003e ■ Fully compatible with the latest version!\u003cbr\u003e Microsoft 365, of course, and Office versions 2013 to 2024!\u003c\/div\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003e[Excel]\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e CHAPTER 01 From data preprocessing to writing practical reports!\u003cbr\u003e\u003cbr\u003e SECTION 01 Editing Data Faster\u003cbr\u003e 01 Learn how to quickly select data\u003cbr\u003e 02 Find cells containing special characters and enter '0' at once\u003cbr\u003e 03 Quickly Fix Incorrect Date Data\u003cbr\u003e Enter data at regular intervals\u003cbr\u003e 04 Modify the unit price table without a formula by applying a discount rate\u003cbr\u003e 05 Remove line break characters at once\u003cbr\u003e\u003cbr\u003e SECTION 02 Formatting Cells to Create a Clean Report\u003cbr\u003e 01 Learn frequently used shortcut keys\u003cbr\u003e 02 Align the title neatly and evenly\u003cbr\u003e 03 Aligning the title in the center of the range without merging cells\u003cbr\u003e 04 Creating a border to emphasize content\u003cbr\u003e\u003cbr\u003e SECTION 03: Specifying the display format to complete an accurate report \u003cbr\u003e01 Learn frequently used custom display formats\u003cbr\u003e 02 Displaying digits in millions\u003cbr\u003e 03 Displaying the date as a day of the week\u003cbr\u003e 04 Display ▲ symbol only on items that increased compared to the previous month\u003cbr\u003e 05 Filling in the gaps between entries and pages in the table of contents\u003cbr\u003e\u003cbr\u003e CHAPTER 02: The Essentials of a Capable Worker! Mastering Functions\u003cbr\u003e\u003cbr\u003e SECTION 04 Learning basic functions frequently used in practice\u003cbr\u003e 01 Calculating Costs Based on Working Hours - IF Function\u003cbr\u003e 02 Calculating the number of projects and research costs - COUNTA, COUNTIF, and SUMIF functions\u003cbr\u003e 03 Calculating the quarter value from the sales date - IFS function\u003cbr\u003e 04 Calculating price using unit price by product code - VLOOKUP function\u003cbr\u003e\u003cbr\u003e SECTION 05 Handling advanced functions to improve work efficiency\u003cbr\u003e 01 Calculating the number of items sold - SUMPRODUCT function\u003cbr\u003e 02 Calculating incentives based on department and achievement rate - VLOOKUP, INDIRECT functions\u003cbr\u003e 03 Get the information you want at once using the employee number - VLOOKUP, MATCH functions \u003cbr\u003e04 Get employee number and date of employment from the left column based on name - XLOOKUP function\u003cbr\u003e 05 Finding Export Partners by Rank - INDEX, MATCH, LARGE Functions\u003cbr\u003e\u003cbr\u003e CHAPTER 03 Analyzing Data and Visualizing Reports\u003cbr\u003e\u003cbr\u003e SECTION 06 Excel Visualization and Reporting Techniques for Practical Data\u003cbr\u003e 01 Linking Summary Reports and Charts\u003cbr\u003e 02 Create a combo chart with two series with different values\u003cbr\u003e 03 Create a chart that analyzes sales averages using error bars.\u003cbr\u003e 04 Highlight only the top-selling items in the entire row\u003cbr\u003e 05 Highlight only reorder items by marking them with a flag\u003cbr\u003e 06 Edit Rule to Adjust Negative Data Bar Values\u003cbr\u003e 07 Creating Production Index Statistics Trends with Sparklines\u003cbr\u003e\u003cbr\u003e SECTION 07: Sorting and Filtering Data to Manage Data\u003cbr\u003e 01 Sorting the housing supply rate from the metropolitan area\u003cbr\u003e 02 Sort all fields at once in the desired order\u003cbr\u003e 03 Extracting data that meets multiple conditions\u003cbr\u003e 04 Extracting data using OR conditions among multiple items \u003cbr\u003e05 Extracting data only for specific days and above-average sales - Advanced Filters and Formulas\u003cbr\u003e\u003cbr\u003e SECTION 08 Quickly Summarizing Data with PivotTables Without Calculations\u003cbr\u003e 01 Create and name a table\u003cbr\u003e 02 Summarizing broadcast frequency and sales by host using a pivot table\u003cbr\u003e 03 Analyze the top 3 companies by quarterly sales\u003cbr\u003e 04 Changing the layout and design of a pivot table\u003cbr\u003e 05 Changing the summary function in the pivot table and displaying the sales ratio\u003cbr\u003e 06 Filter reports by MD in charge\u003cbr\u003e 07 Transferring Pivot Table Values ​​to Form Form\u003cbr\u003e 08 Setting up relationships and creating pivot tables\u003cbr\u003e\u003cbr\u003e CHAPTER 04: Improving Work Efficiency with ChatGPT and Excel Copilot\u003cbr\u003e\u003cbr\u003e SECTION 09: Writing Advanced Formulas and Functions with ChatGPT and Copilot\u003cbr\u003e 01 Explain and generate complex formulas in natural language\u003cbr\u003e 02 Creating a Sales Report with Multiple Conditions\u003cbr\u003e 03 Easily create conditional and nested functions\u003cbr\u003e 04 Optimizing Functions\u003cbr\u003e\u003cbr\u003e SECTION 10 ANALYZING DATA AND DEVELOPING INSIGHTS \u003cbr\u003e01 Automatically create and modify pivot tables\u003cbr\u003e 02 Identifying Data Trends and Patterns\u003cbr\u003e 03 Automatically summarize data and generate key statistical indicators\u003cbr\u003e 04 Deep-dive into the results with Python\u003cbr\u003e\u003cbr\u003e SECTION 11: Visualizing Data and Creating Charts with Generative AI\u003cbr\u003e 01 Get recommendations for chart types suitable for your data\u003cbr\u003e 02 Create and customize charts using natural language.\u003cbr\u003e 03 Creating and Applying Conditional Formatting Rules\u003cbr\u003e\u003cbr\u003e SECTION 10 Getting Help with VBA and Macros\u003cbr\u003e 01 Writing and Explaining VBA Code with ChatGPT\u003cbr\u003e 02 Create and apply macros for repetitive tasks\u003cbr\u003e\u003cbr\u003e \u003cb\u003e[PowerPoint Edition]\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e CHAPTER 01: Mastering Practical Secrets to Improve Your Design\u003cbr\u003e\u003cbr\u003e SECTION 01 Upgrading Your Designs with Shape Graphics\u003cbr\u003e 01 Using theme colors effectively\u003cbr\u003e 02 Using gray to naturally emphasize shapes\u003cbr\u003e 03 Quickly select only the desired color with the eyedropper\u003cbr\u003e 04 Expressing light effects with gradation\u003cbr\u003e 05 Quickly change shape format by copying the format \u003cbr\u003e06 Create a picture by filling multiple shapes\u003cbr\u003e\u003cbr\u003e SECTION 02 Creating Visual Materials Using SmartArt Graphics\u003cbr\u003e 01 Converting Text to SmartArt Graphics\u003cbr\u003e 02 Designing a 7-piece pie with SmartArt graphics\u003cbr\u003e 03 Changing the number of inputs and outputs in a funnel design\u003cbr\u003e\u003cbr\u003e CHAPTER 02 Visualizing Information with Images and Graphs\u003cbr\u003e\u003cbr\u003e SECTION 03 Using Images to Enhance the Design\u003cbr\u003e 01 Create a PNG image with a transparent background\u003cbr\u003e 02 Removing image backgrounds from utility sites\u003cbr\u003e 03 Reduce file size by deleting cropped image areas\u003cbr\u003e 04 Change pictures easily and quickly with 'Change Picture'\u003cbr\u003e 05 Change the color of only some areas of the map with an SVG image\u003cbr\u003e 06 Freely crop images using the shape merge function\u003cbr\u003e\u003cbr\u003e SECTION 04 Designing Tables and Charts to Emphasize Data\u003cbr\u003e 01 Create a table that emphasizes data by minimizing borders\u003cbr\u003e 02 Creating a Progress Chart with Pie Charts and Shapes \u003cbr\u003e03 Create an icon chart that displays the ratio by duplicating icons\u003cbr\u003e 04 Create an infographic chart by cutting out the image.\u003cbr\u003e\u003cbr\u003e CHAPTER 03 Managing Designs with Themes and Utilizing Social Media\u003cbr\u003e\u003cbr\u003e SECTION 05 Managing Designs with Themes and Masters\u003cbr\u003e 01 Applying the same background image to all slides\u003cbr\u003e 02 Changing the background design in the master\u003cbr\u003e 03 Copy the format of the original document to the slide\u003cbr\u003e 04 Apply your favorite theme design to the current file\u003cbr\u003e 05 Setting a custom file as the default theme\u003cbr\u003e 06 Apply design ideas to design like a pro\u003cbr\u003e\u003cbr\u003e SECTION 06 Creating a Presentation Document for Social Media\u003cbr\u003e 01 Create a Facebook cover design\u003cbr\u003e 02 Creating Card News for SNS\u003cbr\u003e 03 Creating YouTube Thumbnails\u003cbr\u003e 04 Creating a Naver Blog Thumbnail\u003cbr\u003e\u003cbr\u003e CHAPTER 04 Creating Smart Presentations with Generative AI\u003cbr\u003e\u003cbr\u003e SECTION 07 Easily Draft Presentations Using AI\u003cbr\u003e 01 Turn your ideas into slides! Use AI to draft. \u003cbr\u003e02 Review and revise the AI-suggested slide outline.\u003cbr\u003e 03 Automatically create a presentation document from a Word file\u003cbr\u003e 04 Automatically Create Slide Summary and Presenter Notes\u003cbr\u003e\u003cbr\u003e SECTION 08: Visualizing Data and Content Easily and Effectively with AI\u003cbr\u003e 01 Easily visualize charts and data with ChatGPT\u003cbr\u003e 02 Automatically visualize text analysis\u003cbr\u003e 03 Quickly summarize video data with AI\u003cbr\u003e\u003cbr\u003e \u003cb\u003e[Word Edition]\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e CHAPTER 01 Mastering Essential Word Skills\u003cbr\u003e\u003cbr\u003e SECTION 01 Formatting and Decorating Your Document\u003cbr\u003e 01 Change text and formatting together\u003cbr\u003e 02 Change the spacing between letters and copy the format\u003cbr\u003e 03 Specifying line and paragraph spacing\u003cbr\u003e 04 Specifying tab spacing\u003cbr\u003e 05 Split text evenly and automatically align it\u003cbr\u003e\u003cbr\u003e SECTION 02 Freely handling documents containing objects\u003cbr\u003e 01 Insert a picture and arrange it to match the text.\u003cbr\u003e 02 Decorate the title with a text box\u003cbr\u003e 03 Inserting and editing formulas\u003cbr\u003e\u003cbr\u003e SECTION 03 Inserting Tables and Charts \u003cbr\u003e01 Calculating the average of table data\u003cbr\u003e 02 Split the table and merge the consecutive tables into one.\u003cbr\u003e 03 Inserting a chart and changing its type\u003cbr\u003e\u003cbr\u003e CHAPTER 02: Creating Documents Systematically Using Convenient Features\u003cbr\u003e\u003cbr\u003e SECTION 04 Writing a Document with Order\u003cbr\u003e 01 Creating a Number Style List\u003cbr\u003e 02 Specifying bullet style\u003cbr\u003e 03 Specifying a multi-level list\u003cbr\u003e 04 Changing the starting number for numbering\u003cbr\u003e 05 Adjusting bullet and text spacing\u003cbr\u003e\u003cbr\u003e SECTION 05 Organizing documents using page functions\u003cbr\u003e 01 Inserting headers and footers\u003cbr\u003e 02 Inserting page numbers\u003cbr\u003e 03 Divide into zones\u003cbr\u003e 04 Merge separate areas into one\u003cbr\u003e 05 Specify different headers for each zone\u003cbr\u003e\u003cbr\u003e SECTION 06 Applying Styles to a Document\u003cbr\u003e 01 Create a new style and apply it to all documents\u003cbr\u003e 02 Editing styles and applying them automatically\u003cbr\u003e 03 Specifying outline levels for styles\u003cbr\u003e 04 Automatically create a table of contents using style\u003cbr\u003e \u003cbr\u003eCHAPTER 03: Using AI to Create Documents Efficiently\u003cbr\u003e\u003cbr\u003e SECTION 07 Get AI-powered Document Creation and Editing Assistance\u003cbr\u003e 01 Quickly draft documents using AI\u003cbr\u003e 02 Edit text in natural language and create a detailed table of contents\u003cbr\u003e 03 Automatically correct grammar and spelling\u003cbr\u003e 04 Rewriting documents in different styles and tones\u003cbr\u003e\u003cbr\u003e SECTION 08: Enhancing Document Design and Visualization with AI\u003cbr\u003e 01 Automatically create and modify tables and charts\u003cbr\u003e 02 Recommending and Inserting Images and Graphic Elements\u003cbr\u003e 03 Summarizing the document and supplementing the content\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eDetailed image\u003c\/b\u003e \u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cdiv\u003e\u003cimg src=\"https:\/\/image.yes24.com\/momo\/TopCate5628\/MidCate007\/562762352.jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\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\u003e100% realism!\u003cbr\u003e Reduce work hours and increase efficiency with AI!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e [Practical Master 1] Work faster! Significantly reduce work hours.\u003cbr\u003e It reflects the latest versions of Microsoft 365 as well as Office 2013 to 2024.\u003cbr\u003e We'll give you only the essential tips to get your work done quickly with our work time-saving skills.\u003cbr\u003e \u003cbr\u003e[Practical Master 2] Essential tools for office workers in one volume! Includes Excel, PowerPoint, and Word.\u003cbr\u003e This book contains the core office tool features that office workers encounter every day.\u003cbr\u003e The author's practical, on-site examples, packed with his expertise, will help you increase your work efficiency by 200%.\u003cbr\u003e\u003cbr\u003e [Practical Master 3] Get smarter with AI! Provides prompts tailored to your work.\u003cbr\u003e 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.\u003cbr\u003e\u003cbr\u003e [Practical Master 4] Easier with video lectures! Free online direct lectures available!\u003cbr\u003e We provide free YouTube online lectures and practical templates.\u003cbr\u003e By following along with the video lectures, you will learn how to resolve various errors and variables that may occur in the workplace. \u003cbr\u003e\n\n\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\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 September 29, 2025\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 448 pages | 188*257mm\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 9791140715640\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 114071564X \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":43893162016810,"sku":"128647","price":37.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/19cc263b94dea5f7f08051da44974102.jpg?v=1765390852","url":"https:\/\/librairie.coreenne.fr\/en\/products\/128647","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}