Logo Block
logo
MegaMenu Block
Breadcrumb Block

Intermediate Excel

Content Body Block

Intermediate Excel

    Book courses

Course Overview

This course will expand your Excel knowledge and skills.  This course is aimed at those that have an understanding of the basics of Microsoft Excel such as creating workbook, using AutoFill and AutoSum, constructing formulae, Absolute Cell References and formatting worksheets.

Suitable For: Any member of staff within the school or an academy .

Date & Venue: View course dates and venues 

Time: Full day 9.30-15.30 with a break for lunch (lunch not included) but refreshments will be provided.

Cost: If you have a Finance package 150 credits per delegate or if no Finance Package purchased please refer to Schools Finance Packages 2018

What you will need to bring

  • Memory stick
  • Lunch

Course Objectives

By the end of the course you will be able to:

  • Create Charts
  • Manipulate and Control Worksheets
  • Link Data from one Worksheet to Another
  • Apply Different Pasting Techniques
  • Apply Conditional Formatting
  • Validate Data Entry
  • Sort/Filter Data

Course Details

Formulas and Functions

How to use formulas such as: if, and, or, Vlookup, sumif, count, countif.  Use of the Function wizard to construct your formulas.

Worksheet Techniques

How to rename, insert, delete, move, copy and hide worksheets.

Data Linking

How to link data contained within another workbook to your current workbook.

Creating Charts

How to create charts based on the data contained within your workbook (e.g. pie charts, bar charts, line graphs etc.)

Special Pasting

How to apply special pasting techniques (e.g. paste values, paste formats, paste formulas, transposing ranges etc.)

Conditional Formatting

How to apply specific formats to cells based on the entry within them.

Hyperlinks

How to insert a hyperlink into a worksheet.

Sorting Data

How to sort data using multiple criteria.

Filtering Data

How to filter data based on custom criteria.

Contact: Email schoolfinance@buckscc.gov.uk  Telephone 01296 382222 option 3

Foot Block
Parameters{showAZBar = True; aZListingPageNodeId = 25375; aZSiteRootNodeId = 24024}
A-Z Services