Course not currently available

Microsoft Excel Intermediate 2007

WDR

Short course

In Horsham ()

£ 175 + VAT

Description

  • Type

    Short course

  • Level

    Intermediate

  • Duration

    1 Day

This course complements the Excel Primary course, and covers some of the more advanced features Excel has to offer. These include managing and filtering lists of data, grouping worksheets and data consolidation, using the "IF" and "Lookup" functions and conditional formatting. Course objectives: This course will enable delegates to enhance their knowledge. Suitable for: All Microsoft Excel users who have either attended the Excel Primary course or who have a good basic knowledge of Excel, and now need to improve their productivity and knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Overview
This course complements the Excel Primary course, and covers some of the more advanced features Excel has to offer. These include managing and filtering lists of data, grouping worksheets and data consolidation, using the "IF" and "Lookup" functions and conditional formatting.

Course objectives
This course will enable delegates to enhance their knowledge of Excel and develop their skills to produce professional and well-presented spreadsheets.

By the end of this course you will have learned
  • How to create a formula using absolute referencing
  • How to link one worksheet to another
  • How to work with "IF", "SumIF", "CountIF" and "VLOOKUP" functions
  • How to consolidate data from multiple worksheets
  • Sorting, filtering and creating subtotals in datalists
  • How to use conditional formatting and paste special options
Who should attend
All Microsoft Excel users who have either attended the Excel Primary course or who have a good basic knowledge of Excel, and now need to improve their productivity and knowledge.

Pre-requisites
Delegates should have a good understanding of the Windows environment and it is advisable that they have attended the Excel Primary course.

Course synopsis
  • Absolute referencing
    What is absolute referencing; when to use absolute referencing
  • Linking data
  • Grouping worksheets
    Grouping worksheets; using functions in grouped sheets; group calculations
  • Data consolidation
    Consolidate within a single worksheet; consolidate in multiple worksheets; link source data; viewing outlines
  • Functions
    The "IF" function; nested "IF" functions; "SumIF" function; "CountIF" function; "Lookup" functions
  • Conditional formatting
    Formats cells providing certain conditions are met
  • Paste special
    Basic paste functions; paste operators; transpose data; paste link
  • Working with data lists
    Sorting and filtering data; subtotals
  • Naming cells and ranges
    Using named ranges to navigate in Excel; creating formulae and functions using named ranges


Microsoft Excel Intermediate 2007

£ 175 + VAT