Part time Excel Advanced

Vocational qualification

In Doncaster

£ 185 + VAT

Description

  • Type

    Vocational qualification

  • Location

    Doncaster

  • Duration

    1 Day

m well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.Course AimsThis course allows the delegate to appreciate the full potential of Excel 2003. By the end of the course, the user will be competent with the following skills:Course OutlineProtection- Cell Protection- Hiding Data- Workbook ProtectionSolver-

Facilities

Location

Start date

Doncaster (South Yorkshire)
The Hub Chappell Drive, DN1 2RF

Start date

On request

About this course

Delegates should be proficient users of Excel 2003, and should have experience of the topics covered in our Introductory and Intermediate courses, either from attending these courses or by knowledge gained from their own experience.

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 2003 - Advanced Type of learning:
Instructor lead at DBIC

Duration:
1 day intensive

Times/dates:

Cost:

£185 (includes course materials, lunch and refreshments)
Corporate rates available please contact us for further information

Target Audience
Anyone wishing to investigate the more powerful and advanced features of Excel 2003.

Pre-Course Requirements
Delegates should be proficient users of Excel 2003, and should have experience of the topics covered in our Introductory and Intermediate courses, either from attending these courses or by knowledge gained from their own experience.

Benefits to the Employer
Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.

Course Aims
This course allows the delegate to appreciate the full potential of Excel 2003. By the end of the course, the user will be competent with the following skills:

Course Outline
Protection

- Cell Protection

- Hiding Data

- Workbook Protection

Solver

- Goal Seek

- Using Solver Constraints

Scenarios

- Creating, Using, Editing and Deleting

- Producing Summary Reports

Lists

- Create a List

- Data Forms

- Adding Subtotals

- Database Functions

PivotTables

- Create and Understand PivotTables

- Display One Item

- Formatting/Grouping

Advanced Functions

- Logical OR/AND

- Date and Time

- Lookup and Reference

- SumIf and CountIf

- Text Functions

- Financial

- Nested

Advanced Charts

- 3D Chart View

- Data Labels and Markers

- Stacked Bar Charts

Data Tables

- One/Two Input Data Tables

Styles

- Create, Use and Delete Styles

Data Consolidation

- By Position or Category

Macros

- Security

- Record

- Run

- Assign to a Button or Menu

Auditing

- Trace Precedents, Dependents and Errors

- Data Validation

Forms

- Create and Format Online Forms

Web Pages

- Create Hyperlinks

- Use Send To

This course outline is a guide. All our courses can be tailored to customer requirements.

Part time Excel Advanced

£ 185 + VAT