Aviation Finance Finuas Logo

http://icbe.ie/wp-content/uploads/2012/02/aviation.png

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;

 

 

CLICK HERE TO BOOK NOW

DATES: 8th October 2012

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

COST: €90.00 per trainee……40% …..funding applied

DURATION: 1 Day

Overview:
In this course, delegates will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
Who Should Attend:
This course is designed for delegates who have already attended Level 1 and Level 2 training in Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students preparing for the Microsoft Certified Applications Specialist exam in Excel.
At Course Completion:
You will automate common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

 

Lesson 1: Streamlining Workflow
Create and Run Macros
Apply Conditional Formatting
Add Data Validation Criteria
Customize Access to Excel Commands (Quick Access Toolbar – 2007)
Update a Workbook's Properties
Modify Excel's Default Settings

 

Lesson 2: Collaborating with Others
Password Protect Files
Share a Workbook
Set Revision Tracking and Review Tracked Revisions
Merge Workbooks

 

 

 

Lesson 3: Auditing Worksheets
Trace Cell Precedents and Dependents
Locate Errors in Formulas
Locate Invalid Data and Formulas
Watch and Evaluate Formulas

 

Lesson 4: Analyzing Data
Create Scenarios
Perform What-If Analysis – Goal Seek, Solver, Data Tables
Develop a PivotTable and PivotChart Reports

 

Lesson 5: Working with Multiple Workbooks
Consolidate Data
Link Cells in Different Worksheets and Workbooks
Edit Links

 

Lesson 6: Importing and Exporting Data
Export to Microsoft Word and PowerPoint
Import a Word Table
Import Text, HTML, CSV Files

Trainer

New Horizons Ireland 

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

Web:       http://www.newhorizonsireland.ie

 

Skillnets
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.

Click here for Finuas Network website www.finuas.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