{"product_id":"140006","title":"Data Analysis with Excel ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jYGWrzASXGvN8fj8sBnNohQEWruEN.png?v=1765077763\" 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 Data Analysis with Excel \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\/148837414\/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\u003eFrom Excel basics to data analysis\u003cbr\u003e Learn Excel Data Analysis by Following\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e \"Learning Data Analysis with Excel\" is aimed at readers who want to learn data analysis using Excel's basic functions and features.\u003cbr\u003e This book details the Excel functions required for data collection, sorting, aggregation, and visualization—the core processes of data analysis—and includes various examples and hands-on projects utilizing real-world data to help you apply them in practice.\u003cbr\u003e By following the projects in this article, you will be able to develop your Excel skills and data handling capabilities.\u003cbr\u003e You can also experience the entire process of data analysis through a comprehensive project that applies what you learned in each chapter.\u003cbr\u003e\u003cbr\u003e ※ This book was developed as a textbook for university lectures, so it does not provide answers to practice problems.\u003cbr\u003e  \u003c\/div\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cul\u003e\u003cli\u003eYou 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\u003ePART 01 Getting Started with Excel\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e CHAPTER 01 Overview of Data Analysis\u003cbr\u003e 01 Data Analysis\u003cbr\u003e 02 Data Analysis Process\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 02 Basic Excel Usage\u003cbr\u003e 01 Excel screen layout and workbook\u003cbr\u003e 02 Editing Worksheets\u003cbr\u003e 03 Cell Editing\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 03 Data Editing and Reference\u003cbr\u003e 01 Data Editing\u003cbr\u003e 02 Copying and cutting data\u003cbr\u003e 03 Cell Reference\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e \u003cb\u003ePART 02 Data Preparation\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e CHAPTER 04 Analysis Data Collection I\u003cbr\u003e 01 Data Definition\u003cbr\u003e 02 Data Collection\u003cbr\u003e 03 Data Entry\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 05 Data Organization\u003cbr\u003e 01 Creating data with appropriate expressions\u003cbr\u003e 02 Creating new data through judgment and reference\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 06 Extracting representative values ​​from data\u003cbr\u003e 01 Finding the representative value\u003cbr\u003e 02 Calculating final grades\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 07 Analysis Data Collection II\u003cbr\u003e 01 Data Definition\u003cbr\u003e 02 Data Entry and Organization\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e \u003cbr\u003e\u003cb\u003ePART 03 Data Analysis and Results Sharing\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e CHAPTER 08 Data Aggregation Using Functions\u003cbr\u003e 01 Aggregate data based on conditions\u003cbr\u003e 02 Finding values ​​based on conditions\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 09 Sorting Data\u003cbr\u003e 01 Sort by one criterion\u003cbr\u003e 02 Sort by two or more criteria\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 10 Aggregating Data Using Subtotals\u003cbr\u003e 01 Execution of partial agreement\u003cbr\u003e 02 Partial sum using one function\u003cbr\u003e 03 Partial sum using two or more functions\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 11 Data Analysis Using Filtering\u003cbr\u003e 01 Automatic Filter\u003cbr\u003e 02 Advanced Filter\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 12 DATA ANALYZING USING PIVOT TABLES\u003cbr\u003e 01 Pivot Table Basics\u003cbr\u003e 02 Understanding the PivotTable Fields Pane\u003cbr\u003e Understanding Row Labels\u003cbr\u003e 04 Grouping in Pivot Tables\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 13 CONDITIONAL FORMATTING AND TABLES\u003cbr\u003e 01 Conditional Formatting\u003cbr\u003e Table 02\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 14 Charts and Sparklines\u003cbr\u003e 01 Chart Overview\u003cbr\u003e 02 Charts and Data\u003cbr\u003e 03 Sparklines and Pivot Charts\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e \u003cbr\u003e\u003cb\u003ePART 04 Functions for Data Analysis\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e CHAPTER 15 Understanding the State of a Data Set\u003cbr\u003e 01 Variance and standard deviation\u003cbr\u003e 02 Data Validation\u003cbr\u003e Phase of value 03\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 16 Forecasting Using Virtual Analysis\u003cbr\u003e 01 Finding the target value\u003cbr\u003e 02 Managing Scenarios\u003cbr\u003e summation\u003cbr\u003e Practice problems\u003cbr\u003e\u003cbr\u003e CHAPTER 17 Comprehensive Data Analysis Project\u003cbr\u003e 01 Data Definition\u003cbr\u003e 02 Data Analysis Practice\u003cbr\u003e\u003cbr\u003e Search\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\/TopCate5423\/MidCate3\/542227254.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\u003eExcel is simple, yet powerful data analysis tool!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e As AI technology continues to advance, the ability to handle and analyze data is becoming an essential skill for individuals.\u003cbr\u003e This book is designed to help you experience the entire process of data analysis using Excel, a highly accessible tool.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eIncludes basic Excel functions and essential functions for data analysis.\u003c\/b\u003e\u003cbr\u003e \u003cbr\u003eThis guide explains in detail the basic concepts and usage methods of each Excel function and function required for data collection, aggregation, sorting, analysis, and visualization, which are essential steps in data analysis, so that even beginners to Excel can easily begin data analysis.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e \u003cb\u003eWe provide four data analysis projects using real-life data!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e We provide examples, exercises, and practice problems in project format that allow you to directly utilize the Excel functions and features you learned in each chapter.\u003cbr\u003e Through this, you can develop your skills from Excel usage to organic data handling.\u003cbr\u003e The four data analysis projects presented in this article are:\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e 1.\u003cbr\u003e Student Performance Analysis\u003cbr\u003e 2.\u003cbr\u003e Shopping mall member information analysis\u003cbr\u003e 3.\u003cbr\u003e Analysis of member reservation status by reservation agency\u003cbr\u003e 4.\u003cbr\u003e Analysis of the current status of the library management system\u003cbr\u003e\u003cbr\u003e \u003cb\u003eThe revised 2nd edition contains even richer content!\u003c\/b\u003e\u003cbr\u003e \u003cbr\u003eThe revised contents reflected in 『Data Analysis with Excel (2nd Edition)』 are as follows.\u003cbr\u003e\u003cbr\u003e - All screen and practice images have been replaced based on the Excel 2021 version.\u003cbr\u003e - Supplement the explanations of each chapter by adding simple examples of using Excel functions and features.\u003cbr\u003e - Added chapter-by-chapter examples and practice problems\u003cbr\u003e - Complement data visualization (Chapters 13 and 14) to accurately express data analysis results.\u003cbr\u003e - Replaced practice problems and added the 'Analysis of the Current Status of the Library Management System' project.\u003cbr\u003e - Added Chapter 17, a comprehensive data analysis project utilizing data from corporate liberal arts education courses. \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 July 10, 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 556 pages | 1,098g | 188*257*22mm\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 9791173400308 \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":43893393621034,"sku":"140006","price":43.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/f2fab439db325b18904957937bf0e33a.jpg?v=1765399956","url":"https:\/\/librairie.coreenne.fr\/en\/products\/140006","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}