Aviation and Aerospace Skillnet

Aviation and Aerospace Network

 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;

 

CLICK HERE TO BOOK NOW

Date: Wednesday 23rd September  2015

Location: Limerick

Trainer: Training Point

Cost: €90 per person  funding applied

 

Programme Overview

This Microsoft Excel Intermediate training course is a 1 Day 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

This Microsoft Excel Intermediate training programme may be of interest to personnel who wish to gain a comprehensive overview of the basic features of Microsoft Excel.A basic understanding of Excel is required for this training course.

 

Target Audience

This Microsoft Excel Intermediate training programme may be of interest to personnel who wish to gain a comprehensive overview of the Intermediate features of Microsoft Excel.A basic understanding of Excel is required for this training course.

 

Programme Content

Setup & Printing Issues
• Worksheet Setup
• Headers and Footers
• 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 OptionsFunctions and Formulas
• Getting Help With Functions.
• Nested Functions.
• Mixed References within Formulas.Time & Date Functions
• TODAY.
• NOW.
• DAY.
• MONTH.
• YEAR.Functions
• ROUND.
• ROUNDDOWN.
• ROUNDUP.

• SUMIF.

Logical Functions
• IF.
• AND.
• OR.

Lookup Functions
• VLOOKUP.

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

Text to columns

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

Introduction to Data Connectors

Subtotalling

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

 

 

 

Trainer Profile Qualification & Relevant Experience

Diane MauneDiane is an ECDL Trainer and Advanced ECDL Trainer Diane has been involved in the delivery of Microsoft Training Programmes for over 10 years.  Her courses meet with excellent feedback without exception. Diane is continually delivering courses on all the Office 2007 and Office 2010 on a daily basis for TrainingPoint.Diane continues to achieve excellent reviews from all clients on a day to day basis here at TrainingPoint  and his experience, level of knowledge and professional manner has been one that Patrick has maintained over the years and continues to do so. 

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