Welcome to Insight

Delivering private IT training for businesses,
public sector and voluntary organisations

We deliver our training
Onsite & Offsite

We Provide
A Wide Range
of Business Skills courses

We Can Help You
Build Your Own
Tailored Courses

The Training You Want
When & Where
You Want It

Keep an Eye on
Our Special Offers
Updated Regularly

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Microsoft Excel Intermediate

< Back to Microsoft and Office Courses | Insight IT Training

Course Details

Excel

Course Duration - One Day

Benefits of Microsoft Excel Intermediate Course

This Intermediate course has been designed to improve the user’s knowledge of Microsoft Excel and develop the basic spreadsheet skills that trainees have already acquired. This course will benefit anyone wishing to develop their basic Excel knowledge. You will learn how to use Charts/Graphs, how to control the screen and use Excel internet features. So if you would like to be more proficient in using Excel, then check out our Intermediate course content for the full picture.

Our course is a one day, 100% hands-on led by highly skilled Microsoft Excel trainers who have a wealth of knowledge in the Microsoft product set. We give you practical exercises to practice the new skills as you learn them.

To get the best of out the Intermediate course, trainees should have attended the Introduction to Microsoft Excel course or have a basic knowledge of Microsoft Excel.

If you are interested in discussing bespoke training from Insight IT, please contact us to discuss this option further and we’ll get back to you with a recommended course outline customised to your needs.

Basic and Advanced courses are also available.

Course Content

Excel Functions

  • Using the SUM, MAX, MIN, COUNT and AVERAGE functions
  • Understanding Absolute and Relative cell references

Excel Charts/Graphs

  • Creating a Chart
  • Formatting a Chart

Controlling the Screen

  • Freezing column and row titles
  • Using the Zoom feature
  • Using the Split Screen feature

Screenshot

  • Use the Screenshot and Screen Clipping features (2010+)

Use Excel Internet Features

  • Viewing a worksheet in a browser
  • Creating a hyperlink to a web site or other document

Naming Ranges in a Worksheet

  • Naming Ranges
  • Move to a Named Range
  • Use Named Ranges in formulae
  • Print a Named Range

Excel Databases

  • Use an Excel list as a Database
  • Setting up a new Database
  • Sorting records in a Database
  • Filtering records in a Database

Prerequisites

Trainees should have attended the Introduction to Excel course or have a basic knowledge of Microsoft Excel.

Contact Us

Interested in our service? Then get in touch today with Insight IT to see how we can tailor your training to suit your needs.

Call us on: 08452 306 099 or contact us online here.