Byron Employment

Byron Employment. Over 71,639 Jobs Australia Wide.

Delivery Method

  • Classroom

Microsoft Excel 2007 Level 1 focuses on basic spreadsheet production using Microsoft Excel 2007 and is designed to give the attendee a sound understanding of how spreadsheets are created, formatted, and printed. The course also concentrates on formulas and functions.

It would be beneficial to have an understanding of personal computers and the Windows operating system as the attendee will be required to start applications, work with and copy files, and locate file folders.

The course duration is 1 day.

Delivery Method

One on one training can be arranged.

Group bookings only - all states and territories.

Getting to know Excel

Selecting ranges

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

Number formatting

Creating a new workbook

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

Copying Excel data

Font formatting

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

Working with workbooks

Formulas and functions

Opening an existing workbook
Moving about a worksheet
Moving about a workbook
Going to a specific location
The open dialog box
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

Printing

Editing in a workbook

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

Row and column formatting

Creating charts

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

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (03) 9699 4940
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (03) 9699 4940 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search