Microsoft Excel Intermediate

Jarrold Training

Training

In Norwich

£ 175 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Level

    Intermediate

  • Location

    Norwich

  • Duration

    1 Day

This one-day training course aims to give basic users of Excel knowledge of commands and functions which will make them more proficient in spreadsheet design and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered. Suitable for: Those wishing to improve their understanding of and ability to use Excel

Facilities

Location

Start date

Norwich (Norfolk)
See map
St James Mill, Whitefriars, NR3 1SH

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

Microsoft Excel Intermediate

One Day Course

Assumed Knowledge:
A working knowledge of Excel gained from prior attendance on a Jarrold Training Microsoft Excel Introduction course or from a user environment.

Course Outline:
Revision
· Product overview
· Revision exercise
Functions
· Date function
· Time function
· Round function
· IF function
· Integer function
Cell Addressing
· Absolute cell addresses
· Relative cell addresses
Conditional Formatting
· Applying conditional formats to text
Database Features
· Using a spreadsheet as a database
· Sorting data
· Basic subtotals
· Filtering data with AutoFilter
· Custom AutoFilter
· Data form
Working with Multiple Sheets
· Selecting sheets
· Inserting & deleting sheets
· Copying sheets
· Copy and paste between sheets
· Naming sheets
· 3D calculations
· Group edit facility
Working with Multiple Workbooks
· Opening multiple workbooks
· Arranging windows
· Linking workbooks
Additional Features
· Inserting comments
Charting
· Revision of basic charts
· Chart types
· Sizing and moving a chart
· Editing a chart
· Changing chart data
· Formatting chart elements
· Drawing features
· Printing a chart

See related categories

Microsoft Excel Intermediate

£ 175 + VAT

The best Excel courses

See all

See all