Intermediate Microsoft Excel 2007

Reed Learning

Short course

In London

£ 199 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Location

    London

  • Duration

    1 Day

Know-how to protect your data using the security features Automation of worksheets using Excel 2007 look up features Improved interpretation of data by learning to create and customise graphs, including plotting trend lines Decision-making skills using the 'If' function and conditional formatting. Suitable for: This course is suitable for people who have attended the introduction course or have sufficient knowledge and understanding of the basics of Excel 2007 and are looking to expand this. Prerequisites A working knowledge of Excel introduction topics or attendance to our Introduction to Excel course.

Facilities

Location

Start date

London
See map
9 Kingsway, WC2B 6XF

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



Who is it for
This course is suitable for people who have attended the introduction course or have sufficient knowledge and understanding of the basics of Excel 2007 and are looking to expand this.

Prerequisites
A working knowledge of Excel introduction topics or attendance to our Introduction to Excel course.

What is it about


  • Know-how to protect your data using the security features


  • Automation of worksheets using Excel 2007 look up features


  • Improved interpretation of data by learning to create and customise graphs, including plotting trend lines


  • Decision-making skills using the 'If' function and conditional formatting


Course overview


  • Setting up entire workbooks with group editing

  • Analysing Filtered data using the SUBTOTAL function

  • Using lookup statements

  • Linking spreadsheets and workbooks

  • 'If' statements and calculations

  • All new conditional formatting features

  • Sorting and filtering data

  • Attaching security to a spreadsheet

  • Setting up and utlising templates

  • Utilising custom chart types

  • Trace Cell Precedents & Cell Dependents

  • Count Functions

  • Auditing Worksheets

  • Locate Invalid Data and Formulas


See related categories

Intermediate Microsoft Excel 2007

£ 199 VAT inc.

The best Excel courses

See all

See all