{"product_id":"110324","title":"Excel Demon King's Excel, do this in these situations! ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jYEEOBHMJB55eF71p9Bh96V9sEGvj.png?v=1765099788\" 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 Excel Demon King's Excel In this case, do it like this! \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\/125346013\/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\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eInstagram's representative Excel Creator!\u003cbr\u003e Excel Demon King reveals practical Excel problem-solving techniques for each situation!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Want to master Excel in practice? Have you ever felt like you could handle it quickly and in one go, but never knew how to do it properly, leaving you feeling lost? The Excel King, with 420K followers on Instagram, shares solutions to specific problems that can arise in Excel.\u003cbr\u003e We provide a customized solution for Excel users who are frustrated and wondering, \"What should I do in this situation?\"\u003cbr\u003e\n\u003c\/div\u003e\u003c\/div\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\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\u003eEnter\/edit.\u003cbr\u003e In times like this, do this!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCreating Your Own Excel Environment\u003c\/b\u003e\u003cbr\u003e Can I create my own shortcuts?\u003cbr\u003e Wait a minute │ I want to insert a check box into an Excel sheet. \u003cbr\u003eCan I change the default font in Excel to a font of my choice?\u003cbr\u003e Can I remove hyperlinks that are set automatically?\u003cbr\u003e Wait a minute │ Can I stop '(주)' from auto-correcting to special characters?\u003cbr\u003e Can you remove the green triangles that appear in the corners of cells?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eSpecify a display format to display data in the desired format\u003c\/b\u003e\u003cbr\u003e Can't I enter the date and time in the same cell?\u003cbr\u003e When I enter a date, an unknown number is displayed.\u003cbr\u003e I want to input a fraction in the format '2\/3', but a date is input.\u003cbr\u003e I want to enter a phone number starting with 0.\u003cbr\u003e I want to change the number display unit.\u003cbr\u003e I want to automatically apply formatting to the data in the cell.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eAutomating tasks with conditional formatting\u003c\/b\u003e\u003cbr\u003e Is it possible to automatically insert borders into cells where data is entered?\u003cbr\u003e I want to automatically color rows that have matching data. \u003cbr\u003eIs it possible to color only odd rows in table data?\u003cbr\u003e Wait a minute │ Can I only use the table style?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eFilter\/sort to see only the data you need\u003c\/b\u003e\u003cbr\u003e Can I filter even if there are merged cells?\u003cbr\u003e Can I filter multiple items at once?\u003cbr\u003e Is it possible to filter only cells containing specific characters?\u003cbr\u003e Can I align the data horizontally?\u003cbr\u003e I want to sort it in any order I want, not ascending\/descending.\u003cbr\u003e Can I sort data by more than one condition?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eFind and replace to find only the data you need\u003c\/b\u003e\u003cbr\u003e Can I change the format applied to multiple cells at once?\u003cbr\u003e Wait a minute │ Can I just delete the format while leaving the cell contents intact?\u003cbr\u003e I want to sum only the numbers in specific cells that have been filled with color.\u003cbr\u003e Can I change the date format to year, month, and day separated by periods?\u003cbr\u003e I want to convert unknown Chinese characters into Korean. \u003cbr\u003eWait a minute │ Isn't the shortcut for auto-sum [Alt]+[=]?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eQuickly fix with the Move option\u003c\/b\u003e\u003cbr\u003e Can I enter the desired data in bulk into blank cells?\u003cbr\u003e Wait a minute │ Is there another way to enter data in bulk into empty cells?\u003cbr\u003e Is it possible to delete rows with empty data at once?\u003cbr\u003e Is it possible to copy\/paste only visible cells, excluding hidden cells?\u003cbr\u003e I want to easily move an entire row\/column.\u003cbr\u003e Wait a minute │ I want to insert rows\/columns easily.\u003cbr\u003e I want to separate text and numbers entered in one column.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eIncrease work efficiency with data validation\u003c\/b\u003e\u003cbr\u003e Is it possible to automatically convert Korean\/English text to match the data to be entered?\u003cbr\u003e Is it possible to insert a list so that only specified items can be entered?\u003cbr\u003e Can I create multiple lists and sublists?\u003cbr\u003e Is it possible to prevent duplicate data entry? \u003cbr\u003eWait a minute │ What is a comparison operator?\u003cbr\u003e Is it possible to insert a data entry method into an Excel sheet?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eQuickly input and edit without overtime\u003c\/b\u003e\u003cbr\u003e Is there a way to quickly enter a weekday date excluding weekends?\u003cbr\u003e I want to enter the column numbers from 1 to 100 at once.\u003cbr\u003e I want to input them directly in order of rank.\u003cbr\u003e Can I create multiple sheets at once?\u003cbr\u003e Can I calculate data from multiple sheets at once?\u003cbr\u003e Wait a minute │ Can I do the same task on multiple sheets at once?\u003cbr\u003e Is it possible to copy only cells with content, excluding spaces?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eShortcut Dictionary\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e \u003cb\u003eFunction.\u003cbr\u003e In times like this, do this!\u003cbr\u003e You can do this with a function too\u003c\/b\u003e\u003cbr\u003e Can you check the Excel version on your PC?\u003cbr\u003e Can I display as many stars (★) as I enter in numbers?\u003cbr\u003e Is it possible to clean up text data with irregular spaces at once?\u003cbr\u003e Wait a minute │ Can I copy\/paste only the results? \u003cbr\u003eI want to capitalize the first letter of my first name and last name entered in English.\u003cbr\u003e I want to keep the serial numbers in order even if I delete rows.\u003cbr\u003e I want to extract and calculate only the numbers from cells that contain mixed text and numbers.\u003cbr\u003e Is it possible to have the serial number automatically entered when entering data?\u003cbr\u003e Is it possible to get all matching values ​​into one cell?\u003cbr\u003e Is it possible to count a specific number of texts within a cell?\u003cbr\u003e Is it possible to combine text entered in multiple cells into one?\u003cbr\u003e Is it possible to extract only the text before a specific text?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCalculating time and date using functions\u003c\/b\u003e\u003cbr\u003e I want to calculate the cumulative working hours excluding lunch time.\u003cbr\u003e Is it possible to separate the date and time entered in one cell?\u003cbr\u003e I want to separate the date data entered in one cell into year, month, and day.\u003cbr\u003e I want to find the day of the week by referencing the date.\u003cbr\u003e Can I find out the current length of employment of the employees? \u003cbr\u003eIs it possible to get the monthly total of one year's cumulative data, separated by year, month, and day?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eHow to properly use functions for complex calculations\/analysis\u003c\/b\u003e\u003cbr\u003e Is it possible to automatically get the ranking?\u003cbr\u003e Is it possible to get the overall ranking of data divided into multiple tables?\u003cbr\u003e Can you find the maximum and minimum values?\u003cbr\u003e I want to round down the calculated amount to the desired unit.\u003cbr\u003e I want to get the sum of the filtered cells.\u003cbr\u003e Is it possible to keep the order of the numbers even when filtering?\u003cbr\u003e Is it possible to reference each array and calculate the total sum at once?\u003cbr\u003e Can you find the sum of odd\/even columns?\u003cbr\u003e Wait a minute │ Can you tell me how many empty cells there are?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eQuickly process data with find\/database functions\u003c\/b\u003e\u003cbr\u003e Can you find out how many employees have exceeded their corporate card usage limit?\u003cbr\u003e Is it possible to sum the cells that contain a specific test? \u003cbr\u003eIs it possible to automatically calculate the cumulative total sales for a specified month?\u003cbr\u003e Can I determine gender by referencing the resident registration number?\u003cbr\u003e Can I extract part of the resident registration number by marking it with '*'?\u003cbr\u003e Is it possible to automatically collate data organized in different sheets?\u003cbr\u003e Is it possible to get the value on the left side of the reference cell without using the XLOOKUP function?\u003cbr\u003e Can I enter the column numbers to be extracted with the VLOOKUP function all at once?\u003cbr\u003e Wait a minute │ Can I use array formulas in the VLOOKUP function in versions lower than M365?\u003cbr\u003e Can I get exact matching data using the VLOOKUP function when there are people with the same name?\u003cbr\u003e Is it possible to get the value to the left of the reference cell?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eResolving Excel Error Messages\u003c\/b\u003e\u003cbr\u003e #Can I prevent the N\/A error from appearing?\u003cbr\u003e Can you check my formula for errors?\u003cbr\u003e Wait a minute │ Is it possible to display a formula directly in a cell, rather than the result of a function?\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePractice.\u003cbr\u003e In times like this, do this!\u003c\/b\u003e \u003cbr\u003eVisualizing data with charts\u003cbr\u003e Is there a way to quickly insert a chart?\u003cbr\u003e I want to insert an image of my choice into the chart background.\u003cbr\u003e I want to insert an image above each series in a bar chart.\u003cbr\u003e Wait a minute │ Is it possible to make specific cells with content invisible?\u003cbr\u003e Can I create a mini chart inside a cell?\u003cbr\u003e Wait a minute │ Can I insert a bar chart inside a cell?\u003cbr\u003e Is it possible to continue a broken line chart that has no data?\u003cbr\u003e Wait a minute │ Can you improve the readability of line charts?\u003cbr\u003e Can I adjust the spacing and size of the bars in a vertical bar chart?\u003cbr\u003e Can I mix bar and line charts?\u003cbr\u003e Wait a minute │ Can you improve the readability of mixed charts?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eLeveraging Data with PivotTables\u003c\/b\u003e\u003cbr\u003e Can I view monthly data quarterly?\u003cbr\u003e Is it possible to sort a pivot table with more than one row label in a desired manner? \u003cbr\u003eI want to insert a dashboard-type chart that links to a table.\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePrint without double-sided paper\u003c\/b\u003e\u003cbr\u003e Is it possible to output only a specific area?\u003cbr\u003e Can I insert page numbers in any format I want?\u003cbr\u003e Is it possible to fix a specific row and repeat the output?\u003cbr\u003e Excuse me │ Can you print the entire sheet at once?\u003cbr\u003e Can I print an Excel sheet with my company logo inserted?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eMastering Excel Image Utilization\u003c\/b\u003e\u003cbr\u003e Can I filter images too?\u003cbr\u003e Can I remove the background of an image?\u003cbr\u003e Is it possible to align the spacing of images accurately in one go?\u003cbr\u003e Is it possible to resize multiple images to fit the size of a cell?\u003cbr\u003e Wait a minute │ Can I extract the image inserted into an Excel sheet as a file?\u003cbr\u003e Can I import an image into an Excel sheet using the image address on the web?\u003cbr\u003e\u003cbr\u003e \u003cb\u003eDocument Management Methods of a Successful Worker\u003c\/b\u003e\u003cbr\u003e Can I protect a specific sheet from being modified by others? \u003cbr\u003eCan I password protect a workbook?\u003cbr\u003e Can I edit sheets within a single workbook simultaneously?\u003cbr\u003e Can I create multiple folders at once using Excel?\u003cbr\u003e Wait a minute │ What are BAT files and ANSI?\u003cbr\u003e\u003cbr\u003e Function Dictionary\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\/TopCate4442\/MidCate007\/444169937.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 Excel...\u003cbr\u003e It provides a clear answer to the question, 'What should I do in this situation?'\u003cbr\u003e\u003cbr\u003e Excel, an essential tool for office workers, is a vast collection of tools, so there's no single right answer to solving a specific problem.\u003cbr\u003e Many job seekers and office workers, despite having basic Excel skills, find practical Excel tasks challenging because they lack the knowledge and experience to flexibly utilize Excel's various functions. \u003cbr\u003eThe goal of this book is to present practical solutions that can be applied immediately in practice, rather than complex and difficult solutions.\u003cbr\u003e\u003cbr\u003e When data entry\/editing leads to overtime due to simple repetitive tasks, try this.\u003cbr\u003e\u003cbr\u003e Let's start by creating an Excel environment that allows you to utilize Excel effectively. Even if you just master basic Excel features like cell formatting, find and replace, conditional formatting, and filter\/sort, your work efficiency will dramatically increase.\u003cbr\u003e Now you can leave work on time! Data entry\/editing work.\u003cbr\u003e In this case, try this!\u003cbr\u003e\u003cbr\u003e A function that I wanted to process quickly and in one go, but was at a loss.\u003cbr\u003e In this case, try this.\u003cbr\u003e\u003cbr\u003e If you've ever wondered, \"Can't this be done with a function?\" or \"What does this function do?\", we present a clear solution that can be quickly and easily handled in one go. \u003cbr\u003eFrom essential functions you need to know to creative ways to use Excel functions that no one has ever thought of! Try this in these situations.\u003cbr\u003e\u003cbr\u003e The practical work of printing, charts, etc., which changed from time to time, was confusing.\u003cbr\u003e In this case, try this!\u003cbr\u003e\u003cbr\u003e Charts and pivot tables help you discover patterns, trends, and insights hidden in your data.\u003cbr\u003e In addition, we generously share practical Excel know-how that enhances data security and consistency, and improves work efficiency, from printing to image and document management.\u003cbr\u003e When you have a difficult Excel job, try this. \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 March 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 304 pages | 808g | 188*257*16mm\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 9791140708895 \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":43893771763754,"sku":"110324","price":33.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/bcbd6edcaabe1d788599f7e54c5fb7ec.jpg?v=1765415989","url":"https:\/\/librairie.coreenne.fr\/en\/products\/110324","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}