http://icbe.ie/wp-content/uploads/2013/04/business_excellence_skillnet.png

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: 11th June 2013

TIMES: 9.30 am – 5.00 pm

LOCATION: Training Point Raheen Industrial Estate Raheen Limerick

COST: €90.00 per member €120 non member

 

 Programme Overview

 

This Microsoft Excel Intermediate training course is a 1 Day public programme, designed for anyone who wants to improve his or her knowledge of Microsoft Excel. Participants will learn topics, which will improve their efficiency and productivity in the work place.

 

 

Programme Objectives

 

 

On completion of this course participants will be able to use much of the functionality with MS Excel including:
• Competent use of Shortcut Keys
• Use formatting tools such as the format painter
• Write and copy formulas – Relative / Absolute
• Work with multiple worksheets and write formulas across sheets / Link Sheets.
• Create professional looking charts and use drawing tools to enhance these.
• Use the database functionality of MS Excel – Sorting & Auto Filter

 

 

Training Content

 

 

Setup & Printing Issues
• Worksheet Margins
• Worksheet Orientation
• Worksheet Page Size
• Headers and Footers
• Header and Footer Fields
• Scaling Your Worksheet to Fit a Page(s)
• Printing Titles On Every Page
• Printing the Row and Column Headings
• Spell Checking
• Previewing a Worksheet
• Viewing Workbooks Side By Side
• Printing Options

 

Functions and Formulas
• Getting Help With Functions.
• Nested Functions.
• Consolidating Data using a 3-D Reference Sum Function.
• Mixed References within Formulas.

 

Time & Date Functions
• TODAY.
• NOW.
• DAY.
• MONTH.
• YEAR.

 

Mathematical Functions
• ROUND.
• ROUNDDOWN.
• ROUNDUP.

 

Logical Functions
• IF.
• AND.
• OR.

 

Mathematical Functions
• SUMIF.

 

Statistical Functions
• COUNT.
• COUNTA.
• COUNTIF.
• CONCATENATE.

 

Lookup Functions
• VLOOKUP.
• HLOOKUP.

 

Database Functions
• DSUM.
• DMIN.
• DMAX.
• DCOUNT.
• DAVERAGE

 

Named Ranges
• Naming Cell Ranges.
• Removing a Named Range.
• Named Cell Ranges and Functions.

 

Cell Formatting
• Applying Styles to a Range.
• Conditional Formatting.
• Custom Number Formats.

 

Manipulating Worksheets
• Copying or Moving Worksheets
• Splitting a Window.
• Hiding Rows, Columns & Worksheets.

 

Templates
• Creating Excel Templates.
• Editing Excel Templates

 

Paste Special Options
• Using Paste Special to Add, Subtract, Multiply & Divide.
• Using Paste Special ‘Values’.
• Using Paste Special Transpose Option.

 

Database & List Management – Sorting and Filtering Data
• Sorting Data by Multiple Columns
• Custom Sorts
• Customized List
• AutoFilter

 

 

 

Charts
• Combined Line and Column Chart.
• Adding a Secondary Axis.
• Changing the Chart Type For a Data Series.
• Adding a Data Series to a Chart.
• Removing a Data Series from a Chart.
• Modifying the Chart Title, Legend & Data Labels.
• Chart Axis Scales.
• Inserting Images Into Chart Columns.
• Formatting the Chart Area

 

 

 

Audience

 

 

 

This Microsoft Excel Intermediate training programme may be of interest to Microsoft Excel users that understand basic Excel skills (typing in cells, used a formula before, opened a workbook…)and also users who have had no formal training in excel but who understand the basic features of the programme.

 

 

 

 

 

Training Company Name

 

 

 

Training Point  Raheen Limerick

 

 

 

Lindsay Keywood

ECDL Trainer, Advanced ECDL Trainer, Microsoft Certified Trainer, Microsoft Office Master Specialist.  Lindsay has been involved in the delivery of Training Projects for Procad Training for over 15 years.  Through these years Lindsay has delivered high quality courses in all application courses with very successful results and the feedback and evaluation form reviews and client recommendations always reflect this.  Her experience, level of knowledge and professional manner has been one that Lindsay has maintained over the years and continues to do so.

Patrick Browne

Microsoft Certified Trainer, ECDL Standard & ECDL Advanced Trainer, MCT/MCSE Technical Trainer, PC Maintenance, WEB Development Trainer etc.  Patrick is our Senior IT/Applications Trainer with over 15 Years training experience. He is also involved in delivering WEB Marketing Design and SEO Training Courses along with all Adobe graphics product. Patrick continues to achieve excellent reviews from all clients on a day to day basis here at Procad Training and his experience, level of knowledge and professional manner has been one that Patrick has maintained over the years and continues to do so.

 

 

 

 

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