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

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

CLICK HERE TO BOOK NOW

DATES: 17th April 2014

LOCATION: New Horizions

COST: €€100.00 per participant…… funding applied

DURATION: 1 Day

TIME: 9.30am to 4.30pm

 

Overview

In this course students will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Objective

Upon successful completion of this course, students will be able to: – enhance productivity and efficiency by streamlining your workflow. – collaborate with others using workbooks. – audit worksheets. – analyze data. – work with multiple workbooks. – import and export data. – use Excel with the web. – structure workbooks with XML.

 

Outline

 

Lesson 1: Streamlining WorkflowUpdate Workbook PropertiesCreate a MacroEdit a MacroApply Conditional FormattingAdd Data Validation Criteria Lesson 2: Collaborating with OthersProtect FilesShare a WorkbookSet Revision TrackingReview Tracked RevisionsMerge WorkbooksAdminister Digital SignaturesRestrict Document Access Lesson 3: Auditing WorksheetsTrace CellsTroubleshoot Errors in FormulasWatch and Evaluate FormulasCreate a Data List Outline
Lesson 4: Analyzing DataCreate a TrendlineCreate SparklinesCreate ScenariosPerform What-If AnalysisPerform Statistical Analysis with the Analysis ToolPak Lesson 5: Working with Multiple WorkbooksCreate a WorkspaceConsolidate DataLink Cells in Different WorkbooksEdit Links Lesson 6: Importing and Exporting DataExport Excel DataImport a Delimited Text File
Lesson 7: Using Excel with the WebPublish a Worksheet to the WebImport Data from the WebCreate a Web Query Lesson 8: Structuring Workbooks with XMLDevelop XML MapsImport and Export XML Data

 

Who Should Attend

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

 Trainer

New Horizions Dublin

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.

 

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