News & Events

Jul
12

SEPTEMBER 2010 COURSES

Please check out our E.B.C Academy Of Studies page for all 2010/2011 full time and part time day and
Jun
30

TEAM LEADING COURSE

E.B.C Academy Of Studies is running an intensive Team Leading Course accredited by the Institute Of
May
12

JUNE WEEKEND COURSES

E.B.C Academy Of Studies is running two short courses in Team Leading & Writing in Business on the 1
Mar
29

EDUCATION & CAREER PLANNING OPEN DAY

E.B.C is holding an educational and career planning open day on Friday the 16th April from 11AM to 3
View all
 
PROFESSIONAL BUSINESS TRAINING
“IT ”
Course Name : –
»  IT
»  Moving from Office 2003 to Office 2007
 
 

IT

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.