I.T.

News & Events

Sep
07

ACCA ACCOUNTING TECHNICIAN

E.B.C is now enrolling for the ACCA Accounting Technician course beginning in October. You can apply

Sep
07

OPEN EVENING & MORNING

E.B.C is holding its open evening on Tuesday the 7th of September and an open morning on Friday the

Sep
07

LIMERICK LIVE 95 FM

E.B.C (Limerick) is currently sponsoring the Job Line on Limerick Live 95 FM. Tune in to Limerick Li

View all

PROFESSIONAL BUSINESS TRAINING

“IT ”

Course Name : –

» IT

» Moving from Office 2003 to Office 2007

Name :

Computer Applications

Level :

Level 4 B10009

Purpose :

This module is designed to enable the learner to understand the practical experience of using applications like Database, Spreadsheets and Computer Graphics. It provides an introduction to assist the learner to use a computer in a working environment.

Entry Requirements :

Level 4 Certificate, Junior Certificate or equivalent qualifications.

Learning Outcomes :

Three Units covering the following areas:

Develop Skills to Create a Database
Develop Skills to manipulate data from a spreadsheet package
Develop Skills to manipulate images using a drawing package
Develop good work habits in the use of the computer and equipment
Introduction to Spreadsheets
Introduction to Graphics

This course is currently not running.

Moving from Office 2003 to Office 2007?

Learn the differences between the 2003 and 2007 versions of Microsoft
Word/Excel/PowerPoint /Outlook
Shortcuts, Tips and Techniques
Demonstrations of all new features
Become familiar with the new user interface with practical exercises

Duration: 1 Day

(Duration may vary depending on the clients requirements)

Fee: €130 (Intermediate to Advanced)

(Prices will vary depending on clients requirements and level of training)

Workshop Date:

Excel 2007

Word 2007

PowerPoint 2007

Excel 2007 - Topics Include the following :

Introduction

Intermediate

Advanced

Getting Started/Excel Window
The office button
The Ribbon
Quick Access Toolbar
Opening and Closing Workbooks
Navigating a Worksheets
Entering and Editing Data
Inserting/Deleting/Resizing
Rows & Columns
Copy/Cut/Paste Commands
Undo/Redo Commands
Selecting Ranges of Cells
Formatting Cells
Adding Borders
Formatting Numbers
Formatting Tables
Creating Simple Formulas
Working with Basic Functions
Relative and Absolute Addresses
Print Setup
Printing Workbooks
Saving
Using Excel Help Function

Recap on Basics Features
Using Multiple Worksheets
Formatting Techniques
Basic IF Statements
Nested IF Statements
Functions & Formulas
Applying Conditional Formatting
Sorting Columns
Creating Templates
Inserting Shapes/Diagrams etc
Creating Charts & Graphs
Using Keyboard Shortcuts
Charts and Graphs
List Management
Using Comments
Working with Large Data
Hiding data
Freezing Panes
Split Cells

Working with Advanced Formulas
Database Functions
Creating Lookups
Creating Subtotals
Cell Validation
Cell Protection/Security
Working with Pivot Tables
What If Analysis
Creating Data Tables
Creating Scenarios
Performing Goal Seeking
Working with Macros
Consolidating Data
Excel with other applications
Linking and Embedding Text Files
Tips to use Excel Efficiently
Excel Keyboard Shortcuts

Word 2007 – Topics Include the following :

Introduction

Intermediate

Advanced

Getting Started/Word Window
The Office Button
The Ribbon
Quick Access Toolbar
Creating a New Document
Saving a Document
Opening a Document
Scroll Bars and Views
Create and Edit Documents
Spelling and Grammar Check
Undo/Redo
Select and Format Text
Format Paragraphs
Ruler and Indentation
Using Tabs
Clipboard – Copy/Cut/Paste
Format Painter
Inserting /Formatting Tables
Print Setup
Printing a Document
Close and Exit Word
Using Word Help Function

Recap on Basic Features
Working with Multiple Documents
Formatting Techniques
Find & Replace
Page Breaks
Hyphenation
Tabs
Multi Level Lists
Creating Columns
Modifying & Formatting Tables
Applying Styles
Using Installed Templates
Creating Templates
Inserting Borders
Inserting Pictures/Clip
Art/Shapes/Smart Art/Charts
Using Headers and Footers
Mail Merge
Reviewing Documents
Inserting Special Characters

Adding Hyperlinks
Working with Macros
Word with other applications
Creating Forms
Table formulas in Word
Using Watermarks
Working with Larger Documents
Creating Table of Contents
Inserting an Index
Inserting Footnotes/Endnotes
Inserting Captions
Inserting Bookmarks
Cross References
Citations
Bibliographies
Adding Hyperlinks to a document
Word Keyboard Shortcuts

PowerPoint 2007 – Topics Include the following :

Introduction

Intermediate

Advanced

Getting Started/PowerPoint Window
The office button
The Ribbon
Quick Access Toolbar
Starting a new Presentation
Saving a Presentation
Creating new presentations
Inserting new slides
Different Views
Formatting
Rearranging /Deleting/Copying slides
Formatting Slides
Inserting pictures/clip
art/shapes/smart art/charts
Inserting Tables
Slide Transitions
Running Presentations
Printing & Saving Presentations

Recap on Basic Features
Format Backgrounds
Adding Text boxes
Master Slides
Creating a photo Album
Re Colouring
Cropping clip art and images
Media Clips
Inserting a sound file
Inserting a movie clip
Animation Effects
Slide Show Manipulation
Using Installed Templates
Creating Templates
Charts and Flow Charts
Using Speaker notes

Custom Slide Shows
Voice Narration
Rehearsing a presentation
Inserting/Editing/ Deleting Comments
Modify Notes Master
Modify Hand out Master
Customising a Slideshow
Using Slide Show menu tools
Packaging a presentation for CD
Exporting Notes & Handouts
Working with Macros
Linking and Embedding Objects
Presentation Techniques
Presentation Keyboard Shortcuts

Training is provided in Office 2003 or Office 2007. and is also supplied on individual applications for example, Word, Excel, PowerPoint etc. which ever suits the clients needs.

Above is a sample of areas covered and additional items can be covered between beginners to advanced levels from each application to customize your training needs. This list is subject to change depending on training requirements of the client.