Aviation Finance Finuas Network
We are pleased to be able to offer a limited number of free places for jobseekers on our network programmes
Please click on the following link to check if you meet Jobseekers eligibility criteria;
DATES: 2oth June 2012
TIME: 9am – 5pm
COST: €90.00 ( 40% funding applied )
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
The Aviation Finance Finuas Network is funded by member companies and the Finuas Network Programme, an initiative of Skillnets Ltd. funded from the National Training Fund through the Department of Education and Skills.