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:  Thursday 19th September  2013

TIME: 9am – 5pm

COST: €100 per participant……funding already applied.

LOCATION: New Horizons

Duration : 1 day

Overview :

In this course, students will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2010.

Objective :

Upon successful completion of this course, students will be able to: – create, edit, and debug a macro. – format worksheets using macros. – create an interactive worksheet. – work with multiple worksheets. – perform calculations.

Who Should Attend

Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Prerequisite(s) or equivalent knowledge:

Excel 2010 – Level 1
Excel 2010 – Level 2
Excel 2010 – Level 3

Outline :

Lesson 1: Developing Macros

Create a Macro with the Macro Recorder
Edit a Macro
Debug a Macro
Customize the Quick Access Toolbar and Hotkeys
Work with Macro Security

Lesson 2: Formatting Worksheets Using Macros

Insert Text
Format Text
Sort Data
Duplicate Data
Generate a Report

Lesson 3: Creating an Interactive Worksheet

Determine the Dialog Box Type
Capture User Input

Lesson 4: Working with Multiple Worksheets

Insert, Copy, and Delete Worksheets
Rename Worksheets
Modify the Order of Worksheets
Print Worksheets

Lesson 5: Performing Calculations

Create User-Defined Functions
Automate SUM Functions

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