	http://www.expert.com.hk/melbourne

Microsoft Excel 2007 Course

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

Date: Monday 4 October 2010

Cost: $330 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

We also offer on-site training courses at your place anywhere in Australia, email to us for details: melbourne@expert.com.hk