Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
  Most popular search | Share this page  
open My list: 0 courses
autocad 2007   office management course   office management courses   train 2 gain   office manager course   itq level 3   nvq level 3 courses   itq level 2   office manager courses   excel courses london
Homepage › IT, Computing, Telecommunications Courses › PC Applications Courses › Excel Courses

Microsoft Office Excel 2007 Level 2

in PTR Associates Ltd (England)

Classes Course

Price:

£250 + VAT

Duration:

1 Day

Start:

consult dates and times
See course programme

Requirements:

Before starting this course,it is recommended that students have attended the Microsoft Office Excel ... see more

Request free information

Course objectives:

You can already create, edit, format, and print basic spreadsheets as covered on the Level 1 course. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. This course is designed for students who wish to gain the skills necessary to create templates, sor...

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
PTR Associates 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 1 Day
Method / place Contact course provider Classes
Course objectives You can already create, edit, format, and print basic spreadsheets as covered on the Level 1 course. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. This course is designed for students who wish to gain the skills necessary to create templates, sor...
Requirements
Before starting this course,it is recommended that students have attended the Microsoft Office Excel 2007 Level 1 course or have equivalent knowledge.
Price £250 + VAT
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Excel Macros And Vba
CTS - Computer Training Solutions
Berkshire - £375 + VAT
 
Excel 2007 Intermediate
2e2 Training
Berkshire - £495 + VAT
 
Microsoft Excel 2003, 2007, XP Intermediate
Alpha Training
- Price: On request
 
Excel 2007 Training
UK Open Learning Ltd
Distance - £195 + VAT
 
Microsoft Excel 2007 Level 2
WWP Training Limited
Berkshire - £450 + VAT
Compare the selected courses
+ excel Courses + Excel Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

Microsoft Office Excel 2007 Level 2
Course objectives:
You can already create, edit, format, and print basic spreadsheets as covered on the Level 1 course. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. This course is designed for students who wish to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Upon successful completion of this course, students will be able to:
  • enhance the workbook.
  • automate workbook creation by using templates.
  • organize data using tables.
  • create and modify charts.
  • analyze data using PivotTables and PivotCharts.
  • work with graphic objects.
  • calculate with advanced formulas.
  • sort and filter data.


    Course content:
    Enhancing Workbooks
  • Customize the Excel Environment
  • Customize an Excel Worksheet
  • Enhance Worksheets Using Themes
  • Work with Comments
  • Access External Resources Using Hyperlinks
  • Use Web-Based Research Tools
    Creating Workbooks Using Templates
  • Create a Workbook from a Template
  • Create a Custom Template
    Organizing Data Using Tables
  • Create Tables
  • Modify Tables
  • Format Tables
    Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts
  • Create a Chart Template
  • Share Excel Charts
    Analyzing Data Using PivotTables and PivotCharts
  • Create a PivotTable
  • Perform Calculations Using PivotTables
  • Analyze Data Using PivotCharts
    Enhancing Visual Appeal Using Graphic Objects
  • Insert Graphics
  • Modify Graphic Objects
  • Emphasize an Area of a Worksheet
  • Illustrate Workflow Using SmartArt Graphics
  • Format Graphic Objects
  • Change the Order of Layered Graphic Objects
  • Group Graphic Objects
  • Organize Graphic Objects
    Calculating Data with Advanced Formulas
  • Refer to a Range of Cells
  • Calculate Data Across Worksheets
  • Perform Date and Time Calculations
  • Format Text Using Formulas
  • Perform Numeric Calculations
  • Calculate Data with Lookup & Reference Functions
  • Perform Logical Analysis
  • Print Formulas
    Sorting and Filtering Data
  • Sort Data in a Spreadsheet
  • Filter Data in a Spreadsheet
  • Calculate Large Volumes of Data
  • Add Subtotals to a Worksheet
    Appendix A: Microsoft Office Specialist: Excel 2007
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates 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

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

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

    Training related to Excel

    More related courses
    Microsoft Excel Intermediate Price: On request Berkshire
    Excel 2007 £30 + VAT Distance
    Microsoft Excel 2007 £60 + VAT Multimedia
    Introduction to Microsoft Excel £150 + VAT Berkshire
    Microsoft Excel 2003 - Proficient Level to Expert User Microsoft Excel 2003 - Proficient Level to Expert User £24 + VAT Online
    + excel Courses + Excel Courses in Berkshire + PTR Associates Ltd Courses
     

    Most searched for in Excel

    Courses IT, Computing, Telecommunications | Courses PC Applications | Courses Excel | Courses Microsoft Excel | Courses Microsoft Office | Courses Spreadsheet
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: microsoft office microsoft excel microsoft office specialist
    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