MS Excel 2000 for Windows Introduction (Cantonese)

 

Chapter: Name: Description:
1 Starting Excel 2000 (4"00')  Starting Excel
 Opening a File
 Closing a File
 Exiting Excel
 Saving a Workbook in Excel
2 Excel 2000 Environment (I) (3"00')  Some terms in Excel you need to know
 Moving around in the workbook
3 Excel 2000 Environment (II) (2"45')  Using GoTo function
 Customizing Excel menu
4 Entering and Editing Data (I) (3"05')  Using AutoFill
 Entering a Custom Data Series
5 Entering and Editing Data (II) (3"20')  AutoComplete
 Editing in a cell
 Undoing an action
6 Entering and Editing Data (III) (3"30')  Moving and copying
 Finding and replacing data
7 Formatting (I) (4"00')  Using the Format Cells dialog box
 Formatting Numbers
 Formatting Text
8 Formatting (II) (4"30')  Using the Style buttons
 Alignment in a Cell
 Formatting Text
 Indented text in cells
9 Formatting (III) (4"50')  Merging and centering over a range
 Text rotation
 Other alignment options
 Changing column width and row height
10 Borders and Shading (I) (3"50')  Adding borders to cells
 Shading cells
11 Borders and Shading (II) (1"45')  Using AutoFormat
 Copying formats using format painter
12 Borders and Shading (III) (2"30')  Conditional formatting
13 Formula (I) (3"20')  What is a Formula  What does it look like 
 Entering formula
14 Formula (II) (1"55')  Natural Language Formula
 Editing formulae
 Using Range Finder
15 Formula (III) (3"00')  What are Functions 
 Using AutoSum
 Using Functions
16 Formula (IV) (3"20')  Data Validation
17 Creating Charts (I) (5"50')  Charting terms
 Creating a Chart
18 Creating Charts (II) (4"50')  Customizing your chart using the chart toolbar
 Printing Charts
19 Printing (I) (2"50')  Setting the area to be printed
 Creating the Print Area
 Print Preview
 Page Break Preview
20 Printing (II) (4"30')  Changing the Page Setup
 Adding Headers and Footers
 Printing with other options
 Printing a Page or Selection

 

MS Excel 2000 for Windows Advanced (Cantonese)

 

Chapter: Name: Description:
1 Putting Excel data on a web page (5"30')  Publishing or saving your data as a Web page
 Deciding whether to make the data interactive or non interactive
 Put Microsoft Excel data that will be non-interactive on a Web page
 Add interactivity to Excel data when publishing a Web page
2 Create a Hyperlink (I) (4"20')  Link to a File
3 Create a Hyperlink (II) (3"30')  Link to a Web Page
 Link to a Specific Location
4 Custom hyperlinks (4"20')  Change the text or graphic for a hyperlink
 Deactivate a hyperlink
 Remove a hyperlink and the text or graphic that represents it
5 Create a Pivot Table (I) (4"30')  Create a Pivot Table report to analyze data
 Change the source data of a Pivot Table Report
6 Create a Pivot Table (II) (6"20')  Change the layout of a Pivot Table Report
 Refresh a Pivot Table Report
7 Create a PivotChart Report (4"30')  Create an independent Pivot Chart
 Create a PivotChart with an associated PivotTable
8 Print a PivotTable Report (7"00')  Print a PivotTable with row and column labels repeated on each page
 Print a PivotTable with outer row field items repeated on each page
 Print the sections of a PivotTable on separate pages
9 Chart Customization (I) (4"30')  Editing chart data
 Changing the default chart format
10 Chart Customization (II) (6"30')  Adding data series or data points to a chart sheet
 Adding data series or data points to an embedded chart
 Changing the worksheet range plotted in a chart
 Deleting data series
11 Goal Seek (3"30')  Using Goal seek command
12 Data Tables (6"00')  One Variable Data Table
 Two Variable Data Table
13 Scenario Manager (I) (4"10')  Defining scenarios
 Display a scenario
14 Scenario Manager (II) (6"20')  Editing a scenario
 Deleting a scenario
 Merging scenario
 Creating a scenario summary report
15 Solver (5"30')  Define and solve a problem using solver
 Add a constraint in Solver
 Change a constraint in Solver
 Delete a constraint in Solver
 Reset the Solver options
16 Data Consolidation (8"10')  Consolidate data by position
 Consolidate data by category
 Update a reference to a source area
17 Data Sharing (3"30')  Link an entire existing file
 Embed selected information from an existing file
18 Macros (7"30')  Recording Marco
 Running Marco
 Assigning a macro to toolbar button
 Changing a toolbar button macro assignment
 Change button image
 Deleting a macro
19 Name Range (6"55')  Assign name for the cell
 Erase name for the cell
 Use name define cell range and establish formula
20 Lookup Function (2"26')  Using HLookup function
 Using VLookup function
21 Trace Changes (5"22')  Audit errors
 Trace Precedents
 Trace Dependents
22 Comment Workbook (6"40')  Insert comment in workbook
 Edit comment in workbook
 Remove comment in workbook
23 Edit others' Workbook (3"56')  Insert changes in workbook
 Accept changes in workbook
 Reject others  changes in workbook
24 Protect Workbook with Password (4"49')  Setup password for the whole workbook
 Remove password for the whole workbook
25 Worksheet Protect (5"58')  Protect worksheet
 Protect workbook
26 dBASE and DCOUNT Function (3"39')  dBASE function
 DCOUNT function