{"product_id":"138512","title":"Excel Function \u0026amp; Formula Bible ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jXPCfGOpVrUDW4O6AwOvvmlFql7Tj.png?v=1765063916\" 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 Function \u0026amp; Formula Bible \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\/95910680\/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\u003eMaster essential Excel functions and formulas optimized for your work to greatly improve your Excel skills!\u003cbr\u003e Everything about Excel functions and formulas, suggested by Choi Jun-seon of Naver Excel's representative cafe, \"Excel...One a Day\"!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e We have selected essential functions and formulas optimized for work that are essential for working with Excel and organized them so that you can learn them through various examples.\u003cbr\u003e From basic functions to intermediate and advanced functions, you will learn practical examples that can be applied directly to your work, and the principles of formula composition and how to utilize functions are thoroughly organized.\u003cbr\u003e In particular, it covers array formulas that significantly increase the productivity of Excel work, as well as dynamic array functions and formulas provided from the Microsoft 365 version, in depth to help you improve work efficiency. \u003cbr\u003eAdditionally, we have detailed the differences between versions so that it can be used in all versions, including Excel 2007, 2010, 2013, 2016, 2019, and Microsoft 365, so you can look it up and use it conveniently anytime, anywhere.\u003cbr\u003e If you have any difficulties while learning, you can visit Naver Excel's representative cafe, 'Excel...One a Day', and get help from the author to solve them.\u003cbr\u003e\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 \",\"\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003ePART 01 Basics of Excel Formulas\u003cbr\u003e\u003cbr\u003e CHAPTER 01 Understanding the Basics of Formulas\u003c\/b\u003e\u003cbr\u003e 01-01 Formulas, functions, and operators\u003cbr\u003e 01-02 Using various methods to enter formulas\u003cbr\u003e 01-03 Understanding Excel Formula Limitations\u003cbr\u003e 01-04 Distinguishing Data Formats in Excel\u003cbr\u003e 01-05 Understanding how to set the display format\u003cbr\u003e 01-06 Understanding the exponential display format (5E+10)\u003cbr\u003e 01-07 Displaying amounts in multiple languages\u003cbr\u003e 01-08 How to Manage Date and Time Data in Excel \u003cbr\u003e01-09 Save the desired value as is using the text display format\u003cbr\u003e 01-10 Understanding Format Codes\u003cbr\u003e 01-11 Apply formats differently according to desired conditions\u003cbr\u003e Displaying the 01-12 ten thousand unit separator\u003cbr\u003e 01-13 How to reference cells in different locations\u003cbr\u003e 01-14 Referencing (linking) cells in other files\u003cbr\u003e 01-15 Change the linked file to another file of your choice\u003cbr\u003e 01-16 Disconnecting a linked file and changing the formula to a value\u003cbr\u003e 01-17 Understanding and Using Relative References\u003cbr\u003e 01-18 Understanding and Using Absolute References\u003cbr\u003e 01-19 Understanding and Using Mixed References\u003cbr\u003e 01-20 Understanding and Using Arithmetic Operators\u003cbr\u003e 01-21 Understanding and Using Comparison Operators\u003cbr\u003e 01-22 Understanding and Using Reference Operators\u003cbr\u003e 01-23 Operator Precedence\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCHAPTER 02 Excel functions that help you use formulas\u003c\/b\u003e\u003cbr\u003e 02-01 Understanding How to Use the Function Wizard\u003cbr\u003e How to use the 02-02 function easily\u003cbr\u003e 02-03 Understanding How to Use the Formula Input Bar\u003cbr\u003e 02-04 How to set a shortcut key to move to the formula input bar\u003cbr\u003e 02-05 Copying and using formulas in various ways \u003cbr\u003e02-06 Fill in values ​​in the separated area with a formula\u003cbr\u003e 02-07 Defining data ranges by name\u003cbr\u003e 02-08 Define and use values ​​to be used in calculations by name\u003cbr\u003e 02-09 Configuring Shortcuts\u003cbr\u003e 02-10 Defining a formula by name\u003cbr\u003e 02-11 How to define file and sheet related names\u003cbr\u003e 02-12 Defining and using names with relative references\u003cbr\u003e 02-13 Defining 3D References and Aggregating Questionnaires\u003cbr\u003e 02-14 Find and delete the name that caused the error\u003cbr\u003e 02-15 Causes of name duplication and solutions\u003cbr\u003e 02-16 Convert to Excel Table\u003cbr\u003e 02-17 Understanding Calculated Columns and Structured References\u003cbr\u003e 02-18 Understanding Various Structured Reference Syntax\u003cbr\u003e 02-19 Structural References and Reference Methods\u003cbr\u003e 02-20 How to resolve compatibility issues with structural references\u003cbr\u003e 02-21 How to Fix Excel Table Range Not Expanding Automatically\u003cbr\u003e 02-22 Hide formula\u003cbr\u003e 02-23 Converting formulas to values\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCHAPTER 03 Solving Formula Problems\u003c\/b\u003e\u003cbr\u003e 03-01 Understanding and Setting Up Error Markers\u003cbr\u003e 03-02 #DIV\/0! Error Causes and Solutions \u003cbr\u003eCauses and Solutions for the 03-03 #N\/A Error\u003cbr\u003e 03-04 #NAME? Causes and Solutions for Errors\u003cbr\u003e 03-05 #NULL! Error Causes and Solutions\u003cbr\u003e Causes and Solutions for Error 03-06 #NUM!\u003cbr\u003e 03-07 #VALUE! Error Causes and Solutions\u003cbr\u003e 03-08 #REF! Error Causes and Solutions\u003cbr\u003e 03-09 ######## Causes and solutions for errors\u003cbr\u003e 03-10 #SPILL! Causes and Solutions for Errors\u003cbr\u003e 03-11 #CALC! Error Causes and Solutions\u003cbr\u003e 03-12 Causes of Circular References and How to Fix Them\u003cbr\u003e 03-13 Check the reference location and quickly move to that location\u003cbr\u003e 03-14 Step-by-step calculation process for complex formulas\u003cbr\u003e 03-15 Checking Calculation Options If the Formula Isn't Calculated Automatically\u003cbr\u003e 03-16 Change the formula result to the value I want using Goal Finder\u003cbr\u003e 03-17 Installing the Solver Add-on\u003cbr\u003e 03-18 Compensating for the shortcomings of finding the target value using the solution\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePART 02 Excel Practical Functions\u003cbr\u003e\u003cbr\u003e CHAPTER 04 Decision Functions\u003c\/b\u003e \u003cbr\u003e04-01 Returning desired results based on whether a condition is met - IF function\u003cbr\u003e 04-02 Judging data using IS series functions - IFERROR function\u003cbr\u003e 04-03 Creating a conditional expression to determine the Excel version - INFO function\u003cbr\u003e 04-04 Solving function nesting problems - AND, OR, NOT, XOR functions\u003cbr\u003e 04-05 Converting an index number to a desired value - CHOOSE function\u003cbr\u003e 04-06 Processing multiple conditions with a single function without nesting - IFS function\u003cbr\u003e 04-07 Converting multiple code values ​​to desired values ​​- SWITCH function\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCHAPTER 05 Editing Functions\u003c\/b\u003e\u003cbr\u003e 05-01 Retrieving only the desired portion of a cell value - LEFT, MID, RIGHT functions\u003cbr\u003e 05-02 Separating left\/right at the delimiter position - FIND, SEARCH functions\u003cbr\u003e 05-03 Separating left and right in cells without delimiters - LEN function\u003cbr\u003e 05-04 Splitting columns at the same delimiter position\u003cbr\u003e 05-05 Finding the current file path, file name, and sheet name - CELL function\u003cbr\u003e 05-06 Returning desired results based on whether a specific word is included \u003cbr\u003e05-07 Splitting numbers by digits - TEXT, REPT functions\u003cbr\u003e 05-08 Various data connection methods\u003cbr\u003e Concatenate text within a range of 05-09 - PHONETIC function\u003cbr\u003e 05-10 Concatenating all data within a specific range - CONCAT function\u003cbr\u003e 05-11 Joining data within a specific range using a delimiter - TEXTJOIN function\u003cbr\u003e 05-12 Modifying and deleting parts of cells - SUBSTITUTE, REPLACE functions\u003cbr\u003e 05-13 Calculating numbers containing text characters\u003cbr\u003e 05-14 Separating only the part of data that contains the same delimiter\u003cbr\u003e 05-15 Separate all data containing multiple delimiters\u003cbr\u003e 05-16 Counting the number of specific words in a string\u003cbr\u003e 05-17 Deleting Invisible Ghost Characters - TRIM, CLEAN Functions\u003cbr\u003e 05-18 Converting text numbers to numeric data - VALUE function\u003cbr\u003e 05-19 Converting text dates to date data - DATEVALUE function\u003cbr\u003e 05-20 Converting numbers to Korean or Chinese characters - NUMBERSTRING function \u003cbr\u003e05-21 How to calculate a string like 100+200 - EVALUATE function\u003cbr\u003e Returning the formula string used in cell 05-22 - FORMULATEXT function\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCHAPTER 06 Aggregation and Statistical Functions\u003c\/b\u003e\u003cbr\u003e 06-01 Counting the number of data under various conditions\u003cbr\u003e 06-02 Conditional configuration pattern for functions with IF\u003cbr\u003e 06-03 Configuring AND and OR conditions using the COUNTIFS function\u003cbr\u003e Counting the number of times in the 06-04 interval - FREQUENCY function\u003cbr\u003e 06-05 Inserting serial numbers into tables in various situations\u003cbr\u003e 06-06 Checking for and Handling Duplicates - COUNTIFS Function\u003cbr\u003e Counting the number of specific words in a string entered in cell 06-07\u003cbr\u003e 06-08 Calculating totals using the SUM and SUMIF functions\u003cbr\u003e 06-09 Relationship between COUNTIF and SUMIF functions\u003cbr\u003e 06-10 Calculate cumulative total\u003cbr\u003e 06-11 Finding the cumulative total that meets the conditions\u003cbr\u003e 06-12 Summing Multiple Conditions with the SUMIFS Function\u003cbr\u003e 06-13 Calculating the sum by background color or font color condition\u003cbr\u003e 06-14 Mean, Median, and Mode - AVERAGE Function\u003cbr\u003e 06-15 Finding the average excluding zero - AVERAGEIF function \u003cbr\u003e06-16 Finding the average excluding the maximum\/minimum values\u003cbr\u003e 06-17 Finding the average excluding the upper\/lower N% (numbers) - TRIMMEAN function\u003cbr\u003e 06-18 Finding a Weighted Average - SUMPRODUCT Function\u003cbr\u003e 06-19 Obtaining N upper\/lower data\u003cbr\u003e 06-20 Finding maximum\/minimum values ​​with constraints\u003cbr\u003e 06-21 Finding the maximum\/minimum value that satisfies the condition\u003cbr\u003e 06-22 Finding the quotient and remainder of division - QUOTIENT, MOD functions\u003cbr\u003e 06-23 Resolving calculation errors in the MOD function\u003cbr\u003e 06-24 Rounding, Up, and Down - ROUND Series Functions\u003cbr\u003e 06-25 Change the rounding standard\u003cbr\u003e Rounding up, down, and up to multiples of 06-26\u003cbr\u003e 06-27 Calculating Ranks - RANK, RANK.EQ Functions\u003cbr\u003e 06-28 Reordering the rankings by classifying them according to new criteria\u003cbr\u003e 06-29 Finding Ranks with Multiple Ranges of Values\u003cbr\u003e 06-30 Finding the ranking for tables with the same structure entered in multiple sheets\u003cbr\u003e 06-31 Finding Percentage Rank - PERCENTRANK Function\u003cbr\u003e 06-32 Aggregating only the data visible on the screen - SUBTOTAL function \u003cbr\u003e06-33 Aggregating without formula errors - AGGREGATE function\u003cbr\u003e 06-34 Assigning serial numbers to data displayed on the screen\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCHAPTER 07 Date and Time Functions\u003c\/b\u003e\u003cbr\u003e 07-01 Recording today's date and time - NOW, TODAY functions\u003cbr\u003e Returning the day of the week for a date on July 2 - WEEKDAY, TEXT functions\u003cbr\u003e 07-03 Automatically record data entry date and time\u003cbr\u003e Calculating the start and end dates of the month of July and April\u003cbr\u003e 07-05 Calculating the start and end dates of the week in which a specific date falls\u003cbr\u003e 07-06 Making a Perpetual Calendar\u003cbr\u003e Return the previous weekday date when the date falls on a weekend\u003cbr\u003e Calculating the date of a specific day of the Nth week of each month\u003cbr\u003e Calculating the date N months (years) before (or after) 07-09\u003cbr\u003e 07-10 Calculate the end date (estimated delivery date) excluding weekends and holidays\u003cbr\u003e Grouping by half year and quarter from 07-11\u003cbr\u003e Calculating Fiscal Year and Fiscal Quarter 07-12\u003cbr\u003e 07-13 Distinguishing between common and leap years\u003cbr\u003e Calculating the week of the month in which the date falls\u003cbr\u003e Calculating the length of service from the date of employment on July 15 - DATEDIF function \u003cbr\u003e07-16 Calculating age, full age, and insurance age\u003cbr\u003e 07-17 Calculating the sum and average of the length of service\u003cbr\u003e 07-18 Divide the time into AM\/PM\u003cbr\u003e 07-19 Distinguishing hours, minutes, and seconds from time\u003cbr\u003e Adjust the 07-20 time in 30-minute and 1-hour intervals\u003cbr\u003e Calculating part-time salary based on working hours\u003cbr\u003e 07-22 Calculate working hours excluding break time\u003cbr\u003e 07-23 Calculating Overtime Hours\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCHAPTER 08 Reference Functions\u003c\/b\u003e\u003cbr\u003e 08-01 Referencing values ​​from another table using the VLOOKUP function\u003cbr\u003e 08-02 Finding values ​​in a range sorted in ascending order\u003cbr\u003e Finding a value in row 08-03 and referencing the cell below - HLOOKUP function\u003cbr\u003e 08-04 Converting the VLOOKUP function to INDEX and MATCH functions\u003cbr\u003e 08-05 Referencing the value in the left column of the value being looked for\u003cbr\u003e 08-06 Referencing values ​​in a table sorted by interval in descending order\u003cbr\u003e 08-07 New Reference Function - XLOOKUP Function\u003cbr\u003e 08-08 New Find Function - XMATCH Function\u003cbr\u003e 08-09 How to reference a value when you only know part of the value to find \u003cbr\u003e08-10 Finding values ​​containing wildcard characters (*, ?, ~)\u003cbr\u003e 08-11 How to find multiple values ​​at once\u003cbr\u003e 08-12 How to troubleshoot when #N\/A error occurs even though the value you are looking for exists\u003cbr\u003e 08-13 Refer to the last entered value\u003cbr\u003e 08-14 Find all locations where duplicate numbers are entered\u003cbr\u003e 08-15 Referencing desired values ​​from multiple tables\u003cbr\u003e 08-16 Referencing desired values ​​from multiple tables with different table configurations\u003cbr\u003e 08-17 Referencing Hyperlinks - HYPERLINK Function\u003cbr\u003e See Figure 08-18 (Image)\u003cbr\u003e 08-19 Referencing Dynamic Ranges - OFFSET Function\u003cbr\u003e 08-20 Reference only the most recent data among the entered data\u003cbr\u003e 08-21 Converting column (or row) data to row data\u003cbr\u003e 08-22 Converting an existing table to table format\u003cbr\u003e 08-23 Refer to locations spaced at regular intervals\u003cbr\u003e 08-24 Always refer to a fixed location -INDIRECT function\u003cbr\u003e 08-25 Consolidating data scattered across multiple sheets into one\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePART 03 Array Formulas and Array Functions\u003cbr\u003e\u003cbr\u003e CHAPTER 09 Principles of Arrays\u003c\/b\u003e \u003cbr\u003e09-01 Differences between general formulas and array formulas\u003cbr\u003e 09-02 Legacy Arrays and Dynamic Arrays\u003cbr\u003e 09-03 Understanding Matrices and Dimensions\u003cbr\u003e 09-04 How to check the values ​​stored in an array\u003cbr\u003e 09-05 Array Constants\u003cbr\u003e 09-06 Array (Matrix) Operations\u003cbr\u003e 09-07 How to change the direction of a one-dimensional array\u003cbr\u003e 09-08 Understanding AND and OR Operations of Boolean Values\u003cbr\u003e 09-09 Duplicate Removal Function - UNIQUE Function\u003cbr\u003e 09-10 Reference all data that meets desired conditions - FILTER function\u003cbr\u003e 09-11 Sorting and returning results within an array - SORT, SORTBY functions\u003cbr\u003e 09-12 Returning a serial number - SEQUENCE function\u003cbr\u003e\u003cbr\u003e \u003cb\u003eCHAPTER 10 Array formulas frequently used in practice\u003c\/b\u003e\u003cbr\u003e Array formula to add IF condition to 10-01 function\u003cbr\u003e 10-02 Array formula handling OR conditions\u003cbr\u003e 10-03 Calculate the average (aggregate) values ​​of the upper and lower N\u003cbr\u003e 10-04 Aggregating columns (or rows) spaced at regular intervals\u003cbr\u003e Counting numbers that match the 10-05 Lotto winning numbers\u003cbr\u003e 10-06 Counting unique numbers\u003cbr\u003e 10-07 Count and display the maximum number of consecutive occurrences of the same value. \u003cbr\u003e10-08 Using 3-Dimensional References in the SUMIF Function\u003cbr\u003e 10-09 Adding IF conditions to a table with an automatic filter applied and aggregating\u003cbr\u003e 10-10 Calculating gender and age group from resident registration numbers\u003cbr\u003e 10-11 When there are multiple identical delimiters, cut left\/right from the last position of the delimiter.\u003cbr\u003e Separate numbers, English, and Korean characters from 10-12\u003cbr\u003e Monthly and quarterly aggregation from data entered only on the 10th-13th day\u003cbr\u003e 10-14 Find and reference approximate locations\u003cbr\u003e Classify data by checking whether it contains 10-15 specific words.\u003cbr\u003e 10-16 Find and reference locations that satisfy all conditions\u003cbr\u003e 10-17 Finding and referencing the position of the last value in a table containing mixed text and numbers\u003cbr\u003e Reference all values ​​that meet the conditions 10-18 in order\u003cbr\u003e 10-19 Reference irregularly merged cells in order\u003cbr\u003e Reference in order the values ​​that meet the conditions of 10-20, excluding blank cells.\u003cbr\u003e 10-21 Reference only unique items that meet the conditions among duplicate data\u003cbr\u003e 10-22 Sort and display data\u003cbr\u003e \u003cbr\u003eSearch\u003cbr\u003e\n\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\u003cimg src=\"https:\/\/image.yes24.com\/momo\/TopCate3242\/MidCate002\/324113044.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\u003eWhat kind of readers is this book for?\u003c\/b\u003e\u003cbr\u003e - Office workers who need to use Excel functions and formulas immediately at work.\u003cbr\u003e - People who want to conveniently create Excel documents by freely handling Excel functions and formulas.\u003cbr\u003e - People who want to learn the principles of Excel functions and formulas by finding and using the content they need whenever they need it.\u003cbr\u003e - People who want to learn and utilize advanced Excel functions that are efficient for work but not easily accessible through practical examples.\u003cbr\u003e - People who want to know the new function formula features and how to use them in the new version of Excel.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eFeatures of this book\u003cbr\u003e Effective use anytime, anywhere with all versions available\u003c\/b\u003e\u003cbr\u003e The structure and utilization of Excel functions and formulas required for work are explained in detail and in an easy-to-understand manner, so you can look them up and learn them whenever you need them. \u003cbr\u003eIt is available for all versions including Excel 2007, 2010, 2013, 2016, 2019, and Microsoft 365, so you can use it anytime, anywhere.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eHigh-level examples that can be applied in practice\u003c\/b\u003e\u003cbr\u003e The high-level examples essential for practical Excel use were selected from the author's lectures, practical experience, and various cases obtained while operating Naver's representative Excel cafe, 'Excel...One a Day.'\u003cbr\u003e You can experience the most optimized practical examples for learning and utilizing Excel functions and formulas.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eEfficient organization that makes it easy to find what you need\u003c\/b\u003e\u003cbr\u003e It is impossible to memorize all 500 or so Excel functions.\u003cbr\u003e Rather than introducing all functions, this book is structured to allow you to learn essential functions and formulas needed for work through case studies.\u003cbr\u003e I put it on my desk and look for it and use it whenever I want.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eIntroduction to new Excel features and how to use them\u003c\/b\u003e \u003cbr\u003eThis article provides a detailed introduction to array formulas that greatly improve the efficiency of Excel work, as well as dynamic array functions and formulas newly added to the Microsoft 365 version, from their principles to how to use them in work.\u003cbr\u003e By learning the array formulas optimized for your work situation one by one whenever you need them, you can quickly improve your work utilization skills.\u003cbr\u003e\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 publication:\u003c\/strong\u003e December 7, 2020\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 928 pages | 188*258*40mm\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 9791162243701\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 1162243708 \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":43893251473450,"sku":"138512","price":46.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/23b2266d539e544955bf6759267bc4dd.jpg?v=1765394048","url":"https:\/\/librairie.coreenne.fr\/en\/products\/138512","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}