|
1. Naming Cells and Ranges
- Creating a Name
- Making a name list
- using the name for calculation
2. Database
- The database components
- Data Form
- Inputing Date
- Deleting Date
- Finding Records
- Using menu commands to find records
- Combining search criteria
- Extracting records
3. Data sorting
4. Datebase Functions
5. Creating and Using an Array Formula
6. Managing Documents with Workbooks
7. Consolidation with several Worksheets
8. Data Table
- One-Input Table
- Two-Input Table
9. Lookup Table
- Lookup()
- Vlookup()
- Hlookup()
10. Document protection
- File protection
- Protect cells/document
- Unprotected document
11. File Linking
12. Publisher and Subscriber options(Macintosh Only)
- Create a publisher
- Subscriber a publisher
13. Filter and Advanced Filter
14. Pivot Table
- Steps to create a simple pivot table
- Creating pivot table from Excel
- Consolidating Data from Multiple Ranges into a Pivot Table
15. Conditional Format
- Define single and multiple criterial
- Delete criterial
16. Data Validation
- Define the data type
- Define the warning message
- Define the error message
17. Sharing and tracking worksheets
- Turning on and let the other users can edit the worksheet.
- Cancel changes made by the others.
18. Drawing Tool Bar
- Line, Rectangle, oval etc...
19. Creating a Chart
- Polishing your chart
- Changing the text format and the pattern color in a chart
- Attach Text
- Adding Legend
- Adding Gridlines
- Adding Arrow
- Adding Unattached Text
- Adding Data Series to the Chart
- Creating an Overlay Chart
- Changing chart type
20. 3D Chart
- To construct a 3D chart
- Formatting the 3D chart
- 3D View
|
