IT / Computer Courses

Your placement cannot be guaranteed until full payment has been made or funding has been approved

ECDL Part-time Courses ECDL 5 Day Course ECDL Online Self Study Course Touch Typing & Keyboard Skills Touch Typing & Keyboard Skills for Children & Students MOS Word Specialist 3 Day Course MOS Excel Specialist 3 Day Course MOS PowerPoint Specialist 2 Day Course I.T. Skills & Digital Literacy Absolute Beginners Computers Create Documents, Web & Emails MOS Excel Specialist 2 Day Course
  • ECDL Part-time Courses

    ECDL (European Computer Driving Licence Course)
    Need to learn computer and Internet skills to get that job? Move ahead in your career?

    Return to education? Or maybe start that little business you have always dreamt of?

    Whatever your goal in work, education or life, ECDL can help you get there.

    Move forward with the world’s most popular IT user certification.

    • ECDL is the certification most widely recognised and highly valued by Irish employers
    • ECDL equips you with practical computer and Internet skills.
    • ECDL offers you a wide range of subject modules.
    • ECDL offers flexible study options, including online learning.
    Do this to keep up with all the changes in Microsoft Office. Ideal as a refresher or a back to work or college course.

  • This extremely popular course consists of 7 subjects called Modules.

    Module 1 - Computer Essentials:
    Discover the essential concepts and skills relating to the use of devices, file creation and management, networks, and data security. This Module covers everything from hardware to software to malware .

    Module 2 - Online Collaboration: Discover the concepts and skills relating to the setup and use of online collaborative tools, such as storage, productivity applications, calendars, social media, web meetings, learning environments, and mobile technology.

    Module 3 - Word Processing: Learn how to use word processing software to accomplish everyday tasks. Discover how to create and format letters and short documents, work with different page sizes, control font and other settings, and insert images in a document

    Module 4 - Excel / Spreadsheets: Discover how to develop, modify and use a spreadsheet for typical data management and analysis tasks. Learn how to use formulas and functions for performing calculations, and create graphs and charts based on spreadsheet data.

    Module 5 - PowerPoint / Presentations: Learn how to create, format, modify and prepare presentations for display and printed distribution. Discover how to create presentation templates, control fonts and background settings, and insert tables, images and charts.

    Module 6 - Access / Databases: Gain the knowledge and skills to create and modify tables, queries, forms and reports. Learn how to relate tables, and how to retrieve and manipulate information from a database by using query and sort tools.

    Module 7 - Online Essentials: Learn about security and safety on the web, and about online communities and communications. This new ECDL Module covers the basics of going online, including web browsing, effective search engine use, online communication and email.
  • As part of this course you will receive the following training materials:

    • Access to Pery Square College training videos & notes
    • ECDL tutorials
    • 7 practice tests - 1 for each module
    • 7 exams - 1 for each module
    • Skills Card & Certificate on successful completion
  • To complete this course successfully you must have good basic computer skills and knowledge of Word Processing with saving, formatting text, cut/copy/paste and also good use of Internet & Email.
    If unsure please ring the college and speak to a trainer who can assess your suitability.

    We currently run this ECDL Course with Microsoft Office 2016.


    You MUST have access to a laptop or PC with Microsoft Office 2016 installed in order to complete the online learning and sample practice tests. 
    (Please try family, friends or local Library if you do not have this software)

    *
    In order to successfully complete this course, the learner is expected to supplement the instructor led training with self-directed learning between classes. An attendance rate of 90% is required in order to ensure that the certification standard can be achieved.
  • You will do an online test after completing each module/subject and practicing a sample test.
    A 45 minute online test will be taken at the end of each of the 7 modules.

    All Tests are Automated Online Exams, with instant marking notification.

    * subject to pass mark of 75% or more

    Certification: European Computer Driving Licence (ECDL)

    It is recommended that even if you have an existing ECDL certificate that you update your skills every 5 years at a minimum.
  • ECDL 5 Day Course

    ECDL (European Computer Driving Licence Course)
    This is an intensive 5 Day ECDL Course suitable for those who need to get an I.T. Certificate in a short period of time.

    Need to prove your I.T. skills in order to get that job, or move ahead in your career, Return to education or maybe start that business you have always dreamt of?

    Whatever your goal in work, education or life, ECDL can help you get there. This certification proves your ability to use the important aspects of Microsoft Office.

    Move forward with the world’s most popular IT user certification.

    • ECDL is the certification most widely recognised and highly valued by Irish employers - 85% required these Skills!
    • ECDL equips you with practical Digital Literacy Skills & updates you on the changes in Microsoft Office
    • ECDL offers you a wide range of knowledge e.g. Word, Excel, PowerPoint, Databases, Online communication & Storage etc.
    • ECDL offers flexible study options, online learning is included in this course.
    Funding Available for Jobseekers - Ask your Intreo Officer/Social Welfare about a TESG Form to see if you are eligible.

  • This extremely popular course consists of 7 subjects called Modules.

    Module 1 - Computer Essentials:
    Discover the essential concepts and skills relating to the use of devices, file creation and management, networks, and data security. This Module covers everything from hardware to software to malware .

    Module 2 - Online Collaboration: Discover the concepts and skills relating to the setup and use of online collaborative tools, such as storage, productivity applications, calendars, social media, web meetings, learning environments, and mobile technology.

    Module 3 - Word Processing: Learn how to use word processing software to accomplish everyday tasks. Discover how to create and format letters and short documents, work with different page sizes, control font and other settings, and insert images in a document

    Module 4 - Excel / Spreadsheets: Discover how to develop, modify and use a spreadsheet for typical data management and analysis tasks. Learn how to use formulas and functions for performing calculations, and create graphs and charts based on spreadsheet data.

    Module 5 - PowerPoint / Presentations: Learn how to create, format, modify and prepare presentations for display and printed distribution. Discover how to create presentation templates, control fonts and background settings, and insert tables, images and charts.

    Module 6 - Access / Databases: Gain the knowledge and skills to create and modify tables, queries, forms and reports. Learn how to relate tables, and how to retrieve and manipulate information from a database by using query and sort tools

    Module 7 - Online Essentials: Learn about security and safety on the web, and about online communities and communications. This new ECDL Module covers the basics of going online, including web browsing, effective search engine use, online communication and email

    Assessment: You will do an online test after completing each module/subject and practicing a sample test.
    A 45 minute online test will be taken at the end of each of the 7 modules.

    All Tests are Automated Online Exams, with instant marking notification

    * subject to pass mark of 75% or more


    Certification: European Computer Driving Licence (ECDL)

    It is recommended that even if you have an existing ECDL certificate that you update your skills every 5 years at a minimum.

  • As part of this course you will receive the following training materials:

    • Access to Pery Square College training videos & notes
    • ECDL tutorials
    • 7 practice tests - 1 for each module
    • 7 exams - 1 for each module
    • Skills Card & Certificate on successful completion


    {tab Who Should Attend}

    • If you are looking for work
    • Need new I.T. Skills for a job promotion
    • Anyone applying for the public service or the Gardai
    • Anyone going to college
  • To complete this course successfully you must be proficient in computers, working knowledge of Word Processing with saving, formatting text, cut/copy/paste and also good use of Internet & Email.
    If unsure please ring the college and speak to a trainer who can assess your suitability.
    We currently run this ECDL Course with Microsoft Office 2016.

    You should have access to a laptop or PC with Microsoft Office 2016 installed in order to complete the online learning and sample practice tests. (Please try family, friends or local Library if you do not have this software)

    *In order to successfully complete this course, the learner is expected to supplement the instructor led training with self-directed learning between classes. An attendance rate of 90% is required in order to ensure that the certification standard can be achieved.

  • ECDL Online Self Study Course

    ECDL (European Computer Driving Licence Course)

    Need to learn computer and Internet skills to get that job? Move ahead in your career?
    Return to education? Or maybe start that little business you have always dreamt of?

    Whatever your goal in work, education or life, ECDL can help you get there.
    Move forward with the world’s most popular IT user certification.

    • ECDL is the certification most widely recognised and highly valued by Irish employers
    • ECDL equips you with practical computer and Internet skills.
    • ECDL offers you a wide range of subject modules.
    • ECDL offers flexible study options, including online learning.
    Included in price: Access to Notes, our own training videos and Online Learning, Test & sample tests for each module.

    Do this to keep up with all the changes in Microsoft Office. Ideal as a refresher or a back to work or college course.

  • This extremely popular course consists of 7 subjects called Modules.

    Module 1 - Computer Essentials:
    Discover the essential concepts and skills relating to the use of devices, file creation and management, networks, and data security. This Module covers everything from hardware to software to malware .

    Module 2 - Online Collaboration: Discover the concepts and skills relating to the setup and use of online collaborative tools, such as storage, productivity applications, calendars, social media, web meetings, learning environments, and mobile technology.

    Module 3 - Word Processing: Learn how to use word processing software to accomplish everyday tasks. Discover how to create and format letters and short documents, work with different page sizes, control font and other settings, and insert images in a document.

    Module 4 - Excel / Spreadsheets: Discover how to develop, modify and use a spreadsheet for typical data management and analysis tasks. Learn how to use formulas and functions for performing calculations, and create graphs and charts based on spreadsheet data.

    Module 5 - PowerPoint / Presentations: Learn how to create, format, modify and prepare presentations for display and printed distribution. Discover how to create presentation templates, control fonts and background settings, and insert tables, images and charts.

    Module 6 - Access / Databases: Gain the knowledge and skills to create and modify tables, queries, forms and reports. Learn how to relate tables, and how to retrieve and manipulate information from a database by using query and sort tools.

    Module 7 - Online Essentials: Learn about security and safety on the web, and about online communities and communications. This new ECDL Module covers the basics of going online, including web browsing, effective search engine use, online communication and email
  • As part of this course you will receive the following training materials:

    • Online access to Pery Square College training videos & notes
    • ECDL tutorials
    • 7 practice tests - 1 for each module
    • 7 exams - 1 for each module
    • Skills Card & Certificate on successful completion

  • To complete this course successfully you must have good basic computer skills and knowledge of at least Word Processing with saving, formatting text, cut/copy/paste and also good use of Internet & Email.
    If unsure please ring the college and speak to a trainer who can assess your suitability.

    ECDL Online Learning is available for Microsoft Office 2010, 2013 or 2016.


    You MUST have access to a Laptop or PC with a relevant Microsoft Office version (see above) installed in order to complete the online learning and sample practice tests at home.

    Contact college to arrange setup and introduction to your ECDL Learning Software.

    YOU MUST INFORM US WHEN BOOKING WHAT VERSION OF MICROSOFT OFFICE YOU WILL BE USING.


    Resits (if you fail a test) and extra sample tests available at extra cost.
  • You will complete an online test for each of the 7 ECDL Modules which must be taken at Pery Square Business College. You will have 45 minutes to complete each online test. Exams held on Friday Afternoons from 2pm - Must book in Advance.

    All Tests are Automated Online Exams, with instant marking notification.

    * subject to pass mark of 75% or more

    Certification: European Computer Driving Licence (ECDL) on successful completion of all 7 Modules.

    It is recommended that even if you have an existing ECDL certificate that you update your skills every five years at a minimum.
  • touch-typing-keyboard-skills

    Touch typing is now a skill that everyone can and should learn.
    Most of the tasks that we used to perform with a pen and a pad of paper are now being done on our computers, laptops and Tablets. Everything from sending emails, writing reports, college assignments, even scheduling our workdays is digital.

    If you spend a significant amount of time at a desk, in front of a computer then you probably know that sitting and typing can take a toll on your body. Achy shoulders, stiff neck and sore wrists are some of the side effects of poor posture and bad computer habits. As you learn the proper way to sit and cultivate better habits, your arms and shoulders will relax and your energy levels will stay consistent throughout the day. Touch typing isn’t just about increasing your typing speed and reducing errors, it’s about adopting healthy computer habits to reduce the risk of injury and provide increased comfort.

    It is time to STOP Typing with 2 Fingers & START Typing more efficiently.

  • Initially you will learn in the first 5 lessons which finger hits each of the letters on the keyboard and following this you will commence our typing tutor software for the remaining 15 lessons to progress with your speedbuilding and accuracy to reach a minimum of at least 20 words per minute.

    At the end of the course you will receive your Touch Typing certificate.

    You can also book follow-on Speedbuilding and Audio Typing/Digital Transcription courses if you wish to progress. Both of these are priced at €10 per hour.
  • Touch typing is now a skill that everyone can and should learn.

    Anyone who uses a Computer or Laptop for tasks throughout the day or if you are hoping to make a career in administration or enter college.
  • Applicants must have Basic computer skills
  • touch-typing-keyboard-skills-for-children-students

    Every Child and Student should know their way around a Computer Keyboard as they will spend a lot of time on it either with assignments or emails. Later for work or college this is a beneficial skill that will always stick with them and give them a compeditive advantage.

    This course provides Touch Typing lessons and instructions by a tutor and Typing instructor program. This course can be started any time that is suitable for you and the college. It is run in 1 hour sessions preferably 3 times per week or more.

  • Initially you will be drilled 5 times by an instructor to teach you the placement of fingers on the keyboard and then you can come in at your own convenience to train yourself with 15 speedbuilding and accuracy sessions on a typing tutor software.

    After the course has finished you will have 2 more months to improve your speed and when you come to collect your certificate your speed will be tested again and certified.
  • The aim of this course is to teach touch typing skills and improve typing speeds. You will learn by memory where all the letters are located on the keyboard and what fingers look after which keys all without looking at your fingers or the keyboard at all. The workload is divided up between all fingers and emphasis is put on correct posture when spending time on a computer. Speeds of 15-20 words per minute are a minimum expectation at the end of this course and with sufficient effort and practice higher speeds are easily achieved.
  • Applicants must have:
    • Basic computer skills
  • mos-word-specialist-3-day-course

    Microsoft Office Specialist - Word
    Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their skills and advance their careers.

    Microsoft Word is the most commonly used word-processing tool in the business world, but its functionality is often under-used. Our course will give you or your staff the skills needed to use Word to its full potential and create better documents in less time.

    The ability to efficiently produce proposals, reports and a host of other business documents is an extremely valuable and transferable business skill. Such documents are used on a daily basis and the ability to write succinct documents enhances professional reputations and relationships.

    This course is designed to advance existing Word users and help them take advantage of the powerful features available in Word.

  • Getting Started with Word

    • Exploring the Word window
    • Using Standard/Personalised Menus
    • Using the Office Assistant
    Editing a Document

    • Inserting Text in a Document
    • Selecting, Deleting and Restoring Text
    • Creating a Folder/Saving alternatively named files
    Working with Tables

    • Inserting a Table/Merging Table Cells
    • Inserting and Deleting Columns & Rows
    • Resizing /Adding Shading/Modifying Borders
    Formatting Text

    • Aligning, Moving and Copying Text/Applying Styles
    • Creating a Paragraph Border, Adding Shading
    • Previewing/Printing a Document
    Using Automated Formatting

    • Setting AutoFormat Options/ Borders
    • Create Automatic Bulleted/Numbered List
    • Multiple Attributes with Format Painter
    • Creating/Inserting an AutoText Entry
    • Creating and Printing a Mailing List
    Using Editing and Proofing Tools

    • Checking Spelling/Grammar/Thesaurus
    • Finding/Replacing Specific Text
    • Creating AutoCorrect Entries & Exceptions
    • Inserting Date & Time, Special Characters
    Working with Graphics

    • Insert a Picture from a File/Clipart Gallery
    • Creating WordArt/Drawing a Shape/Resizing
    Working with Columns

    • Creating Columns, changing Column Width
    • Inserting a Column Break/Vertical Lines
    Using Templates and Wizards

    • Using a Word Template
    • Creating your own Template
    • Using a Wizard
    Word and the Web

    • Inserting a Hyperlink to a Web Page
    • Sending a Document as an E-mail Message
    • Saving or viewing as a Web Page
  • The course is geared towards users requiring a detailed knowledge of the package in order to produce professional publications and further streamline and automate repetitive office tasks.

    Microsoft Office Specialist certification gives you the tools to build a brighter future.

    Achieve industry-recognized certification
    Learn the computing skills companies are looking for
    Boost your workforce resume
    Differentiate yourself from other applicants
    Gain valuable experience and confidence
    Heighten your earning potential
    Prepare yourself for a successful future.
  • Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, Viewing System Information.

    You must have completed ECDL or other similar training course and have good working knowledge of Microsoft Word Processing.
  • mos-excel-specialist-3-day-course

    Microsoft Office Specialist - Excel
    Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their skills and advance their careers.

    Microsoft Excel is perhaps the most important computer software program used in the workplace today. That's why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.

    This course is aimed at participants who wish to gain an industry qualification in the Excel environment.

    Candidates will demonstrate the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects.

  • Learning Worksheet Fundamentals

    • Creating Workbooks
    • Magnifying and Shrinking a Worksheet on Screen
    • Understanding MS Excel Window Environment
    • Hiding and Unhiding Rows & Columns
    • Selecting a Range of Cells
    • Freezing and Unfreezing Rows & Columns
    • Entering Text/Numbers/Dates in a Worksheet
    • Moving Between Worksheets in a Workbook
    • Entering a Range of Data
    • Adding and Deleting Worksheets in a Workbook
    • Editing Cell Contents
    • Creating a Three-Dimensional Formula
    • Moving Between Worksheets
    • Linking Workbooks
    • Naming and Saving Workbooks
    • Opening Workbooks
    • Renaming Worksheets
    • Closing Workbooks and Quitting Excel

    Editing and Formatting Worksheets

    • Formatting Numbers
    • Creating Charts Using the Chart Wizard
    • Adjusting the Size of Rows and Columns
    • Moving/Resizing/Deleting Charts
    • Aligning Cell Contents
    • Modifying Chart Titles and Adding Axis Labels
    • Creating and Applying Conditional Formats
    • Moving and Formatting Chart Elements
    • Finding and Replacing Cell Content
    • Changing the Chart Type & Organising Source Data
    • Inserting and Deleting Cells/Rows/Columns
    • Updating Data and Formatting the Axes
    • Cutting/Copying/Pasting/Clearing Cells
    • Adding Gridlines and Arrows
    • Using Additional Paste Features

     

     

    Formatting Cells

    • Formatting Text
    • Building/Editing/Copying Formulas
    • Formatting Numbers as Currency
    • Using the Sum Function and AutoSum
    • Using Format Painter
    • Using the Formula Palette
    • Adding Borders/Shading to Cells
    • Using the Date Functions
    • Using AutoFormat
    • Using Absolute and Relative Cell References
    • Creating and Applying Styles
    • Using Basic Statistical Functions
    • Merging Cells

    Changing Print Options

    • Adding Headers and Footers
    • Using the PMT Function to Forecast Loan Payments
    • Changing Margins and Centering a Worksheet
    • Calculating Cumulative Interest
    • Changing the Orientation and Scale
    • Computing Investment Value
    • Adding and Deleting Page Breaks
    • Using the IF Function
    • Setting and Clearing a Print Area

     Rows/Columns/Worksheets/Workbooks

    • Magnifying and Shrinking a Worksheet on Screen
    • Understanding MS Excel Window Environment
    • Hiding and Unhiding Rows and Columns
    • Selecting a Range of Cells
    • Freezing and Unfreezing Rows and Columns
    • Entering Text/Numbers/Dates in a Worksheet
    • Moving Between Worksheets in a Workbook
    • Entering a Range of Data
    • Adding and Deleting Worksheets in a Workbook
    • Editing Cell Contents
    • Creating a Three-Dimensional Formula
    • Moving Between Worksheets
    • Linking Workbooks

    Working with Charts

    • Creating Charts using the Chart Wizard
    • Adjusting the Size of Rows and Columns
    • Moving/Resizing/Deleting Charts
    • Aligning Cell Contents
    • Modifying Chart Titles and Adding Axis Labels
    • Creating and Applying Conditional Formats
    • Moving and Formatting Chart Elements
    • Finding and Replacing Cell Content
    • Changing the Chart Type & Organising Source Data
    • Inserting and Deleting Cells/Rows/Columns
    • Updating Data and Formatting the Axes
    • Cutting/Copying/Pasting/Clearing Cells
    • Adding Gridlines and Arrows
    • Using Additional Paste Features
    • Previewing and Printing a Chart

    Performing Basic Calculations

    • Building/Editing/Copying Formulas
    • Formatting Numbers as Currency
    • Using the Sum Function and AutoSum
    • Using Format Painter
    • Using the Formula Palette
    • Adding Borders/Shading to Cells
    • Using the Date Functions
    • Using AutoFormat
    • Using Absolute and Relative Cell References
    • Creating and Applying Styles
    • Using Basic Statistical Functions
    • Merging Cells
    • Using Numbered Series and AutoFill

    Using Basic Financial and Logical Functions

    • Using the PMT Function to Forecast Loan Payments
    • Changing Margins and Centering a Worksheet
    • Calculating Cumulative Interest
    • Changing the Orientation and Scale
    • Computing Investment Value
    • Adding and Deleting Page Breaks
    • Using the IF Function

    Using Excel with the Internet

    • Creating and Editing Hyperlinks
    • Saving Workbooks and Worksheets as Webpages
    • Sending Workbooks via E-Mail
  • This course is aimed at those who want to learn how to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs.

    Microsoft Office Specialist certification gives you the tools to build a brighter future.

    Achieve industry-recognized certification
    Learn the computing skills companies are looking for
    Boost your workforce resume
    Differentiate yourself from other applicants
    Gain valuable experience and confidence
    Heighten your earning potential
    Prepare yourself for a successful future
  • Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, Viewing System Information.

    You must have completed ECDL or similar training course and have good general computer skills and have working Knowledge of Excel / Spreadsheets and other Microsoft Office Software.   
  • mos-powerpoint-specialist-2-day-course

    Microsoft Office Specialist - PowerPoint

    Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their skills and advance their careers.

    Microsoft PowerPoint is the number-one tool for creating impactful presentations.


    Whether for briefing internal colleagues or pitching to clients, presenting is at the heart of business life. Successful presentations have the power to create excellent first impressions, communicate complex and important messages, and lay the foundations for fruitful business relationships and projects.

    This course is aimed at participants who wish to gain an industry qualification in the PowerPoint environment. Candidates will demonstrate their ability to create and manage presentations, insert and formate shapes and slides, create slide content, apply transitions and animations and manage multiple presentations.

  • Creating a Presentation

    • Creating a Presentation Using a Wizard
    • Viewing and Choosing a Colour Scheme
    • Exploring and Moving around a Presentation
    • Changing Colours in a Colour Scheme
    • Changing Text in the Outline Pane, Slide Pane
    • Creating a New Scheme
    • Reversing one or more Actions
    • Adding New Colours to Colour Menus
    • Changing Presentation Views, Properties
    • Adding a Background
    • Previewing Slides and Saving Presentations

    Working with a Presentation

    • Using the Design Template
    • Drawing, Editing, Copying and Moving an Object
    • Entering Text into Slide/Outline/Notes Pane
    • Changing the Shape of an Object
    • Creating a New Slide
    • Modifying Object Attributes
    • Editing in Normal View
    • Aligning, Connecting Objects
    • Entering Speakers’ Notes
    • Adding 3-D Effects to Objects
    • Rearranging Slides in Slide Sorter View
    • Changing, Rotating, Flipping Objects
    • Showing Slides

    Printing a Presentation

    • Inserting a Table
    • Moving Around and Selecting Cells
    • Merging Table Cells
    • Inserting and Deleting Columns & Rows
    • Resizing a Table
    • Adding Shading to a Table
    • Modifying Table Borders

    Outlining Your Ideas

    • Creating a Blank Presentation
    • Navigating in Slide Show View
    • Viewing and Entering Text
    • Annotating Slides During a Slide Show
    • Inserting an Outline from MS Word
    • Setting Text Transitions
    • Changing the View of an Outline
    • Animating Slides
    • Selecting, Rearranging, Slides, Paragraphs & Text
    • Hiding a Slide during a Slide Show
    • Sending an Outline or Notes to Word

    Adding and Modifying Text

    • Selecting and Deselecting Objects
    • Inserting Sound, Movies
    • Adding and Formatting Text to Slides
    • Setting Slide Timings
    • Adjusting the Position of Text Objects
    • Rehearsing Slide Timings
    • Changing Text Alignment and Spacing
    • Recording a Narration
    • Checking Spelling, Presentation Styles

    Applying and Modifying Templates

    • Understanding PowerPoint Masters
    • Creating an Agenda Slide or Home Page
    • Changing the Display using the Master
    • Creating a Hyperlink to a Slide/Excel Chart/Web site
    • Modifying Master Placeholders
    • Creating an Action Button
    • Formatting Master Text
    • Previewing a Presentation as a Web Page
    • Reapplying a Slide Layout
    • Saving and Publishing a Web Page as a Presentation
    • Hiding Master Objects
    • Accessing the Internet from PowerPoint
    • Saving a Template

    Using a Colour Scheme

    • Viewing and Choosing a Colour Scheme
    • Exploring and Moving around a Presentation
    • Changing Colours in a Colour Scheme
    • Changing Text in the Outline Pane, Slide Pane
    • Creating a New Scheme
    • Reversing one or more Actions
    • Adding New Colours to Colour Menus
    • Changing Presentation Views, Properties
    • Adding a Background
    • Previewing Slides and Saving Presentations
    • Copying a Colour Scheme

    Drawing and Modifying Objects

    • Drawing, Editing, Copying and Moving an Object
    • Entering Text into Slide/Outline/Notes Pane
    • Changing the Shape of an Object
    • Creating a New Slide
    • Modifying Object Attributes
    • Editing in Normal View
    • Aligning, Connecting Objects
    • Entering Speakers’ Notes
    • Adding 3-D Effects to Objects
    • Rearranging Slides in Slide Sorter View
    • Changing, Rotating, Flipping Objects
    • Showing Slides
    • Grouping and Ungrouping Objects

    Inserting Information into PowerPoint

    • Inserting a Clip Art Image
    • Previewing Slides in Black and White
    • Scaling an Image
    • Adding a Header and a Footer
    • Re-colouring a Clip Art Image
    • Changing the Page Setup
    • Inserting and Formatting a Table
    • Choosing a Printer
    • Inserting a Graph, Excel, Organisational Chart
    • Printing Slides, Audience Handouts, Speaker Notes
    • Inserting and Modifying a Picture

    Producing a Slide Show

    • Navigating in Slide Show View
    • Viewing and Entering Text
    • Annotating Slides During a Slide Show
    • Inserting an Outline from MS Word
    • Setting Text Transitions
    • Changing the View of an Outline
    • Animating Slides
    • Selecting, Rearranging, Slides, Paragraphs & Text
    • Hiding a Slide during a Slide Show
    • Sending an Outline or Notes to Word
    • Creating and Editing a Custom Slide Show

    Creating a Multimedia Presentation

    • Inserting Sound, Movies
    • Adding and Formatting Text to Slides
    • Setting Slide Timings
    • Adjusting the Position of Text Objects
    • Rehearsing Slide Timings
    • Changing Text Alignment and Spacing
    • Recording a Narration
    • Checking Spelling, Presentation Styles
    • Using the Projector Wizard

    Creating an Internet Presentation

    • Creating an Agenda Slide or Home Page
    • Changing the Display using the Master
    • Creating a Hyperlink to a Slide/Excel Chart/Web site
    • Modifying Master Placeholders
    • Creating an Action Button
    • Formatting Master Text
    • Previewing a Presentation as a Web Page
    • Reapplying a Slide Layout
    • Saving and Publishing a Web Page as a Presentation
    • Hiding Master Objects
    • Accessing the Internet from PowerPoint
    • Saving a Template
    • Presenting a Show on Two Monitors

    Reviewing and Sharing a Presentation

    • Sending a Presentation
    • Taking Notes during a Presentation
    • Broadcasting a Presentation over a Network
    • Using the PowerPoint Viewer
    • Hosting and Participating in an Online Broadcast
    • Using the Pack and Go Wizard
    • Using Online Collaboration, Online Meeting
    • Holding a Web Discussion

  • This course is aimed at participants who wish to gain an industry qualification in the PowerPoint environment.

    Microsoft Office Specialist certification gives you the tools to build a brighter future.

    Achieve industry-recognized certification
    Learn the computing skills companies are looking for
    Boost your workforce resume
    Differentiate yourself from other applicants
    Gain valuable experience and confidence
    Heighten your earning potential
    Prepare yourself for a successful future
  • Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, Viewing System Information.

    You must have completed the ECDL course or have good working Knowledge of Powerpoint.
  • it-skills-digital-literacy

    I.T. Skills & Digital Literacy

    If you want to know more about Word Processing & Excel/Spreadsheets and using
    the internet for connecting with people then this course is for you. Also for those
    considering doing a European Computer Driving Course (ECDL) or just want to use
    your time more efficiently when on the computer/laptop.

    • Internet:
      • Introduction to LinkedIn
      • Skype for free/cheap phone calls
      • Online Collaboration
      • Google + and Hangouts
      • Dropbox for storage
    • Filing System/Windows Explorer:
      • Check when a file or folder was created or last used or accessed
      • Create folders and subfolders
      • Renaming, Copying, moving, deleting files and folders
      • Virus checking and using memory sticks
    • Microsoft Word:
      • Find and replace text
      • Styles and how to use
      • Bullets/numbering
      • Change text quickly from all Caps
      • Copy format quickly
      • Cut, copy and paste text
      • Save as different versions e.g. .pdf
    • Excel Spreadsheets:
      • Learn how to enter, edit, delete and format data
      • How to create addition, subtraction, division and multiplication
      • Create formulae such as Sum, Average, Min, Max, Count
      • Create charts
      • Print within Excel
  • You must have completed the Introduction to Computers Level 1 & 2 or have good basic working Knowledge of Word Processing, Internet & Email. You may bring your own Laptop if you prefer.
  • computer training

    Who is this course for? 
    Complete beginners, learn how to turn on/off the computer or laptop, how to use the mouse, open/close applications/programmes, create folders to save files in, print and change the data in Word. Also how to use the Internet and e-mail.


  • General use Computer:
    • How to turn computer on and off
    • How to use the mouse properly and scroll bar
    • Open and close programmes/applications
    • Familiarise yourself with the various keyboard buttons including the € symbol
    • Windows and how to resize and move and switch between open applications
    • Find applications quickly

    Microsoft Word:
    • How to enter text and delete same
    • How to select text (writing) and use Bold, Italic, Underline
    • How to change writing colour, size and style
    • How to spellcheck your document
    • Use Ribbon buttons including Undo/Redo
    • Difference between Save and Save as
    • Create a folder and how find it in your filing system

    Internet:
    • Learn how to open a website
    • Learn to differentiate between the different Internet software
    • How to use Google to search for information
    • Print from websites
    • Book airline tickets, holidays or complete other online booking forms

    E-mail:
      • Learn how to write an e-mail and send it
      • How to read an e-mail and reply to the sender
      • How to use To CC and BCC
      • How to reply, print & delete messages.
  • For those who know little or nothing and want to start at the beginning.
  • You do not need to have prior experience of a computer or laptop for this courseYou may bring your own Laptop if you prefer.
  • create-documents-web-emails

    Who is this course for?

    If you've used a computer before but need to know more about the Internet, E-mail, Creating Documents using Word Processing, Filing Systems, Internet Security and Buying-on-Line then this is the course for you.

    • Filing System/Windows Explorer:
      • Create folders and subfolders
      • Renaming files and folders
      • Copying, moving and files and folders
      • Virus checking and using memory sticks
    • Microsoft Word:
      • Improve the appearance of words (called text)
      • Learn how to layout letters in Word
      • Bullets, numbering, line spacing, alignment
      • Change margins and orientation
      • Difference between Save and Save as
      • Create a folder and how find it in your filing system
      • Create and use Tabs
      • Create Tables
      • Insert Pictures
      • How to number pages automatically
      • How to copy, move (cut) and paste text
    • Internet:
      • Learn how to use the Internet for secure and safe purchasing of goods
      • Source information, cars and other products
      • Learn quick ways to find information on any topic on the internet.
      • Pay bills online using cards or Internet Banking (you will need to setup with your bank to do this — if you have telephone banking these are the details required)
    • E-mail:
      • Compose, reply, print & delete messages
      • Send an e-mail to multiple users and how to use CC & BCC
      • Learn how to attach pictures and files such as a C.V. or letter
  • >If you know a little but need to know more about computers & email.
  • You must have completed the Introduction to Computers Level 1 Course or have basic working Knowledge of the computer, Internet & basic Email skills. You may bring your own Laptop if you prefer.
  • mos-excel-specialist-2-day-course

    Microsoft Office Specialist - Excel

    Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their skills and advance their careers.

    Microsoft Excel is perhaps the most important computer software program used in the workplace today. That's why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.

    This course is aimed at participants who wish to gain an industry qualification in the Excel environment.

    Candidates will demonstrate the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects.

  • Learning Worksheet Fundamentals

    • Creating Workbooks
    • Magnifying and Shrinking a Worksheet on Screen
    • Understanding MS Excel Window Environment
    • Hiding and Unhiding Rows & Columns
    • Selecting a Range of Cells
    • Freezing and Unfreezing Rows & Columns
    • Entering Text/Numbers/Dates in a Worksheet
    • Moving Between Worksheets in a Workbook
    • Entering a Range of Data
    • Adding and Deleting Worksheets in a Workbook
    • Editing Cell Contents
    • Creating a Three-Dimensional Formula
    • Moving Between Worksheets
    • Linking Workbooks
    • Naming and Saving Workbooks
    • Opening Workbooks
    • Renaming Worksheets
    • Closing Workbooks and Quitting Excel

    Editing and Formatting Worksheets

    • Formatting Numbers
    • Creating Charts Using the Chart Wizard
    • Adjusting the Size of Rows and Columns
    • Moving/Resizing/Deleting Charts
    • Aligning Cell Contents
    • Modifying Chart Titles and Adding Axis Labels
    • Creating and Applying Conditional Formats
    • Moving and Formatting Chart Elements
    • Finding and Replacing Cell Content
    • Changing the Chart Type & Organising Source Data
    • Inserting and Deleting Cells/Rows/Columns
    • Updating Data and Formatting the Axes
    • Cutting/Copying/Pasting/Clearing Cells
    • Adding Gridlines and Arrows
    • Using Additional Paste Features

    Formatting Cells

    • Formatting Text
    • Building/Editing/Copying Formulas
    • Formatting Numbers as Currency
    • Using the Sum Function and AutoSum
    • Using Format Painter
    • Using the Formula Palette
    • Adding Borders/Shading to Cells
    • Using the Date Functions
    • Using AutoFormat
    • Using Absolute and Relative Cell References
    • Creating and Applying Styles
    • Using Basic Statistical Functions
    • Merging Cells

    Changing Print Options

    • Adding Headers and Footers
    • Using the PMT Function to Forecast Loan Payments
    • Changing Margins and Centering a Worksheet
    • Calculating Cumulative Interest
    • Changing the Orientation and Scale
    • Computing Investment Value
    • Adding and Deleting Page Breaks
    • Using the IF Function
    • Setting and Clearing a Print Area

    Rows/Columns/Worksheets/Workbooks

    • Magnifying and Shrinking a Worksheet on Screen
    • Understanding MS Excel Window Environment
    • Hiding and Unhiding Rows and Columns
    • Selecting a Range of Cells
    • Freezing and Unfreezing Rows and Columns
    • Entering Text/Numbers/Dates in a Worksheet
    • Moving Between Worksheets in a Workbook
    • Entering a Range of Data
    • Adding and Deleting Worksheets in a Workbook
    • Editing Cell Contents
    • Creating a Three-Dimensional Formula
    • Moving Between Worksheets
    • Linking Workbooks

    Working with Charts

    • Creating Charts using the Chart Wizard
    • Adjusting the Size of Rows and Columns
    • Moving/Resizing/Deleting Charts
    • Aligning Cell Contents
    • Modifying Chart Titles and Adding Axis Labels
    • Creating and Applying Conditional Formats
    • Moving and Formatting Chart Elements
    • Finding and Replacing Cell Content
    • Changing the Chart Type & Organising Source Data
    • Inserting and Deleting Cells/Rows/Columns
    • Updating Data and Formatting the Axes
    • Cutting/Copying/Pasting/Clearing Cells
    • Adding Gridlines and Arrows
    • Using Additional Paste Features
    • Previewing and Printing a Chart

    Performing Basic Calculations

    • Building/Editing/Copying Formulas
    • Formatting Numbers as Currency
    • Using the Sum Function and AutoSum
    • Using Format Painter
    • Using the Formula Palette
    • Adding Borders/Shading to Cells
    • Using the Date Functions
    • Using AutoFormat
    • Using Absolute and Relative Cell References
    • Creating and Applying Styles
    • Using Basic Statistical Functions
    • Merging Cells
    • Using Numbered Series and AutoFill

    Using Basic Financial and Logical Functions

    • Using the PMT Function to Forecast Loan Payments
    • Changing Margins and Centering a Worksheet
    • Calculating Cumulative Interest
    • Changing the Orientation and Scale
    • Computing Investment Value
    • Adding and Deleting Page Breaks
    • Using the IF Function

    Using Excel with the Internet

    • Creating and Editing Hyperlinks
    • Saving Workbooks and Worksheets as Webpages
    • Sending Workbooks via E-Mail
  • This course is aimed at those who want to learn how to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs.

    Microsoft Office Specialist certification gives you the tools to build a brighter future.

    Achieve industry-recognized certification
    Learn the computing skills companies are looking for
    Boost your workforce resume
    Differentiate yourself from other applicants
    Gain valuable experience and confidence
    Heighten your earning potential
    Prepare yourself for a successful future
  • Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, Viewing System Information.

    You must have completed ECDL or similar training course and have good general computer skills and have working Knowledge of Excel / Spreadsheets and other Microsoft Office Software.
Pery Square Business College & Staff Agency.
4 Pery Square, Limerick, Ireland.
Telephone: +353 (0)61 310155
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Call or Email to discuss the right course for you.
European Computer Driving Licence, ECDL
Irish Computer Society
Microsoft Office Specialist Certification
Quality and Qualifications Ireland (QQI)