Duration: 1 day(s)
Course Code: XL07L3
Early Bird Courses
London 19th Jan 2018 £191.75 Book
London 13th Feb 2018 £191.75 Book
London 23rd Mar 2018 £191.75 Book
London 18th Apr 2018 £191.75 Book
London 23rd May 2018 £191.75 Book
London 21st Jun 2018 £191.75 Book
Click to view further dates
For dates or any further enquiries please call 01344 830100
Price: P.O.A

Microsoft Excel 2007 Level 3

Course Aims

This course is aimed at people who want expand their knowledge into some of the more advanced calculation and analytical capability of Microsoft Excel.

Course Pre-requisites

Students who wish to attend this course must have a good knowledge of Excel 2007 and be competent at working with basic formulas and functions, multiple sheets and multiple files.

Course Objectives

On completion of this Excel training course delegates will be able to:

  • Manage and enhance large worksheets
  • Use Logical and Lookup functions
  • Set data restrictions using data validation
  • Use the Subtotal feature
  • Grouping information with Outline view

Course Content

Using Logical, Lookup & Round Functions

  • Using the VLOOKUP/HLOOKUP Functions
  • Using IF, Nested Ifs, ISERROR, AND, OR & ROUND Functions

Using Range Names

  • Jumping to a Named Range
  • Assigning Names
  • Using Range Names in Formulas

Using Auditing Tools

  • Displaying the Auditing Toolbar
  • Displaying/Removing Dependent Arrows
  • Displaying/Removing Precedent Arrows
  • Removing Tracer Arrows
  • Tracing Cells Causing Errors

Working with Outlines

  • Applying, Expanding & Collapsing an Outline
  • Modifying & Clearing Outline Settings
  • Using Auto Outline

Using Data Validation & Subtotals

Validating Data

Creating a Custom Error Message

Removing a Data Validation

Creating Subtotals In a List

 

Using Conditional & Custom Formats

  • Applying, Changing, Adding & Deleting a Conditional Format

Using Worksheet Protection

  • Unlocking Cells In a Worksheet; Protecting & Unprotecting a Worksheet & Workbook, Setting Manual & Automatic Calculation

Creating/Revising PivotTables

  • Creating a PivotTable Report
  • Enhancing your Pivot Table
  • Adding & Selecting Fields
  • Refreshing a PivotTable Report
  • Adding, Moving, Deleting PivotTable Report Fields

Working with Advanced Filters and Database Functions

  • Use the Advanced Filter Feature to Display and Extract Data from Tables
  • Database Functions(Dsum, Daverage, Dcounta)

Appendix – Custom Views

  • Creating, Displaying and Deleting Custom Views

Action planning

Review of Programme

Click to expand...

What previous delegates have said about our Excel 2007 Level 3 course

 

"Trainer was highly knowledgeable and passionate about the subject matter. He showed patience when questions were asked and explained them very well." 

 

"Dhru was a great trainer, very enthusiastic and had a teaching style which was easy to understand and brought the subject matter to life"

 

Click to expand...