Business Excellence Skillnet

 

Business Excellence Skillnet

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: Monday 9th June 2014

TIMES: Registration 9.15 Training starts at  9.30 am – 4.30 pm

LOCATION: Cork

COST: €€75 per member €€110 non member (funding applied/regular cost is €180.50 per person)
(Courseware Manual / Certificate and Lunch & Light Refreshments Included in price)

Course Description

This is an Microsoft Excel Advanced course.  The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending.  For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.

Course Duration

1 day

Course Objectives

On completion, candidates should be familiar with the mosre advanced functions of Microsoft Excel and also be equipped with the necessary skills to produce complex documents and integrate them with output from other Windows applications.

Course Content

FUNCTIONS
Excel 2007 Functions
Getting help about using a particular function
TODAY
DAY
MONTH
YEAR
SUMIF
ROUND
COUNT
COUNTA
COUNTIF
PROPER
UPPER
LOWER
CONCATENATE
FV
NPV
PMT
PV
RATE
HLOOKUP
VLOOKUP
IF
AND
OR
ISERROR
DSUM
DMIN
DMAX
DCOUNT
Using nested functionsUSING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES
Using a one input data table command
Using a two input data table command

A FIRST LOOK AT PIVOT TABLES
Creating a Pivot Table
Dropping data into the Pivot Table
Modifying data and refreshing the Pivot Table
Grouping data within a Pivot table

SCENARIOS
Scenario Manager - an example
Showing a scenario
Viewing an alternative scenario
Create a scenario summary

AUDITING
Tracing precedent cells
Tracing the dependants of a cell
Displaying all formulas within a worksheet
Adding comments
Displaying comments
Removing comments
Editing comments

MACROS
Displaying the Developer tab
Recording and running macros
Lowering your macro security level
Customizing the Quick Access Toolbar
Changing the Quick Access Toolbar Macro icon
Removing a macro icon from the Quick Access Toolbar
Raising your macro security level

Who should attend?

Aimed at frequent users who have an excellent knowledge of Microsoft Excel’s basic and intermediate principles, this course provides candidates with practical experience of the topics listed in the course outline.

Pre-requisites

Those attending should have an understanding of Microsoft Excel to an intermediate level, be competent Microsoft Windows users, and be familiar with the basics of file and disk management.

 

Training Company Name

c2

Mike Derham

tel: Ireland +353 (0)87 6843811
fax: +353  (0)21 4580 480
e-mail: info@c2.ie
twitter: @c2worldwide

 

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

 

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

 


 

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