Microsoft Office 2007 Overview
Microsoft Office 2007 courses enable clerical and office professionals to develop important skills in typing, data entry as well as internet literacy and to start using the basic features of Microsofts powerful desktop applications. Students will experience many of the integration points of the 2007 Microsoft Office system and understand how work is made easier through the seamless interaction of the products they know and use. The TCCIT Microsoft Office 2007 course curriculum is for: Access, Excel, Outlook, PowerPoint, Project, Publisher, Visio & Word.
Microsoft Access 2007 courses initiate the student's recognition of Access 2007 new key enhancements for insertion in a table, a simple typing valuein a new column in a data sheet with transfer capabilities to enable you to paste an Office Access 2007 table into a new Office Access 2007 table for easy data transfer. With its Microsoft Office Fluent user interface and interactive design capabilities that do not require deep database knowledge, Microsoft Office Access 2007 helps you track and report information with ease.
Access 2007 Level 1 is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.
Access 2007 Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications.
Access 2007 Level 3 is for the individual whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
Access 2007 Level 4 you learn how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases. This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft Office Access 2007 application, and are interested in learning introductory level administrator skill sets.
For those who have used earlier versions of Microsoft Office Access, ideally Microsoft Office Access 2003, and who are planning to upgrade to Microsoft Office Access 2007, Access 2007 New Features provides useful information for upgrading to the newest version.
TCCIT Solutions Access 2007 course curriculum: Access 2007 New Features | Access 2007 Level 1 | Access 2007 Level 2 | Access 2007 Level 3 | Access 2007 Level 4
Microsoft Excel 2007 offers new key enhancements such as the shared charting engine across the Microsoft Office system that helps you to create and interact with charts the same way, regardless of the program. Improve the organization of your projects and people with the scheduling power and capabilities of Office Project Standard 2007. Easily report and communicate information in various formats according to the needs of stakeholders. The Visual Reports feature uses Microsoft Office Excel and Microsoft Office Visio Professional to produce PivotTable views, charts, graphs, and diagrams based on Project data.
Excel 2007 Level 1 focuses on how to edit, and print data. This course is designed for people preparing for certification as a Microsoft Office Specialist in Excel, who already have knowledge of Microsoft Office, Windows XP, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.
Excel 2007 Level 2 focuses on how to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.
Excel 2007 Level 3 students will extend their knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
Excel Intro to VBA allows you to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development. In this course, you will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.
For those who have used earlier versions of Microsoft Office Excel, ideally Microsoft Office Excel 2003, and who are planning to upgrade to Microsoft Office Excel 2007, Excel 2007 New Features provides useful information for upgrading to the newest version.
TCCIT Solutions Excel 2007 course curriculum: Excel 2007 New Features | Excel 2007 Level 1 | Excel 2007 Level 2 | Excel 2007 Level 3 | Excel Intro to VBA
Microsoft Outlook 2007 has new key enhancements such as the shared charting engine across the Microsoft Office system that helps you to create and interact with charts the same way, regardless of the program. Improve the organization of your projects and people with the scheduling power and capabilities of Office Project Standard 2007. Easily report and communicate information in various formats according to the needs of stakeholders. The Visual Reports feature uses Microsoft Office Outlook and Microsoft Office Visio Professional to produce PivotTable views, charts, graphs, and diagrams based on Project data.
Outlook 2007 Level 1 is designed for any person with a basic understanding of Microsoft Windows who needs to use Microsoft Outlook 2007 to compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.
Outlook 2007 Level 2 is designed for experienced Outlook users who need to customize their environment, calendar, and email messages to meet their specific requirements and who wish to track, share, assign, and locate various Outlook items.
Outlook 2007 Level 3 is for persons with an intermediate understanding of Outlook who need to use Outlook to personalize and organize their email, organize Outlook items, manage Outlook data files, share and link contacts, create forms, and work offline and remotely.
TCCIT Solutions Outlook 2007 course curriculum: Outlook 2007 Level 1 | Outlook 2007 Level 2 | Outlook 2007 Level 3
Microsoft PowerPoint 2007 offers new key enhancements for custom layouts to help you quickly create precisely the layout you envision without being bound by one of the prepackaged standard layouts. Microsoft Office PowerPoint 2007 enables users to quickly create high-impact, dynamic presentations, while integrating workflow and ways to easily share information. From the Microsoft Office Fluent user interface to the new graphics and formatting capabilities,
PowerPoint 2010 Level 1 puts the control in your hands to create great-looking presentations. The Office Fluent user interface in Office PowerPoint 2007 makes creating, presenting, and sharing presentations an easier and more intuitive experience.
PowerPoint 2010 Level 2 offers you the rich features and capabilities of PowerPoint in a streamlined, uncluttered workspace that minimizes distraction and helps you achieve the results you want more quickly and easily.
TCCIT Solutions PowerPoint 2007 course curriculum: PowerPoint 2007 New Features | PowerPoint 2007 Level 1 | PowerPoint 2007 Level 2
Microsoft Project 2007 teaches students project management tools with the right blend of usability, power, and flexibility, so you can manage projects more efficiently and effectively. You can stay informed and control project work, schedules, and finances, keep project teams aligned, and be more productive through integration with familiar Microsoft Office system programs, powerful reporting, guided planning, and flexible tools.
Project 2007 Level 1 offers new key enhancements such as the shared charting engine across the Microsoft Office system that helps you to create and interact with charts the same way, regardless of the program. Improve the organization of your projects and people with the scheduling power and capabilities of Office Project Standard 2007.
Project 2007 Level 2 you learn how easily to report and communicate information in various formats according to the needs of stakeholders. The Visual Reports feature uses Microsoft Office Project and Microsoft Office Visio Professional to produce PivotTable views, charts, graphs, and diagrams based on Project data. A user can easily define custom report templates and share these with other Project users. You will effectively track and analyze projects with a better understanding of the schedule and impact of changes.
TCCIT Solutions Project 2007 course curriculum: Project 2007 Level 1 | Project 2007 Level 2
Microsoft Publisher 2007 is an easy-to-use, flexible program for creating newsletters, brochures, business cards, postcards, flyers, among others for print, email, and the web. In this course, 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. Course Objective: You will create, format, revise, and distribute publications. Target Student: This course was designed for persons with a basic understanding of Microsoft Windows and Microsoft Word who need to learn how to use Microsoft Publisher 2007 to create, layout, and edit publications.
TCCIT Solutions Publisher 2007 course curriculum: Publisher 2007 Level 1
Microsoft Visio 2007 is an easy-to-use, flexible program for creating diagrams, charts and 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 these courses, you will learn the essentials of Visio. These courses are designed for persons who have an understanding of basic workflows and the concept of end-to-end flowcharting.
Visio 2007 Level 1 teaches you how to create diagrams and charts that 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.
Visio 2007 Level 2 enables 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.
TCCIT Solutions Visio 2007 course curriculum: Visio 2007 Level 1 | Visio 2007 Level 2
Microsoft Word 2007 courses initiate the student's recognition of Word 2007 new key enhancements and quick styles that save you time by quickly formatting text and tables through out your document, building blocks for predefined content reduce the errors associated with copying and pasting commonly used content. With Word 2007, you can share documents with colleagues to gather feedback efficiently. You can help prevent unwanted distribution of your documents and help ensure that private comments or hidden text are removed prior to publishing.
Word 2007 Level 1 will provide you with the basic concepts required to produce basic business documents. This course is intended for individuals who want to gain basic knowledge of working on Word. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer. Individuals who want to pursue Microsoft Office Specialist certification in Microsoft Office Word 2007 can also take this course.
Word 2007 Level 2 you gained all the basic sakills that you need to create a wide range of standardized business documents. If you use Microsoft Word 2007 on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft Word 2007 works for you.
Word 2007 Level 3 you will use Word to create, manage, revise, and distribute long documents and forms. Students should be able to use Microsoft Office Word 2007 to create, edit, format, save, and print business documents that contain text, tables, and graphics.
TCCIT Solutions Word 2007 course curriculum: Word 2007 New Features | Word 2007 Level 1 | Word 2007 Level 2 | Word 2007 Level 3
MOS: Microsoft Office Specialist certification program is the only comprehensive, performance-based certification program approved by Microsoft to validate desktop computer skills in these Microsoft Office desktop productivity programs: Word, Excel, Outlook, PowerPoint, Access and Project. This Microsoft Office Specialist certification program provides computer program literacy, measures proficiency, and identifies opportunities for enhancement of skills. Successful candidates receive a Microsoft Office Specialist certification credential that sets them apart from their peers in the competitive job market. The certificate is a valuable credential that is recognized worldwide as proof that an individual has the desktop computing skills needed to work productively and efficiently.The Microsoft Office Specialist certification program offers four levels of certification: Specialist, Expert, Master, and Master Instructor For more info: The Microsoft Office Specialist
For more information about Corporate Training, please either call us at your convenience at 212-684-5151 or email us at info@TCCITSolutions.com. Also please view our Complete Course List and our Complete Schedule.