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

 

   
 

microsoft excel 2007 level 1 training

Upon completion of our Microsoft Excel 2007 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 2 days.

   

Getting to know Excel
Getting started
The Excel screen
Using the ribbon
Using keytip badges
Minimising the ribbon
Shortcut menus
Understanding dialog boxes
Launching dialog boxes
The quick access toolbar
Customising the quick access toolbar
The office button
Using the office button
The status bar
Customising the status bar
Exiting safely from Excel

Creating a new workbook
Understanding workbooks
Using the blank workbook template
Typing text into a worksheet
The save as dialog box
Saving a new work sheet
Typing numbers into a worksheet
Typing simple formulas in a worksheet
Easy formulas
Making and saving changes
Printing a worksheet
Safely closing a workbook

Working with workbooks
Opening an existing workbook
Moving about a worksheet
Moving about a workbook
Going to a specific location
The open dialog box

Editing in a workbook
Understanding data editing
Overwriting cell contents
Editing longer cell entries
Editing formulas
Editing functions
Clearing a cell
Deleting in a worksheet
Undoing and redoing operations

Selecting ranges
Understanding ranges
Selecting ranges
Selecting non-continuous ranges
Using special selection techniques
Selecting larger ranges
Selecting rows
Selecting columns
Viewing range calculations
Creating an input range

Copying Excel data
Understanding copying in Excel
Using fill for quick copying
Copying from one cell to another
Copying from one cell to a range
Copying from range to another
Copying relative formulas
Copying to a non-continuous range
Copying to and other worksheet
copying to and other workbook
 

Formulas and functions
Understanding formulas
Creating formulas that add
Creating formulas that subtract
Creating formulas that multiply and divide
Understanding functions
Using the sum function to add
Summing non-contiguous ranges
Calculating an average
Finding a maximum value
Finding a minimum value
More complex formulas
What if formulas

Row and column formatting
Approximating column widths
Setting precise column widths
Setting the default column width
Approximating row height
Setting precise row heights
Hiding rows and columns
Unhiding rows and columns

Number formatting
Understanding number formatting
Applying general formatting
Formatting as currency
Formatting percentages
Formatting as fractions
Formatting as dates
Using the thousands separator
Increasing and decreasing decimals

Font formatting
Understanding font formatting
Working with live preview
Changing fonts
changing font size
Growing and shrinking fonts
Making cells bold
Italicising text
Underlining text
Changing font colours
Changing background colours
Using the format painter
Applying strikethrough
Subscripting text
Superscripting text

Printing
Understanding printing
Previewing before you print
Quick printing
Selecting a printer
Printing a range
Printing an entire workbook
Specifying the number of copies
The print dialog box

Creating charts
Understanding the charting process
Choosing the chart type
Creating a new chart
Working with an embedded chart
Resizing the chart
Dragging the chart
Printing an embedded chart
Creating a chart sheet
Changing the chart type
Changing the chart layout
Changing the chart style
Printing a chart sheet
Embedding a chart into a worksheet
Deleting a chart

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