We offer training on both Windows and Mac computers locally around Cambridge but also any location in the UK and abroad if required:

  • Microsoft Office: Word, Excel, Outlook, PowerPoint, OneDrive, Visio, Teams
  • Microsoft Project
  • Microsoft SharePoint
  • Adobe Creative Suite: Photoshop, InDesign, Illustrator, Acrobat
  • Power BI
  • And many others…just call us on 01223 841848 or email us

Excel Intermediate

Location Great Shelford, Cambridge
Price ex. VAT £210.00
Start Date 08 July 2020
Course type Standard
Course code FROG228
Duration 1 Day

Description

The aim of this course is to have the participant `up and running' immediately following a one day intermediate programme based upon their existing skills and future needs.  At the end of the course the participant should be able to create a good selection of spreadsheets and graphs.

Target Audience

Designed for existing users.

Prerequisites

Attendance of the Introduction course or equivalent knowledge.

Outline

Refresher of the Basics

  • Tips for Creating Spreadsheets
  • Basic Formulae/Functions/Absolute References

Names

  • Creating and Naming Cells

Tips for Working with Large Spreadsheets

  • Freezing Screen Titles
  • Splitting Windows
  • Displaying Multiple Sheets/Files on Screen

Worksheet and File Linking

  • Creating Simple Links  

Page Setup Options

  • Margins
  • Headers and Footers
  • Printing Titles
  • Sheet Options
  • Scaling
  • Page Break Preview
  • Setting Print Areas
  • Sheet Background

List Data

  • Sorting a List
  • Filters

Charts and Shapes

  • Creating, Formatting and Editing Basic Charts
  • Sparklines 

Course Search

Contact Us
Contact Us