Excel Level 2                          

 Date  Trainer  Venue  Duration  Member
 Price
  Non Member
 Price
 15/03/2011 New Horizons
 New Horizons  - Dublin
1 Day
 €200  €300

Objective:

In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Upon completion, you will have gained the skills necessary to apply advanced formulas to a worksheet, to manage and display data in various formats, including visual elements.

Who should attend this course?

This course is designed for delegates who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data. In addition, this course helps prepare students for the Microsoft Certified Applications Specialist exam in Excel.


Travel details to the venue/parking:

Courses are held at Strand House 22-24 Strand Street Great Dublin 1 which is behind the Jervis Shopping Centre in the heart of Dublin.

Parking is in multi-level car park nearby on Jervis Street or on Parnell Street.  The Luas stops nearby as well as many bus routes.

What do you need to bring with you?

Nothing.

 

This course will cover:

Lesson 1: Creating and Applying Templates
    Create a Workbook from a Template
    Create a Custom Template
    Working with Comments
    Create a Hyperlink

Lesson 2: Creating and Modifying Charts
    Create a Chart
    Format Chart Items (2007 styles)
    Change the Chart Type
    Save a Custom Chart Template
    Create a Trend line
    Export a Chart to Word and or PowerPoint
    Smart Art (2007 Only)


Lesson 3: Calculating with Advanced Formulas
    Create and Apply a Named Range
    Calculate Between Worksheets and Workbooks
    Date and Time Functions
    Text Functions
    Database Functions
    Statistical Functions
    Lookup and Reference Functions
    Logical Functions

Lesson 4: Manage Data Lists
    Create a Data List
    Sort Data Lists
    Create and Apply Auto and Advanced Filters
    Add Subtotals to a Data List
    Group and Outline Data Lists

 

More about this Speaker:


With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT training company. Through an integrated learning approach that ensures that new knowledge can be applied to real-life situations, New Horizons Ireland - Dublin and Galway - delivers a full range of computer training courses; from basic application and desktop productivity tools to complex and integrated business systems.