Aviation and Aerospace Skillnet

DATES: Wednesday 11th November 2015

LOCATION: New Horizions

COST: €€100.00 per participant...... funding applied

DURATION: 1 Day

TIME: 9.30am to 5.00pm

 

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 Horizons Dublin

http://www.newhorizonsireland.ie

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

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

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

For more information on Skillnets, please visit www.skillnets.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