microsoft excel 2007 level 2 training

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

To obtain them most benefit from this course it is suggested that you have completed Microsoft Excel level 1 or have equivalent experience.

The course duration is 1 day.

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

Finding and replacing
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

Formula referencing
Absolute verses relative referencing
Relative formulas
Problems with relative formulas
Creating absolute references
Creating mixed references

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

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

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

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

Sorting data
Understanding lists
Performing an alphabetical sort
Performing a numerical sort
Sorting on more than one column
Sorting numbered lists
Sorting by rows

Filtering data
Understanding filtering
Applying and using a filter
Clearing a filter
Creating compound filters
Creating custom filters
Multiple value filters
Using wildcards

Page setup
Using built in margins
Setting custom margins
Changing margins by dragging
Centring on a page
Changing page orientation
Specifying the paper size
Setting the print area
Clearing the 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

Headers and footers
Understanding headers and footers
Adding a quick header
Adding a quick 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

pdf version