Cork Chamber business support Cork

You are here: Home > Training > Training Courses > MS Excel (Advanced) 2007/2010

MS Excel (Advanced) 2007/2010

Start Date Thursday, 23rd November 2017
Duration 1 day
Start & Finish Time 9.30am - 5.00pm
Trainer e-Bridge
Places 5
Location Cork International Hotel, Airport Business Park
Members Fee €130.00
Non-Members Fee €170.00

Book / Request a place on this course

To book/request a place on this course, please complete the following online form.



Overview

This course is designed to follow-on from the MS Excel Intermediate course. Having already familiarised yourself with the most efficient way of performing everyday tasks, and having covered some intermediate tasks, it is now time to build on that knowledge.

A large proportion of the course is dedicated to using the Database Features in MS Excel - this is a very powerful side to Excel that not many people utilise to its fullest potential.

Useful functions such as IF and Lookups are covered in addition to automating tasks using Macros etc.

Objectives

On completion of this course participants will be proficient in the more advanced functionality of MS Excel including:

• Advanced Data Analysis – Advanced Filtering, Creating Names Ranges, Sub-Totalling feature, Database Function, Pivot Tables

• Recording Macros

• IF, Lookup and other functions

• Goal Seek & Scenario Manager

• Protecting worksheets & workbooks

Who Should Attend?

This course is designed for experienced users of MS Excel. Ideally you should have completed an Intermediate training course prior to attending this advanced programme. Please review the course outline as this is the content that will be covered on the day.

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 Aoife (aoife@corkchamber.ie/021-4530141) to discuss.

Outline

Essentials and shortcuts

- An overview / recap of some essential Intermediate topics
- Run-through of shortcuts

Named Ranges

- Creating a named range
- Redefining a named range
- Users for named ranges

Text Manipulation

- Upper / Lower / Proper Functions
- Text to columns
- Concatenation
- Trim
- Right / Left / Mid Function

Database Features

- Sorting Records
- Using AutoFilter
- Removing duplicates
- Subtotalling lists
- Database Functions - DSUM / DAVERAGE / DMAX / DMIN / DCOUNT

Working with Pivot Tables

- Pivot Table Concepts
- Setting up the Pivot Table Layout
- Refreshing Pivot Table Data
- Using PivotTable AutoFormat
- Filtering PivotTable Data
- Creating calculated fields
- Grouping dates and values

More on Functions

- Using the COUNT Functions
- Using LOOKUP Functions (Vlookup & Hlookup)
- Using the IF Function
- Using IS Functions
- Using the SUMIF Function
- Creating Formulae with Nested Functions
- PMT Function

What IF Analysis

- Using Goal Seek
- Scenario Manager

Auditing

- Using the Auditing Toolbar
- Tracing Precedents & Dependents

Macros

- Recording & Running Macros
- Assigning a Macro to the quick access toolbar

Content, Worksheet & Workbook protection

- Data validation
- Protecting Worksheets
- Protecting Workbook Access
- Assigning Password Protection
- Removing a Password
- Preventing Changes to a Workbook

Entry Requirements

A large proportion of this course is dedicated to using the Database features in MS Excel which many people don't utilise to it's full potential. It's highly recommended that you first attend Excel Intermediate prior to 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