Microsoft Office 2010 Overview
Microsoft Office 2010 courses enable students to start using the basic features of Microsoft's powerful desktop applications. Microsoft Office 2010 is a complete suite of productivity and database software. Students will experience many of the integration points of the 2010 Microsoft Office system and understand how work is made easier through the seamless interaction of the products they know and use. For those experienced users of Microsoft Office who have used earlier versions of Microsoft Office, ideally Microsoft Office 2003, and who are planning to upgrade to Microsoft Office 2010. TCCIT Solutions recommends: Office 2010: Transition from 2003
Microsoft Access 2010 is the database program in the Microsoft Office Suite. These courses are designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. TCCIT Solutions offers 4 levels of Microsoft Access training.
Access 2010 Level 1 covers the basic skills, including: identifying the components of the Microsoft Access 2010 environment, identifying the components of a database, organizing data in tables, viewing data in tables, querying a database, designing forms and generating reports.
Access 2010 Level 2 concentrates on some more advanced skills, including: streamlining data entry and maintaining data integrity, joining tables to retrieve data from unrelated tables, creating flexible queries to display specified records, allowing for user-determined query criteria, modifying data using queries, improving forms, customizing reports to organize the displayed information, producing specific print layouts and sharing data between Access and other applications.
Access 2010 Level 3 focuses on the more advanced concepts, including: restructuring data into appropriate tables to ensure data dependency and minimizing redundancy, writing advanced queries to analyze and summarize data, creating and revising Microsoft Access 2010 macros, customizing reports by using various Microsoft Access 2010 features, and maintaining their databases using Microsoft Access 2010 tools.
Access 2010 Level 4 concentrates on the most advanced topics, including: sharing Access data with other applications, using VBA to automate a business process, creating and modifying a database switch board, setting the startup options, securing databases and sharing a database using a SharePoint site.
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 2010, Access 2010: Transition from Access 2003 provides useful information for upgrading to the newest version.
TCCIT Solutions Access 2010 course curriculum is: Access 2010 Level 1 | Access 2010 Level 2 | Access 2010 Level 3 | Access 2010 Level 4 | Access 2010 Transition from Access 2003
Microsoft Excel 2010 is the Spreadsheet program in the Microsoft Office Suite. This course is designed for students who desire to gain the necessary skills to create, edit, format, print basic Microsoft Office Excel 2010 worksheets and gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks. TCCIT Solutions offers 4 levels of Microsoft Excel training.
Excel 2010 Level 1 covers the basic skills, including: creating a basic spreadsheet, performing calculations, and modifying, formatting and printing an Excel spreadsheet.
Excel 2010 Level 2 concentrates on some more advanced skills, including: using advanced formulas, organizing worksheet and table, creating and modifying charts, analyzing data using PivotTables, Slicers, and PivotCharts, inserting and modifying graphic objects in a worksheet and customizing and enhancing Microsoft Excel workbooks.
Excel 2010 Level 3 focuses on the more advanced concepts, including: streamlining the workflow, collaborating with other workbook users, auditing worksheets, analyzing data, working with multiple workbooks, importing and exporting data, integrating Excel data with the web and structuring workbooks with XML.
Excel PivotTables 2010 allows you to create and analyze PivotTable data. This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.
Microsoft Excel VBA 2010 teaches you how to automate your job tasks in Microsoft Office Excel 2010. The course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).
Excel 2010: Transition from Excel 2003 provides useful information 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 2010.
TCCIT Solutions Excel 2010 course curriculum is: Excel 2010 Level 1 | Excel 2010 Level 2 | Excel 2010 Level 3 | Excel Pivot Tables 2010 | Microsoft Excel VBA 2010 | Excel 2010 Transition from Excel 2003
Microsoft Outlook 2010 is the Communication program in the Microsoft Office Suite. These courses are intended for people who have a basic understanding of Microsoft Windows and want to know how to use Outlook to manage their time and information. You will use Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks, and create notes. TCCIT Solutions offers 3 levels of Microsoft Outlook training.
Outlook 2010 Level 1 covers the basic skills, including: exploring the Outlook interface, sending mail, and responding to messages, composing email messages, organizing email messages into folders, managing contacts and contact information, scheduling appointments and meeting and manage tasks and notes.
Outlook 2010 Level 2 concentrates on some more advanced skills, including: customizing message settings, organizing and locating Outlook messages, setting calendar options, tracking activities, assigning and tracking tasks, sharing folder information and customizing the Outlook environment.
Outlook 2010 Level 3 focuses on the more advanced concepts, including: personalizing their email, organizing Outlook items, managing Outlook data files, working with contacts, saving and archiving email messages, creating a custom form and working offline and remotely.
For those who have used earlier versions of Microsoft Office Outlook, ideally Microsoft Office Outlook 2003, and who are planning to upgrade to Microsoft Office Outlook 2010, Microsoft Office Outlook 2010: Transition from MS Outlook 2003 provides useful information for upgrading to the newest version.
TCCIT Solutions Outlook 2010 course curriculum is: Outlook 2010 Level 1 | Outlook 2010 Level 2 | Outlook 2010 Level 3 | Outlook 2010 Transition from Outlook 2003
Microsoft PowerPoint 2010 is the Presentation program in the Microsoft Office Suite. You will explore the PowerPoint environment and create a presentation. You will format text on slides to enhance clarity. To enhance the visual appeal, you will add graphical objects to a presentation and modify them. You will also add tables and charts to a presentation to present data in a structured form. You will then finalize a presentation to deliver it. TCCIT Solutions offers 2 levels of Microsoft PowerPoint training.
PowerPoint 2010 Level 1 covers the basic skills, including: exploring the PowerPoint 2010 interface and familiarizing yourself with the interface, creating a presentation, formatting text on slides, adding graphical objects to a presentation, modifying graphical objects on slides, working with tables in a presentation, importing charts to a presentation, and preparing to deliver a presentation.
PowerPoint 2010 Level 2 concentrates on some more advanced skills, including: customizing the PowerPoint environment, customizing a design template, adding SmartArt graphics to a presentation, adding special effects to a presentation, customizing a slide show, collaborating on a presentation and securing and distributing a presentation.
For those who have used earlier versions of Microsoft Office PowerPoint, ideally Microsoft Office PowerPoint 2003, and who are planning to upgrade to Microsoft Office PowerPoint 2010, Microsoft Office PowerPoint 2010: Transition from MS PowerPoint 2003 provides useful information for upgrading to the newest version.
TCCIT Solutions PowerPoint 2010 course curriculum is: PowerPoint 2010 Level 1 | PowerPoint 2010 Level 2 | PowerPoint 2010 Transition from PowerPoint 2003
Microsoft Project 2010 is the Project Management program in the Microsoft Office Suite. These courses are designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans. TCCIT Solutions offers 2 levels of Microsoft Project 2010 training.
Project 2010 Level 1 covers the basic skills, including: identifying the basic features and components of the Microsoft Project environment, creating a new project plan file and entering project information, managing tasks by organizing tasks and setting task relationships, managing resources for a project and finalizing a project plan.
Project 2010 Level 2 concentrates on some more advanced skills, including: identifying the basic features and components of the Microsoft Project environment, creating a new project plan file and entering project information, managing tasks by organizing tasks and setting task relationships, managing resources for a project and finalizing a project plan.
TCCIT Solutions Project 2010 course curriculum is: Project 2010 Level 1 | Project 2010 Level 2
Microsoft Publisher 2010 adds new capabilities geared to help you create, print, and distribute professional-quality publications and sales and marketing materials. With the updated user interface, an improved print experience to help with more efficient printing, new picture placement and manipulation tools, building blocks of content, and fine typography options such as true small caps, ligatures, and stylistic alternates, Publisher 2010 improves the desktop publishing experience and makes the results more predictable so that you get the publications you want. TCCIT Solutions offers 1 level of Microsoft Publisher training.
TCCIT Solutions Microsoft Office 2010 course curriculum is: Publisher 2010 Level 1
Microsoft Visio 2010 allows you to design, manage basic diagrams, workflow, and flowcharts. Start by building your diagram with professional-looking templates and modern, pre-drawn shapes. Then, easily link your diagram to popular data sources (such as Excel). You’ll see data automatically refresh right within your diagram, reflected in vibrant visuals such as icons, symbols, colors, and bar graphs. Finally, with just a few clicks, publish your data-linked diagram to SharePoint, and provide access to others on the Web, even if they don’t have Visio. TCCIT Solutions offers 2 level of Microsoft Publisher training.
Visio 2010 Level 1 teaches you how to design and manage basic diagrams, workflow, and flowcharts. This course is designed for persons who have an understanding of the basic workflow and the concept of end-to-end flowcharting. Students will become familiar with the Visio interface, create a basic Visio document and create a route map by using Visio features to work with shapes and text.
Visio 2010 Level 2 teaches you how to create custom elements and a custom template, represent external data as a drawing, and share your work with others.
TCCIT Solutions Visio 2010 course curriculum is: Visio 2010 Level 1 | Visio 2010 Level 2
Microsoft Word 2010 is the Word Processing program in the Microsoft Office Suite. These courses are designed for persons who need to create and modify standard business documents in Microsoft Word 2010, and learn how to create or modify complex business documents and customized with Word efficiency tools. It also aims to assist persons preparing for the Microsoft Office Specialist exams for Microsoft Word 2010. TCCIT Solutions offers 3 levels of Microsoft Word training.
Word 2010 Level 1 covers the basic skills, including: creating and editing basic Word documents, formatting text and paragraphs, inserting tables, special characters and graphical objects and controlling the page setup and appearance of a Word document.
Word 2010 Level 2 concentrates on some more advanced skills, including: managing lists, customizing tables, charts and formats, using styles and themes, modifying pictures, creating customized graphic elements, inserting content, controlling text flow, and using templates, mail merges and macros.
Word 2010 Level 3 focuses on the more advanced concepts, including: using Word with other programs, collaborating on documents, managing document versions, adding reference marks and notes, simplifying the use of long documents, securing a document and creating forms.
For those who have used earlier versions of Microsoft Office Word, ideally Microsoft Office Word 2003, and who are planning to upgrade to Microsoft Office Word 2010, Microsoft Office Word 2010: Transition from MS Word 2003 provides useful information for upgrading to the newest version.
TCCIT Solutions Word 2010 course curriculum is: Word 2010 Level 1 | Word 2010 Level 2 | Word 2010 Level 3 | Word 2010 Transition from Word 2003
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.