Training available from 2e2
Microsoft Visio Specialised  : Objectives: Microsoft Visio is the preferred set of tools for creating business diagrams and technical drawings combining power, ease of use, and flexibility. This course is an introduction to how Visio can help users to create drawings that are suited to particular business needs. This course will give delegates a good overview of the main features of Visio. Delegates will receive practical guidance on how to create a range of business diagrams.
Prerequisites: Delegates should have a good working knowledge of Microsoft Windows. A knowledge of drawing techniques is helpful although not essential.
Microsoft Office
Microsoft Access Fundamentals : Objectives: By the end of this course you will be able to create 1:1 and 1:many relational databases. You will be able to construct tables, implement forms, design and use simple and complex queries, and produce reports based on your data.
Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and should also be able to use a mouse and keyboard.
Target Audience: The course is aimed at those who will be designing, supporting and creating databases. Delegates will learn how to use the more advanced and powerful features of Access in order to be more efficient in data management including complex forms, reports with charts and action queries for bulk data processing.
Microsoft Access Specialised : Objectives: By the end of this course you will be able to produce advanced form interfaces, understand hyperlinked and data access pages, create and use macros, design advanced data queries and implement Access security features.
Prerequisites: This course is designed for students who have completed the Access Database Fundamentals course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
Target Audience: Advanced users who need to build secure databases for other users, and those wishing to automate and control the use of database objects. Delegates will be shown Internet tools, such as Data Access Pages, more...
Microsoft Excel Advanced : Objectives: After completing this course, you will know how to: Use names to assign descriptive labels to cells; use financial functions to calculate values based on conditions. Use data tables to view the effects of multiple input values on a formula. Use the Subtotal command, the Subtotal function and database functions to summarise list data; and use data forms and validation to facilitate data entry in lists; and use data tables to project values. Create and use PivotTables to analyse and compare large amounts of data. Import data from and export data to external databases. Use Goal Seek and Solver to perform what-if analysis; and use custom scenarios, advance custom views and pivot tables to more...
Microsoft Excel Fundamentals : Objectives: By the end of this course you will be able to produce a formatted worksheet, confidently create basic dynamic formulae and create a visual representation of the data, using the provided manual if required.
Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard.
Microsoft Excel Intermediate : Objectives: After completing this course, you will know how to: Navigate large worksheets effectively by using magnification, frozen panes, and split panes; and control the printing of large worksheets. Navigate, manage, and print multiple worksheets; link workbooks by using 3-D formulas; and summarise data by using the Consolidate command. Change the View, General, and Calculation settings of Excel; and customise toolbars and menus. Add borders and shading; apply special formats; create, apply, and modify styles; and change the orientation of cells. Sort lists by columns; and filter lists based on complex criteria. Format data points; create combination charts and trend lines; and add and more...
Microsoft Outlook Fundamentals : Objectives: By the end of this course you will be able to send and receive messages, manage folders and messages, schedule appointments, meetings and events. In addition, delegates will learn how to manage tasks and contacts, create and manage notes.
Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard.
Target Audience: Anyone wishing to learn how to send and receive email, schedule meetings and appointments. In addition the creation of a contacts list, task management and general organisation of daily personal and business information will also be covered.
Microsoft PowerPoint Fundamentals : Objectives: By the end of this course you will be able to create a presentation, apply graphics, text elements and apply visual effects, using the manual provided if required.
Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard.
Target Audience: Anyone who needs to use PowerPoint for more complex and sophisticated tasks.
Microsoft PowerPoint Specialised : Objectives: By the end of this course you will be able to add multimedia features; work with Master Slides; discover how to share information and learn how to create enhanced slide shows.
Prerequisites: This course is designed for students who have completed the PowerPoint Fundamentals course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
Target Audience: Anyone who needs to use PowerPoint for more complex and sophisticated tasks.
Microsoft Project FastPath : Objectives: Our one day FastPath course is an ideal starter covering similar material as level 1 but without the concepts or multiple project handling. As such it is aimed at those delegates with experience of Project but no formal training, and those moving to a newer version. On completion of this course, delegates will be able to create, resource and manage projects, including costs, using a variety of powerful features. Time saving options such as reports will also be introduced allowing users to produce effective data.
Prerequisites: Delegates should have some existing experience of Microsoft Project, or be migrating from another project management application
Microsoft Project Level 1 : Objectives: On completion of this course, delegates will be able to create, resource and manage projects, including costs, using a variety of powerful features. Time saving options such as reports will also be introduced allowing users to produce effective data.
Prerequisites: Delegates should have good mouse and keyboard skills.
Microsoft Project Level 2 : Objectives: On completion of the course, delegates will be able to effectively utilise advanced features within Project. These include fixed work, fixed duration and fixed units scheduling, multiple project management, cost analysis and customisation. Delegates will be able to integrate Project with other Office applications.
Prerequisites: Delegates should have attended a Project Level 1 or FastPath course or have the equivalent knowledge.
Microsoft Visio Fundamentals : Objectives: Microsoft Visio is the preferred set of tools for creating business diagrams and technical drawings combining power, ease of use, and flexibility. This course is an introduction to how Visio can help users to create drawings that are suited to particular business needs. This course will give delegates a good overview of the main features of Visio. Delegates will receive practical guidance on how to create a range of business diagrams.
Prerequisites: Delegates should have a good working knowledge of Microsoft Windows. A knowledge of drawing techniques is helpful although not essential.
Microsoft Word Advanced : Objectives: By the end of this course you will be able to create and manage data lists for merging purposes, use the referencing tools to add navigation and add additional information to documentation, create macros to eliminate repetitiveness and design forms with added intelligence, using the provided manual if required.
Prerequisites: This course is designed for students who have completed the Word Intermediate or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
Microsoft Word Fundamentals : Objectives: By the end of the is course you will be able to produce a formatted short document, confidently create tables, check, minimise and eliminate errors, using the provided manual if required.
Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and you should also be able to use a mouse and keyboard.
Microsoft Word Intermediate : Objectives: By the end of this course you will be able to use MS Word as a Desktop Publishing tool, create sections breaks and newspaper columns, manage the presentation of a document and confidently use the advance formatting table options such as calculating data, using the provided manual if required.
Prerequisites: This course is designed for students who have completed the Word Fundamentals Course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
|
