Home Page
 
  home > training > microsoft office > microsoft excel level 1  
   
 
 
   

 

   
 

microsoft excel level 1 training

Upon completion of our Microsoft Excel 2003 level 1 training you will be able to create spreadsheets for  real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs, and managing lists.

This course assumes no prior knowledge of Microsoft Excel. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files, and locate file folders.

The course duration is 1 day.

   

Spreadsheets
How spreadsheets work
Spreadsheets characteristics
Spreadsheet functionality
The appropriateness of spreadsheets

Excel 2003 orientation
Starting microsoft Excel 2003
The Excel 2003 screen
Understanding the workbook
Moving the cell pointer
Moving about the workbook
Using go to
Menus and toolbars
Using menus and toolbars
Using context sensitive menus
Exiting Excel

A simple workbook
Creating a new workbook
Entering data in a workbook
Saving a new workbook
Opening a saved workbook
Creating an input range
Saving your work
Essential formatting
Column best fit
Closing a workbook

Selecting ranges
Selecting contiguous ranges
Selecting non-contiguous ranges
Using special selection techniques
Selecting larger ranges
Range calculations

Formulas
Understanding formulas
Formulas that add
The sum function
Formulas that subtract
Formulas that multiply and divide
Referential formulas
What if formulas
More complex formulas
Formula error checking
Common error messages
Copying and filling
Understanding copying in Excel
Using fill for quick copying
Copying from one cell to another
Copying from one cell to multiple cells
Copying from many cells to many cells
Copying relative formulas
Copying to a non-contiguous range

Working with functions Functions
Typing a sum function
Summing non-contiguous ranges
Calculating an average
The maximum function
The minimum function

Printing
Print preview
Simple printing
Previewing large worksheets
Page orientation
Scaling to fit
Printing to multiple pages
Creating page headers and footers
Formatting headers and footers
Printing formulas

Charting
Using the chart wizard
Choosing the chart type
Changing the chart type
Modifying a chart
Printing a chart
Creating a pie chart
Creating a bar chart
Moving a chart
Deleting a chart

Getting help
Printed help sources
The help task pane
Searching for general help
Searching for specific help
Understanding a help window
Disabling online content
Enabling online content
Displaying and using the office assistant
Customising the office assistant
Disabling the office assistant

pdf version
 

For further information call us on +61 3 8611 9800 or request information here. To request a booking on a course, click here.
 
   
privacy | webmaster | about us | partners | exam centre | contact us | sitemap