Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: train 2 gain | itq level 2 | excel courses london | nvq 2 | nvq 2 in care | advanced excel course london | excel courses in london | excel course london | teaching assistant level 2 | city and guilds 2330 level 2
Homepage IT, Computing, Telecommunications Courses PC Applications Courses Excel Courses

Microsoft Excel 2

in Ipso Facto Training Solutions Ltd. (England)

Classes Workshop

Price:

£150 + VAT

Duration:

1 Day

Start:

consult dates and times
See course programme

Request free information

Course objectives:

To apply visual elements and advanced formulas to a worksheet to display data in various formats.

Ipso Facto Training Solutions Ltd.

Our new training centre is located at the Solent Business Park, Whiteley, ideally situated between Southampton and Portsmouth. Also scheduled courses at the Solstice Park, Amesbury, Wiltshire, near Sa...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
Ipso Facto Training Solutions 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 Workshop Duration 1 Day
Method / place Contact course provider Classes
Suitability In Microsoft® Office Excel: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Target Student: The target students for this course are students who wish to gain the skills necessary to create templates, sort and filter data
Course objectives To apply visual elements and advanced formulas to a worksheet to display data in various formats.
Price £150 + VAT
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Microsoft Excel 2003 - Entry Level to Proficient User
focus4training
Online - £24 + VAT
 
Excel 2007
We Teach You
Distance - £30 + VAT
 
Microsoft Excel Advanced
Prolog Training
Distance - £300 + VAT
 
Microsoft Excel 2003, 2007, XP Intermediate
Alpha Training
- Price: On request
 
Microsoft Excel 2007
Career Vision Training Ltd
Multimedia - £60 + VAT
Compare the selected courses

Course programme

Microsoft Excel 2
Microsoft Excel 2

Low class numbers helped and gave time to focus on specific issues as required. The location was ideal living in Southern Hampshire. [Adam Tait]  


Course Objectives
By the end of this level you will be able to:

  • Use Conditional Formatting to manage data
  • Create and apply templates
  • Sort, Filter, Subtotal and use Pivot tables to analyse data
  • Manage complex formulas using Range Names
  • Calculate with advanced formulas including IF's and Vlookup
  • Create and modify charts
  • Work with graphic objects
  • Use a range of useful shortcuts

    Content Creating and Applying Templates - Create a Workbook from a Template - Create a Custom Template - Working with Comments - Create a Hyperlink - Use Web-based Research Tools   Creating and Modifying Charts - Create a Chart - Format Chart Items - Change the Chart Type - Create a Diagram   Working with Graphic Objects - Insert Graphics - Create AutoShapes - Format Graphic Objects - Change the Order -  Graphic Objects - Group Graphic Objects - Move, Copy, and Resize Graphic Objects   Calculating with Advanced Formulas - Create and Apply a Name for a Range of Cells - Calculate Across Worksheets - Calculate with Date and Time Functions - Calculate with Financial Functions - Calculate with Statistical Functions - Calculate with Lookup and Reference Functions - Calculate with Logical Functions   Sorting and Filtering Data - Sort Data Lists - Filter Data Lists - Create and Apply Advanced Filters - Calculate with Database Functions - Add Subtotals to a Worksheet   Using Excel with the Web - Export Excel Data - Publish a Worksheet to the Web - Import Data from the Web - Create a Web Query
  • see the full course programme

    on request

    get more information on the programme directly from Ipso Facto Training Solutions 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...
     

    On Ipso Facto Training Solutions Ltd.

    Provider description
    Our new training centre is located at the Solent Business Park, Whiteley, ideally situated between Southampton and Portsmouth. Also scheduled courses at the Solstice Park, Amesbury, Wiltshire, near Salisbury for Microsoft courses, PRINCE2 courses and others. Check out our Business Management courses including: Finance for Managers, Report Writing skills, Dynamic Presentation skills and Project Management related courses. All courses have been designed for new and experienced business managers. The feedback from these courses have been fantastic with delegates gaining new skills that they can employ straight away. For more information about any of these courses or other courses in our portfolio please don't hesitate to contact us.
    If you have multiple delegates we can offer a discount for that course, so don't forget to state how many delegates require training.
    Advantages of studying with Ipso Facto Training Solutions Ltd.
    We aim to provide an excellent service when booking a course right through to course completion. All our courses are delivered by qualified experts that have years of experience in delivering those courses. Our training centre is new with plenty of natural light and easy access to the M27 motorway system via J9. It also has free parking around the building. We also have small class sizes with an average of five delegates. This make for a perfect environment for learning. We're also regularly complemented on our lunch and refreshments.
    Course provider history
    1998 Microsoft and IT courses 2000 + Project Management courses 2001 + Programming courses 2002 + Business Skills courses 2003 + Microsoft Server courses and Oracle 2004 + Finance courses 2006 + Heath and Safety courses 2007 + PRINCE2
    Specialises in
    Microsoft user, Microsoft Programmer, Server Administrators. Project Management related courses including PRINCE2 and MSP. Business Skills courses of all kinds, Time Management etc Finance courses for Managers and Executives. Health and Safety courses.

    All courses

    by Ipso Facto Training Solutions Ltd. on emagister.

    See list of courses

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

    Most searched for in Excel

    Information related to Excel

    More related courses
    Excel for Beginners £73 + VAT Hampshire
    Excel 2000 Mos £75 + VAT Online
    Excel 2007 Training £195 + VAT Distance
    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