Microsoft Office 365 Training Courses

As the commercial arm of Colchester Institute, CI Business Solutions offers a range of Microsoft Office 365 Training Courses for groups of staff who require training. These courses can be adapted to suit your business needs and requirements, and can be delivered off-site on an in-company basis.

We are able to offer bespoke training to suit your needs. If you can’t see what your looking for on this page please contact us using the enquiry form below and we will work with you to put together a package of training.

Advanced Microsoft Word

Microsoft Office – Microsoft Word

The Advanced Microsoft Word aims to provide delegates with skills in integrating text and graphics, producing complex documents with the use of advanced layout and structural and presentation tools, and creating on-line forms.

Who Is The Course Aimed At?

Delegates with a good all-round knowledge of Word who are interested in gaining particular expertise in desktop publishing and handling long documents in Word.

Course Content

  • Newspaper-style Columns
  • Styles
  • Table of Contents Generation
  • Automatic Indexing
  • Footnotes
  • Inserting & Handling Graphics, including Cropping
  • Using the Drawing Tools, including Text Boxes & Callouts
  • WordArt
  • Linked Text boxes or Autoshapes with Running Story
  • Creating On-Line Forms with Form Fields, Drop Down
  • Lists and Check Boxes

Entry Requirements

Delegates should have a sound knowledge of Word, with mouse use, preferably having previously attended the Intermediate course.

Save time using Excel

Overview

Many people waste time not understanding the functions of Excel, this course will provide an understanding and the knowledge required to get the best from EXCEL!!!!

This training will give you a good understanding of the functions of Microsoft Excel, and can be delivered either on a 1:1 or group basis.

This course is aimed at any level of personnel within any business who already have a basic understanding of Microsoft Excel and wish to develop their skills further.  By the end of this course, delegates will be able to;

  • Demonstrate the main functions of Microsoft Excel
  • Successfully implement the use of Excel into their Job Role


Course Content

The course can be tailored to meet your specific requirements and deal with any issues you may wish to address. To give you an idea of the course content, we could cover the following areas for you.

  • Working with Large Worksheets
  • Navigating Worksheets & Workbooks
  • Viewing Options
  • Page Break Preview
  • Hiding & displaying data
  • Printing large Worksheets
  • Freeze and Split Panes
  • Multiple Worksheets/Workbooks
  • Inserting sheets
  • Renaming sheets
  • Copying sheets
  • 3D formulas to link sheets
  • Consolidating data
  • Linking Workbooks
  • Recap Formulas
  • Relative & absolute referencing
  • Averages, minimum & maximum
  • Paste functions
  • Conditional Formulas
  • Formatting the Worksheet
  • Adding Borders & Shading
  • AutoFormats
  • Copying Formats
  • Text Formatting
  • Working with dates
  • Using Special Number Formats
  • Indented lists
  • Merge & Centering

 

Outcomes

You will receive individual feedback and will be asked to complete a personal action plan to identify key changes to implement and skills to practice.

Advanced Microsoft Word
LocationColchester
Duration1 Day Workshop
CampusColchester Campus
Start DateWe can adapt this course to suit your requirements
PricePrices on application
Save time using Excel
LocationColchester
Braintree
Duration1 Day Workshop
CampusColchester Campus
Braintree Campus
Start DateWe can adapt this course to suit your requirements
Price£190

Disclaimer

All Fees and prices shown on the website are for courses starting in the 2019-20 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 2019-20 academic year will be added to the website from June 2020.

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 Courses)