You use Excel 2007 to work with data and need to improve the processes involved. This course looks at how you can work directly with Excel 2007 and its components to manipulate the application to help you work with your data. ...
In this course you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities using the Microsoft Office 2007 applications. The course covers examples in Excel...
One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will...
You have the basic skills needed to work with Microsoft Office Access 2007 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database...
Your training in and use of Microsoft Office Access 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft Office Access 2007. You have worked with the various Access objects, such as...
In previous levels, you were introduced to the various features of Microsoft Office Access 2007 that dealt with local database management. However, effective database management calls for mastering the advanced administrative and collaborative...
In “Access 2007 Programming Using VBA” you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the...
You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Office...
In Microsoft Office Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will...
Your training in and use of Microsoft Office Excel 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting...
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want...
Information is a key to the success of any organisation. Gathering and sharing information within your organisation, with clients and customers alike, can also be an important task. Microsoft Office InfoPath 2007: Creating InfoPath Forms is a...
This course is the first in a series of three Microsoft Office Outlook 2007 courses. It will provide you with the skills you need to start sending and responding to email in Microsoft Office Outlook 2007, as well as maintaining your Calendar,...
If you have been using Microsoft Office Outlook 2007 as a communications tool, then you know how to send a mail message; schedule appointments and meetings; and create contacts, tasks, and notes. This course is the second in a series of three...
This course is the third in a series of Microsoft Office Outlook 2007 courses. It builds on the email and calendaring skills you have already obtained and will provide you with the skills needed to personalize email, organize Outlook items,...
Course Objective: You will explore the PowerPoint environment and create a new presentation. You will format text on slides to enhance clarity. In order to enhance the visual appeal, you will add graphical objects to a presentation and modify...
As a Microsoft Office PowerPoint 2007 user, you are familiar with the basics of creating a presentation, and you are able to convey information effectively in a simple way. Static content in presentations, however, will not keep your audience...
You need to gather information about the various tasks involved, resources required to accomplish the tasks, and the overall cost in order to plan a project. Microsoft Office Project Professional 2007 acts as a tool that assists you in...
Microsoft Project 2007: Level 2 is the second course in the Microsoft Project 2007 series. In Microsoft Project 2007: Level 1, you used your project management skills to create a complete project plan. The plans need to be updated and modified...
You’ve created intranet sites using Microsoft Windows SharePoint Services. There will be times when you would want to build sites that lay emphasis on your company’s unique requirements and sites that align themselves with the company’s unique brand identity. In this course, you...
Now that you know how to create customised SharePoint sites matching your branding, you may want to extend your sites to include more functionality. With SharePoint Designer, you can extend your sites more easily than before.Course Objective:...
Diagrams and charts 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...
Microsoft Office Visio Professional 2007: Level 2 is the second course in the Microsoft Visio 2007 series. In Microsoft Office Visio Professional 2007: Level 1, you used the various templates to design and manage workflows and flowcharts. This...
Word processing is the use of computers to create, revise, and save documents for printing and future retrieval. This course is the first in a series of three Microsoft Office Word 2007 courses. It will provide you with the basic concepts...
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 customise and automate the way Microsoft Word 2007 works for you. You can also...
You know to use Microsoft Office Word 2007 to create and format typical business documents. Now, you may need to work on more complex documents. In this course, you will use Word to create, manage, revise, and distribute long documents and...