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: June 18th 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)

Programme Overview

This is an Microsoft Excel Intermediate 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.

Programme Objectives

The course provides candidates with practical experience of the topics listed in the course outline below.  On completion, candidates should have an excellent knowledge of the basic concepts and a working knowledge of some advanced features.

 

Training Content

MANIPULATING DATA, & NAMED RANGES
Paste special
Importing text
Naming cell range(s) in a worksheet
Named ranges within formulas
Creating subtotals
Removing subtotals

TEMPLATES
Using templates
Creating templates
Opening and editing templates

FORMATTING & DISPLAY TECHNIQUES
Formatting tables
Using conditional formatting

Creating custom number formats
Freezing columns and rows
Hiding and un-hiding rows and columns
Hiding and un-hiding worksheets

SORTING AND QUERYING DATA
Sorting internal Excel database lists
Custom sort options
Using AutoFilter to query data
Multiple queries
Removing filters
Top 10 AutoFilter
Filtering unique records
Advanced Filter

LINKING & CONSOLIDATING DATA
Linking individual cells within a worksheet
Linking charts to data within a worksheet
Linking a cell range on one worksheet to another worksheet
Linking data on one worksheet to a chart in another
Linking data from one workbook to another
Linking a chart from one workbook to another
Copying data from Excel into a Word document
Linking data from Excel into a Word document
Copying a chart from Excel into a Word document
Linking a chart from Excel into a Word document
Consolidating data over several worksheets or worksheet pages

CHARTS FORMATTING TECHNIQUES
Changing the angle of pie chart slices
Formatting the chart axis fonts
Formatting the chart axis scales
Formatting the chart axis text orientation
Creating and positioning a chart title
Re-positioning a chart legend
Re-positioning chart data labels
Exploding the segments within a pie chart
Deleting a data series within a chart
Adding a data series to a chart
Modifying the chart type for a defined data series
Widening the gap between columns / bars within a 2-D chart
Inserting an image into a 2D chart (as a background)
Inserting an image into a 2D chart (to format a column or bar of data)

PROTECTION AND SECURITY
Specifying a password for opening a workbook
Using the “read-only recommended” option
Removing a password from an Excel workbook
Protecting a worksheet or worksheet elements
Removing workbook protection

 

Audience

This course is aimed at users who wish to build on their baisc knoweldge of Microsoft Excel.

Pre-requisites

Those attending should have a basic understanding of Microsoft Excel to an introductory level, be competent 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