Microsoft Office 2016 Courses Training

These courses are available to UCD staff and students (except MS Project which is available for staff only) and are designed for first time users as well as those who need to reinforce their Microsoft Office skills.

Please note: Courses are currently available online only

Microsoft Office online training

UCD staff can avail of LinkedIn eLearning courses which are specifically designed for the MOS certification preparation: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

LinkedIn Learning course Microsoft Project 2010 Essential Training

LinkedIn have a course for each product in the Office suite and they provide the range for each level (Specialist, Expert Specialist and Master).

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.

 

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.

 

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.

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).

 

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

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.