Data Analysis with Excel
 |
Description
Book Introduction
From Excel basics to data analysis
Learn Excel Data Analysis by Following
"Learning Data Analysis with Excel" is aimed at readers who want to learn data analysis using Excel's basic functions and features.
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.
By following the projects in this article, you will be able to develop your Excel skills and data handling capabilities.
You can also experience the entire process of data analysis through a comprehensive project that applies what you learned in each chapter.
※ This book was developed as a textbook for university lectures, so it does not provide answers to practice problems.
Learn Excel Data Analysis by Following
"Learning Data Analysis with Excel" is aimed at readers who want to learn data analysis using Excel's basic functions and features.
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.
By following the projects in this article, you will be able to develop your Excel skills and data handling capabilities.
You can also experience the entire process of data analysis through a comprehensive project that applies what you learned in each chapter.
※ This book was developed as a textbook for university lectures, so it does not provide answers to practice problems.
- You can preview some of the book's contents.
Preview
index
PART 01 Getting Started with Excel
CHAPTER 01 Overview of Data Analysis
01 Data Analysis
02 Data Analysis Process
summation
Practice problems
CHAPTER 02 Basic Excel Usage
01 Excel screen layout and workbook
02 Editing Worksheets
03 Cell Editing
summation
Practice problems
CHAPTER 03 Data Editing and Reference
01 Data Editing
02 Copying and cutting data
03 Cell Reference
summation
Practice problems
PART 02 Data Preparation
CHAPTER 04 Analysis Data Collection I
01 Data Definition
02 Data Collection
03 Data Entry
summation
Practice problems
CHAPTER 05 Data Organization
01 Creating data with appropriate expressions
02 Creating new data through judgment and reference
summation
Practice problems
CHAPTER 06 Extracting representative values from data
01 Finding the representative value
02 Calculating final grades
summation
Practice problems
CHAPTER 07 Analysis Data Collection II
01 Data Definition
02 Data Entry and Organization
summation
Practice problems
PART 03 Data Analysis and Results Sharing
CHAPTER 08 Data Aggregation Using Functions
01 Aggregate data based on conditions
02 Finding values based on conditions
summation
Practice problems
CHAPTER 09 Sorting Data
01 Sort by one criterion
02 Sort by two or more criteria
summation
Practice problems
CHAPTER 10 Aggregating Data Using Subtotals
01 Execution of partial agreement
02 Partial sum using one function
03 Partial sum using two or more functions
summation
Practice problems
CHAPTER 11 Data Analysis Using Filtering
01 Automatic Filter
02 Advanced Filter
summation
Practice problems
CHAPTER 12 DATA ANALYZING USING PIVOT TABLES
01 Pivot Table Basics
02 Understanding the PivotTable Fields Pane
Understanding Row Labels
04 Grouping in Pivot Tables
summation
Practice problems
CHAPTER 13 CONDITIONAL FORMATTING AND TABLES
01 Conditional Formatting
Table 02
summation
Practice problems
CHAPTER 14 Charts and Sparklines
01 Chart Overview
02 Charts and Data
03 Sparklines and Pivot Charts
summation
Practice problems
PART 04 Functions for Data Analysis
CHAPTER 15 Understanding the State of a Data Set
01 Variance and standard deviation
02 Data Validation
Phase of value 03
summation
Practice problems
CHAPTER 16 Forecasting Using Virtual Analysis
01 Finding the target value
02 Managing Scenarios
summation
Practice problems
CHAPTER 17 Comprehensive Data Analysis Project
01 Data Definition
02 Data Analysis Practice
Search
CHAPTER 01 Overview of Data Analysis
01 Data Analysis
02 Data Analysis Process
summation
Practice problems
CHAPTER 02 Basic Excel Usage
01 Excel screen layout and workbook
02 Editing Worksheets
03 Cell Editing
summation
Practice problems
CHAPTER 03 Data Editing and Reference
01 Data Editing
02 Copying and cutting data
03 Cell Reference
summation
Practice problems
PART 02 Data Preparation
CHAPTER 04 Analysis Data Collection I
01 Data Definition
02 Data Collection
03 Data Entry
summation
Practice problems
CHAPTER 05 Data Organization
01 Creating data with appropriate expressions
02 Creating new data through judgment and reference
summation
Practice problems
CHAPTER 06 Extracting representative values from data
01 Finding the representative value
02 Calculating final grades
summation
Practice problems
CHAPTER 07 Analysis Data Collection II
01 Data Definition
02 Data Entry and Organization
summation
Practice problems
PART 03 Data Analysis and Results Sharing
CHAPTER 08 Data Aggregation Using Functions
01 Aggregate data based on conditions
02 Finding values based on conditions
summation
Practice problems
CHAPTER 09 Sorting Data
01 Sort by one criterion
02 Sort by two or more criteria
summation
Practice problems
CHAPTER 10 Aggregating Data Using Subtotals
01 Execution of partial agreement
02 Partial sum using one function
03 Partial sum using two or more functions
summation
Practice problems
CHAPTER 11 Data Analysis Using Filtering
01 Automatic Filter
02 Advanced Filter
summation
Practice problems
CHAPTER 12 DATA ANALYZING USING PIVOT TABLES
01 Pivot Table Basics
02 Understanding the PivotTable Fields Pane
Understanding Row Labels
04 Grouping in Pivot Tables
summation
Practice problems
CHAPTER 13 CONDITIONAL FORMATTING AND TABLES
01 Conditional Formatting
Table 02
summation
Practice problems
CHAPTER 14 Charts and Sparklines
01 Chart Overview
02 Charts and Data
03 Sparklines and Pivot Charts
summation
Practice problems
PART 04 Functions for Data Analysis
CHAPTER 15 Understanding the State of a Data Set
01 Variance and standard deviation
02 Data Validation
Phase of value 03
summation
Practice problems
CHAPTER 16 Forecasting Using Virtual Analysis
01 Finding the target value
02 Managing Scenarios
summation
Practice problems
CHAPTER 17 Comprehensive Data Analysis Project
01 Data Definition
02 Data Analysis Practice
Search
Detailed image
Publisher's Review
Excel is simple, yet powerful data analysis tool!
As AI technology continues to advance, the ability to handle and analyze data is becoming an essential skill for individuals.
This book is designed to help you experience the entire process of data analysis using Excel, a highly accessible tool.
Includes basic Excel functions and essential functions for data analysis.
This 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.
We provide four data analysis projects using real-life data!
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.
Through this, you can develop your skills from Excel usage to organic data handling.
The four data analysis projects presented in this article are:
1.
Student Performance Analysis
2.
Shopping mall member information analysis
3.
Analysis of member reservation status by reservation agency
4.
Analysis of the current status of the library management system
The revised 2nd edition contains even richer content!
The revised contents reflected in 『Data Analysis with Excel (2nd Edition)』 are as follows.
- All screen and practice images have been replaced based on the Excel 2021 version.
- Supplement the explanations of each chapter by adding simple examples of using Excel functions and features.
- Added chapter-by-chapter examples and practice problems
- Complement data visualization (Chapters 13 and 14) to accurately express data analysis results.
- Replaced practice problems and added the 'Analysis of the Current Status of the Library Management System' project.
- Added Chapter 17, a comprehensive data analysis project utilizing data from corporate liberal arts education courses.
As AI technology continues to advance, the ability to handle and analyze data is becoming an essential skill for individuals.
This book is designed to help you experience the entire process of data analysis using Excel, a highly accessible tool.
Includes basic Excel functions and essential functions for data analysis.
This 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.
We provide four data analysis projects using real-life data!
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.
Through this, you can develop your skills from Excel usage to organic data handling.
The four data analysis projects presented in this article are:
1.
Student Performance Analysis
2.
Shopping mall member information analysis
3.
Analysis of member reservation status by reservation agency
4.
Analysis of the current status of the library management system
The revised 2nd edition contains even richer content!
The revised contents reflected in 『Data Analysis with Excel (2nd Edition)』 are as follows.
- All screen and practice images have been replaced based on the Excel 2021 version.
- Supplement the explanations of each chapter by adding simple examples of using Excel functions and features.
- Added chapter-by-chapter examples and practice problems
- Complement data visualization (Chapters 13 and 14) to accurately express data analysis results.
- Replaced practice problems and added the 'Analysis of the Current Status of the Library Management System' project.
- Added Chapter 17, a comprehensive data analysis project utilizing data from corporate liberal arts education courses.
GOODS SPECIFICS
- Date of issue: July 10, 2025
- Page count, weight, size: 556 pages | 1,098g | 188*257*22mm
- ISBN13: 9791173400308
You may also like
카테고리
korean
korean
![GQ KOREA Mark (Monthly): December [2025]](http://librairie.coreenne.fr/cdn/shop/files/8ef265dbbfbf186523ed75ba7319009d.jpg?v=1765340328&width=3840)
