Microsoft Office Training Courses
Our portfolio of training courses offer a wide selection of classes and variety of interest to the corporate student. Whether you are new at your job learning with our introductory Microsoft Powerpoint and Outlook training courses, learning new tips and tricks with the Intermediate skill levels in our Word and Excel training classes, or delving into the depths the programs by taking our advanced Access training courses, Training Centres of Canada - Toronto can provide you with the premiere training class environment to upgrade your skills.click below to view in depth information regarding training dates, pricing and outlines of topics for each office program
|Access Training Courses||Excel Training Courses||Outlook Training Courses||PowerPoint Training Courses||Visio Training Courses||Word Training Courses||2010 Transition Training Courses|
What is Microsoft Office?
- a database management system that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases. Software developers and data architects can use Microsoft Access to develop application software, and "power users" can use it to build software applications. Like other Office applications, Access is supported by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating-system functions.
- is a spreadsheet application. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).
It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface, for example, a stock analyzer,or in general, as a design tool that asks the user questions and provides answers and reports.
In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule, analyze the results, make a Word report or Power Point slide show, and e-mail these presentations on a regular basis to a list of participants.
- is a personal information manager.
Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, a journal and web browsing.
It can be used as a stand-alone application, or can work with Microsoft Exchange Server and Microsoft SharePoint Server for multiple users in an organization, such as shared mailboxes and calendars, Exchange public folders, SharePoint lists and meeting schedules. There are third-party add-on applications that integrate Outlook with devices such as BlackBerry mobile phones and with other software such as Office and Skype internet communication. Developers can also create their own custom software that works with Outlook and Office components using Microsoft Visual Studio.In addition, Windows Mobile devices can synchronize almost all Outlook data to Outlook Mobile.
presentations consist of a number of individual pages or "slides". The "slide" analogy is a reference to the slide projector. Slides may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. For larger audiences the computer display is often projected using a video projector. Slides can also form the basis of webcasts.
PowerPoint provides three types of movements:
Entrance, emphasis, and exit of elements on a slide itself are controlled by what PowerPoint calls Custom Animations.
Transitions, on the other hand, are movements between slides. These can be animated in a variety of ways.
Custom animation can be used to create small story boards by animating pictures to enter, exit or move.
PowerPoint provides numerous features that offers flexibility and the ability to create a professional presentation. One of the features provides the ability to create a presentation that includes music which plays throughout the entire presentation or sound effects for particular slides. In addition to the ability to add sound files, the presentation can be designed to run, like a movie, on its own.
PowerPoint allows the user to record the slide show with narration and a laser pointer. You may customize slide shows to show the slides in different order than originally design and to have slides appear multiple times. Microsoft also offers the ability to broadcast the presentation to specific users via a link and Windows Live.
- is a diagramming and vector graphics application.
Used to design computer network diagrams / or generate visual maps of networks, servers, storage, services, data centers, and other peripherals.
A concept map is a way of representing relationships between ideas, images, or words in the same way that a sentence diagram represents the grammar of a sentence, a road map represents the locations of highways and towns, and a circuit diagram represents the workings of an electrical appliance. In a concept map, each word or phrase is connected to another and linked back to the original idea, word or phrase. Concept maps are a way to develop logical thinking and study skills by revealing connections.
A flowchart is a type of diagram that represents an algorithm or process, showing the steps as boxes of various kinds, and their order by connecting them with arrows. This diagrammatic representation solution to a given problem. Process operations are represented in these boxes, and arrows; rather, they are implied by the sequencing of operations. Flowcharts are used in analyzing, designing, documenting or managing a process or program in various fields.
- is a word processing software application that enables you do easily create both simple and complex documents, such as memos or reports. Microsoft Word provides tools to enable you to check spelling of your document, create merge letters and add graphics to enhance your written information.
1. Create visually compelling documents
With Word, you can create compelling documents while applying formatting effects such as shadow, bevel, glow, and reflection to your document text. You can spell-check text that uses visual effects, and add text effects to paragraph styles. Many of the same effects used for images are now available to both text and shapes, enabling you to seamlessly coordinate all of your content.
2. Turn your text into compelling diagrams
Word offers you more options to add visual impact to your documents. Choose from dozens of additional SmartArt Graphics to build impressive diagrams just by typing a bulleted list. Use SmartArt to transform basic, bullet-point text into compelling visuals that better illustrate your ideas.
3. Add visual impact to your document
New picture-editing tools in Word enable you to add special picture effects without additional photo-editing software. You can easily adjust pictures with color saturation and temperature controls. You also get improved tools for easier and more precise cropping and image correction, to help you turn a simple document into a work of art.