In a hands-on environment, you will learn about Excel’s amazing tools, spreadsheets and workbooks. In this class participants will create and format worksheets, workbooks and charts. You will learn how to enter and edit text, values, formulas, and navigate between worksheets and workbooks. You will also explore various options for printing and this program’s graphing capabilities.

Prerequisites: Keyboarding skills an asset. Windows introduction or experience with Windows

This course is for students who already have an understanding of the basic features of Microsoft Access. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access which add functionality to your database and will save you time. Topics include: structuring existing data, writing advanced queries, using macros to automate common tasks, and enhancing forms and reports. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

Prerequisites: Access Introduction or equivalent experience using Access in the workplace

This course is designed for students new to working with Microsoft Access. Learn to use Access to quickly track and report information with ease - even if you don’t have any database experience. This course will guide you through the process of designing, creating and using a simple database so that you can make more informed business decisions from recorded data. Topics include creating and modifying tables; data manipulation; sorting and filtering records as well as performing queries. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

This class may be offered live on your personal computer if you have a webcam with a microphone, high speed internet and Microsoft Excel software. Call Rick Wagman at (306) 775-7450 for more information.

Prerequisites: Basic computer skills or Computer Basics class

Increase your productivity and apply advanced analysis techniques to more complex data sets by using more of the built in features of Microsoft Excel. Topics include: using functions; pivot and input tables; sorting and filtering numeric data, advanced charts and macros. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

Prerequisites: Excel Introduction or equivalent experience using Excel in the workplace

Microsoft Excel is a powerful tool for creating spreadsheets that allows you to analyze and share information more effectively. This course is intended for people new to Excel. In this class you gain the skills and knowledge needed to create and use worksheets and charts. Topics include: entering, copying and manipulating data; creating and editing simple formulas; using common functions; formatting worksheets; and printing data. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

Prerequisites: Basic computer skills or Computer Basics class

In this 5-day comprehensive course you will be introduced to the fundamentals, and obtain hands-on skills with, the popular group of programs in Microsoft Office: Word, Excel, Outlook, Access and PowerPoint. This course is intended for participants who would like to jumpstart their Microsoft Office productivity skills. Upon completion you will be able to immediately apply your new knowledge in your career environment. This course is not recommended for the novice computer user and we suggest you have basic experience with at least one Microsoft Office program.

Prerequisites: Familiarity using computers is required, including basic knowledge of Windows; keyboarding an asset

Microsoft Visio allows you to easily create a broad range of business and technical diagrams applicable to any organization. In this course, you learn to use the built-in Visio templates and stencils to create sophisticated diagrams. You also learn how to create and work with stencils and drawing pages; utilize drawing tools; utilize the text editing and formatting tools; use shape connectors; add backgrounds to drawings; and much more! Hands-on exercises during this course will help you to practice features as you learn them. A course manual will be provided.

Prerequisites: Familiarity using computers is required, including basic knowledge of Windows

In this course, students will use Microsoft Outlook to manage email, calendar entries, tasks and contacts. You will also gain an understanding of email terminology and concepts such as spam, viruses, phishing and distribution lists. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

This course is designed to provide students with an understanding of PowerPoint. It will benefit anyone wishing to create dynamic presentations which will help you to communicate information and sell ideas. Topics include: creating and running a slide show presentation; working with text and content; incorporating illustrations and shapes; adding transitions and animation effects; custom layouts and slide masters; using charts; printing slides, handouts, notes and outlines. Handson exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

Prerequisites: Basic computer skills or Computer Basics class

Join us in this introduction to this amazing presentation software package You will discover how easy it can be to create an impressive slide show and presentation material. This class will explore basic tools in a hands on environment, so you can go home and put it straight to use.

Prerequisites: Windows introduction or experience with Windows

Advanced Project is for those who already have a good understanding of the basic features of Microsoft Project and want to find out more about this powerful business tool. In this course, you will build on your knowledge by learning about the specialized capabilities which will add to the functionality of your project. Topics include: cost control; work breakdown schedule, sub projects; resource allocation including shared resources; the complete range of alternative visual view of reports; and a demonstration of future considerations for Project – SharePoint, Visio and Project Server. You will learn to work from the back end to front end with a comprehensive project case to determine project dates and build a cumulative in-class project.

Prerequisites: Project Essentials or a good understanding of Microsoft Project

This course provides practical guidance on how to plan and schedule projects using MS Project. On completion of the course students will have acquired the skills needed to create a new project; analyze and adjust schedules with date, dependency and resource constraints; customize and print Gantt Chart views and reports; and record and review task progress against the baseline. Readers will also acquire the necessary skills to customize and print high quality charts and reports for effective communication of project plans. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

Prerequisites: A general understanding of Windows is beneficial

Microsoft Publisher is an easy-to-use, flexible program for creating newsletters, brochures, business cards, postcards and flyers for print, email, and the Web. You will look at how to create a publication from scratch or use one of the hundreds of business and personal designs available in Publisher.

Prerequisites: Good working knowledge of Windows and word processing

Find yourself assigned to the role of SharePoint member and site owner? Lots of questions? Well here’s the answer to all your questions. Our Microsoft Office SharePoint Server 2010 training will show you the basics of how SharePoint can be used as an effective way to collaborate with your organization. Hands-on exercises during the course will help you practice skills as you learn them.

Prerequisites: Knowledge of Microsoft Office and experience accessing information via a web browser.

This course helps you create automated spreadsheets for all those repetitive tasks. We take you through Visual Basic for Applications in Excel, all the way from recording Excel VBA macros through to designing your own user forms. On the way you will learn what variables are, how to write object-oriented programs, how to create loops and much more besides. Microsoft Excel VBA macros are fun – let us show you why! Hands-on exercises during class will allow you to practice these skills. You will receive a manual for future reference.

Prerequisites: Sound Excel skills and understand key concepts of spreadsheets or equivalent to our advanced course level

Are you ready to take your Word Documents to the next level? This course takes you through the basics of Visual Basic for Word, covering the automation of documentation for repetitive tasks and the production of automated templates. At the end of the course, users will be able to record and run macros, edit the VBA code, build in looping structures and create custom forms. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for future reference

Prerequisites: You must have sound Word skills, equivalent to our advanced course level

Microsoft Word is the word processing choice of most companies. It is the leading word processing package in the Windows environment. You will learn about the various keyboard functions, and explore the many tools for creating impressive documents. With practical hands on learning, this class will get you up and running in the basics of this widely used program.

Prerequisites: Keyboard familiarity an asset. Windows introduction or experience with Windows

Increase your productivity and create more complex documents by learning how to use more features of Microsoft Word. Our instructors will take experienced users of through advanced tasks such as creating a table of contents and using master and sub documents when working with longer projects. Learn to perform complex merges, import data from other programs and advanced automation through the use of fields, forms and macros. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

Prerequisites: Microsoft Word Introduction or equivalent experience using Word

This course is intended for people new to Microsoft Word and is designed to help you to obtain the basic skills required to create professional looking documents such as letters and memos. You will learn to create, edit, format, print and review short documents. You will learn to apply basic page, paragraph and character formatting options, create a document from a template, insert pictures and clip art, create a simple table and merge a mailing list to produce labels. Hands-on exercises during class will allow you to practice these skills. You will receive a manual for your future reference.

Prerequisites: Basic computer skills or Computer Basics class