Online Knowledge ExchangeNetwork ForumsSharing Best PracticeCommunities of PracticeBusiness Forums and ConferencesTraining ScheduleApplied ResearchInnovation and LEAN Six Sigma FederationICBE Finuas NetworkWebinars
Who We Are

The Irish Centre for Business Excellence (ICBE) is a non profit organisation established by leading companies on the island of Ireland.

We are a network of organisations who demonstrate a deep commitment to Continuous Improvement and the pursuit of Business Excellence.

Our success is based on members freely sharing knowledge and actively participating in networking opportunities organised by the centre.

*Please note that you require a username and password to access the Members' Area. If you have not registered before .. click here


Members Logo
News & Events
05 Aug 2010
Transformational Change Management - Webinar
17 Aug 2010
ICBE HR Network - a dedicated forum for HR Professionals (First Event)
18 Aug 2010
2 Day Foundations Certificate in ROI
27 Aug 2010
Master of Science in Biomedical Science (via Distance Learning)
30 Aug 2010
Fundamentals of Leasing
30 Aug 2010
Certified TWI Train the Trainer Programme
31 Aug 2010
Laser Safety in the Workplace
31 Aug 2010
FETAC Train the Trainer
31 Aug 2010
Internal Quality Auditor
31 Aug 2010
Learning Technologies Event
01 Sep 2010
Transformational Change Management Event: Definitions, Challenges, Approaches with Peter DeJager
02 Sep 2010
Advanced Microsoft Excel
06 Sep 2010
UL MBA in Aviation Management
06 Sep 2010
TWI with Donald Dinero
07 Sep 2010
HR Policies & Procedures Best Practice Networking Workshop
08 Sep 2010
FETAC Safety & Health at Work (Level 5)
09 Sep 2010
Lean Executive Leadership Programme 2010
09 Sep 2010
1 Day Innovation Masterclass
10 Sep 2010
TWI Refresher workshop with Donald Dinero
13 Sep 2010
The Institute of Project Management Certified Project Management Diploma
14 Sep 2010
UL Certified Project Management
14 Sep 2010
Best Practice Site Visit to Bord na Mona
16 Sep 2010
Advanced Borrowing Techniques
16 Sep 2010
Time Management & Personal Effectiveness
21 Sep 2010
Critical Thinking for Successful Leadership
21 Sep 2010
Project Management Event with Fergus O Connell
22 Sep 2010
HR's Role in Employee Engagement to Sustain a Lean Transformation Programme
22 Sep 2010
ICBE Learning and Development Network (West) - First Event
22 Sep 2010
Creating an Innovation Roadmap for your Organisation
23 Sep 2010
Advanced Lease Finance - The Creative Financing Alternative
24 Sep 2010
Lean Executive Leadership Refresher workshop
27 Sep 2010
Lean Manufacturing Tools Programme - FETAC Level 5
27 Sep 2010
Site Visit: Ken Kreafle, Toyota Motors
28 Sep 2010
Franklin Covey Leadership programme - Great Leaders, Great Teams, Great Results
28 Sep 2010
Employment Law Update
30 Sep 2010
Lean Leadership - Professor Peter Hines
30 Sep 2010
Technical Report Writing - SQT
30 Sep 2010
Intermediate Microsoft Excel
04 Oct 2010
University of Kentucky Jishuken Room Plan
06 Oct 2010
Advanced Microsoft Excel
13 Oct 2010
FETAC Train the Trainer
20 Oct 2010
Best Practice Visit to Data Display
10 May 2011
Lean Flight Initiative Conference - LFI 2011
Advanced Microsoft Excel

Course Overview:

This Microsoft Excel Advanced Training course is a 1 Day Programme designed for candidates who would like to enhance their understanding and knowledge of Excel. It takes participants through the items listed in the course contents to a point where participants can use Microsoft Excel to increase efficiency in their everyday work.

Pre-requirements:

A good knowledge of Excel

Content

  • Importing Data from External Sources
  • Templates & Styles
  • Analysing Data
  • Pivot Tables
  • Macros and Custom Controls
  • Security and Proofing 
  • Customising Excel
  • Collboration and Consolidation

Course Outline:

Importing Data From External Sources

  • Importing Files
  • Using the Text Wizard
  • Using the Microsoft Query
  • Web Queries

Templates & Styles

  • Creating & Applying Templates
  • Creating, Applying, Editing & Deleting Styles

Analysing Data

  • What-If Analysis
  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Solver

Pivot Tables

  • Understanding Pivot Tables
  • Creating Pivot Tables
  • Modifying & Refeshing Pivot Tables
  • Grouping Data within Pivot Tables

Macros and Custom Control

  • Using Macros
  • Recording a Macro
  • Assigning a Macro to a shortcut key
  • Running Macros
  • Working with Buttons
  • Creating a New Button
  • Renaming & Formatting a Button
  • Assigning a Macro to a Button

Security and Proofing

  • Working with Security Features
  • Protecting Excel Files
  • Worksheet Protection
  • Protecting Cells
  • Digital Signatures
  • Data Validation
  • Using Text to Speech
  • Working with Comments

Customising Excel

  • View Options
  • Calculation Options
  • Edit Options
  • General Options
  • Custom Lists
  • Save Options
  • Workspaces

Collaboration and Consolidation

  • Sharing Workbooks
  • Comparing and Merging Workbooks
  • Sending Workbooks
  • Consolidation
Note: The above syllabus may change during the training course to provide more detail in aspects, which have been ascertained to be of greater value to the trainee.


06 Oct