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

Excel - Linking Sheets & Workbooks

< Back to 1 to 3 hour Microsoft short courses from Insight IT Training

Course Details

Microsoft Excel

Course Duration - 2 hours

Course Objectives

You might want to consider this mini course if:

You find you are entering the same data in more than one place.

You want to change several sheets adding the same information to each - maybe a new row with a certain piece of information on it.

You would like to have a totals sheet that summarises the other sheets. 

You might also work with multiple workbooks and would like to share information between these files.

Our course content will help you achieve these goals.

Course Content

Multiple Worksheets

  • Working in a file with many sheet tabs (move a sheet or copy it)
  • Set up a file with many sheets all with the same layout - without using copy and paste!
  • Make the same change to all the worksheets in the file - all in one go.
  • Create calculations that bring in information from another sheet

Multiple Workbooks

  • Create a formula that brings in information from a different workbook
  • Use Workspace files to quickly open many files that are all stored in different locations

Prerequisites

This course does assume that you have some prior experience of using Excel and creating formulas. 

What's Next

You may find that you already know the functions you can use with your worksheets to make life easier. If not, check out our Excel - Advanced Functions short course.

Another mini course you might want to consider is our Excel - PivotTables & What-If Analysis course. 

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.