品牌乐学无忧网 | 有效期至长期有效 | 最后更新2014-09-25 14:53 |
Excel 2003
总学时:
Lesson 1: Creating and Applying Templates
Create a Workbook from a Template
Create a Custom Template
Working with Co妹妹ents
Create a Hyperlink
Lesson 2: Creating and Modifying Charts
Create a Chart
Format Chart Items
Change the Chart Type
Lesson 3: Working with Graphic Objects
Insert Graphics
Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Create and Apply a Name for a Range of Cells
Calculate Across Worksheets
Calculate with Date and Time Functions
Calculate with Text Functions
Calculate with Statistical Functions
Calculate with Math and Trigonometry Functions
Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Add Subtotals to a Worksheet
Lesson 6: Streamlining Workflow
Create a Macro
Edit a Macro
Cust机构omize Access to Excel Co妹妹ands
Apply Conditional Formatting
Add Data Validation Criteria Update a Workbook's Properties
Modify Excel's Default Settings
Lesson 7: Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Adjust Macro Settings
Administer Digital Signatures
Lesson 8: Auditing Worksheets
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Locate Invalid Data and Formulas
Watch and evaluate Formulas
Group and Outline Data
Lesson 9: Analyzing Data
Create a Trendline
Create Scenarios
Perform What-If Analysis
Develop a PivotTable© Report
Develop a PivotChart© Report
Perform Statistical Analysis with the Analysis ToolPak
Lesson 10: Working with Multiple Workbooks
Create a Workspace
Consolidate Data
link Cells in Different Workbooks
Edit links
Lesson 11: importing and Exporting Data
Export to Microsoft Word
import a Word Table
import Text Files
Lesson 1: Creating and Applying Templates
Create a Workbook from a Template
Create a Custom Template
Working with Co妹妹ents
Create a Hyperlink
Lesson 2: Creating and Modifying Charts
Create a Chart
Format Chart Items
Change the Chart Type
Lesson 3: Working with Graphic Objects
Insert Graphics
Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects
Lesson 4: Calculating with Advanced Formulas
Create and Apply a Name for a Range of Cells
Calculate Across Worksheets
Calculate with Date and Time Functions
Calculate with Text Functions
Calculate with Statistical Functions
Calculate with Math and Trigonometry Functions
Calculate with Logical Functions
Lesson 5: Sorting and Filtering Data
Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Add Subtotals to a Worksheet
Lesson 6: Streamlining Workflow
Create a Macro
Edit a Macro
Cust机构omize Access to Excel Co妹妹ands
Apply Conditional Formatting
Add Data Validation Criteria Update a Workbook's Properties
Modify Excel's Default Settings
Lesson 7: Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Adjust Macro Settings
Administer Digital Signatures
Lesson 8: Auditing Worksheets
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Locate Invalid Data and Formulas
Watch and evaluate Formulas
Group and Outline Data
Lesson 9: Analyzing Data
Create a Trendline
Create Scenarios
Perform What-If Analysis
Develop a PivotTable© Report
Develop a PivotChart© Report
Perform Statistical Analysis with the Analysis ToolPak
Lesson 10: Working with Multiple Workbooks
Create a Workspace
Consolidate Data
link Cells in Different Workbooks
Edit links
Lesson 11: importing and Exporting Data
Export to Microsoft Word
import a Word Table
import Text Files