Desktop Courses

Below is the list of all the classes we are currently offering. Click the course's name for additional information.
? Need more information?
Can’t find what you’re looking for?
Interested in booking a private training session?
Contact us and let us know your training needs.
Before registering for a class, please consult our Cancellation Policy






Access 2007/2010 Level 2

Students will learn about field properties. How to restrict data entry in fields, create input mask, lookup fields, simple queries, action queries, parameter queries and query joins. Focus will also be placed on the use of wild cards. Students will also learn how to maintain data security utilizing referential integrity.
 
  Course Outline:



Access 2007/2010 Level 3

Students will learn how to create forms using the form wizard, create textbox controls, Combo boxes, sub forms, and command buttons. They will learn all the functionalities of a form in design view, and how to create reports from queries, import data from Excel file, and how to set form properties.
 
  Course Outline:



Access 2010 boot camp

5 half days boot camp. Prerequisite Intermediate computer skills and experience with Microsoft Excel and other Microsoft Office programs. Access Training Topics Covered – • Database Concepts • Design vs. Datasheet View • Database wizard • Creating blank databases • Creating tables • Working with Fields • Adding fields • Identifying primary key fields • Adding records • Changing table designs • Modifying field names • Deleting and inserting fields • Records • Finding and editing records • Sorting and filtering records • Setting field properties • Input Masks • Validation Rules • Queries • Creating Queries • Filtering Queries • Modifying query results • Using Calculators • Average and Count functions • Creating forms to enter data • Formatting and customizing forms • Using forms to find, sort, and filter records • Creating reports through the report wizard • Field properties • Relational databases • Database normalization • Table Relationships • Referential integrity • Related Tables • Creating lookup fields • Modifying lookup fields • Sub-datasheets • Complex queries • Joining tables in a query • Using calculated fields • Summarizing and grouping values • Advanced form design • Adding unbound controls • Graphics • Adding combo boxes • Reports and printing • Customized headers and footers • Calculated values • Labels • Advanced Queries • Creating Crosstab queries • Creating parameter queries • Using Action queries Workshop – Instructor led assistance on individual student databases This Boot camp concentrates on building the Access Database, it does not include Macros, Creating a Splash screen, or Splitting of the DB.



Access 2010/2013/2016 Level 1

Students will learn to how to define the appropriate tables, fields, and data types for a database. They will create and modify fields, understand normalization, define the (3) types of relationships, determine Primary and Foreign keys, and create relationships between tables. Students will participate in hands on labs, create notes from the instructor’s guidelines, and begin building an individual database.
 
  Course Outline:



Crystal Reports Level 1

This course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret information. As a business benefit, learners will find that this course is an in-depth approach to the entire report creation cycle from planning a report prototype to distributing a report.
 
  Course Outline:



Crystal Reports Level 2

This course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret information. As a business benefit, learners will find that their increased understanding of formulas, variables, arrays, templates, parameters, summaries, and sections will help them make more effective report design decisions and create more efficient reports.
 
  Course Outline:



Excel 2007/2010 Level 1

Students will gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets. They will also learn how to perform calculations and manage large workbooks.
 
  Course Outline:



Excel 2007/2010 Level 2

Students will learn how to create templates, sort and filter data, import and export data, and analyze data. Students will also learn how to calculate with advanced formulas, organize worksheet and table data using various techniques, create and modify charts, analyze data using PivotTables and PivotCharts, insert graphic objects, and customize and enhance workbooks and the Microsoft® Office Excel® environment.
 
  Course Outline:



Excel 2007/2010 Level 3

Students will gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, work with multiple workbooks, import and export data, and use Excel with the web.
 
  Course Outline:



Excel 2013/2016 Level 2

Students will learn how to create templates, sort and filter data, import and export data, and analyze data. Students will also learn how to calculate with advanced formulas, using Ifs/VlookUps/Arrays and 3D Functions, organize worksheets and table data using various techniques, Create and modify charts, analyze data using PivotTables and Pivot Charts.



Excel 2013/2016 Level 3

Students will gain the skills necessary to create Macros, assign buttons to a Macro, use advance functions, such as SumIfs, CountIfs, create interactive Charts, Sparklines, collaborate with others, audit and analyze worksheet data, work with multiple workbooks, use Trim function and export data. Create Name range functions.



Excel 2013/2016 Level 1

Students will gain the skills necessary to create & edit basic Excel formulas. They will also learn how to perform range calculations and use short cuts to manipulate large spreadsheets. How to hide & freeze rows and columns, separate text into columns, and find blanks within a spreadsheet.



InfoPath 2007/2010

Microsoft® Office InfoPath® Forms is a product that gathers and shares information. In this course, you will use InfoPath to streamline the process of gathering and sharing information.
 
  Course Outline:



JavaScript 101

This class is strictly for Beginners with no programming skills. Students will learn how to create; Basic JavaScript ,declare Variables to store User-Entered Data, create functions that can be used anywhere in the program, examine the different types of objects, and create a simple game using JavaScript



MOS 2010 Outlook Expert Training




MOS 2010 Review for exam

MOS 2010 Review for exam



MOS Microsoft Office Excel Expert Training




MOS PowerPoint 2010 expert training




Office 2007/2010 skill level assessment

Our Microsoft Certified Trainer will access your current or prospective employee's level of ability in Microsoft Office. Each Microsoft office program is assessed separately.



Office 2013 New Features

An overview of the new features in Word, Excel and PowerPoint in Office 2013. This class can be customized to suite your needs.



Office 365

Overview of the Cloud using Office 365, creating Team sites, SharePoint, Lync



Outlook 2010/2016

This course focuses on using Outlook to communicate & organize data pertaining to the office environment. Students will manage emails, create contacts, learn to drag & drop from emails to create task, appointment, etc. Schedule meetings, share calendars, and organize task. Go behind the scenes to change default options in various components of Outlook. Create and assign categories, flag emails, and create Quick Steps for repetitious task. Create folders and use multiple time zones on the calendar. Save time by easily attaching documents that you most recently used to your emails from the Ribbon.
 
  Course Outline:



PowerPoint 2007/2010 Advanced

As a Microsoft® Office PowerPoint® 2007 user, you are familiar with the basics of creating a presentation and you are able to convey information effectively in a simple way. Static content in presentation, however, will not keep your audience interested. In this course, you will enhance presentations with feature that will transform basic presentations into a powerful means of communication.
 
  Course Outline:



PowerPoint 2007/2010 Proficient

Students will use the features available to create, modify and customize presentations. They will learn to add text and visual elements, import data from other sources, and create outputs. Slide show features such as timings, transitions and animation will also be covered. Students will learn to prepare and deliver a professional and effective presentation.
 
  Course Outline:



PowerPoint 2013 Level 1

Students will use the features available to create, modify and customize presentations. They will learn to add text and visual elements, import data from other sources, and create outputs. Slide show features such as timings, transitions and animation will also be covered. Students will learn to prepare and deliver a professional and effective presentation.



PowerPoint 2013 Level 2

As a Microsoft® Office PowerPoint® 2013 user, you are familiar with the basics of creating a presentation and you are able to convey information effectively in a simple way. Static content in presentation, however, will not keep your audience interested. In this course, you will enhance presentations with feature that will transform basic presentations into a powerful means of communication.



Project 2007 Advanced

Customised courses are available to meet any need. High-end topics include creating and customizing views, calendars, and tables; working with resource pools; combining projects and managing multiple projects; and creating custom calculations. We can create a high-end working environment that incorporates Project into Outlook (via Exchange or internet based mail handling), centralized server shared Projects and resources, and Project Central / Server.



Project 2007 Introduction

Students will get an overview of creating and managing projects. They will discuss resources, linking tasks, observe the critical path, and working with constraints. Students will get a general overview of outlining, generating project reports, resolving time restrictions and resource conflicts, as well as sorting and filtering data.
 
  Course Outline:



Project 2010 Advanced

Customised courses are available to meet any need. High-end topics include creating and customizing views, calendars, and tables; working with resource pools; combining projects and managing multiple projects; and creating custom calculations. We can create a high-end working environment that incorporates Project into Outlook (via Exchange or internet based mail handling), centralized server shared Projects and resources, and Project Central / Server.



Project 2010 Introduction

Students will get an overview of creating and managing projects. They will discuss resources, linking tasks, observe the critical path, and working with constraints. Students will get a general overview of outlining, generating project reports, resolving time restrictions and resource conflicts, as well as sorting and filtering data.



Project 2013 level 1

Starting a Project, Working with Project Calendars, Working with Project Resources
 
  Course Outline:



Project 2013 level 2

Managing the Project Environment, Create a Work Breakdown Structure, Identify Task Relationships, Define Resources within the Proje
 
  Course Outline:



Project 2013 level 3

Tracking your Project Work Package Estimates, Creating an Initial Schedule, Create a Resource Leveled Schedule, Formatting Output and Printing Reports, Recording a Macro in Project 2013
 
  Course Outline:



Publisher 2010

Students will learn how to create flyers, brochures, business cards as well as multi-page documents using text, graphics, various formats and styles.



Quickbooks Pro 2013 level 1

Students will learn how to manage the accounts of a small business. This will include creating invoices, writing cheques, paying bills, creating purchase orders, tracking inventory, creating various reports, and transferring information to Excel and Word.



Quickbooks Pro 2013 level 2

Upon successful completion of this course, students will be able to: • customize forms. • use the other QuickBooks accounts and track credit card transactions. • create and modify various types of reports. • create graphs. • track and pay sales tax. • track payroll information with QuickBooks. • keep track of the job you are working on and generate reports for it. • use QuickBooks to write various types of letters. • synchronize QuickBooks with other contact management software.



Visio 2010 Level 1

Diagrams and charts play a pivotal role in knowledge dissemination, making complex data easy to understand. Microsoft® Office Visio® Professional 2007 has a host of features that are instrumental in creating pictorial representations of information. In this course, you will learn the essentials of Visio.
 
  Course Outline:



Visio 2010 Level 2

This course will build upon the knowledge gained, and enable you to work with many advanced features, including using the drawing tools, creating and working with custom stencils and templates, and sharing your Visio drawings with other applications.
 
  Course Outline:



Word 2010/2013/2016 Level 2

Students will learn how to manage lists, customize tables and charts, modify pictures, create customized graphic elements, use quick parts to insert content, control text flow, use templates to automatic document creation, automate mail merges and use macros.
 
  Course Outline:



Word 2010/2013/2016 Level 3

Students will learn how to reference document content (table of contents, index, cross referencing, footnotes and endnotes). Embedding external content (eg Excel tables and charts), document versions, forms, tracking changes, securing the document, and long document considerations will be presented.
 
  Course Outline:



Word 2010/2016 Level 1

Students will explore the user interface and learn how to open and view a document, customize the word environment, obtain help, enter and format text, save a document, use tables, insert graphics, control page layout and use the spell check and thesaurus. Learn the new feature in 2016 called "Tell me what you want to do" Learn how to collaborate with colleagues in Real Time. View a complete list of recent changes to a document
 
  Course Outline:



Word 2013 Level 1

Students will explore the user interface and learn how to open and view a document, customize the word environment, obtain help, enter and format text, save a document, use tables, insert graphics, control page layout and use the spell check and thesaurus.



Word 2013 Level 2

Students will learn how to manage lists, customize tables and charts, modify pictures, create customized graphic elements, use quick parts to insert content, control text flow, use templates to automatic document creation, automate mail merges and use macros.



Word 2013 Level 3

Students will learn how to reference document content (table of contents, index, cross referencing, footnotes and endnotes). Embedding external content (eg Excel tables and charts), document versions, forms, tracking changes, securing the document, and long document considerations will be presented.


? Need more information?
Can’t find what you’re looking for?
Interested in booking a private training session?
Contact us and let us know your training needs.
Before registering for a class, please consult our Cancellation Policy