Course Resources

Upcoming Classes

View and register for upcoming courses.

View Upcoming Classes View Upcoming IT and Cybersecurity Classes

Course Evaluations

Please click the link below to fill out our course evaluation following your class. We appreciate your feedback!

Course Evaluation

Course Data Files

Click on the dropdown menu below to download data files for your course. To save individual files to your computer, right click and select "Save link as..."

Access 2013 - Level 1

Full data set (compressed .zip format):

d151ben_data.zip

Individual data files:

access_conference.accdb

access_conference_2.accdb

access_conference_3.accdb

access_conference_4.accdb

access_conference_5.accdb

access_conference_6.accdb

access_conference_7.accdb

access_conference_8.accdb

departments.txt

university-courses.xlsx

university_ba.accdb

university_ct.accdb

university_de.accdb

university_frm.accdb

university_imp.accdb

university_qry.accdb

university_rel.accdb

university_rpt.accdb

university_td.accdb

Access 2013 - Level 2

Full data set (compressed .zip format):

d152en_data.zip

Individual data files:

university_qry.accdb

university_rpt-review.accdb

university_rpt.accdb

university_tbl review.accdb

university_tbl.accdb

crest.bmp

greenthumb.bmp

orders_demo.accdb

rosenburg.bmp

students.bmp

university-case-study.accdb

university.bmp

university_frm-review.accdb

university_frm.accdb

university_qry-review.accdb

Access 2013 - Level 3

Full data set (compressed .zip format):

d153en_data.zip

Individual data files:

university_cust.accdb

university_mac.accdb

university_sb.accdb

university_se.accdb

university_adm.accdb

Access 2016 - Data Entry and Reports

Full data set (compressed .zip format):

access-2016-der.zip

Individual data files:

access_conference.accdb

access_conference_2.accdb

access_conference_3.accdb

access_conference_4.accdb

university_ba.accdb

university_qry.accdb

university_rpt.accdb

university_td.accdb

Access 2016 - Level 1

Full data set (compressed .zip format):

d161ben_data.zip

Individual data files:

university_td.accdb

access_conference.accdb

access_conference_2.accdb

access_conference_3.accdb

access_conference_4.accdb

access_conference_5.accdb

access_conference_6.accdb

access_conference_7.accdb

access_conference_8.accdb

departments.txt

university-courses.xlsx

university_ba.accdb

university_ct.accdb

university_de.accdb

university_frm.accdb

university_imp.accdb

university_qry.accdb

university_rel.accdb

university_rpt.accdb

Access 2016 - Level 2

Full data set (compressed .zip format):

d162en_data.zip

Individual data files:

crest.bmp

greenthumb.bmp

orders_demo.accdb

rosenburg.bmp

students.bmp

university-case-study.accdb

university.bmp

university_frm-review.accdb

university_frm.accdb

university_qry-review.accdb

university_qry.accdb

university_rpt-review.accdb

university_rpt.accdb

university_tbl-review.accdb

university_tbl.accdb

Adobe InDesign
School of Business - Cat Brochure
Adobe Premiere
Adobe Premiere Level 1 - Course Resources
Excel 2013 - Level 1

Full data set (compressed .zip format):

s151en_data.zip

Individual data files:

budget.xlsx

income-2.xlsx

income-3.xlsx

income-4.xlsx

review-2.xlsx

review-3.xlsx

review-4.xlsx

review-5.xlsx

Excel 2013 - Level 2

Full data set (compressed .zip format):

s152en_data.zip

Individual data files:

central.xlsx

consolidation.xlsx

detail.xlsx

div1.xlsx

div2.xlsx

div3.xlsx

div4.xlsx

div5.xlsx

division-summary.xlsx

divisions-detail.xlsx

divisions.xlsx

money.bmp

naming.xlsx

north.xlsx

ontarget.xlsx

outline.xlsx

projections.xlsx

review-1.xlsx

review-2-linking.xlsx

review-2.xlsx

review-3-report-consolidation.xlsx

review-3.xlsx

review-4.xlsx

review-5.xlsx

salescom.xlsx

south.xlsx

Excel 2013 - Data List Management

Full data set (compressed .zip format):

s153den_data.zip

Individual data files:

fullmoon.xlsx

if-co.xlsx

if-co_2.xlsx

if-co_3.xlsx

if-co_4.xlsx

if-co_5.xlsx

new-tours.csv

new-tours.prn

orders.accdb

table-co.xlsx

travel.xlsx

Excel 2013 - Spreadsheet Analysis

Full data set (compressed .zip format):

s153sen_data.zip

Individual data files:

finfuncs.xlsx

housemax.xlsx

housemax5.xlsx

newprod.xlsx

newprod2.xlsx

newprod4.xlsx

newprod5.xlsx

sales.xlsx

scenario.xlsx

Excel 2013 - VBA Programming

Full data set (compressed .zip format):

s153ven_data.zip

Individual data files:

janexp-6.xlsm

janexp-7.xlsm

janexp-8.xlsm

janexp-9.xlsm

accounting.accdb

completed-files.zip

janexp-1.xlsm

janexp-2.xlsm

janexp-3.xlsm

janexp-4.xlsm

janexp-5.xlsm

Excel 2016 - Level 1

Full data set (compressed .zip format):

s161en_data.zip

Individual data files:

budget.xlsx

income_2.xlsx

income_3.xlsx

income_4.xlsx

review_2.xlsx

review_3.xlsx

review_4.xlsx

review_5.xlsx

Excel 2016 - Level 2

Full data set (compressed .zip format):

excel-2016-lvl-2-data-files-03-2023.zip

Individual data files:

acting-manager-profits.xlsx

central.xlsx

consolidation.xlsx

detail.xlsx

div1.xlsx

div2.xlsx

div3.xlsx

div4.xlsx

div5.xlsx

division_summary.xlsx

divisions.xlsx

divisions_detail.xlsx

excel-2019-l2-supplemental-functions.docx

finfuncs.xlsx

functions.xlsx

mileage-date-since-last-travel.xlsx

money.bmp

naming.xlsx

north.xlsx

ontarget.xlsx

outline.xlsx

projections.xlsx

review_1.xlsx

review_2.xlsx

review_2_linking.xlsx

review_3.xlsx

review_3_report_consolidation.xlsx

review_4.xlsx

review_5.xlsx

salescom.xlsx

south.xlsx

supplemental-topics.xlsx

 

Excel 2016 - Data List Management

Full data set (compressed .zip format):

excel-2016-dlm-all.zip

Individual data files:

fullmoon.xlsx

if-co.xlsx

if-co_2.xlsx

if-co_3.xlsx

if-co_4.xlsx

if-co_5.xlsx

new-tours.csv

new-tours.prn

orders.accdb

table-co.xlsx

travel.xlsx

Excel 2016 - Spreadsheet Analysis

Full data set (compressed .zip format):

excel-2016-ssa-data-files-03-2023.zip

Individual data files:

finfuncs.xlsx

housemax.xlsx

housemax5.xlsx

janexp.xlsm

newprod.xlsx

newprod2.xlsx

newprod4.xlsx

newprod5.xlsx

sales.xlsx

scenario.xlsx

ssa-macros-supplemental.pdf

theatre-with-if-vlookup-macro.xlsm

Excel 2016 - VBA Programming

Full data set (compressed .zip format):

s163ven_data.zip

Individual data files:

janexp-3.xlsm

janexp-4.xlsm

janexp-5.xlsm

janexp-6.xlsm

janexp-7.xlsm

janexp-8.xlsm

janexp-9.xlsm

accounting.accdb

completed-files.zip

janexp-1.xlsm

janexp-2.xlsm

Google Courses

Google Tips and Tricks - April 22, 2022 by Terrance Judge

Welcome to Google Forms by Terrance Judge

Microsoft Office Tips and Tricks

Excel complete package

Excel Essential Files

Goal Seek

Scenario

SSA Solver and solutions

Macro

Windows and Office Tips & Tricks

AAP Kevin Moffitt Speaker Notes

Rural Municipalities of Alberta November 7 Presentation

OneNote 2016

Full data set (compressed .zip format):

onenote-2016-data.zip

Individual data files:

accommodations-and-venue.jpg

global-agm-2017.docx

global-agm-2017.pptx

global-holidays_1.zip

global-tours.zip

south-america.jpg

south-america.pptx

team-meetings.one

tour-bookings.xlsx

tours-worldwide.zip

tours_1.zip

tours_2.zip

tours_3.zip

tours_4.zip

tours_5.zip

word-table.docx

PowerPoint 2013 - Level 1

Full data set (compressed .zip format):

p151en_data.zip

Individual data files:

accounts.pptx

agm.pptx

review-3.pptx

review-4.pptx

review-5.pptx

review-6.pptx

review-7.pptx

review.pptx

travel.pptx

travel1.pptx

travel3.pptx

travel4.pptx

travel5.pptx

travel6.pptx

travel7.pptx

travel7b.pptx

PowerPoint 2013 - Level 2

Full data set (compressed .zip format):

p152en_data.zip

Individual data files:

bond-list.xlsx

employee-sign-up-sheet.docx

environmental-facts.pptx

fern.jpg

greenteam.docx

healthy-futures.pptx

join-the-green-team-2.pptx

join-the-green-team.pptx

leaves.png

mission-statement.docx

music.mp3

product-table.docx

recycling-breakdown.pptx

recycling-review.pptx

save-the-earth-seminars.pptx

saving-the-earth-2.pptx

saving-the-earth-3.pptx

saving-the-earth-4.pptx

saving-the-earth.pptx

saving-trees.docx

supplies-stats.xlsx

table-2.docx

table-3.docx

table-4.docx

table-one.docx

the-recycling-players.pptx

version-one.pptx

version-two.pptx

water-lilies.jpg

wildlife.wmv

PowerPoint 2016 - Level 1

Full data set (compressed .zip format):

p161en_data.zip

Individual data files:

accounts.pptx

agm.pptx

profits-growth-chart.jpg

review-3.pptx

review-4.pptx

review-5.pptx

review-6.pptx

review-7.pptx

review.pptx

travel1.pptx

travel2.pptx

travel3.pptx

travel4.pptx

travel5.pptx

travel6.pptx

travel7.pptx

travel7b.pptx

PowerPoint 2016 - Level 2

Full data set (compressed .zip format):

p162en_data.zip

Individual data files:

bond-list.xlsx

employee-sign-up-sheet.docx

environmental-facts.pptx

fern.jpg

greenteam.docx

healthy-futures.pptx

information.emf

join-the-green-team-2.pptx

join-the-green-team.pptx

leaves.png

mission-statement.docx

product-table.docx

recycling-breakdown.pptx

recycling-review.pptx

save-the-earth-seminars.pptx

saving-the-earth-2.pptx

saving-the-earth-3.pptx

saving-the-earth-4.pptx

saving-the-earth.pptx

saving-trees.docx

supplies-stats.xlsx

table-2.docx

table-3.docx

table-one.docx

the-recycling-players.pptx

tow-truck.emf

version-one.pptx

version-two.pptx

water-lilies.jpg

wildlife.wmv

Project 2013 - Level 1

Full data set (compressed .zip format):

m151en_data.zip

Individual data files:

2outline.mpp

3costs.mpp

3projcal.mpp

3rescal.mpp

3resource.mpp

3taskcal.mpp

4print.mpp

4report.mpp

5constraint.mpp

5critical.mpp

5tasktype.mpp

6baseline.mpp

6contours.mpp

6leveling.mpp

6locating.mpp

6resolving.mpp

7compare.mpp

7update.mpp

8filter.mpp

9formatting.mpp

1basics.mpp

2depend.mpp

2link.mpp

Project 2013 - Level 2

Full data set (compressed .zip format):

m152en_data.zip

Individual data files:

1custom.mpp

1report.mpp

1view.mpp

2meeting-2013.mpp

2organizer.mpp

2template.mpp

3eva.mpp

3track.mpp

3visualreport.mpp

4export.mpp

4import.xlsx

5conference.mpp

5remodel.mpp

5shareholder.mpp

6pool.mpp

6share1.mpp

6share2.mpp

7financialreport.pptx

7ganttbars.mpp

7macro.mpp

7wbs.mpp

Project 2016 - Level 1

Full data set (compressed .zip format):

m161en_data.zip

Individual data files:

6resolving.mpp

7compare.mpp

7update.mpp

8filter.mpp

9formatting.mpp

1basics.mpp

2depend.mpp

2link.mpp

2outline.mpp

3costs.mpp

3projcal.mpp

3rescal.mpp

3resource.mpp

3taskcal.mpp

4print.mpp

4report.mpp

5constraint.mpp

5critical.mpp

5tasktype.mpp

6baseline.mpp

6contours.mpp

6leveling.mpp

6locating.mpp

Project 2016 - Level 2

Full data set (compressed .zip format):

m162en_data.zip

Individual data files:

2template.mpp

3eva.mpp

3track.mpp

3visualreport.mpp

4export.mpp

4import.xlsx

5conference.mpp

5remodel.mpp

5shareholder.mpp

6pool.mpp

6share1.mpp

6share2.mpp

7financialreport.pptx

7ganttbars.mpp

7macro.mpp

7wbs.mpp

1custom.mpp

1report.mpp

1view.mpp

2meeting-2017.mpp

2organizer.mpp

Project Management

Case Study #1

Project Charter Template

Risk Management Template

PowerPoint Slides

Personal Action Plan

Project Change Request Template

Project Change Control Log

Project Template Package (Google Sheets)

Project Template Package (Excel)

Project Template GoA

Publisher 2013

Full data set (compressed .zip format):

G151en_data.zip

Individual data files:

Newsletter3.pub

Newsletter3b.pub

Newsletter4.pub

Newsletter5.pub

Newsrelease.txt

wwraft.gif

Newsletter1.pub

SPSS Application
Introduction to SPSS Application files
Visio 2013

Full data set (compressed .zip format):

f151en_data.zip

f152en_data.zip

Individual data files:

1logo.vsdx

1sales.vsdx

2layer.vsdx

3back.vsdx

4behave.vsdx

4dcf.vsdx

5shapes.vsdx

6custom.vsdx

7contact.xlsx

7import.vsdx

7pivot.xlsx

7power.vsdx

7report.vsdx

abc-background.vsdx

abc-training.vsdx

class-a.vsdx

class-layout.vsdx

connect-net.vsdx

corp-network.vsdx

corp-preview.vsdx

corp-tools.vsdx

dcf_logo.png

drawing.vsdx

gradhat.bmp

mh-connect.vsdx

mh-flow.vsdx

mh-format.vsdx

mh-logo.vsdx

mh-sales.vsdx

mh-text.vsdx

owl.bmp

owl.png

payroll-connect.vsdx

payroll.vsdx

sales-network.vsdx

Visio 2016

Full data set (compressed .zip format):

f161en_data.zip

f162en_data.zip

Individual data files:

1logo.vsdx

1sales.vsdx

2layer.vsdx

3back.vsdx

4behave.vsdx

4dcf.vsdx

5shapes.vsdx

6custom.vsdx

7contact.xlsx

7import.vsdx

7pivot.xlsx

7power.vsdx

7report.vsdx

abc-background.vsdx

abc-training.vsdx

class-a.vsdx

class-layout.vsdx

connect-net.vsdx

corp-network.vsdx

corp-preview.vsdx

corp-tools.vsdx

dcf_logo.png

drawing.vsdx

gradhat.bmp

mh-connect.vsdx

mh-flow.vsdx

mh-format.vsdx

mh-logo.vsdx

mh-sales-draft.vsdx

mh-sales.vsdx

mh-text.vsdx

owl.bmp

owl.png

payroll-connect.vsdx

payroll.vsdx

sales-network.vsdx

Word 2013 - Level 1

Full data set (compressed .zip format):

w151en_data.zip

Individual data files:

global_1.docx

global_2.docx

global_3.docx

global_4.docx

global_5.docx

global_6.docx

global_7.docx

notice_2.docx

notice_3.docx

notice_4.docx

notice_5.docx

notice_6.docx

notice_7.docx

Word 2013 - Level 2

Full data set (compressed .zip format):

w152en_data.zip

Individual data files:

bendel-letter.docx

benefits.docx

confirm.docx

contractors-list.xlsx

employee-guide_2.docx

events-formatted.docx

events.docx

expenses.docx

format.docx

formletter.docx

formsorted.docx

gh-building-blocks.docx

guide.docx

letter.docx

policy.docx

sort-records.docx

sunset.jpg

Word 2013 - Level 3

Full data set (compressed .zip format):

w153en_data.zip

Individual data files:

beginnings.docx

cover.docx

done.docx

edits.docx

equipment.docx

excel-commissions.xlsx

flights.docx

form.docx

group.docx

guest.docx

handbook.docx

letter.docx

news.docx

newsletter.docx

open-house.docx

peers.docx

publication.docx

sorting-and-calculation.docx

spring-plans.docx

text.docx

tours.docx

Word 2016 - Level 1

Full data set (compressed .zip format):

w161en_data.zip

Individual data files:

global_1.docx

global_2.docx

global_3.docx

global_4.docx

global_5.docx

global_6.docx

global_7.docx

notice_2.docx

notice_3.docx

notice_4.docx

notice_5.docx

notice_6.docx

notice_7.docx

Word 2016 - Level 2

Full data set (compressed .zip format):

w162en_data.zip

Individual data files:

bendel-letter.docx

benefits.docx

confirm.docx

contractors-list.xlsx

employee-guide_2.docx

events-formatted.docx

events.docx

expenses.docx

format.docx

formletter.docx

formsorted.docx

gh-building-blocks.docx

guide.docx

letter.docx

policy.docx

sort-records.docx

sunset.jpg

Word 2016 - Level 3

Full data set (compressed .zip format):

w163en_data.zip

Individual data files:

beginnings.docx

cover.docx

done.docx

edits.docx

equipment.docx

excel-commissions.xlsx

excel-suppliers.xlsx

flights.docx

form.docx

group.docx

guest.docx

handbook.docx

letter.docx

news.docx

open-house.docx

parent.docx

peers.docx

publication.docx

spring-plans.docx

text.docx

tours.docx

Contact Us

Technology Training Centre

B-11 Cameron Library
780.492.1397
training@ualberta.ca

Cancellation Policy

Written or on-line cancellation must be received 10 business days prior to the course start date. Registration fees for cancellations less than 10 business days before the course will not be refunded.

Cancellation by the Technology Training Centre

The Technology Training Centre reserves the right to cancel open-enrollment classes at any time. All efforts will be made to give the course registrants 5 business days' notice of cancellation. At the time of cancellation, registrants have the option of being moved to another date, a different course of equal value or be refunded for the course fee. The Technology Training Centre will not be responsible for any travel expenses incurred.