MS Excel 2003 for Windows Basic (Cantonese)

 

Chapter: Name: Description:
1 Working with Excel 2003 Interface (5"00') Introducing Menu Bar, Toolbars and the User Interface of Microsoft Excel 2003
2Use of Templates (5"00') Create a workbook using a template
 Save your own template
3 Saving Workbooks (5"00') Save and Save As
4Data Editing (5"00') Show you 3 methods for editing the contents of a cell
5 Moving Cell Contents (5"00') Show you 4 methods for moving the contents from one cell to another
6 Copying Cell Contents (5"00') Show you 4 methods for copying the contents from one cell to another
7Delete Data (5"00') Show you 3 methods for clearing the cell contents
8Working with Rows and Columns (5"00') Insert and Delete Rows and Columns
 Delete a Cell
9Hide and Unhide Columns and Rows (5"00') Show you how to hide and unhide the columns and rows
10Use of Smart Tag (5"00') The usage of Smart Tag while inputting data
11Data Inputting Techniques (5"00') Input data with using autofill
 Use of Fill function
12Custom List (5"00') Use of Standard Custom List
 How to customize your own list and store into Excel
 How to delete the custom list
13Text Formatting (5"00') Changing the format of a cell
 Apply color to cell contents
14Number Format (5"00') Apply Number formats to a cell
15Alignment in a cell (5"00') Apply different alignment in a cell
16Cell Border (5"00') Apply the cell border with different styles and color
17Format Painter (5"00') Use of format painter to apply the formats more quickly
18Auto Format (5"00') Use of Auto Format to apply the pre-defined format in Excel
19Conditional Formatting (5"00') Use of Conditional Formatting
20Setting up pages (5"00') Set up the pages properties, header and footer for the worksheet
21Printing Worksheet (5"00') Use of Print Preview
 Properties of printing a worksheet

 

MS Excel 2003 for Windows Intermediate (Cantonese)

 

Chapter: Name: Description:
1 Using Simple Formula & AutoSum (5"00') The simple formula by using + and -
 The use of Autosum and Autofill
2Using Functions (5"00') Auto Calculation
 Using functions wizard to calculate
3Data Validation (5"00') Adding the input warning alerts to the specific cell range
4Relative Reference (5"00') The use of relative reference
5Absolute Reference (5"00') The use of absolute reference
6Logical Functions (5"00') Using AND, OR, IF functions
7Math and Trig Functions (5"00') Using ROUND, ROUNDUP, ROUNDDOWN functions
8Date and Time Functions (5"00') Inserting Today, Current Time
 Calculating date difference
9Statistical Functions (5"00') Using COUNTIF, RANK, COUNT, COUNTA functions
10Financial Functions (5"00') Using PMT function to calculate fix interest rate payment
11Lookup and Reference (5"00') Using VLOOKUP, HLOOKUP functions
12Data Form (5"00') Using Form function to input data
13Sorting (5"00') Sorting the data in different order
14Filtering (5"00') Using AutoFilter, and its customization
15Auto Outline (5"00') Use of Auto Outline and Group data manually
16Subtotal (5"00') Use of Subtotal function to calculate the group summary
17Using Chart Wizard (5"00') The procedures to draw a chart by using wizard
18Modifying the Chart information (5"00') Modifying the chart type such as Chart title, Axes, Gridlines and Legend
19Modifying the Chart type (5"00') Customize the chart type to bar, line, pie chart, etc
20Modifying the data series (5"00') Using Source Data dialog box
 Changing data source range and series order
21Add data to a chart (5"00') Adding additional data after the chart is drawn

 

MS Excel 2000 for Windows Advanced (English)

 

Chapter: Name: Description:
1 Using Pivot Table (5"00') Using Pivot Table Wizard to create a Pivot Table
 Changing Pivot Table layout
2Modify a Pivot Table (5"00') Modify the display contents by adjusting the control in Pivot Table
3Create a Pivot Chart (5"00') Create a Pivot Chart by using Chart Wizard
4Data Table (5"00') Using Data table in single variable on fixed interest rate payment, and in dual variables situation
5Goal Seek (5"00') Using Goal Seek to resolve practical problem
6Scenario (5"00') Creating Scenario
 Inputting value to establish a mock situation
 Using Scenario Manager
 Showing Scenario summary
7Consolidation (5"00') Consolidating data by reference cell
 Consolidation data by label
 Keep data update by linking to sources data
8Password protection And Read-only (5"00') Using password to open, removing password
9Protect Workbook (5"00') Protecting workbook structure and workbook window
 Removing workbook protection
10Protect Sheet (5"00') Protecting worksheet and removing worksheet protection
11Specify cell that can be changed after protection (5"00') Protecting certain cells in worksheet
12Allow User to Edit Ranges (5"00') Assigning protection to certain cell range at user level protection
13Hide Formulas (5"00') Hiding formulas by worksheet protection
14Record a Macro (5"00') Recording Macro in Excel 2003
 Assigning hotkeys for Macro
15Run a Macro (5"00') Running a Macro by Macro dialog box
 Running a Macro by hotkey
16Relative and Absolute Record (5"00') Recording a Macro by relative reference
 Recording a Macro by absolute reference
17Assign Macro (5"00') Assigning Macro to a button at toolbar
18Save as HTML (5"00') Saving workbook as a HTML file
 Adding interactivity for your workbook HTML
 Publishing the whole workbook
19Open HTML File (5"00') Opening a workbook HTML file at default browser
 Sorting at HTML
 Switching between worksheet
20Send the file through email (5"00') Sending worksheet as email attachment
21Hyperlink (5"00') Adding hyperlink to internet web page
 Adding hyperlink to send e-mail
22Getting Data from a Web Page (5"00') Getting data from a web page by Web Query
 Refreshing Data from web page