Microsoft Office 2016 Courses Training

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

Book here:  Microsoft Office online and classroom 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. Covers calculations, charts and Excel as a simple database.

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. Advanced formulas and functions-  date and time, lookup, financial, conditional logic, conditional summary. Pivot tables and charts. Review of charting including advanced features.

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.

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. 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. Styles and References (Table of contents, Table of Figures, Footnotes and Endnotes).

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.

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 Project, a program used in project management. Use Project to enhance their Project Plans with Gantt charts, resource plans, resource budgets etc.

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.