Theme 01 Getting Started with Excel
Lesson 01 New Features in Excel 2024
Lesson 02 Setting up the Excel work environment

Theme 02 Basic Excel Tasks
Lesson 01 Excel Data Types and Input Methods
Lesson 02 Efficient Data Entry
Lesson 03 Validation to Increase Data Accuracy
Lesson 04 Writing Simple Calculations
Lesson 05 Range Selection Options and Copy/Paste

Theme 03 Using Formats to Effectively Write Reports
Lesson 01 Cell Formatting
Lesson 02 Using Conditional Formatting
Lesson 03 Screen Control and Printing

Theme 04 Efficient Data Management and Data Processing
Lesson 01 Sorting and Autofilter
Lesson 02: Tables for Efficient Data Management
Lesson 03 Data Processing Techniques Frequently Used in Practice
Lesson 04: Data Collection and Processing Using Power Query

Theme 05 Practical Application Functions
Lesson 01 Understanding Functions and Defining Names
Lesson 02 Mathematical Functions for Practical Calculations
Lesson 03 Statistical Functions for Summarizing Data
Lesson 04 Logical Functions and Information Functions
Lesson 05 Text and Date/Time Functions for Data Processing
Lesson 06 Find/Reference Functions
Lesson 07 Newly Added Dynamic Array Functions

Theme 06 Charts that visualize data
Lesson 01 Creating and Editing Excel Charts
Lesson 02: Creating Charts Frequently Used in Practice

Theme 07 Data Analysis Tools for Practical Use
Lesson 01 Data Organization and Summary
Lesson 02 Data Analysis Using Pivot Tables
Lesson 03: What-If Analysis and Forecasting Tools in Excel

Theme 08: Utilizing Generative AI
Lesson 01: Using Generative AI
Lesson 02: Automating Repetitive Tasks with Generative AI

Excel, you can use it as much as you know!

Since the advent of ChatGPT, many tasks have become replaceable by AI.
Is this also true for Excel work? Can you work efficiently without knowing any Excel functions? The answer is no.
This is because competitiveness ultimately comes from knowing the structure and principles of Excel.
Therefore, 'Excel 2024 Guide for Beginners' was created to help both beginners and professionals understand and utilize Excel's various essential functions, numerous features, added content, and how to utilize generative AI in Excel work more easily and practically.

For beginners, we start with an explanation of Excel's work environment settings, worksheets, and toolbars.
It will also be helpful to those who are familiar with Excel, as it first explains shortcuts that beginners may not know well and automatic setting functions that are often overlooked.
And the 100 practical applications that follow follow the core function guide in 28 lessons.
The key features are explained in detail, with each button and its usage explained in detail, so that this book can be used like a dictionary.
Additionally, if the usage has changed since a specific version, it is listed to ensure compatibility across all versions.
And in practical use, it is particularly rich in screen captures.
As with the description of the core functions, we have carefully guided you through the buttons to click and the values ​​to enter, along with images, to help you understand easily and apply them to your own situation.

This book will be helpful for beginners who want to learn Excel for immediate practical use, office workers who want to improve the efficiency of repetitive report work, practitioners who search for Excel usage methods whenever a new task arises, practitioners who want to learn not only the functions they use every time, but also data analysis and automation, and experts who want to know the latest Excel functions and how to utilize AI.