Microsoft Excel

Short course

In London

£ 185 + VAT

Description

  • Type

    Short course

  • Location

    London

  • Duration

    1 Day

Facilities

Location

Start date

London
See map
23 Bloomsbury Square, WC1A 2PJ

Start date

On request

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

Excel is Microsoft's spreadsheet software and is basically used to store and add up numbers. In many ways Excel is like a super-powered calculator.

You could use Excel to calculate your monthly spending, do simple accounts for your small business or work out what your mortgage repayments are going to when the interest rate rises. If you've got children they may be able to use Excel to help them do calculations for their Maths or Science homework.

Kensington College offers easy-to-understand courses in Microsoft Excel. The topics covered include:

Microsoft Excel Courses: Morning

  • Entering data
  • Editing Data
  • Formatting
  • AutoSum
  • Formulas
  • Absolute Reference
  • Charts
  • Practice

Microsoft Excel Courses: Afternoon (Advanced)

  • Sorting
  • Filtering
  • Goal Seek
  • Sub Totals
  • Linking
  • Inserting & Moving Worksheets
  • If
  • Macros
  • Intro to VBA
  • Templates
  • Scenarios
  • Auditing
  • Pivot Tables
  • Solver
  • Conditional Formatting
  • Vlookup & Hlookup
  • Data Validation
  • To Set The Print Area
  • Page Break Preview
  • Header & Footer
  • Borders

Extra Topics

Tailor-made. Topics selected from:

Topics

  • Linking to Access
  • Random Number Generation
  • More Advanced Charts
  • Outlining
  • Data Functions
  • Data Tables
  • Financial Functions
  • More Advanced Pivot Tables
  • Histograms
  • Add Ins
  • etc !

Private training:

A student who has some knowledge already of Excel may benefit more from 2-3 hours of individual lessons. In that time advanced topics eg scenarios, macros, pivot tables, etc can easily be covered.
Given time it would also be possible to consider any job-specific spreadsheet requirements that a student has.

2003 or 2007?

Both Excel 2003 and 2007 although 2003 predominates. If only 2007 is required, please let us know.

Additional information

Payment options:

Cost: £95 per half day Private training: Cost: £60 per hour

Microsoft Excel

£ 185 + VAT