Microsoft Excel Level 3

Short course

In Salford

£ 145 + VAT

Description

  • Type

    Short course

  • Location

    Salford

  • Duration

    1 Day

Advanced features within Excel

Facilities

Location

Start date

Salford (Greater Manchester)
See map
33-35 Winders Way, M6 6BU

Start date

On request

About this course

Confidence in using Excel, and have knowledge to our Intermediate level

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Microsoft Excel Level 3

Course Summary

Summary: Advanced features within Excel.

  • Welcome and brief recap on level 2.
  • Ask any relevant question. Expect an honest answer.
  • Creating and using Excel templates.
  • Commonly used formulae's explained and tested.
  • Let's twist, pivoting your data and charts, why and how.
  • Protecting your carefully crafted data. Stopping the "oops"
  • Getting the right data into the right place - always and automatically.
  • Flagging changing data with colours and borders.
  • Hyperlinking to other programmes, the internet and email.
  • Automating repetitive tasks - with shortcuts, buttons and toolbar icons.
  • Looking up data from lists. Validating. Preventing "dirty data"
  • Let's get creative. Putting it all together at last.
  • Using your workbooks to practise.

Duration: 1 day

Group: Microsoft

Contents

Prerequisites Confidence in using Excel, and have knowledge to our Intermediate level.

Duration 1 day

Course Objectives

Advanced features within Excel.

Course Content

  • Welcome and brief recap on level 2.
  • Ask any relevant question. Expect an honest answer.
  • Creating and using Excel templates.
  • Commonly used formulae's explained and tested.
  • Let's twist, pivoting your data and charts, why and how.
  • Protecting your carefully crafted data. Stopping the "oops"
  • Getting the right data into the right place - always and automatically.
  • Flagging changing data with colours and borders.
  • Hyperlinking to other programmes, the internet and email.
  • Automating repetitive tasks - with shortcuts, buttons and toolbar icons.
  • Looking up data from lists. Validating. Preventing "dirty data"
  • Let's get creative. Putting it all together at last.
  • Using your workbooks to practise.

Notes

Versions 2003, XP, 2000 & 97. If you have any specific questions please bring them along. Please note that this course does not cover Visual Basic skills.

Prerequisites

A good understanding of Excel

Course: Microsoft Excel Level 2

Suggested Next Steps

Course: Microsoft Access Level 1

Scheduled Dates and Fees

Start Dates Fee Notes

Thursday 29 January 2009 £145 (ex VAT)
Thursday 26 February 2009 £145 (ex VAT)
Thursday 26 March 2009 £145 (ex VAT)
Thursday 30 April 2009 £145 (ex VAT)
Thursday 28 May 2009 £145 (ex VAT)
Thursday 25 June 2009 £145 (ex VAT)

Microsoft Excel Level 3

£ 145 + VAT