Display & Accessibility Options

Skip to navigation

Skip to main content

Contact Us

Accessibility Statement

Text Only Version

Site map

A- A A+
You are here: Home > IT Training > Excel 2007 Intermediate

Excel 2007 Intermediate

Microsoft Office 2007

Next available Norwich date:  22 February 2012
Book Now

Course Aims:

This one-day training course aims to give basic users of Excel knowledge of commands and functions which will make them more proficient in spreadsheet design and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered.

Assumed Knowledge: 

A working knowledge of Excel gained from prior attendance on a Jarrold Training Microsoft Excel Introduction course or from a user environment.

Version:

Microsoft Office 2010.

Excel 2003 Intermediate course profile

Excel 2010 Intermediate course profile

What people say:

  

I thought the course was excellent! I have learn't so much useful information to take away.

I can't praise the course enough it met my expectations & more.

Victory Housing - March 2011

Special Offer

Book one person onto any two levels of Excel training and receive £30 off the total price.

Profile Outline:

 

Revision

  • New Features and Product overview
  • File Formats and Working in Compatibility mode
  • Quick Access Toolbar and Excel Options
  • Revision Exercise

Functions

  • Date function
  • Time function
  • Round function
  • IF function
  • Integer function

Cell Addressing

  • Absolute cell addresses
  • Relative cell addresses

Conditional Formatting

  • Applying conditional formats to text
  • Applying conditional formats to numerical values
  • Clearing rules

Database Features

  • Using a spreadsheet as a database
  • Sorting data
  • Basic subtotals
  • Filtering data with Filter
  • Custom Filter
  • Define a range as a table
  • Find Feature

Working with Multiple Sheets

  • Selecting sheets
  • Inserting & deleting sheets
  • Copying sheets
  • Copy and paste between sheets
  • Naming sheets
  • 3D calculations
  • Group edit facility
  • Using Hyperlinks to link worksheets

Working with Multiple Workbooks

  • Opening multiple workbooks
  • Arranging windows
  • Linking workbooks
  • Hyperlinks to worksheets and workbooks

Additional Features

  • Inserting comments

Charting

  • Revision of basic charts
  • Chart types
  • Sizing and moving a chart
  • Editing a chart
  • Changing chart data
  • Formatting chart elements
  • Drawing features
  • Printing a chart

 

 

 

DO NOT DELETE THIS TEXT
Profile Details:
Norwich Dates:
  • 22 February 2012
    Book Now
  • 13 March 2012
    Book Now
  • 04 April 2012
    Book Now
Training Options
People who attended this course, also booked:
Information & print: