Advanced Microsoft Excel

Herefordshire & Worcestershire Chamber of Commerce

Short course

In Worcester

£ 188 + VAT

The best Secretarial courses

See all

See all

Description

  • Type

    Short course

  • Location

    Worcester

  • Duration

    1 Day

On completion of this course, delegates will be able to: Understand and create highly complex formulae. Understand workbook auditing. Understand advanced filters. Use macros and pivot tables. Use Scenarios and Data Tables. Suitable for: Delegates who want to further their knowledge of this powerful business tool.

Facilities

Location

Start date

Worcester (Worcestershire)
See map
Severn House, Prescott Drive, Warndon Business Park, WR4 9NE

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

Course Overview -Advanced Microsoft Excel

This intensive course is designed to allow business users to fully understand the advanced features of Microsoft Excel from Pivot Tables and Macros to advanced functions and document security.

Course Format and Duration

This is a tutor led and exercise based course which runs for one day, with a short lunch break. It allows delegates to be led in group exercises as well as trying tasks out for themselves.

Course Outcomes

This course will equip delegates with the skills and knowledge to be able to:

• Use Statistical functions and Conditional Functions
• Manage Data Forms & Filters
• Understand the advanced filter dialog box
• Introduce Macros
• Use the PivotTable and PivotChart Wizard
• Use MATCH with VLOOKUP or HLOOKUP

See related categories

Advanced Microsoft Excel

£ 188 + VAT

The best Secretarial courses

See all

See all