Basic Data Processing Using Excel

Chapter 1 Working with Excel
1.1 Understanding with the Excel Interface
1.1.1 Getting to Know Excel Window
1.1.2 Understanding the Excel Ribbon
1.1.3 Exploring Ribbon Tabs
1.1.4 Finding Help
1.2 Workbook Basic Operations
1.2.1 Starting a New Workbook File
1.2.2 Saving the Workbook
1.2.3 Opening the Existing Workbook
1.2.4 Closing the Workbook
1.3 Worksheet Basic Operation
1.3.1 Selecting a Worksheet
1.3.2 Renaming the Worksheet
1.3.3 Inserting a Worksheet
1.3.4 Deleting a Worksheet
1.3.5 Moving a Worksheet
1.3.6 Coping a Worksheet
1.3.7 Formatting Worksheet Tab Color
1.3.8 Splitting a Worksheet
1.3.9 Hiding and Unhiding a Worksheet
1.4 Cells Basic Operation
1.4.1 Selecting Cells
1.4.2 Inserting Cells
1.4.3 Deleting Cells
1.4.4 Moving Cells Data
1.4.5 Coping Cell Data
1.4.6 Merging Cells
1.5 Rows and Columns Basic Operation
1.5.1 Changing Rows Height and Column Width
1.5.2 Inserting Rows or Columns
1.5.3 Deleting Rows or Columns

Chapter 2 Entering and Editing Data
2.1 Entering Data
2.1.1 Entering Common Data
2.1.2 Typing Data in the Formula Bar
2.1.4 Entering Time
2.1.5 Entering Special Symbols
2.2 Editing Cell Data
2.2.1 Editing Part Cell Data
2.2.2 Undoing and restoring Cell Data
2.3 Quick Filling Data
2.3.1 Quick Filling Blank Cells
2.3.2 Using the Fill Handle
2.3.3 Entering the Arithmetic Series
2.4 Adding Comment to Cells
2.4.1 Adding Comment
2.4.2 Editing Comment
2.4.3 Deleting comment
2.5 Finding and Replacing Data
2.5.1 Finding Data
2.5.2 Replacing Data

Chapter 3 Formatting a Workbook
3.1 Formatting Cell Data
3.1.1 Formatting Font and Size
3.1.2 Formatting Font and Size
3.1.3 Formatting Number
3.1.4 Applying a Text Wrap
3.2 Adding Cell Borders and Shading
3.2.1 Adding Borders
3.2.2 Formatting Cell Background
3.2.3 Adding a Background to a Worksheet
3.3 Using Conditional Formatting and Styles
3.3.1 Setting Conditional Formatting
3.3.2 Clearing Conditional Format
3.3.3 Appling Cell Styles
3.4 Setting Data Validation Rule
3.4.1 Setting Input Data Length
3.4.2 Testing Input Validation
3.4.3 Setting Input Data Dropdown List Content
3.4.4 Setting Input Data Range
3.5 Adding Worksheet Graphics
3.5.1 Inserting a Clip Art
3.5.2 Inserting Image Files
3.5.3 Editing Image Size
3.5.4 Inserting WordArt
3.5.5 Inserting and Editing Shapes
3.5.6 Inserting a SmartArt Graphic

Chapter 4 Working with Formula
4.1.1 Learning Operators
4.1.2 Entering a Formula
4.1.3 Copying a Formula
4.1.4 Deleting a Formula
4.2 Understanding Cell References
4.2.1 Applying Absolute References
4.2.2 Applying Relative References
4.2.3 Applying Mixed References
4.2.4 Using Same Workbook Cell Reference
4.2.5 Using Other Workbook Cell Reference
4.3 Using an Array Formula
4.3.1 Without Using an Array Formula
4.3.2 Using an Array Formula
4.3.3 Viewing Array Formula
4.3.4 Modifying Array Formula
4.4 Using Function to Calculate Data
4.4.1 Understanding Excel Functions
4.4.2 Typing a Function
4.4.3 Inserting a Function
4.4.4 Searching a Function

Chapter 5 Common Excel Function
5.1 Common Text Function
5.1.1 Left Function to Extract
5.1.2 Right Function to Extract
5.1.3 MID Function to Extract
5.1.4 Joining Strings Using the & Operator
5.1.5 UPPER Function to Convert Text to Uppercase
5.1.6 LOWER Function to Convert Text to Lowercase
5.2 Common Date and Time Functions
5.2.1 Using NOW Function to Get Date and Time
5.2.2 Using TODAY Function to Get the Current Date
5.2.3 Using YEAR Function to Get Year
5.2.4 Using MONTH Function to Get Month
5.2.5 Using Day Function to Get Day
5.2.6 Using DATE Function to Get Year, Month, and Day
5.3 Common Math Function
5.3.1 Using SUM Calculate Numerical Sum
5.3.2 Using AVERAGE Calculate Mean
5.3.3 Using MAX Calculate Maximum
5.3.4 Using MIN Calculate Minimum
5.4 Working with Logical Functions
5.4.1 Using IF Conditional Return Value
5.5 Working with Lookup Functions
5.5.1 Using LOOKUP Return Value
5.5.2 Using VERTICAL LOOKUP (VLOOKUP) Return Value Cross More Columns
5.5.3 Using HORIZONTAL LOOKUP (HLOOKUP) Return Value Cross Rows

Chapter 6 Statistics and Analysis
6.1 Basic Data Sorting
6.1.1 Sorting by One Condition
6.1.2 Sorting by Multiple Criteria
6.2 Analyzing Worksheet Data
6.2.1 Auto Filtering
6.2.2 Removing Filtering
6.3 Understanding Pivot Table
6.3.1 Inserting a Pivot Table
6.3.2 Dragging Fields
6.3.3 Sorting Pivot Tables
6.3.4 Filtering Pivot Tables
6.3.5 Changing Summary Calculation
6.3.6 Creating Two-Dimensional Pivot
6.3.7 Grouping Pivot Table Items

Chapter 7 Using Chart to Represent Data
7.1 Creating a Chart
7.1.1 Selecting a Data Source
7.1.2 Moving and Resizing Charts
7.1.3 Changing the Chart Type
7.1.4 Adding a Title
7.1.5 Switching Row/Column
7.1.6 Positioning Legend
7.1.7 Adding Data Legends