Intermediate Microsoft Excel 2007 Training Courses

Short course

In Twickenham

£ 295 + VAT

Description

  • Type

    Short course

  • Location

    Twickenham

  • Duration

    1 Day

  • Start date

    Different dates available

This course aims to give delegates a greater understanding of MS Excel 2007.

                               

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 will have improved their skills in using Microsoft Excel 2007. They will be able to:

Manipulate worksheets
Apply conditional formatting
Use various functions, including financial, logical and date/time functions
Manage Excel tables
Customise charts
Use Excel in conjunction with other applications

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

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

  • MS Excel
  • Excel
  • Microsoft excel training
  • Microsoft Excel
  • Sorting
  • Excel table
  • Structured references
  • AutoFilter
  • Excel Tables
  • Formula AutoComplete
  • Editing
  • Freezing panes
  • Grouping
  • Ungrouping
  • Worksheets
  • Functions<br /> <br /> <br /> <br /> <br />

Course programme

Editing

Data - naming cell ranges in a worksheet, the Name Manager, importing text files, using Paste Special options
Formatting - applying formatting to a cell range by the use of styles, creating custom number formats, using conditional formatting options
Display - inserting a new worksheet, renaming a worksheet, deleting a worksheet, adding colour to worksheet tabs, formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns, hiding/unhiding worksheets, grouping and ungrouping worksheets
Using subtotalling features
Linking - Linking data within a worksheet, between worksheets and between workbooks, link charts within a worksheet, between worksheets and between workbooks, linking to a word-processing documents, consolidating data in adjacent worksheets using a 3D sum function
Charts and graphs - Changing angle of pie chart slices, formatting chart axes numbers or text, re-positioning title, legend or data labels in a chart, 'exploding' all the segments in a pie chart, adding or deleting a data series in a chart, modifying the chart type for a defined data series, widening the gap between columns or bars in a 2D chart, inserting an image in a 2D chart
Functions

Resizing the Formula Bar, Formula AutoComplete
Using date and time functions: TODAY, DAY, MONTH, YEAR
Using mathematical functions: SUMIF, SUMIFS, ROUND
Using statistical functions: COUNT, COUNT, COUNTBLANK, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
Using text functions: PROPER, UPPER, LOWER, CONCATENATE
Converting text to columns
Using financial functions: FV, NPV, PMT, PV, RATE
Using lookup functions: IF, AND, OR, ISERROR
Using available database functions: DSUM, DMIN, DMAX and DCOUNT
Using nested functions
Excel tables

Creating an Excel table
Editing an Excel table
Table quick styles
Inserting and deleting rows and columns in tables
Sorting
Using the AutoFilter with tables
Totals
Removing duplicate rows from worksheets
Creating a dropdown list for table entry
Structured references

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

Intermediate Microsoft Excel 2007 Training Courses

£ 295 + VAT