Byron Employment

Byron Employment. Over 71,639 Jobs Australia Wide.

Delivery Method

  • Classroom

Microsoft Excel 2007 Level 2 focuses on real world spreadsheet production using Microsoft Excel 2007 and is designed to give the attendee a sound understanding of formulas, lookup functions, sorting, filtering, and formatting.

It would be beneficial to have completed Excel 2007 Level 1 or have equivalent experience.

The course duration is 1 day.

Delivery Method

One on one training can be arranged.

Group bookings only - all states and territories.

Working with a worksheet

Filling data

Understanding worksheets
Changing worksheet view
Worksheet zooming
Viewing the formula bar
Viewing the gridlines
Viewing the ruler
Inserting cells
Deleting cells
Inserting columns
Inserting rows
Deleting rows and columns
Switching between worksheets
Filling a series
Filling a growth series
Filling a series backwards
Filling using options
Creating a custom fill list
Modifying a custom fill list
Deleting a custom fill list

Sorting data

Cell alignment

Understanding lists
Performing an alphabetical sort
Performing a numerical sort
Sorting on more than one column
Sorting numbered lists
Sorting by rows
Understanding cell alignment
Aligning right
Aligning to the centre
Aligning left
Aligning top
Aligning bottom
Aligning to the middle
Rotating text
Indenting cells
Wrapping and merging text
Merging and centring
Merging cells
Unmerging cells

Logical functions

Filtering data

Understanding logical functions
Using IF to display text
Using IF to calculate values
Nesting IF functions
Using IFERROR
Using TRUE and FALSE
Using AND
Using OR
Using NOT
Examples of logical functions
Finding the right logical function
Understanding filtering
Applying and using a filter
Clearing a filter
Creating compound filters
Creating custom filters
Multiple value filters
Using wildcards

Finding and replacing

Lookup functions

Understanding find and replace operations
Finding text
Finding cell references in formulas
Replacing values
Using replace to change formulas
Replacing within a range
Finding formats
Finding constants using go to special
Finding formulas using go to special
Finding the current region
Finding the last cell
The go to special dialog box
Understanding data lookup functions
Using CHOOSE
Using VLOOKUP
Using VLOOKUP for exact matches
Using HLOOKUP
Using MATCH
Using INDEX
Understanding referencing functions
Using ADDRESS
Using AREAS
Using COLUMN and COLUMNS
Using ROW and ROWS
Using OFFSET
Examples of lookup functions
Finding the right lookup function

Page setup

Formula referencing

Using built in margins
Setting custom margins
Changing margins by dragging
Centring on a page
Changing page orientation
Specifying the paper size
Setting and clearing print area
Inserting page breaks
Using page break preview
Removing page breaks
Setting a background
Clearing the background
Setting rows as repeating print titles
Printing gridlines
Printing headings
Scaling to a percentage
Fit to a specific number of pages
Strategies for printing larger spreadsheets
Absolute verses relative referencing
Relative formulas
Problems with relative formulas
Creating absolute references
Creating mixed references

Formula techniques

Headers and footers

Scoping formulas
Creating nested functions
Editing nested functions
Copying nested functions
Using concatenation
Switching to manual recalculation
Forcing recalculation
Pasting values from formulas
Pasting formulas as pictures
Understanding headers and footers
Adding a quick header and footer
Switching between headers and footers
Typing text into headers and footers
Modifying headers and footers
Adding page numbering
Adding date information
Adding workbook information
Adding a picture
Formatting headers and footers
Dragging margins for headers and footers
Creating a different first page
Different odd and even pages

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