Section 01.
Getting Started with Excel 2021
Practice 01 | Starting and Closing Excel 2021
Practice 02 | Understanding the Excel 2021 Screen Layout
Practice 03 | Executing Commands with the Ribbon Menu
Exercise 04 | Customizing the Quick Access Toolbar
Try to solve the problem

Section 02.
Entering data and calculating formulas
Practice 01 | Entering Various Data
Practice 02 | Entering Special Characters and Chinese Characters
Practice 03 | Calculating the sum using a formula
Try to solve the problem

Section 03.
Managing Worksheets
Practice 01 | Inserting and Deleting Cells
Practice 02 | Adjusting Row and Column Sizes
Exercise 03 | Managing Worksheets
Try to solve the problem

Section 04.
Formatting Cells
Practice 01 | Font and Customization
Practice 02 | Adding a border and specifying a background color
Practice 03 | Specifying the Data Display Format
Try to solve the problem

Section 05.
Insert a picture and decorate it nicely
Practice 01 | Inserting and Editing Images
Practice 02 | Drawing with Shapes
Practice 03 | Decorating Text with WordArt
Try to solve the problem

Section 06.
Print the worksheet
Practice 01 | Print Preview
Practice 02 | Creating Headers and Footers
Practice 03 | Setting Up Print Pages
Try to solve the problem

Section 07.
Using conditional formatting
Practice 01 | Cell Highlighting Rules
Practice 02 | Upper/lower rules
Practice 03 | Data Bar/Color/Icon Combination
Practice 04 | Creating a Search Function with Conditional Formatting
Try to solve the problem


Section 08.
Formulas and functions
Practice 01 | Entering and Checking Formulas
Practice 02 | Calculating with Auto Sum
Practice 03 | Defining Names and Using the Function Wizard
Try to solve the problem

Section 09.
Learning the basics of functions
Practice 01 | Finding the number of items based on conditions
Practice 02 | Finding the sum based on conditions
Practice 03 | Ranking by Sales
Practice 04 | Searching Data Using a Criteria Table
Try to solve the problem

Section 10.
Function input and nesting usage
Exercise 01 | Displaying the Current Date and Time
Exercise 02 | Extracting Characters on the Left Side of Text
Practice 03 | Rounding Decimals
Exercise 04 | Displaying Different Values ​​Depending on Conditions
Try to solve the problem

Section 11.
Create a chart
Practice 01 | Inserting a Chart
Practice 02 | Changing the Chart Format
Practice 03 | Changing the Chart Type
Try to solve the problem

Section 12.
Extract only the data you want by filtering
Practice 01 | Extracting Data Using Automatic Filters
Practice 02 | Extracting Data Using Advanced Filters
Try to solve the problem

Section 13.
Data sorting and subtotals
Practice 01 | Sorting in ascending and descending order
Practice 02 | Sorting by Various Criteria
Practice 03 | Inserting Subtotals
Exercise 04 | Inserting Overlapping Subtotals
Try to solve the problem

Section 14.
Import external data
Practice 01 | Importing External Data
Practice 02 | Data Processing
Practice 03 | Splitting Text
Try to solve the problem

Section 15.
Validate data
Practice 01 | Setting up data validation
Exercise 02 | Removing Duplicate Items
Try to solve the problem

Section 16.
Pivot Table Basics
Practice 01 | Creating a Pivot Table
Practice 02 | Handling Pivot Table Fields
Practice 03 | Creating a Pivot Chart
Try to solve the problem

Section 17.
Using Pivot Tables
Practice 01 | Setting up value fields and adding calculated fields
Practice 02 | Using Slicers and Timelines
Try to solve the problem

Section 18.
Analyzing data virtually
Practice 01 | Scenario Manager
Practice 02 | Finding the Target Value
Practice 03 | Using Data Tables
Try to solve the problem

Section 19.
Using Macros to Automate Documents
Practice 01 | Recording and Running Macros
Exercise 02 | Automating Documents Using Form Controls
Exercise 03 | Attaching a Macro to a Form Control
Try to solve the problem

Section 20.
Leveraging Artificial Intelligence (AI)
Exercise 01 | Creating Functions with Generative AI
Practice 02 | Creating Excel Documents with Generative AI
Try to solve the problem

01 Practice-oriented follow-up structure
We have organized the training system around basic functions and examples essential for practical use, so that anyone can easily follow along and learn.

02 Includes substantial know-how from veteran teachers
It contains all the key learning points based on students' questions, so you can improve your learning efficiency.

03 Cool and beautiful design
It has a cool design and font to maximize learning efficiency.

04 Includes a wealth of problems you can challenge yourself with.
At the end of each section, problem-solving exercises are included to help you develop your understanding and application skills.