Courses & Programs

 

Courses for Office Administration

Certificate in Office Administration

Duration: Weekend classes -5 weeks: Course Code: CIOF -Admin
Cost: $875

Office Administration Certificate course prepared the learners with skills in Microsoft office suite application programs like Word, Excel, PowerPoint and Outlook. You will learn all about documentation, filing, book keeping and printing using software technology.

The program prepares you to increase your confidence and be employable in an entry level position with basic skills and training to assist in various areas of administration in most offices.

Employment Positions that you can tap after the completion of the course are

  • Office Assistant
  • Data Entry Clerk
  • Junior Administrative Assistant
  • Customer Service Support Clerk
  • Receptionist/Front Desk

Course Content:

  • Computer Fundamentals and working with windows 10
  • Business Communication: Wok culture in Canadian offices
  • Microsoft Word: Business letters,Memos,Official Emails
  • Microsoft Excel: Pivot Data analysis,Salary preparation,Sales tax,invoices,advanced excel formulas
  • Microsoft Outlook: Tips to organize office work and contacts efficiently with Outlook
  • Office procedures: Cataloging,Documentation, Filing and printing
  • Job Search ,interview preparation &Resume writing

Advanced Excel & Word

Duration : 10 hours – 3 Weeks
Course Code: Adv-WE
Cost: $395

This course is meant for the learners who wish to equip themselves with the advanced skills in the concepts and features of the Microsoft Word and Excel applications. The courses content gives a customized solution for the students who aspires to enhance their office software skills and have that extra edge in their office.

  • Using shapes, smart art and Word Art in documents
  • Working with Pictures; Working with Clip Art; Working with Text Boxes and Shapes
  • Using Section Breaks; Working with Sections
  • Creating a Table of Contents ; Creating an Index table
  • Working with Quick Styles; Using Installed Templates; Creating a Custom Template
  • Modifying Document Properties; Creating Custom Themes; Customizing the Quick Access Toolbar; Customizing the Microsoft Word Environment
  • Mail Merge Process; Setting Up the Main Document; Previewing and Completing the Merge; Merging Envelopes; Merging Labels
  • Using Bookmarks; Using Footnotes, Endnotes, text and picture watermarks
  • Creating an Electronic Form; Creating a Printed Form

Excel Part:

  • Creating Custom Themes; Working with Quick Styles; Using Conditional and Custom Formatting
  • Referencing Data; Using Hyperlinks; Ensuring Data Integrity
  • Built in functions in Excel, Financial Functions
  • Creating Tables; Sorting and Filtering Data; Grouping and Outlining
  • Understanding PivotTable and PivotChart Reports; Creating PivotTable and PivotChart Reports
  • Protecting a Workbook; Sharing a Workbook with Others; Reviewing and Consolidating Workbook
  • VLOOKUP’s and Data Cleansing

Mastering QuickBooks

Duration : 10 hours
Course Code: QB-Master
Cost: $900

Get started with QuickBooks & set up the right way

  • Learn about your version of QuickBooks and how it compares to the other versions available.
  • Set up your company the RIGHT way. And, if you’ve already set up, learn how to fix any errors you made.
  • Set up online banking and connect your bank and credit cards. Learn how QuickBooks can enter many transactions for you!
  • Import data from Excel and other sources.
  • Discover the best ways to move around QuickBooks to find what you need…fast!
  • See how to get help when you need it.

Everyday transactions

The how and why of standard QuickBooks transactions

  • Sales & money in:
    • Invoices, sales receipts, payments, deposits, credit memos, and customer statements.
    • Run and customize reports to get deeper insight into sales and customers.
    • Stay on top of who owes you money with the best ways to “remind” customers to pay.
  • Expenses & money out:
    • Bills, bill payments, checks, electronic payments, debit card purchases, bills vs. checks, and vendor credits.
    • Run and customize expense & vendor reports to get deeper insights about how and where you’re spending money.
  • Inventory: Set up inventory parts, purchase orders, receive items, adjust inventory.
  • Sales Taxes: set up, adjust, pay, and report sales taxes.

Information Technology Programs

Certificate in Networking Fundamentals

Duration : 8 weeks
Course Code: NTW
Cost: $$$

You can be starting your IT career or taking your current IT skills to the next level in just a few short weeks. The course provides you the practical knowledge with hands on lab exercises.  Our instructors are finest in the IT industry with over 10 years experience in the field.

You will learn all about the network technologies, installation and configuration, media and topologies, management, and security. Candidate job roles include network administrator, network technician, network installer, help desk technician and IT cable installer. Companies such as Dell, HP, Shaw, Telus and many others recommend or require CompTIA Network+ for their networking technicians.

Check course syllabus here   Syllabus for Certificate in Computer Networking (NTW)

Introduction to PC,Laptops & Basic troubleshooting

Duration : 15 hours
Course Code: BCT
Cost: $$$

The course provides you the practical knowledge with hands on lab exercises  for learning about PC’s ,Laptops ,printers and other digital devices used with computerized systems.  Our instructors are finest in the IT industry with over 10 years experience in the field.

You will learn all about hardware and software common errors and fixing those errors like windows errors,installation of new devices , drivers and other relevant software.  The program will help you overcome day to day issues that you face while working with computers.

Certificate in Computer Systems Technology

Duration : 6 weeks
Course Code: CST
Cost: Call to find a quote.

Certificate in Computer Systems Technology course aims towards IT aspirant students who have networking and administrative skills. Our students want to further their careers in IT by acquiring a foundational knowledge of computing topics; prepare for the CompTIA A+ Certification examination; or use A+ as the foundation for advanced networking certifications or career roles.

The program strengthens foundation-level knowledge and skills necessary for a career in IT support. It gives hands-on” orientation focused on scenarios in which troubleshooting, and tools must be applied to resolve problems. Our students will gear up to take up the roles like IT Technician, PC Support technician, Helpdesk Support, IT Support etc.  The course will teach you about the hardware common to virtually every personal computer, including microprocessors, RAM, power supplies, motherboards, UEFI/BIOS, the system setup utility, the expansion bus, and input/output devices. You will learn how things work, how to configure everything, and how to troubleshoot in real-world environments.

Check course syllabus here   Syllabus for Certificate in Computer Systems Technology (CST)

Windows Server2019 Installation & Configuration

Duration : 3 weeks
Course Code: WSIC
Cost: Call to find a quote.

WSIC: Server Installation and Configuration course makes you learn how to install the core service and additional required services for Windows Server 2019. You will gain an understanding of the Active Directory and how to manage users and accounts within it. Reduce user maintenance through the creation and configuration of organizational units and user groups. You will be working on the virtual machines for server management.  Our experienced instructors will teach you the course ware with practical labs. and hands on exercises 100% of the course. You will be supported with exam preparation tools and techniques as well.

Course Content:

  • Installation of Windows Server 2019
  • Configuration of Servers roles and features
  • Configure Hyper-V
  • Deploy and configure core network services
  • Install and administer Active Directory
  • Create and manage GPO’S (Group policies)

Windows Server 2019 Administration

Duration : 6 weeks
Course Code: WSA
Cost: Call to find a quote.

This is the second Course in our Windows Sever 2019 course woks, after Installing and Configuring Windows Server 2019 WSIC Course. Students will like a look at how to administer, deploy, configure, & monitor network servers as well as various advanced files. Learn the main exam objectives by learning these key concepts we cover:

  • Deploy, manage, and maintain servers
  • Configure File and Print Services
  • Configure network services and access
  • Configure a Network Policy Server (NPS) infrastructure
  • Configure and manage Active Directory
  • Configure and manage Group Policy

Course Breakdown:

  • Section 1: Learn how to deploy, maintain and monitor Windows Server 2019. Utilize the deployment services, windows server update services and how the main monitoring solutions in Server 2019
  • Section 2:Know how to appropriately assign access rights to users, securely track access to resources, and how to provide up to date and efficient access to those resources.
  • Section 3:Look at the configuration of network access and services in Windows Server 2012 by become familiar with the components of DNS, how to configure and maintain DNS, and how to use remote access.
  • Section 4: Gain a thorough understanding of the network policy server infrastructure and how to properly configure one to benefit an organization.
  • Section 5: Review the enhancements and features of the Active Directory Domain Services and walk through the process of hosting a domain database and providing security-related services throughout an enterprise.
  • Section 6: Learn the skills needed to work within the Group Policy Management Console, how to configure and control Group Policy settings, and about the resourcefulness of Group Policy templates.
  • Section 7: Cover virtualization of Windows Server 2019 domain controllers, updates to remote access in Windows Server 2019, and updates to distributed file system in Windows Server 2019

We teach you paired with a variety of demonstrations and quizzes giving visual example and real world look of the concepts that will be talked about. This course is 80-90% practical and hands on. Our experienced instructors will facilitate the learning process through out for you.

Microsoft Office Courses

MS Word

Duration : 8 hours
Course Code: MSW
Cost: $395

The course is best suited for the beginners and new aspirants in software field. This course is at a competitive price taught by an experienced teacher in a small interactive classroom environment. Through lectures and class assignments, students learn skills that are required by many jobs and school projects. This course will also prepare students for questions that are asked on many employment skill tests.

Learn to create, navigate, and organize documents and use the help functions. You will learn to

  • To create ,edit manipulate text documents
  • View and format documents
  • Set and work with page layouts features
  • Use the Find and Replace feature,
  • Paragraph shading and editing
  • Using Proof reading and language tools,
  • Create, format and modify tables
  • Working with hyperlinks and cross references
  • Learning how to preview and print a document.

Microsoft Word Advanced

Duration : 6  hours
Course Code: MWA Fee: $395

The Microsoft Word Level advanced course gives students intermediate- to advanced-level concepts and features of the Microsoft Word application. In this course, students learn to customize Word and build upon the basic skills learned in the Word Fundamentals course. The learning objectives for each lesson through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the Word skills covered in the course.

  • Using shapes, smart art and Word Art in documents
  • Working with Pictures; Working with Clip Art; Working with Text Boxes and Shapes
  • Using Section Breaks; Working with Sections
  • Creating a Table of Contents ; Creating an Index table
  • Working with Quick Styles; Using Installed Templates; Creating a Custom Template
  • Modifying Document Properties; Creating Custom Themes; Customizing the Quick Access Toolbar; Customizing the Microsoft Word Environment
  • Mail Merge Process; Setting Up the Main Document; Previewing and Completing the Merge; Merging Envelopes; Merging Labels
  • Using Bookmarks; Using Footnotes, Endnotes, text and picture watermarks
  • Creating an Electronic Form; Creating a Printed Form

Microsoft Excel Level-1

Duration : 6 hours
Course Code: MEF
Fee: $325

Our Excel level -1 course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly. Learn how to: Quickly set up workbooks, enter data, and format it for easier viewing, do calculations and find and correct errors, make decisions and Visualize data with charts and graphs, including new sunbursts, waterfalls, and tree maps and Print worksheets and charts.

  • Exploring Microsoft Excel; Creating Workbook Files; naming worksheets ,adding worksheets
  • Viewing Worksheets; Navigating Worksheets and Workbooks; Managing Worksheets and Workbook Files
  • Cell referencing : Relative and Absolute
  • Creating Basic Formulas; Editing Text and Values; Clearing, Moving, and Copying Cell Content; Modifying Worksheet Structure
  • Understanding Functions; Using Functions; Using Mathematical and text Functions; Using Date and Time Functions;
  • Formatting Cells and Cell Content; Formatting Worksheets
  • Preparing Worksheets for Printing; Using Find and Replace; Previewing and Printing Worksheets

Microsoft Excel Level-2

Duration : 5 hours
Course Code: MEB
Fee: $350

Microsoft Excel Level 2 course teaches students intermediate to advanced-level concepts and features of the Microsoft Excel application. In this course, students learn to customize Microsoft Excel and streamline workflow by building upon the basic skills learned in the Microsoft Excel – Level 1 course. They learn to use named references, validate and consolidate data, use links and hyperlinks, and reference external data. Students learn to use cell comments, custom and conditional formatting, styles, and templates. They also practice working with graphics, charts, diagrams, and databases (lists).

  • Creating Custom Themes; Working with Quick Styles; Using Conditional and Custom Formatting
  • Referencing Data; Using Hyperlinks; Ensuring Data Integrity
  • Built in functions in Excel
  • Creating Tables; Sorting and Filtering Data; Grouping and Outlining
  • Understanding PivotTable and PivotChart Reports; Creating PivotTable and PivotChart Reports
  • Protecting a Workbook; Sharing a Workbook with Others; Reviewing and Consolidating Workbook
  • VLOOKUP’s and Data Cleansing

Microsoft Excel Level-3

Duration : 5 hours
Course Code: MEC
Fee: $375

In this advanced Excel course, you will learn about: Alternative Data Sets, Dynamic Worksheets with PivotTables, Automating Repetitive Tasks with Macros, Working with Other Microsoft Office Apps, Business Intelligence Analysis and Forecasts and Visualizations.

  • Using Microsoft Excel with Other Microsoft Office Programs; Importing Data from External Sources; Using Microsoft Excel Data on the Web
  • Advanced Formula Techniques
  • Working with Macros
  • Data Cleaning and Preparation
  • Financial Functions and Working with Dates
  • Building Professional Dashboards

Microsoft Access Level-1

Duration : 6 hours
Course Code: RDBMS-1
Cost: $395

This course will give learners an introduction to the Access , students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries, and how to work with forms and reports. This course will help students prepare for the Microsoft Office Specialist exam for Access.

  • Introduction to Microsoft Access; Exploring the Access Application Window; Opening and Closing a Database; Getting Help
  • Examining Database Objects; Managing Data; Editing Data in Datasheet View
  • Creating a Database; Creating a Table; Setting Field Properties; Modifying Tables and Fields
  • Sorting and Filtering Data; Displaying and Formatting Data; Using Queries to Retrieve
  • Understanding and Creating Forms; Modifying and Customizing Forms; Formatting and Modifying Form Properties
  • Understanding and Creating Reports; Modifying and Customizing a Report; Formatting Reports and Modifying Report Properties; Printing a Report

Microsoft Access Advanced

Duration : 5 hours
Course Code: RDBMS-2
Cost: $375

This course will enable students with the advanced concepts of the database system in Access. This course contains the following content :

  • Database Relationships; Defining a Database Relationship; Modifying Table Design
  • Selecting Data from a Single Table
  • Selecting Data from Multiple Tables; Creating Parameter and Action Queries; Summarizing and Grouping Data; Optimizing a Query
  • Importing and exporting data from Access to other applications like excel
  • Creating Advanced queries and reports
  • Access Macros
  • SQL and Microsoft Access

Power Point & Outlook

Duration : 4 hours
Course Code: MPO-1
Cost: $325

Microsoft Outlook is available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, journal, and web browsing.

If you want to present any information creatively and professionally, Microsoft PowerPoint is the perfect tool. With this course, we help you learn how to use Microsoft PowerPoint and start creating memorable PowerPoint presentations. All classes in PowerPoint are taught by experienced and professional trainers.

The students in this course will learn the following content :

  • Outlook – Adding and Removing Account
  • Use the Address Book, format and spell check new messages
  • Attach files and insert illustrations to messages.
  • Customize read and response options.
  • Use flags, categories, and folders to organize messages.
  • Create and work with Contacts.
  • Create appointments and schedule meetings in Calendar.
  • Create and work with Tasks and Notes
  • Working with the Calendar.

Power-point content:                       

  • Basic features and functions of PowerPoint.
  • Develop a PowerPoint presentation.
  • Perform advanced text editing operations.
  • Add graphical elements to your presentation.
  • Modify objects in your presentation.
  • Add tables to your presentation.
  • Add charts to your presentation.
  • Prepare to deliver your presentation.

Introduction to keyboarding & Windows

Duration : 6 Hrs.
Course Code: WKB-10
Cost: $425

  • Personal computers and Windows 10
  • Start menu, task bar and desktop Work with Desktop Windows
  • Windows 10 Navigation Summary
  • Manage Files and Folders with File Explorer
  • Create and Modify Files with Desktop Applications
  • Change Basic Windows Settings
  • Configure user accounts and Passwords
  • Use Windows Defender
  • Store and Share Files with OneDrive
  • Keyboarding and typing skills with best and easy typing software provided by the institute to you
  • Effective tips and learning tools for improving typing speed on the keyboard