Aviation Finance Finuas Logo

Aviation Finance Finuas Network

 We are pleased to be able to offer a limited number of free places for jobseekers on our network programmes subject to funding being available

Please click on the following link to check if you meet Jobseekers eligibility criteria;

 

CLICK HERE TO BOOK NOW

DATES: Tuesday 16th February 2016

TIME: 9am - 5pm

COST: €€100.00

LOCATION: New Horizons 22 – 24 Strand Street Great,  Dublin 1,

Objectives

In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Content

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 Trendline
Export a Chart to Word and or PowerPoint
SmartArt (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
Next Steps
Excel - Level 3

 

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.

At Course 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.

 

Trainer

New Horizons Ireland 

Address: 22 – 24 Strand Street Great,  Dublin 1, Ireland

Web:       http://www.newhorizonsireland.ie

Skillnets funded from the National Training Fund through the Department of Education and Skills

The Aviation Finance Finuas Network is funded by member companies and the Finuas Networks Programme, an initiative of Skillnets funded from the National Training Fund through the Department of Education and Skills.

Click here for Finuas Network website www.finuas.ie

 


 

Enquire about this course:

Full Name (required)

Your Email (required)

Your Message

Anti-Spam Check:
Please enter the text & numbers as they appear in this image
captcha