PART 1 Excel

01 Excel 2021 Basic Functions and Worksheet Handling ● 2
1 Starting and ending Excel ● 2
2 Excel Basic Screen Configuration ● 6
3 Integrated Document Management ● 10
4 Print the workbook ● 14
5 Editing Worksheets ● 19
6 Worksheet Management ● 28
Unit Summary ● 37
Practice Problem ● 40

02 Data Entry and Editing ● 43
1 Enter letters and numbers ● 43
2. Entering symbols and Chinese characters ● 47
3 Enter date and time ● 51
4 Autofill ● 53
Unit Summary ● 64
Practice Problem ● 66

03 Cell Format Basics and Utilization ● 68
1 Cell Formatting ● 68
2 Understanding the [Cell Format] Dialog Box ● 74
3 Conditional Formatting ● 84
Unit Summary ● 90
Practice Problem ● 91

04 Entering formulas and referencing cells ● 97
1 Formula input ● 97
2 cell references ● 103
3 Entering formulas using functions ● 109
Unit Summary ● 113
Practice Problem ● 114

05 Excel Functions ● 117
1 Understanding Statistical Functions ● 118
2 Handling Math/Trigonometric Functions ● 127
3 Handling Text Functions ● 131
4 Handling Logical Functions ● 134
5 Handling Date/Time Functions ● 140
6 Find Function/Reference Function ● 143
7 Database Functions ● 147
Unit Summary ● 151
Practice Problem ● 154

06 Data Visualization ● 159
1 Understanding Charts ● 159
2 Chart Creation ● 163
3 Chart Editing ● 168
4 Creating Various Charts ● 175
Unit Summary ● 183
Practice Problem ● 185

07 Data Management and Analysis ● 188
1 Sorting and subtotaling data ● 188
2 Extracting Data ● 197
3 Pivot Tables and Pivot Charts ● 204
Unit Summary ● 212
Practice Problem ● 214

PART 2

01 PowerPoint Basic Functions ● 220
1 Understanding Presentations and PowerPoint ● 220
2 Starting PowerPoint ● 226
3 Handling PowerPoint Documents ● 229
4 Handling Slides ● 232
5 PowerPoint Basic Function Practice Problems ● 239

02 Text Slide ● 241
1 Enter text ● 241
2 Text Editing ● 247
3 Different types of text input ● 257
4 Text Slide Practice Problems ● 265

03 Multimedia Object Design ● 267
1. Use of Shapes ● 267
2 Image Utilization ● 283
3 Using Audio and Video ● 290
4 Multimedia Object Design Practice Problems ● 299

04 Data Visualization ● 301
1 Creating and Editing Tables ● 301
2 Creating and Editing Charts ● 313
3 Using Word Art ● 324
4 Using SmartArt ● 327
5 Data Visualization Practice Problems ● 332

05 Animations and Slideshows ● 334
1 Animation Settings ● 334
2 Screen Transition Effects ● 343
3 Slideshows and Settings ● 350
4 Using Hyperlinks ● 355
5 Animation and Slideshow Practice Problems ● 359

06 Design Management and Printing Functions ● 361
1 Design Theme ● 361
2 Slide Master ● 367
3 Printing Functions ● 382
4 Design Management and Printing Function Practice Problems ● 386