Cork Chamber business support Cork

You are here: Home > Training > Training Courses > MS Excel (Intermediate)

MS Excel (Intermediate)

Start Date Friday, 17th November 2017
Duration 1 Day
Start & Finish Time 09.30-17.00
Trainer E-bridge
Places A waiting list is currently in operation for this course. Please contact us if you'd like to be added.
Location Cork Airport Hotel
Members Fee €130.00
Non-Members Fee €170.00

Overview

This course is designed for those who may have been using MS Excel for some time, but have never received formal training. We will work through basics including the use of shortcut keys & some less familiar formatting options. We will then move on to more intermediate topics such as working with and linking multiple worksheets, creating charts, managing lists (Sorting & AutoFilter) among other options.

Summary of Outline
- Excel Essentials – Data Entry, Navigating, Editing, Formatting, Moving & Copying – Clipboard Task Pane etc.
- Managing and working with lists – Sorting & Filtering, Freeze Panes, Print Titles.
- Formulas and Functions – Sum, Average, Min, Max, Count – Relative v’s Absolute when copying formulas.
- Multiple worksheets – Inserting, Deleting, Linking,
- Charts – Creating, Editing, Formatting, Combined charts, Secondary Axis.

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

Who Should Attend?

Anyone who has a good working knowledge of MS Excel 2007 or 2010 but may never have attended formal training.

Limited free places are available for those who are unemployed. Please visit our website www.corkchamber.ie/trainingunemployed for details of eligibility and other terms & conditions, or contact Jennifer (jennifer@corkchamber.ie/021-4530141) to discuss.

Outline

Excel Basics (An Overview)

- Review of Excel Basics concentrating on quick methods of performing commonly used commands / features including an overview of Speed Keys

Formatting

- Advanced Formatting Options
- Using the Format Painter
- Deleting Formats
- Using AutoFormat
- Conditional Formatting

Viewing and Modifying Worksheets

- Zoom Setting
- Splitting a Worksheet
- Freezing Titles
- Print Titles
- Hiding and Unhiding Columns and Rows

Formulae and Functions

- Recap of Basic Formulae
- Recap of Basic Functions
- Copying Formulae
- Relative vs. Absolute cell addressing

Custom Lists

- Working with Text Lists in Excel
- Creating Custom Lists
- Incrementing Numbers & Dates

Working with Multiple Worksheets

- Switching between sheets
- Inserting /Renaming / Deleting Sheets
- Moving / Copying sheets
- Group Edit
- Linking sheets using Formulae
- Breaking links

Charts and Drawing Tools

- Creating a chart
- Changing the Chart Type
- Changing / Adding chart elements
- Formatting charts
- Moving / Resizing the chart
- Creating combined charts
- Displaying data on a secondary basis

Database Features

- Sorting Records
- Using AutoFilter

Working with Dates

- Formatting Dates
- Date Calculations
- The Today Function

Entry Requirements

This course is suitable for those who are currently using MS Excel on a regular basis but may not have attended formal training recently or may never have attended training.

Participants should have a basic working knowledge of Excel before attending this course.

About this form

The purpose of this booking form is to gather profile information about participants on programmes funded by Skillnets from the National Training Fund through the Department of Education & Skills (DES). Only aggregated participant data will be reported to the DES. Separately, Skillnets will inform the Department of Social Protection (DSP) about the attendance of individuals in receipt of income support from DSP on short courses (i.e. 20 days or less). This is part of an arrangement with the Department, which supports the participation of its clients on Skillnets programmes.

Please Note: The number of free places available on this course are limited, and may already be allocated. In filling in this form, you are requesting a place on this course as opposed to making a confirmed booking. A member of our training team will be in touch closer to the course start date to advise if we are in a position to offer you a place on this course. If we are not able to offer you a place on this course, your request will be kept on file for future courses.

As an ongoing quality control measure and to ensure the highest possible standard of training, courses may be inspected from time to time.

 

BiznetCork 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.

NDP - Education and Skills - Skillnets - Finuas

For further information please visit www.skillnets.ie


Cork Chamber©, Fitzgerald House, Summerhill North, Cork, T23 TD90, Tel: (021) 4509044, Email: info@corkchamber.ie, Company Registration Number - 13918

website design and development by esus web solutions