Intermediate Microsoft Excel

This course looks at some of the formulas and functions that can be used in Excel, including ones that allow you to link Spreadsheets.

Who Is The Course Aimed At?

This workshop is aimed at those who have been using Excel for a while and now want to take their skills to the next level.

Course Objectives/Key Benefits

Intermediate Excel Course Objectives

  • Being able to use AutoSum to produce calculations
  • Using addition, subtraction, multiply and divide
  • Being able to format a spreadsheet to improve it’s appearance
  • Preparing a Spreadsheet for printing
  • Being able to save and share a workbook
  • Being able to show data in a Chart format

Training method:

Hands on training in a friendly and relaxed atmosphere

Course outcome/qualification:

Certificate of Attendance.

Course Content
  • Being able to use $ and brackets in formulas effectively
  • Linking Worksheets and Workbooks
  • Use the Watch Window to make using more than 1 sheet at a time easier
  • Being able to use Names in Formula
  • Protecting Worksheets
  • Using dates within Formalas
  • Being able to use all features of the Fill Handle
Entry Requirements

Ability to create basic formulas i.e. +, – etc and functions i.e. Sum, Average

Intermediate Microsoft Excel
LocationColchester
Braintree
Duration1 Day Workshop
CampusColchester Institute
The College at Braintree
Start DateVarious dates throughout the year. Next Start Date: 20/07/2018
Price£120 + VAT

Disclaimer

All Fees and prices shown on the website are for courses starting in the 2017-18 academic year and correct at the time of entering/printing information, however these may be subject to change. The College cannot accept legal or financial liability as a result of any such changes. Fees for courses starting in the 2018-19 academic year will be added to the website from June 2018.

The course information describes programmes offered by Colchester Institute. The College takes all reasonable steps to provide courses as described, but cannot guarantee provision. The information is for guidance and does not form any part of a contract.

The College reserves the right to update and amend information as and when necessary. Colchester Institute will do its best to provide the courses shown, but may have to modify or withdraw a course depending on customer demand and other factors.

(Leisure Course)