Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips

Testimonials

Huxley Bertram

"Very good, Alan made it fun and interesting. I now want to apply some of what he showed us today. It should be extremely useful".

Fontus Health Limited

"An enjoyable day and Simon was very professional and approachable."

Middlesbrough Council

"Excellent. Learnt lots of new knowledge on Excel."

Motorplus

"Good fun easy to learn and great trainer very friendly and approachable"

Microsoft Excel 2007 Training Course Beginners

Learn how to manage, edit and print data using Microsoft Excel with this comprehensive 1 day training course. You will learn how to perform various calculations, and successfully enter information in a work sheet, and develop a workbook. As you work through the exercises you will become familiar with the Excel environment and will see just what a useful tool it is.

Other Excel training courses

Course Duration: 1 Day

Course Prerequisites:

As this is a beginners course you just need to know the basis of operating a computer. File management, and turning the thing off and on.

Course Outline

Exploring the Microsoft Excel 2007 Environment

  • Explore the User Interface
  • Explore the Ribbon
  • Obtain Help
  • Customize the Quick Access Toolbar

Working with an Excel 2007 Worksheet

  • Navigate in Excel
  • Select and Enter Data
  • Save a Workbook

Modifying a Worksheet in Excel 2007

  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Performing Calculations ion Excel 2007

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions
  • Create a Mixed Reference

Formatting a Worksheet with Excel 2007

  • Convert Text to Columns
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Merge Cells
  • Apply Number Formats
  • Align Cell Contents
  • Find and Replace Formats
  • Apply AutoFormat
  • Apply Cell Styles
  • Apply Themes

Developing a Workbook using Excel 2007

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • Copy and Paste Worksheets

Printing Workbook Contents using Excel 2007

  • Set Print Titles
  • Create a Header and a Footer
  • Set Page Margins
  • Change Page Orientation
  • Set Page Breaks
  • Print a Range

Customizing Layout in Excel 2007

  • Split a Worksheet
  • Arrange Windows
  • Freeze and Unfreeze Rows and Columns
  • Hide and Unhide Worksheets

Beginners Excel Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

I would like to receive training special offer emails
I would like to be notified about free software hints and tips





Microsoft Excel 2007 Training Course Beginners