Course Information

  • Home
  • Course Information
Microsoft® Applications

Connect Learning has been offering computer application classes for more than 15 years. We offer training on the latest software versions of Microsoft Office, Primavera P6, and Adobe software, including classes in our public and online classrooms, onsite and private coaching. We offer a full range of classes from Introduction to Advanced levels. We also customize our cirriculum for onsite classes to fit our clients needs.

Please use these outlines as a general guide for the topics that will be taught. We cannot guarantee that all the topics listed in an outline will be covered during your particular class. Based on student need, your instructor may have to adjust the course content to suit your class, unexpected events, as well as the number and skill level of the students in attendance.

Microsoft® Access

Microsoft® Access is a database application that allows users to create custom databases to store information in an organized structure. The program also provides a visual interface for creating custom forms, tables, and queries. Data can be put into an Access database using either a form or a spreadsheet interface. The information stored within an Access database can be queried, searched, and accessed from other programs. Access is a proprietary database management system that is compatible with other database programs since it supports Open Database Connectivity (ODBC). This allows data to be sent to and from other database programs and also enables Access to serve as the back end for a database-driven website.

Microsoft® Excel

Microsoft® Excel is an electronic spreadsheet program that is designed to work primarily with numbers. An electronic spreadsheet is a computer software program that is used for storing, organizing and manipulating data. Related data is stored in a collection of cells organized into rows and columns forming a table. Excel can store multiple spreadsheet pages in a single computer file. The saved computer file is referred to as a workbook, and each page in the workbook is a separate worksheet. Excel is capable of:

  • Finding information
  • Calculating basic or complex formulas
  • Analyzing and charting data
  • Formatting, sorting, and filtering data
  • Printing reports
Microsoft® OneNote

Microsoft® OneNote is a computer program for free-form information gathering and multi-user collaboration. It gathers users' handwritten or typed notes, drawings, screen clips, and audio files into a clearly delineated organizational structure that simulates physical note-taking, revolving around notebooks, tabs, and pages. Notes can be shared with other OneNote users over the Internet or a network. If you do a lot of notetaking, attend multiple meetings, and collaborate with others on projects, then OneNote can keep all your information, including words in pictures, in a searchable format. You can have multiple notebooks - the structure works well for dividing up work tasks. Across the top of each notebook are tabs, each one representing what it calls a section. The sections hold the individual notes, which are listed down the right side. You can also nest a note under another note, which keeps related items organized or breaks up a long list, and still keep your data integrated with the rest of the Office suite.

Microsoft® Outlook

Microsoft® Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite, however Outlook may be used as a standalone application. It allows you to access your email from different accounts in one place. And you can add any email account that ends in @outlook.com, @live.com, @hotmail.com, or @msn.com to Outlook. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, 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. Companies can also integrate Outlook with Microsoft’s SharePoint platform to share documents, project notes, collaborate with colleagues, send reminders and much more.

Microsoft® PowerPoint

Microsoft® PowerPoint is a presentation program developed by Microsoft that allows users to create anything from basic slide shows that can be used for education, to complex business presentations. The presentations are made up of slides, which could contain text, images, audio clips or movies. Sound effects and animated transitions are used to draw attention to specific information, or move from one slide to another. They can be created from a blank slide or from templates pre-configured for specific projects. When presenting a PowerPoint presentation, the presenter may choose to have the slides change at preset intervals or may decide to control the flow manually. This allows more interactivity with the audience and brings greater focus to each point.

Microsoft® Project

Microsoft® Project, is a program designed to give the user more efficient project and portfolio management tools to set realistic goals by creating schedules, distributing resources and managing budgets. The main modules include project work, project teams, schedules and finances. The Project Guide helps users create projects, track tasks, and report results. The software helps contractors simplify the assignment of resources, tasks and budgets to help project managers gain control over their resources and finances. Microsoft Project also comes with a customizable wizard that walks users through the process of project creation, from assigning their tasks and resources to reporting the final results. Project is used in a variety of industries including construction, manufacturing, pharmaceuticals, government, retail, financial services and health care.

Microsoft® Publisher

Microsoft® Publisher is a desktop publishing application that allows users to easily create business cards, greeting cards, calendars, newsletters and much more. In Publisher, the emphasis is placed on page layout and design rather than text composition and proofing. When you first open Publisher, you see a selection of templates which are ready-made publications to start a card, brochure or other creations. Templates give you everything you need to quickly customize your publication by editing the existing text, insert new text boxes or add your own images. With Publisher, every object stays exactly where you want it. Place a paragraph of text or a picture without worrying about how other objects will move or jump between pages as it might in a Word document.

Microsoft® Sharepoint

Microsoft® SharePoint is a browser-based collaboration and document management platform. It allows groups to set up a centralized, password protected space for document sharing. Organizations use SharePoint to create websites. You can use it as a secure place to store, organize, share, and access information. "SharePoint" can refer to one or more SharePoint products or technologies, including:

  • SharePoint Online – A cloud-based service, hosted by Microsoft, for businesses of all sizes. It allows your employees to create sites to share documents and information with colleagues, partners, and customers.
  • SharePoint Server – Organizations can deploy and manage SharePoint Server on-premises. It includes all the features of SharePoint Foundation and it offers additional features and capabilities, such as Enterprise Content Management, business intelligence, enterprise search, personal sites, and Newsfeed.
  • SharePoint Foundation – No longer available separately for the SharePoint 2016 release, SharePoint Foundation was the underlying technology for all SharePoint sites.
Microsoft® Visio

Microsoft® Visio is a diagramming and vector graphics application and is part of the Microsoft Office family. The product was first introduced in 1992, made by the Shapeware Corporation. It was acquired by Microsoft in 2000. Microsoft Visio for Windows is available in different editions that share the same interface, but some editions have additional templates for more advanced diagrams and layouts, as well as capabilities intended to make it easy for users to connect their diagrams to data sources and to display their data graphically. The premium edition features three additional diagram types, as well as intelligent rules, validation, and sub processes.

Microsoft® Word

Microsoft® Word is word processing software that allows users to create and edit text documents. Word processing skills refer to the know-how of using word processing software to create professional word documents. These skills are needed to create letters, emails, organizations' reports and other documents. Users can start with a blank document, or work from templates pre-configured for specific projects. Microsoft Word is a part of the Microsoft Office Suite, but it is also sold independently. Microsoft Word let users format various components of a document, everything from text attributes and alignment, to custom table layouts. The program also allows users to insert and format images and shapes; and view or edit PDF files.