Microsoft Excel: Intermediate

in Media Training (England)

Classes Course

Place:

London

Price:

Ask the course provider

Duration:

On request

Start:

consult dates and times
See course programme

Course objectives:

A continuation from the introductory course, this one day course looks at more in-depth functionality and commands in Excel. You will look at different ways of formatting and presenting information and use both databases and charts to analyse data. This outline is based on Microsoft Excel 2007 (or Excel 2008 if you are a Mac user). If you are using a different...

See course programme
Course details
venues and dates
Course alerts similar to these

More courses Subject area

Place

Request information

Contact directly and with no obligation with

Media Training

You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.

* Compulsory fields

*Name *Surname

*E-mail

*Country/ region *Area/ County

*I would like more information on

By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.

I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:

:| :) ;)

Average Fast Very fast

Course details

Type Course Duration On request

Method / place Contact course provider Classes in London where

Course objectives A continuation from the introductory course, this one day course looks at more in-depth functionality and commands in Excel. You will look at different ways of formatting and presenting information and use both databases and charts to analyse data. This outline is based on Microsoft Excel 2007 (or Excel 2008 if you are a Mac user). If you are using a different...

Price

Ask
the
course provider

back
Course programme
ex-students and opinions

Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

Excel Intermediate
Pass training
London - £210 + VAT

Intermediate Microsoft Excel
Reed Learning
London - £275 + VAT

Microsoft Excel 2003, 2007, XP Intermediate
Alpha Training
- Price: On request

Excel 2003 Intermediate
2e2 Training
London - £495 + VAT

Excel Advanced
Nobleprog Limited
London - £630 + VAT

Compare the selected courses

+ excel Courses + Excel Courses in London + Courses in London + Media Training Courses

Course programme

Microsoft Excel: Intermediate

Course Overview

A continuation from the introductory course, this one day course looks at more in-depth functionality and commands in Excel.

You will look at different ways of formatting and presenting information and use both databases and charts to analyse data.

This outline is based on Microsoft Excel 2007 (or Excel 2008 if you are a Mac user). If you are using a different version, please give us a call on 020 7359 9855.

Course content

Introduction
· Refresher on basic formulas and functions
· Preventing rounding errors
· Building in checks and proofs
· Conditional formulas
· Linking worksheets / workbooks

Further functions
· Logical functions; IF, AND, OR
· Conditional statistical functions
· Date and time functions

Creating business diagrams
· Creating Venn diagrams
· Editing diagrams
· Exporting diagrams

Databases
· Creating a database
· Sorting and filtering
· Sub-totalling
· Consolidations
· Enhanced list functionality
Formatting numbers
· Creating custom number formats
· Conditional formatting
· Controlling date formats

Creating charts
· The different types of charts
· Chart formatting features
· Using Trends
· Combining charts
· Linking Excel and Word

Security
· Worksheet protection
· Workbook protection

Questions and answers

see the full course programme