ICT Training

Microsoft Excel 2010/13 – Intermediate

Call for dates and availability

Location: SBS Office – Unit 240 Interchange Business Centre, Howard Way, Newport Pagnell, MK16 9PY

Full day course including refreshments and buffet lunch – 9:30am to 3.30pm

About the course

Learn how to use Excel to its full potential to aid your working life, including how to create formulas and graphs.

Why attend?

To learn how to take advantage of Excel’s more advanced functions.

Training agenda

Setup & Printing Issues

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Header and Footer Fields
  • Scaling Your Worksheet to Fit a Page(s)
  • Printing Titles On Every Page
  • Printing the Row and Column Headings
  • Spell Checking
  • Previewing a Worksheet
  • Viewing Workbooks Side By Side
  • Printing Options

Functions and Formulas

  • Getting Help With Functions
  • Nested Functions
  • Consolidating Data using a 3-D Reference Sum Function
  • Mixed References within Formulas

Paste Special Options

  • Using Paste Special to Add, Subtract, Multiply & Divide
  • Using Paste Special ‘Values’
  • Using Paste Special Transpose Option

Target audience

Anyone who would like to learn how to use Excel to its full potential.

Knowledge required

All levels of Word proficiency are welcome. Course prices and current offers Should you require any further information please talk to us on 0345 222 1551 • option 7. To reserve a space on this course please complete the booking form and email to training@schoolbusinessservices.co.uk

Click here to contact us today!

12 divided by 2 =

Please see our privacy policy