Microsoft Excel course outline by Computer Academy

Search course content

Microsoft Excel course outline by Computer Academy

1.Open Microsoft Excel application

Starting Excel

2. Basic technique

Cells selection
Data entry
To insert a row
To delete a row
Undo
To copy a range of cells
To move a range of cells
Clear cell information

3. Entering a formula

Using formulas
Using operators (+,-,x, ¸,etc...)
Using reference
Tips for entering a formula

For more Excel courses, please click here.

4. Files operation

Saving a worksheet
Save as...
Save
To close a worksheet
Delete a worksheet

5. Printing a file

Page setup
Header and footer
File preview
Turn the grid lines off
Turn the row/column heading off
Auto scaling
Setting manual page breaks
Setting row or column titles
Setting print area

6. Useful functions

SUM( )
AVERAGE( )
MAX( )
MIN( )
IF()
Count()

7. Tips in editing a worksheet

Paste insert row/column
Drag and drop
Autofill
Fill down
Fill right

8. Address notation

Relative address
Absolute address

9. Polishing the spreadsheet

Changing default fonts
Changing font size
Changing column width
Changing row height
Setting border lines
Setting pattern to a range of cell
Turning gridlines on/off
Alignment (vertical and horizontal)
Text orientation
Autoformat

10. Number format

Adding currency sign to the cells

11. Creating a master spreadsheet

Creating a document template
Using a document template

Client Testimonial

“… Their training programmes are well organised, practical and useful in our work. I am particularly impressed by their training materials and their highly professional trainers.”

Mr. Thomas Ng – Head of Graphic Unit
Hong Kong University of Science and Technology

“… It is our pleasure to write this letter for Computer Academy who started to be one of our PC courses provider since early 1996. Due to its satisfying service, we included it as our external PC vendor of Motorola University…we found that the service proviced by Computer Academy was responsive, reasonably priced and up to our standard…“

Ms. Beth Chiu –Human Resources Section Manager
Motorola Asia Pacific Limited

"Very well-constructed courses. The tutor taught patiently."

Ms Chan Kwun Ping

more ...

12. Exchange files with other applications

Changing file format (Louts-123, or old version Excel etc)

13. Styles

Creating styles
Using styles
Editing styles
Merge any styles from other documents

14. Tool bar

Utility tool bar
Promote and demote buttons
Show outline symbols button (utility tool bar)
Select visible cells button (utility tool bar)

15. Data sorting

16. Drawing tool bar

Line, rectangle, oval etc...

17. 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

18. 3D Chart

To construct a 3D chart
Formatting the 3D chart
3D view

top

Duration: 2 evening sessions or 1 day Fee: $1,080
deadline on two weeks before

Continuing Education course

		Diploma Course in Computer Graphic Design


		Diploma course in 3d Modelling and Animation


		Diploma in Multimedia Web Design and Development


	Relating Courses



		Access

		Excel-Advanced

		Filemaker Pro

		Financial Accounting with Excel

		Powerpoint

		Powerpoint-Advanced

		Professional Reports Writing using Microsoft Word

		Word I

		Word-Advanced