Home	Dreamweaver	ASP.NET	XML	C#	Fireworks	ASP	Adv JavaScript
Contact	ColdFusion	VB.NET	Perl	JScript	VBScript	SQL	Adv Java
How it works	ActionScript	Intro Java	JSP	Flash	HTML	PHP	eMarketing

10-week online MS Excel

You will learn :

Spreadsheet Characteristics and how it works
Spreadsheet Functionality
Workbook
Using Go To, Menus and Toolbars
Using Context Sensitive Menus
Insert a Column
Entering data and saving data in a workbook
Entering Text and Numbers
Entering Numbers as Labels or Values
Standard and Formatting toolbars
Insert Comments
Worksheets, Formula Bar and Status Bar
Down Arrow Key, Up Arrow Key, Tab Key, Shift+Tab Keys, Right and Left Arrow Keys, Page Up and Page Down and End Key
Moving Quickly Around the Worksheet
Scroll Lock moves the window, but not the cell pointer.
Name Box
Creating An Input Range
Choosing a Default Font
Formatting
Column Best Fit
Adjusting the Standard Column Width
Wrapping Text
Deleting a Cell Entry
Smart Tags
Using special selection techniques
Range Calculations
Formulas
Use formulas to add
Numbers and Mathematical Calculations
Reference Operators
Functions
Using a function
Entering a Function by Using the Menu
Calculate a sum by using the Sum icon.
The sum function and use formulas to subtract
Use formulas to Multiply And Divide
Calculating an Average
Use Min function
Using Max
Using Count
Referential Formulas
More Complex Formulas
Copying In Excel
Using Fill
Fill the days of the week
Filling time
Fill numbers
Fill feature
Change the format of the time
Copying from one cell to multiple cells
Copying relative formulas
Print Preview
The chart wizard
Choosing the chart type
Create a Column Chart
Create a Pie Chart
Changing the Size and Position of a Chart

Cost: $US155 (US dollars) including course notes and lots of examples and exercises. You will have your own instructor whom you can ask as many questions as possible by email. You have the option of completing the course between 4 to 10 weeks.

Next online course (Ecourse) starting date:

Our next online course starting date is Monday 19 November 2012

Enquires or Enrolment:

Email: courses@expert.com.hk
or
Phone: + 61 3 9700 6260 (9am-5pm Australian Eastern time Monday to Friday)