Professionally upskill with one of the below Microsoft courses on a day, evening or Saturday course
Details of this course are available upon request. Please click here for our contact details.
Word is the word processing package from Microsoft and is without a doubt the most widely used word processing software today. Being able to type up your own letters is one thing but being able to apply some of the powerful functionality that it brings will enable users to produce the kind of professional documents that are expected in today's competitive business environment. The course comes in 3 levels. Level 1 is for beginners and covers mainly basic word processing functions. Level 2 is for people who currently use Word but would like to advance their skills further and Level 3 is for users who really want or need to develop their skills to use the more powerful features of Word such as using hyperlinks, recording macros and managing long documents
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
LESSON 2: BASIC EDITING
Word is the word processing package from Microsoft and is without a doubt the most widely used word processing software today. Being able to type up your own letters is one thing but being able to apply some of the powerful functionality that it brings will enable users to produce the kind of professional documents that are expected in today's competitive business environment. The course comes in 3 levels. Level 1 is for beginners and covers mainly basic word processing functions. Level 2 is for people who currently use Word but would like to advance their skills further and Level 3 is for users who really want or need to develop their skills to use the more powerful features of Word such as using hyperlinks, recording macros and managing long documents
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
| Course content: LESSON 1: GETTING TO KNOW WORD
|
|
LESSON 2: BASIC EDITING
- Cut, Copy & Paste
- Clipboard
- Delete/Insert Text
- AutoCorrect
- AutoText
- Smart Tags
- Spell Check
- Fonts
- Bullets & Numbering
- Paragraph
- Borders & Shading
- Format Painter
- Creating
- Formatting
- Sorting
- Headers & Footers
- Page Set-Up
- Print Preview
- Margins
- FormLetters
- Labels
- Envelopes
- Emails
Word is the word processing package from Microsoft and is without a doubt the most widely used word processing software today. Being able to type up your own letters is one thing but being able to apply some of the powerful functionality that it brings will enable users to produce the kind of professional documents that are expected in today's competitive business environment. The course comes in 3 levels. Level 1 is for beginners and covers mainly basic word processing functions. Level 2 is for people who currently use Word but would like to advance their skills further and Level 3 is for users who really want or need to develop their skills to use the more powerful features of Word such as using hyperlinks, recording macros and managing long documents
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
LESSON 2 : EDITING TEXT
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
|
Course Content:
|
|
- Cut, Copy & Paste
- Clipboard
- Delete/Insert Text
- AutoCorrect
- AutoText
- Smart Tags
- Keyboard ShortCuts
LESSON 3 : FORMATTING
- AutoFormat
- Bullets & Numbering
- Paragraph
- Borders & Shading
- Format Painter
LESSON 4 : TABLES
- Creating
- Formatting
- Sorting
- Calculations
- Positioning
LESSON 5 : TEMPLATES
- Creating a Template
- Styles
LESSON 6 : LONG DOCUMEN
- Page Numbering
- Headers & Footers
- Footnotes & Endnotes
- Inserting Special Characters
LESSON 7 : MAIL MERGE
- FormLetters
- Labels & Envelopes
- Queries & Filtering
- Emails
LESSON 8 : GRAPHICS
- WordArt
- ClipArt
- Pictures
- Graphs
- Linking & Embedding between applications
Training can be held nationwide or at our training centre in Donnybrook
Details of this course are available upon request. Please click here for our contact details.
Level 3 is for users who want or need to develop their skills to use the more powerful features of Word such as using hyperlinks, recording macros and managing long documents.
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
LESSON 2 : LONG DOCUMENTS
Level 3 is for users who want or need to develop their skills to use the more powerful features of Word such as using hyperlinks, recording macros and managing long documents.
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
|
Course Content:
|
|
- Using Styles
- Section Breaks
- Page Numbering
- Creating a Table of Contents
- Creating an Index
- Hyperlinks
- Outline View
- Master Documents
LESSON 3 : REFERENCES
- Captions
- Footnotes & Endnotes
- Bookmarks & Cross-references
LESSON 4 : MACROS
- Recording
- Running
- Editing
- Storing
LESSON 5 : FORMS
- Using Tabs
- Using Tables
- Forms Toolbar
- Saving as Template
- Protecting Forms
LESSON 6 : GRAPHICS
- Editing Graphics
- Watermarks
- Text Boxes
- Charts
- Linking & Embedding between applications
LESSON 7: MARKUP TOOLS
- Versions
- Comments
- Reviewing Toolbar
Details of this course are available upon request. Please click here for our contact details.
Excel is a very powerful spreadsheet package used for many applications including data analysis.
If you want to store data, maintain accounts or analyse figures using formulae, then this course is for you. Excel is ideal if you are heavily involved in Budgeting/Forecasting or if you work with a large amount of product codes..
Pre-requisistes:
It is advised that delegates complete a pre course questtionaire (downloadable here) in order to asses their specific level thus managing delegates expectations
WORKING WITH WORKSHEETS
Excel is a very powerful spreadsheet package used for many applications including data analysis.
If you want to store data, maintain accounts or analyse figures using formulae, then this course is for you. Excel is ideal if you are heavily involved in Budgeting/Forecasting or if you work with a large amount of product codes..
Pre-requisistes:
It is advised that delegates complete a pre course questtionaire (downloadable here) in order to asses their specific level thus managing delegates expectations
|
Course content:
|
|
- Entering Data
- Selecting Cells
- AutoComplete
- AutoCorrect
- Smart Tags
MANAGING WORKSHEETS
- Moving & Copying Worksheets
- Saving Files
- Closing Excel
- Document Workspaces
IMPROVING THE LOOK OF YOUR DATA
- Formatting Rows & Columns
- Formatting Numbers
- Formatting Text
- Applying Borders
- Alignment
- Autoformat
Training courses can be held nationwide or at our training centre in Donnybrook.
Excel is a very powerful spreadsheet package used for many applications including data analysis.
If you want to store data, maintain accounts or analyse figures using formulae, then this course is for you. Excel is ideal if you are heavily involved in Budgeting/Forecasting or if you work with a large amount of product codes..
Pre-requisistes:
It is advised that delegates complete a pre course questtionaire (downloadable here) in order to asses their specific level thus managing delegates expectations
MANAGING WORKSHEETS
If you want to store data, maintain accounts or analyse figures using formulae, then this course is for you. Excel is ideal if you are heavily involved in Budgeting/Forecasting or if you work with a large amount of product codes..
Pre-requisistes:
It is advised that delegates complete a pre course questtionaire (downloadable here) in order to asses their specific level thus managing delegates expectations
|
Course Content:
|
|
- Moving , Copying & Renaming Worksheets
- Templates
- Linking Worksheets
- Comparing WorkSheets
- Document Workspace
IMPROVING THE LOOK OF YOUR DATA
- Autoformat
- Using Styles
- Conditional Formatting
PRINTING
- Headers & Footers
- Page Set-Up
- Page Break Preview
- Print Preview
- Margins
DATABASE & LIST MANAGEMENT
- Sorting Data
- AutoFilter
- Subtotals
- Data Forms
Training can be held nationwide or at our training centre in Donnybrook
Details of this course are available upon request. Please click here for our contact details.
Excel is a very powerful spreadsheet package used for many applications including data analysis.
It gives professionals the tools to manage critical business data and everyday users the power to get the most out of their information.
Pre-requisites:
It is advised that delegates complete a pre course questionnaire (downloadable here) in order to asses their specific skill level thus allowing us to manage their expectations manage delegates expectations.
Excel is a very powerful spreadsheet package used for many applications including data analysis.
It gives professionals the tools to manage critical business data and everyday users the power to get the most out of their information.
Pre-requisites:
It is advised that delegates complete a pre course questionnaire (downloadable here) in order to asses their specific skill level thus allowing us to manage their expectations manage delegates expectations.
|
Course Content:
|
|
CREATING LINKS TO OTHER APPLICATIONS
- Embedding & Linking Objects
- Hyperlinks
- Managing Links
TEMPLATES
- Using, Creating & Applying Templates
SUMMARISE & ANALYSE DATA USING PIVOTTABLE REPORTS
- PivotTable Reports
- PivotChart Reports
ANALYSING DATA
- What-If Analysis
- Goalseek
- Data Tables
- Scenario Manager
- Solver
MACROS & CUSTOM CONTROLS
- About Macros
- Creating & Running Macros
- Assigning Buttons To Macros
- Adding Custom Controls
SECURITY & PROOFING
- Protecting Excel Files
- Cell & Worksheet Protection
- Digital Signatures
- Data Validation
- Documentation
CUSTOMISING EXCEL
- Configuring Excel Options
- Customising The Excel Environment
- Workspaces
COLLABORATION & CONSOLIDATION
- Sharing Workbooks
- Sending Workbooks
Training can be held nationwide or at our training centre in Donnybrook
Details of this course are available upon request. Please click here for our contact details.
PowerPoint is a presentation graphics program. Jefferson provides training that will help make you create attention-grabbing slides and shows with ease, collaborate with team members on your presentations, and share them live or online.
The course comes in 2 levels and is suitable for people who have to make eye-catching or simply informative and objective presentations regularly. Level 1 is for beginners and introduces the user to understanding presentations, slides, layout and transitions. Level 2 takes it a step further by teaching presenters about the slide master, templates, automated shows and linking.
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
Training can be held nationwide or at our training centre in Donnybrook
PowerPoint is a presentation graphics program. Jefferson provides training that will help make you create attention-grabbing slides and shows with ease, collaborate with team members on your presentations, and share them live or online.
The course comes in 2 levels and is suitable for people who have to make eye-catching or simply informative and objective presentations regularly. Level 1 is for beginners and introduces the user to understanding presentations, slides, layout and transitions. Level 2 takes it a step further by teaching presenters about the slide master, templates, automated shows and linking.
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
|
Course Content:
|
|
Details of this course are available upon request. Please click here for our contact details.
PowerPoint is a presentation graphics program. Jefferson provides training that will help make you create attention-grabbing slides and shows with ease, collaborate with team members on your presentations, and share them live or online.
The course comes in 2 levels and is particularly suitable for people who have to make eye-catching or simply informative and objective presentations regularly. Level 1 is for beginners and introduces the user to understanding presentations, slides, layout and transitions. Level 2 takes it a step further by teaching presenters about the slide master, templates, automated shows and linking.
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
PowerPoint is a presentation graphics program. Jefferson provides training that will help make you create attention-grabbing slides and shows with ease, collaborate with team members on your presentations, and share them live or online.
The course comes in 2 levels and is particularly suitable for people who have to make eye-catching or simply informative and objective presentations regularly. Level 1 is for beginners and introduces the user to understanding presentations, slides, layout and transitions. Level 2 takes it a step further by teaching presenters about the slide master, templates, automated shows and linking.
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
Course content*
|
|
Training can be held nationwide or here in our training centre in Donnybrook
Pre requisites:
Details of this course are available upon request. Please click here for our contact details.
Overview
Access is a powerful database software package from Microsoft. Whether you are a beginner or experienced programmer, you can learn to build powerful, customisable solutions that integrate easily with the Web and enterprise data sources.
"The course comes in 2 levels. Level 1 is for beginners and introduces the user to understanding databases, tables, relationships and the terminology used. Level 2 is for more experienced users and develops their knowledge further by teaching users to cross tab and action queries, incorporate graphs, macros and learn advanced form and report design".
Computer training courses can be held on site anywhere in Ireland or at our comprehensive facility in Donnybrook Dublin
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
Overview
Access is a powerful database software package from Microsoft. Whether you are a beginner or experienced programmer, you can learn to build powerful, customisable solutions that integrate easily with the Web and enterprise data sources.
"The course comes in 2 levels. Level 1 is for beginners and introduces the user to understanding databases, tables, relationships and the terminology used. Level 2 is for more experienced users and develops their knowledge further by teaching users to cross tab and action queries, incorporate graphs, macros and learn advanced form and report design".
Computer training courses can be held on site anywhere in Ireland or at our comprehensive facility in Donnybrook Dublin
Pre requisites:
It is advised that delegates complete a pre course questtionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
|
Course content
|
|
Details of this course are available upon request. Please click here for our contact details.
Overview
Access is a powerful database software package from Microsoft. Whether you are a beginner or experienced programmer, you can learn to build powerful, customisable solutions that integrate easily with the Web and enterprise data sources.
"The course comes in 2 levels. Level 1 is for beginners and introduces the user to understanding databases, tables, relationships and the terminology used. Level 2 is for more experienced users and develops their knowledge further by teaching users to cross tab and action queries, incorporate graphs, macros and learn advanced form and report design".
Computer training courses can be held on site anywhere in Ireland or at our comprehensive facility in Donnybrook, Dublin.
Pre requisites:
It is advised that delegates complete a pre course questionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
Importing and Linking Data
Overview
Access is a powerful database software package from Microsoft. Whether you are a beginner or experienced programmer, you can learn to build powerful, customisable solutions that integrate easily with the Web and enterprise data sources.
"The course comes in 2 levels. Level 1 is for beginners and introduces the user to understanding databases, tables, relationships and the terminology used. Level 2 is for more experienced users and develops their knowledge further by teaching users to cross tab and action queries, incorporate graphs, macros and learn advanced form and report design".
Computer training courses can be held on site anywhere in Ireland or at our comprehensive facility in Donnybrook, Dublin.
Pre requisites:
It is advised that delegates complete a pre course questionaire ( downloadable on the site) in order to asses their specific level thus managing delegates expectations
|
Course content:
|
|
- Import data from different sources
- Linking to a Spreadsheet
- Linking tables in other databases
Relationships and Referential Integrity
- Relationships
- Set a default join type for a relationship
- Using Find Unmatched and Find Duplicates Query
- Using Lookup fields for referential integrity
Business Rules
- Set Field properties
- Creating input masks
- Setting validation rules
- Data type usage
- Advanced Queries
- Multiple criteria in a query
- Using indexes to optimise queries
- Parameter queries
- Totals queries
- Calculations in queries
- Summary queries
- Crosstab queries
- Action queries
Advanced Form Design
- Using the Toolbox to add controls to a form
- Edit form sections
- Changing properties of Form controls
- Inserting graphics to Forms
- Creating subforms
Advanced Report Design
- Change the properties of Report objects
- Inserting Graphs to a report
- Sorting and Grouping options
- Edit report sections
- Creating Subreports
Access and the Internet - Data Access Pages
- What is a DAP
- Create a DAP
- Connect to a data source
- Edit a DAP
Details of this course are available upon request. Please click here for our contact details.
OFFICE 2007 OVERVIEW WITH MS WORD, EXCEL, POWERPOINT, ACCESS & OUTLOOK
MS WORD OVERVIEW
OFFICE OVERVIEW
|
Course content: The main changes:
|
|
- The Office Button in MS Word
- The Ribbon
- The Mini Toolbar
- The Quick Access Toolbar
- The Tabs
- Formatting
- Quick Styles
- The Insert Tab
- The Review Tab
- Page Layout Options
- Word Options
- The New file formats
- Saving in different formats
MS EXCEL OVERVIEW
- The Office Button in MS Excel
- The New View
- The New Features
- A Run through the tabs
- Formatting
- Formulas
- Objects
- Tables
- Working with Data Lists
- Pivot Tables
- The New File Formats
- Compatibility Mode
- File Conversions
- Excel Options
MS POWERPOINT OVERVIEW
- Opening and Saving Presentations
- Views
- Slide Designs and backgrounds
- Slide Layouts
- Word Art
- Smart Art
- Shapes and Pictures
- Charts
- Animations
- Transitions
MS ACCESS OVERVIEW
- Creating and Saving Databases
- Creating and Editing Tables
- Table relationships
- Queries
- Forms / Reports
MS OUTLOOK OVERVIEW
- Enhanced Search
- Creating and Sending Messages
- Attachment Preview
- Categorising and Flagging
- To Do Bar
- Calendar
- Contacts
- Electronic Business Cards
