Online Microsoft Office 2007 eLearning - Training Resources

Adding Graphics to Presentations in PowerPoint 2007 Microsoft PowerPoint 2007 is a useful authoring application tool for creating dynamic slide show presentations. This course demonstrates how to create visually appealing presentations using PowerPoint's design templates and implementing new Microsoft Office 2007 themes. The course also explores the introduction of SmartArt in PowerPoint 2007, a feature that allows you to add some glamour to your  more...

Working with Text and Paragraphs in Word 2007 Word 2007 makes it easy to apply formatting to documents by providing a live visual preview of various formatting options. This enables you to view the formatting change before actually committing to it. This course explains the Font and Paragraph formatting options, as well as the Mini toolbar and live preview features. In addition, the creation and formatting of bulleted, numbered, and  more...

Structuring Editing Saving and Opening Documents in Word 2007 Word 2007 provides many options for structuring and editing documents which are complemented by a variety of editing tools. There are also options for saving documents which can be customized to suit your word processing needs. This course explains the use of page and section breaks, spacing adjustment, and column insertion, and explores the basic editing tools packaged with Word 2007. A new  more...

Printing Help and Automated Formatting in Word 2007 Microsoft Office Word 2007 provides new features called Quick Styles and building blocks which make it easy to create great looking documents quickly. You can select Quick Styles using the new Live Preview feature to view the different styles before committing the changes. This course demonstrates the use of Quick Styles, building blocks, templates and AutoCorrect features in detail. Previewing  more...

Working with Documents in Word 2007 Microsoft Office Word 2007 has various design features that can be used to enhance your Word documents. These include Clip Art, SmartArt, WordArt, shapes, curves, lines, and diagrams to name a few. This course explains how to use Word 2007's Drawing Tools, including working with WordArt, AutoShapes, Pictures, Clip Art, and SmartArt. It also demonstrates the use of headers, footers, and page  more...

Analyzing Data in Excel 2007 Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve  more...

Protecting and Sharing Excel 2007 Workbooks In many organizations, teams and individuals require frequent and possibly simultaneous access to common spreadsheets and workbooks. To meet these demands without affecting efficiency, a number of review, security, and collaboration features are available in Excel 2007. Workbooks, worksheets, and specific data within worksheets, can be protected, enabling only those with access to view or make  more...

Exchanging Data with Excel 2007 In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage  more...

New Features in MS Office 2007 This course covers the basic features of Microsoft Office 2007. Additionally, it covers new capabilities in Office 2007. The course also explains key concepts associated with the Ribbon, the Office menu, and convenience tools. End users who want to migrate to Office 2007.  more...

New Features for End Users in Microsoft Office 2007 To recognize the new features for end users in Microsoft Office 2007 Previous Microsoft Office users, including business customers and individual Office users who plan on upgrading to Office 2007, will be candidates for this training.  more...

Microsoft Office Excel PowerPoint and Outlook 2007 To use the new features of Microsoft Office Excel, PowerPoint, and Outlook 2007 Previous Microsoft Office users, including business customers and individual Office users who plan on upgrading to Office 2007, will be candidates for this training.  more...

Microsoft Access 2007 and Microsoft Publisher 2007 To recognize the new features in Microsoft Access 2007 and Publisher 2007. Previous Microsoft Office users, including business customers and individual Office users who plan on upgrading to Office 2007, will be candidates for this training.  more...

Sharing and Collaboration in Microsoft Office Enterprise 2007 To recognize the sharing and collaboration features of Microsoft Office 2007 Previous Microsoft Office users, including business customers and individual Office users who plan on upgrading to Office 2007, will be candidates for this training.  more...

Data Security Archiving and Working Offline in Outlook 2007 You can use the enhanced security features included in Microsoft Outlook 2007 to protect your e-mail and computer from malicious attacks that can arrive in the form of incoming e-mail messages. The program also provides you with tools used to archive and manage the size of your mailbox to ensure that you can locally store your e-mail messages for future reference. With Outlook 2007 you can choose  more...

Instant Text and Unified Messaging in Outlook 2007 You can secure your e-mail in Microsoft Outlook 2007 using Information Rights Management (IRM), a feature that allows you to set access permissions for specific messages. Setting these restrictions secures your sensitive information against forwarding, printing, and copying. In addition, when used with an Exchange Server, Outlook 2007 provides you with a comprehensive messaging approach, including  more...

Business Contact Manager with Outlook 2007 Microsoft Outlook 2007 with Business Contact Manager helps to save time and improve sales and marketing to ensure excellent customer service by providing customer and contact management in one central location. It allows you to easily manage all your contacts, customer information, and opportunities in one location making it easier to find and manage. It also allows you to create marketing  more...

Advanced Data Manipulation Features in Word 2007 Word 2007 enables you to create forms quickly and easily, so that they can be used by other users of Word 2007. Forms contain form fields that you can link to external data sources, and Word 2007 contains security features to protect forms from tampering by other users. Inserting fields has been simplified in Word 2007 by means of built-in commands and content controls. The mail merge feature is  more...

Advanced Document Features in Word 2007 Some of the advanced features of Microsoft Office Word 2007 offer ways in which you can automate and streamline the way you work. You can use macros in Word 2007 to easily automate repetitive, complex tasks. A macro is a set of instructions that can group a series of actions and keystrokes as a single command. You can also simplify the management of your Word 2007 files by using master documents.  more...

Collaborative Features in Word 2007 Microsoft Office Word 2007 offers several options for securing and protecting Word documents as well as providing various collaborative features. This course demonstrates how to use Word 2007's document security, which includes locking document formatting, password protecting a document, marking a document as read-only, using Document Inspector, viewing privacy options, and adding a digital  more...

SharePoint 2007 Essentials To use SharePoint for file sharing, collaboration, and discussion, and integrate and use it with Office applications End users of Office SharePoint Server 2007  more...

Fundamentals of Microsoft Office Project 2007 The Fundamentals of Microsoft Office Project 2007 course introduces key concepts related to working with projects and tasks in Project 2007. The course also covers basic tasks related to assigning resources and creating project calendars. This course is designed for project managers, managers, supervisors, team leaders, or consultants who are actively involved in the project management activities  more...

Working with Microsoft Office Project 2007 The Working with Microsoft Office Project 2007 course covers how to manage tasks, resources, and calendars. This course covers the steps for setting tasks constraints and deadlines. In addition, this course covers the steps for outlining, linking, and splitting tasks. This course also covers the steps for allocating resources, monitoring resource allocations, leveling resources, and assigning  more...

Creating and Designing a Project In the corporate world, the project is a fundamental building block. Each project in which a company engages is unique, and fulfills an individual or corporate goal. And each project comprises a series of related tasks that culminate in a project deliverable. Microsoft Office Project 2007 is a comprehensive tool for project managers responsible for the overall design of projects, enabling them to  more...

Getting Started with MS Word 2007 This course covers important features and components of the Word 2007 interface. It also teaches the procedures of creating new documents, formatting text, and using different views to customize the display of documents. Additionally, the course teaches how to format paragraphs to enhance readability, create lists to organize text, and use styles to quickly format documents. Users who desire to  more...

Getting Started with Word 2007 With Office Word 2007, Microsoft introduces some of the most significant changes to Word in years. Most notable is the new intuitive user interface which replaces the traditional menus and toolbars, featuring the Ribbon , the Quick Access toolbar, and the Mini Toolbar as well as a new Office button which replaces the File menu. This course provides an introduction to Word 2007 and demonstrates how  more...

Advanced Features of Microsoft Office Access 2007 This course is designed for application developers and end users who desire to gain the necessary skills to create and manage a database by using Microsoft Office Access 2007. This course will also help them to understand the advantages that a relational database program can bring to their business processes. This course is designed for application developers and end users who desire to gain the  more...

SQL Server 2005 Analysis Services SSAS ...nd SQL Server Reporting Services. See integration with Microsoft Office 2007 and Microsoft SharePoint 2007. Course Duration: 5 days Prerequisites: This course does not require any prior experience with Analysis Server 2005. It is assumed that students have working experience with SQL Server 2000 or 2005; basic relational database concepts (e.g., tables, queries, and indexing);  more...