This two-day session is intended for experienced business users of Excel who want to get more out of their day-to-day use of the Excel.  With understandable and accessible real-world examples, advanced formula functions, spreadsheet database/list creation, and chart creation, attendees will somersault their understanding of Excel to the next level.  Users can also submit their own Excel files and they will be integrated directly into the learning process at no extra charge.

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by learning how to troubleshoot and solve numerous Excel issues and problems, apply advanced analysis techniques to more complex data sets, collaborate on Excel worksheets with others, and share Excel data so that it can be used with other applications.

In this course, you will apply Macros and 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.

This two-day comprehensive session covers all of the critical aspects of this powerful planning software, from reviewing and establishing how Microsoft Project fits into the Project Planning Process, to setting the correct working time values (7, 7.25, 7.5, 7.75, or 8 hours per day), to clearly understanding the different ways to build and estimate task durations and details, to create and assign working resources and costs (including an easy-to-follow method for adding overtime), to finalizing and tracking project details.

Don't take chances with sub-standard training sessions that minimalize and trivialize the use and understanding of the latest version of this amazing and powerful software - make the choice to learn from a Microsoft Project master trainer today!

This introductory-level two-day session covers everything new Microsoft Access database users need, from understanding how databases and tables work, to real-world, accessible and logical examples of table design, to creating, testing, and using powerful filters and queries, creating powerful data input forms to maintain databases quickly, and building clean and efficient reports that allow for the easy printing of your data.

When was the last time you clearly understood what a database was and how it worked using relevant examples?  Submit your own details and sample databases and learn Access in an enviroment tailored to your needs today!

This advanced session is intended for those who have taken the introductory Designing and Creating Databases session, or who are experienced with the use of Access 2007. This second session covers use of new XML features found in Access 2007, Macros, Switchboard forms, and customization techniques using Visual Basic for Applications, and scenarios for easily splitting and effectively securing databases.

As an experienced user of Microsoft Excel, you now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2003 to streamline and enhance your spreadsheets with advanced features such as pivot tables, formulas, templates, and graphics.

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational database tools.

In previous training, you were introduced to various features of Microsoft Office Access 2003 focusing on local database management. However, effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using macros and VBA code, and secure databases.

You need to build web-sites for a public Internet or private Intranet web-site, but using a more graphically-oriented web-design tool aligned with Microsoft Internet Explorer and Microsoft Office. The features and functions found in Expression Web 2007 will enable you to create web-sites that fulfill these requirements.

Diagrams and charts play a pivotal role in knowledge dissemination, making complex business processes and data easier to understand. Microsoft Visio Professional 2007 includes a host of features that are instrumental in creating pictorial representations of this information. In this course, you will learn the essentials of process design and visualization, along with effective strategies for diagram creation and customization using Visio Professional 2007.

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by learning how to troubleshoot and solve numerous Excel issues and problems, apply advanced analysis techniques to more complex data sets, collaborate on Excel worksheets with others, and share Excel data so that it can be used with other applications.

In this course, you will work with Microsoft Office PowerPoint 2007 to create electronic presentations as well as learn best slide development practices and presentation delivery techniques used by top practitioners such as Atkinson, Duarte, and Altman.

In this course, you will learn the essentials of process design and visualization, along with effective strategies for flowchart and diagram creation and customization using Microsoft Visio Professional 2003.

Enhance and expand your existing knowledge of Microsoft Office 2007 and take it to the next level, covering the most essential and more challenging functions of Microsoft Word, Excel, and PowerPoint from a business-oriented perspective.