Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Go to homepage The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: autocad 2007 | paramedic training uk | cameraman training | mewp training | solar energy training | venepuncture training | stakeholder management training | adobe captivate training | autocad training london | information architecture , training
Homepage > IT, Computing, Telecommunications > PC Applications > Excel

Excel 2007 Training

in UK Open Learning Ltd (England)

Distance Course

Price:

£195 VAT inc.

Duration:

90 Hours


See course programme

Requirements:

There are no entry requirements..

Request free information

Course objectives:

Learn skills in one of the most powerful spreadsheet programs, produce impressive business documents easily and quickly, and enhance your personal productivity and promotional value.

UK Open Learning Ltd

We provide over 200 distance learning courses to students all over the world. They are fully tutor supported and are fully accredited. Choose from Pet Grooming, Web Design, Child Care, Bookkeeping, ...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
UK Open Learning Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 90 Hours
Method / place Contact course provider Distance
Students per class 600
Suitability If you're a spreadsheet novice or an experienced professional, the Excel 2007 course from LearnKey can help you master spreadsheets.
Course objectives Learn skills in one of the most powerful spreadsheet programs, produce impressive business documents easily and quickly, and enhance your personal productivity and promotional value.
Requirements
There are no entry requirements..
Price £195 VAT inc.
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Excel 2007
We Teach You
Distance - £30 VAT inc.
 
Microsoft Excel Advanced
Prolog Training
Distance - £300 + VAT
 
Microsoft Excel 2003, 2007, XP Intermediate
Alpha Training
- Price: On request
 
Excel 2007
Sales 101 Ltd
Distance - £95 + VAT
Compare the selected courses
+ excel Courses + UK Open Learning Ltd Courses

Course programme

Excel 2007 Training
Excel Course Outline:
 
Session 1
Section A: Introduction
  • What You Will Learn

  • Excel 2007 Interface

  • Ribbon and Tabs

  • Document Windows

  • Navigation Tips
    Section B: Creating and Manipulating Data

  • Entering Data

  • AutoFill a Series

  • Fill Non-Adjacent Cells

  • AutoFill on Multiple Sheets

  • Creating Custom Lists

  • Series Formatting
    Section C: Managing Worksheets

  • Copying Worksheets

  • Inserting and Deleting Worksheets

  • Hiding Worksheets
    Section D: Data Integrity

  • Validation Criteria

  • Character Validation

  • Drop-Down Lists
    Section E: Modifying Cell Content

  • Cut, Copy, Paste

  • Transposing Data

  • Copy Cell Format Only

  • Removing Duplicates

  • Data Validation
    Section F: Changing Views

  • Zoom Features

  • Workbook Views

  • Page Layout View

  • Repeating Cell Content

  • Freeze Panes

  • Split Windows

  • Viewing Multiple Windows

  • Saving Hot Links

  • Hiding the Ribbon

    Session 2
    Section A: Formatting Data

  • Formatting Worksheets

  • Worksheet Backgrounds

  • Watermarks
    Section B: Modifying Rows and Columns

  • Inserting Rows

  • Inserting Columns

  • Cutting and Inserting Columns

  • Modifying Cell Width/Height

  • Inserting Multiple Rows and

  • Columns

  • Inserting and Deleting Cells

  • Formatting Rows and Columns

  • Hiding/Unhiding Rows and

  • Columns
    Section C: Formatting Numbers

  • Currency Format

  • Format Painter

  • Formatting Dates

  • Special Formats

  • Cell Styles
    Section D: Formatting Text and Tables

  • Fonts, Fills, and Alignment

  • Comments

  • Merging and Splitting Cells

  • Inserting Hyperlinks

  • Formatting as a Table

  • Summary Function
    Section E: Understanding Formulas

  • Using Operations

  • Creating

  • Formulas

  • AutoSum

  • Common Functions

  • Searching for Functions

  • Copying Formulas

  • Absolute Cell References
    Session 3
    Section A: Referencing Formulas

  • Dependent References

  • Multiple Sheet References

  • Consolidating Data

  • Consolidating with Links
    Section B: Ranges and Dates

  • AutoSum

  • Cell Names

  • Formulas with Cell Names

  • COUNT

  • COUNTA

  • Date Formulas
    Section C: Subtotals

  • Overview

  • Subtotal Options

  • Selecting Visible Data

    Section D: Lookups

  • Lookups Purpose

  • VLOOKUP

  • VLOOKUP Exact Match

  • HLOOKUP

  • HLOOKUP Exact Match
    Section E: Conditional Logic

  • IF Syntax

  • IF Statement

  • Nested IF

  • Nested IF Syntax
    Section F: More Conditional Logic


  • AND

  • OR

  • NOT

  • IFERROR

  • SUMIF

  • AVERAGEIF

  • COUNTIF

  • SUMIFS

  • AVERAGEIFS

  • COUNTIFS

    Session 4
    Section A: Financial Formulas

  • Future Value

  • Payment

  • Goal Seek

  • Changing Rate

  • Scenario Manager
    Section B: Text Formulas

  • Case Formulas

  • Paste Column Widths

  • Operations in Paste Special

  • Skip Blanks

  • AutoCalculate

  • Fix Number Fields

  • Trim Spaces

  • Substitute Text
    Section C: Introduction to Charts

  • Chart Types

  • Instant Chart

  • Update Chart

  • Column Chart

  • Picture Fill

  • Adjust Chart Size

  • Line Chart

  • Scatter Chart
    Section D: Formatting Charts

  • Chart Styles

  • Chart Layouts

  • Add Labels

  • Axis Options

  • Chart Title

  • Legends

  • Data Labels
    Section E: Conditional Formatting

  • Highlight Cells Rules

  • Top/Bottom Rules

  • Data Bars

  • Colour Scales

  • Custom Formatting Rule

  • Text Formatting
    Section F: Adding Graphics to Spreadsheets

  • Insert Pictures

  • Modifying Pictures

  • Insert Shapes

  • Insert SmartArt

  • Apply Themes
    Session 5
    Section A: Outlining, Sorting, and Filtering

  • Group and Ungroup

  • Sort Data

  • Sort Multiple Levels

  • Filter Data

  • Advanced Filter

  • Conditional Sorting and Filtering

  • Sorting and Filtering Data

  • Attributes
    Section B: PivotTables

  • Overview

  • Creating PivotTables

  • Choosing Fields

  • Sub Fields

  • PivotTable Layout

  • Filtering PivotTables

  • Totals

  • Modifying PivotTable Data

  • PivotCharts
    Section C: Protecting Data

  • Workbook Passwords

  • Protecting Workbooks

  • Hiding Worksheets

  • Unlocking Cells
    Section D: Collaboration

  • Document Properties

  • Formatting Comments

  • Document Inspector

  • Sharing a Workbook

  • Track Changes

  • Accept/Reject Changes

  • Information Rights Management

  • Using IRM

  • Signature Line

  • Mark as Final
    Section E: Saving a Workbook

  • Save As Previous Version

  • Templates

  • Save As PDF

  • Save As Web Page

  • Macro-Enabled Workbook
    Section F: Printing

  • Page Orientation

  • Page Breaks

  • Print Area

  • Margins

  • Headers and Footers

  • Scaling
    • see the full course programme

    on request

    get more information on the programme directly from UK Open Learning Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users
    Get direct information on how to enrol, venues and availability...
     

    Course provider details

    Provider description
    We provide over 200 distance learning courses to students all over the world.
    They are fully tutor supported and are fully accredited.
    Choose from Pet Grooming, Web Design, Child Care, Bookkeeping, Counselling, Mental Health and much more.
    Course provider history
    UK Open Learning is a family owned and run business dedicated to providing the correct course to our students and we ensure our tutor support is second to none. Unlike the large companies we know each student and they are not just a number. We are also an Open College Network accredited centre.
    Get direct information on how to enrol, venues and availability...
     

    Most searched for in Excel

    Courses IT, Computing, Telecommunications | Courses PC Applications | Courses Excel | Courses Microsoft Excel | Courses Microsoft Office | Courses Spreadsheet

    Information related to Excel

    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina (new)
    Words related to the courses viewed: microsoft office microsoft excel
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights