Introductory Microsoft Excel 2007 Training Courses

4.5
2 reviews
  • Ashton Community Trust Employment and Training Services have worked with JMD Training for a few years to provide our unemployed clients with the skills and qualifications needed to help them gain employment. JMD training have always provided an excellent service and have always met the needs and requirements of the organisation. Clients have always returned excellent feedback on any training course attended especially the help and support the trainers provide. I have enjoyed working with JMD Training and I look forward to continuing to work with them in the future.
    |
  • Ashton Community Trust Employment and Training Services have worked with JMD Training for a few years to provide our unemployed clients with the skills and qualifications needed to help them gain employment. JMD training have always provided an excellent service and have always met the needs and requirements of the organisation. Clients have always returned excellent feedback on any training course attended especially the help and support the trainers provide. I have enjoyed working with JMD Training and I look forward to continuing to work with them in the future.
    |

Short course

In Twickenham

£ 295 + VAT

Description

  • Type

    Short course

  • Location

    Twickenham

  • Duration

    1 Day

  • Start date

    Different dates available

This course aims to introduce delegates with little or no understanding of the Microsoft Excel software to the basic features of the package.

                     

Facilities

Location

Start date

Twickenham (Middlesex)
12 Northcote Road, TW1 1PA

Start date

Different dates availableEnrolment now open

About this course

On completion of the course delegates should understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. They should also be able to accomplish standard mathematical and logical operations using basic formulae and functions. They should also be able to use some of the more advanced Microsoft Excel applications such as importing objects, and creating graphs and charts.

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

4.5
  • Ashton Community Trust Employment and Training Services have worked with JMD Training for a few years to provide our unemployed clients with the skills and qualifications needed to help them gain employment. JMD training have always provided an excellent service and have always met the needs and requirements of the organisation. Clients have always returned excellent feedback on any training course attended especially the help and support the trainers provide. I have enjoyed working with JMD Training and I look forward to continuing to work with them in the future.
    |
  • Ashton Community Trust Employment and Training Services have worked with JMD Training for a few years to provide our unemployed clients with the skills and qualifications needed to help them gain employment. JMD training have always provided an excellent service and have always met the needs and requirements of the organisation. Clients have always returned excellent feedback on any training course attended especially the help and support the trainers provide. I have enjoyed working with JMD Training and I look forward to continuing to work with them in the future.
    |
100%
4.6
excellent

Course rating

Recommended

Centre rating

Laura O'Donnell

4.5
09/05/2017
What I would highlight: Ashton Community Trust Employment and Training Services have worked with JMD Training for a few years to provide our unemployed clients with the skills and qualifications needed to help them gain employment. JMD training have always provided an excellent service and have always met the needs and requirements of the organisation. Clients have always returned excellent feedback on any training course attended especially the help and support the trainers provide. I have enjoyed working with JMD Training and I look forward to continuing to work with them in the future.
What could be improved: All good.
Would you recommend this course?: Yes

Laura O'Donnell

4.5
09/05/2017
What I would highlight: Ashton Community Trust Employment and Training Services have worked with JMD Training for a few years to provide our unemployed clients with the skills and qualifications needed to help them gain employment. JMD training have always provided an excellent service and have always met the needs and requirements of the organisation. Clients have always returned excellent feedback on any training course attended especially the help and support the trainers provide. I have enjoyed working with JMD Training and I look forward to continuing to work with them in the future.
What could be improved: All good.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 14 years

Subjects

  • Excel
  • MS Excel
  • Microsoft Excel
  • Microsoft excel training
  • Printing
  • Spreadsheet
  • Print Preview
  • Print Break Preview
  • Spelling
  • Worksheet
  • Cell styles
  • Table formats
  • Format Painter
  • Decimal point
  • Date styles
  • Currency
  • Percentages<br />

Course programme

Getting Started

First Steps with Microsoft Excel - opening, creating a new spreadsheet, saving, closing, using Help functions, converting documents, compatibility checker, switching between open worksheets and workbooks
Adjusting Basic Settings - changing spreadsheet view mode, using the zoom tool, Quick Access toolbar, freezing and unfreezing row and/or column titles, modifying basic operations in Excel such as username and the default directories for opening and saving workbooks
Cells

Inserting Data – entering a number, date, text in a cell
Selecting Data - cells, range of adjacent or non-adjacent cells, rows, columns
Copying, Moving, Deleting
Editing Data – Inserting additional cell content, replacing existing cell content, using the undo and redo buttons
Finding and Replacing
Rows and Columns - inserting rows and columns, modifying row height and cell width, deleting rows and columns
Sorting Data
Worksheets

Handling worksheets – inserting a new worksheet, renaming a worksheet, deleting a worksheet, copying worksheets, moving worksheets
Formulae and Functions

Arithmetic and Logical Formulae - addition, subtraction, multiplication, division, standard error messages
Cell referencing - relative cell referencing, absolute cell referencing, mixed cell referencing
Working with Functions - sum, average, minimum, maximum, count, if
Formula AutoComplete
Formatting

Formatting Numbers and Dates - number of decimal places, commas to indicate thousands, number of zeros after the decimal point, date styles, currency, percentages
Formatting Cells - text size, bold, italic, font type, underline, double underline, font colour, text orientation, cell background colour, format painter
Formatting Cell Ranges - centring and aligning cell contents, centring a title over a cell range, adding border effects
Cell styles
Applying table formats
Charts and Graphs

Using charts/graphs – producing different types of graphs and charts to analyse data, editing or modifying charts or graphs, changing chart type, moving and deleting charts or graphs
Preparing Outputs

Worksheet Setup – modifying worksheet margin settings, adjusting worksheet setup to fit one page, adding a header and footer, changing document orientation, page size, etc.
Spelling
Print Preview and Print Break Preview
Applying automatic title rows printing on every page of a worksheet
Printing Simple Worksheets – using print options, previewing a spreadsheet, printing a spreadsheet or a worksheet, printing part of a worksheet or a pre-defined cell range

Additional information

Course Type Cost per day
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

Introductory Microsoft Excel 2007 Training Courses

£ 295 + VAT