Microsoft Office 2016 Courses Training

These courses are available to UCD staff and students (except MS Access and MS Project which are available for staff only) and are designed for first time users as well as those who need to reinforce their Microsoft Office skills. Courses will be held in the Daedalus Building in Belfield.

All of the courses listed below are free and participants can sit a free exam to qualify for Microsoft Office Specialist (MOS) accreditation. Participants can prepare for the MOS accreditation exam by downloading a GMetrix MOS self-test.

Open All

IT/07 - Microsoft Excel 2016 Core Skills

Aimed at:  All UCD staff & students

The course is aimed at those with a basic knowledge of computers who are interested in producing spreadsheets. Participants will be ready to take the Microsoft Office Specialist Excel Core Skills exam.

Click here for information on Self-test for Microsoft Office Specialist certification exam.?

Objectives:

This course aims to give participants an introduction to spreadsheets using Excel. The emphasis is on practical, hands-on production.

Content:

By the end of the course participants should be able to produce basic spreadsheets.
They should understand formulas for arithmetic, absolute versus relative cell references, referencing other worksheets and linking workbooks.
They should also understand formatting, tabs, printing and charting.
How to add illustrations to a spreadsheet.
Advanced and conditional formatting of cells.
Sorting and filtering of tables, hyperlinks, and sharing of workbooks are covered.

Date:

Staff: Click here for schedule and booking form

Students: Click here for schedule
 
Excel Core Manual (login required)

Note that all CCI Manuals are UCD-Confidential and are not to be used outside UCD.

 

IT/08 - Excel 2016 Expert Skills

Any queries regarding this training should be directed to ittraining@ucd.ie

Aimed at:  All staff & students

This course aims to give participants further information on Excel. The emphasis is on practical, hands-on production. Participants will be ready to take the Microsoft Office Specialist Excel Expert Skills exam.

Click here for information on Self-test for Microsoft Office Specialist certification exam.?

Prerequisites:
The course is aimed at those with knowledge of Excel equivalent to the Excel Core Skills course.

Objectives:
By the end of the course participants should be familiar with more advanced features of Excel.

Contents:
Advanced formulas and functions-  date and time, lookup, financial, conditional logic, conditional summary.
Pivot tables.
Review of charting including advanced features such as dynamic charts.
Conditional formatting,formula auditing.
Advanced filtering. Sharing workbooks.
Data analysis- goal seek, scenarios.
Pivot charts.
Protecting workbooks.
 
Staff: Click here for schedule and booking form

Students: Click here for schedule
 
Excel Expert Manual (login required)

Note that all CCI Manuals are UCD-Confidential and are not to be used outside UCD.

IT/05 - PowerPoint 2016 Core Skills

Aimed at:  All staff & students

Course Aim:

This course aims to give participants an introduction to presentations using Microsoft PowerPoint . The emphasis is on practical, hands-on production. The course is aimed at those with a basic knowledge of computers who are interested in producing presentations. Participants will be ready to take the Microsoft Office Specialist Powerpoint Core Skills exam.

Click here for information on Self-test for Microsoft Office Specialist certification exam.?

Objectives:

By the end of the course participants should be able to make use of most PowerPoint features.

Contents:

Using the UCD Visual Identity Template to create Text slides including bulleting and numbering.
Text content including text boxes and WordArt, Illustrations and Shapes, Smart Art, Charts and Tables.
Understanding the Slide Sorter feature.
Working with Slide Masters.
How to use Animations.
How to create Handouts and Print slides.
How to use external content like hyperlinks.
Video and audio files.
Collaborate on and share Presentations.
Export slide contents to Blackboard.

Staff: Click here for schedule and booking form

Students: Click here for schedule

Powerpoint Core Manual (login required)

Note that all CCI Manuals are UCD-Confidential and are not to be used outside UCD.

IT/10 - Core Skills in Introductory Microsoft Word 2016

Aimed at:  All staff & students

This course aims to give participants an introduction to document production using Microsoft Word. The emphasis is on practical, hands-on production. The course is aimed at those with a basic knowledge of computers who are interested in producing documents. At the end of the course participants will be ready to take a free exam leading to Microsoft Office Specialist Word Core Skills certification.

Click here for information on Self-test for Microsoft Office Specialist certification exam.?

Objective:
Introduce the features of Word.

Content:
By the end of the course participants should be able to make use of cutting, copying, pasting, formatting including styles, tabs, lists with numbering or bullets, line spacing, indenting, page breaks, headers and footers, printing, symbols and drawings.

On completion of the course participants should be able to make use of tables, Smart Art, shapes, Tracking Document changes, Styles and References (Table of contents, Table of figures, Indexing, Footnotes and Endnotes).

Staff: Click here for schedule and booking form

Students: Click here for schedule

Word Core Manual (login required)

Word Expert Manual (login required)

Note that all CCI Manuals are UCD-Confidential and are not to be used outside UCD.

Aimed at: All Staff

Microsoft Access is the package used for databases with one or more tables. Participants will be ready to take the Microsoft Office Specialist exam.

Click here for information on Self-test for Microsoft Office Specialist certification exam.

Objectives:
To understand databases consisting of more than one related table.
To understand how to query a database.
To understand how to import data to a table from Excel.
To understand how to maintain a database so that data is not lost.
To use forms to enter data into a database table.
To use reports to show data extracted from a database in a neat manner.

Content:
Set up a table, modify it, import and export data
Sort and filter records in a table
Run queries against a table with various criteria
Relate multiple tables together into a database
Enforce referential integrity on table relationships
Backing up and restoring databases, splitting databases etc.
Designing forms for data entry
Creating and modifying reports, printing reports, exporting to Adobe PDF
Using advanced table features to ensure data is inputted correctly into databases
Building advanced queries including those that automatically update many records
Advanced controls in reports

Staff only: Click here for schedule and booking form

Access Core Manual (Staff login required)

Please remember Copyright Law and UCD Acceptable Use Policy. Our dedicated Electronic Software License Portal allows us unlimited viewing and printing of the Certification Guides for one year. Please note that the Certification Guides are only for use within our licensed location (UCD) and not to be distributed to third parties.

IT/12  MS Project 2010 This course is free.

Course Aim:

This course aims to give participants an introduction to MS Project, a program used in project management. It lists the tasks that make up a project and their timescales and dependencies. It also shows the resources assigned to complete the tasks.

Prerequisites:

No prerequisites for this course

Objectives:

Course attendees will be able to use MS Project to enhance their Project Plans with Gantt charts, resource plans, resource budgets etc. They will be able to use MS Project to track progress and to alter the Project Plan to deal with any changes, as well as using it as a tool to communicate with other project stakeholders.

Staff: Click here for schedule and booking form