Microsoft Office Courses

Microsoft Access Level 1
Data Entry and Reports
1 Day
This course provides students with a solid foundation for working with existing Microsoft Access databases. Participants learn about and work with tables, queries, and reports. They also examine page set up options and print / print preview functions.
Microsoft Access Level 1
Database Design
2 Days
This course provides students with a comprehensive introduction to designing Microsoft Access databases. Participants learn about and work with tables, forms, queries, and reports. An emphasis is placed on creating new database objects and enhancing data integrity. Students also examine page set up options and print / print preview functions.
Microsoft Access Level 2
Advanced Database Design
1 Day
In this course, students take their Microsoft Access database design skills to the next level. Participants enhance tables by creating lookups and constructing various types of advanced queries, forms and reports.
Microsoft Access Level 3
Advanced Topics
1 Day
This course provides students with methods they can use to make their Microsoft Access databases more user-friendly and secure. Participants learn about macros, switchboards, database security, and various settings they can apply to customize any database.

Microsoft Excel Level 1
1 Day
This course provides students with an introduction to Microsoft Excel. Participants learn about spreadsheet concepts and how to organize data into rows and columns. They perform calculations, apply formatting to enhance the presentation of worksheet data and examine page setup options and print / print preview functions.
Microsoft Excel Level 2
1 Days
This course helps students take their Microsoft Excel skills to the next level. Participants learn to organize, protect and display data using various tools. They use the IF function, create linking formulas and set up multiple worksheets. Students also create and modify charts, use styles and apply conditional formatting.
Microsoft Excel Level 3
Data List Management
1 Day
This course helps students organize and manage large amounts of data. Participants learn to sort and filter data, create subtotaled lists, and work with various functions to summarize data. They also examine Pivot tables, MS Query, and processes for importing data from other sources.
Microsoft Excel Level 3
Spreadsheet Analysis
1 Day
In this course, students explore Microsoft Excel’s advanced features relating to complex worksheets. Participants explore absolute and mixed cell references, financial functions, goal seek, data tables, solver, and various tools focused on analysis.
Microsoft Excel Level 3
VBA Macros
2 Days
This course provides students with a comprehensive introduction to Microsoft Excel VBA macros. Participants become familiar with techniques for recording, writing, running, and maintaining macros. They also learn about VBA programming basics, user forms, handling errors, accessing external data, and automation in Excel.

Microsoft Outlook Level 1
1 Day
This course provides students with an introduction to Microsoft Outlook. Participants learn about the Outlook environment and work with notes, e-mail messages, contacts, tasks, and meetings. Additionally, they create e-mail distribution groups, manage junk mail, and examine various ways to view information in Outlook.
Microsoft Outlook Level 2
1 Day
In this course, students focus on advanced features in Microsoft Outlook. Participants customize views, utilize various methods to manage folders, and explore advanced messaging capabilities. They also share folder access and archive outdated items.

Microsoft Powerpoint Level 1
1 Day
This course provides students with an introduction to Microsoft PowerPoint. Participants learn about presentation concepts, creating new presentations, and organizing text in an outline. Additionally, they modify colour schemes and slide masters, work with design templates and various formatting options, and add graphical elements to their presentations.
Microsoft PowerPoint Level 2
1 Day
In level 2, students learn to share information between presentations and applications in Microsoft Office. Participants also add charts to their presentations, incorporate various graphical elements, and build advanced slideshows.

Microsoft Project Level 1 provides students with a comprehensive introduction to creating and managing project plans in Microsoft Project. Students learn how to create a new project file, enter tasks and resources, and work with the various views and reports available.
Microsoft Project Level 2
1 Day
Microsoft Project Level 2 provides students with an in-depth look at how to customize various elements in Microsoft Project and share information.

Students learn how to create custom tables, views, and reports. Participants also examine processes for importing and exporting data, and they learn how to share custom elements, tasks, and resources across multiple project files.

The course provides students with an introduction to Microsoft Word. Participants learn to edit and format documents, control page layout, and use various writing tools such as spell check, AutoText, and document templates.
Microsoft Word Level 2
1 Day
In this course, students learn about tables, mail merge, working with styles, templates, and forms.
Microsoft Word Level 3
1 Day
This course provides students with the foundation they need to work with complex documents. Participants learn about enhancing publications with graphics, building page layout, document organization, and automating actions.