Application Training
Government Agency E-Skills has reported that 40% of all IT users have received no IT training and are therefore lacking the necessary skills to do their jobs efficiently & cost effectively.
Melton IT
Services Ltd, Based in Manchester UK, can perform Training Needs Analysis for each of your staff and
identify training required to equip your staff with the required skills.
Whether you are a beginner or a professional, our objective is to provide you with quality computer training courses. Below you will find the course outline of our computer training courses. The recommended course duration is also listed in each outline. However both the topics covered and the duration our computer training courses can be tailored to your requirements and objectives to ensure the best value for money. The computer training courses can be delivered in three methods to suit your requirements:
Group workshops- The course is delivered to small groups of up to 10 delegates by using training methods (TAP) specifically developed for IT training by the Institute of IT Trainers (IITT.)Desk side one-to-one - The course is delivered by a trainer who will sit with you at your desk in your office or home. You benefit from your own personal computer training course where you dictate the pace and ask the questions you want to. If your organisation is located outside the Manchester area, we can bring the training room to you with our equipment hire service.
Don't forget our Customer Guarantee-If you are not completely satisfied with your computer training courses, we will refund your money.
View our course outlines: Microsoft Office 2003 & 2007
| OFFICE 2003 | OFFICE 2007 | ||
|
Microsoft
Office 2007 New Features This one-day Tutor led course covers those features of Microsoft Office 2007 that are new to the Office system. Students will learn about the Microsoft Office button, Ribbon tabs and Ribbon groups, galleries, contextual Ribbon tabs, Live Preview, the Dialog Box Launcher, the Document Information Panel, and the Mini toolbar. Students will also work with the XML file format and the macro and non-macro file formats. In addition, dedicated units for Word, Excel, PowerPoint, Outlook, and Access introduce the new features of each application.
|
|||
|
Microsoft Word Level
1- This one-day Tutor led course is designed to help you to obtain the basic skills required to create simple documents using Microsoft Word 2003. You will learn to create, edit, format, print, and review short documents such as letters and memos. You will learn to apply basic page, paragraph, and character formatting options, create a document from a template, insert pictures and clip art, and create a simple table. You will also learn to review a document using features of Word. Download full course outline |
 Microsoft
Word 2007 Level 1-This one-day Tutor led course covers the basic functions and features of Word 2007. Students will learn how to enter and edit text, and save and browse documents. They will learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof and print documents, and insert graphics
|
||
|
Microsoft Word Level
2- This course is designed to help you to develop existing skills in Word to create and collaborate on more complex documents. You will learn to create documents that incorporate different objects, such as graphs, pictures, and diagrams. You will also learn to save a document in different file formats and apply more complex formatting, such as sections, columns, and outline numbering. Finally, you will learn to combine a document with a data source to create mail merge letters and labels. Download full course outline |
Microsoft
Word 2007 Level 2- This one-day Tutor led course builds on the skills and concepts taught in Word 2007: Basic. Students will work with styles, sections, and columns. They will format tables, print labels and envelopes, and work with graphics. They will also use document templates, manage document revisions, and work with Web features
|
||
|
Microsoft Word Level
3- This course is designed to help you to develop document solutions for longer format document types, such as a report, thesis, book, or manual. You will learn to use templates, styles, and fields to format and cross-reference long documents consistently. You will learn more advanced page layout techniques, allowing you to create documents such as a newsletter or simple magazine. You will also learn to merge a document with a data source to create mail merge letters and to manage linked objects. Download full course outline |
Microsoft
Word 2007 Level 3- This one-day Tutor led course builds on the skills and concepts taught in Word 2007: Intermediate. Students will perform mail merges, create and use forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames. They will also create macros, customize the Quick Access toolbar and keyboard shortcuts, and work with XML documents
|
||
|
Microsoft Excel
Level 1- This course is designed to help you to obtain the basic skills required to create and use a spreadsheet using Microsoft Excel. You will learn to enter and edit data, create formulas, format elements of a worksheet, and insert charts Download full course outline |
Microsoft Excel 2007 Level 1- This
one-day Tutor led course teaches the basic functions and features of Excel
2007. After an introduction to spreadsheet terminology and Excel's
window components, students will learn how to use the Help system and
navigate worksheets and workbooks. Then they will enter and edit text,
values, formulas, and pictures, and they will save workbooks in various
formats. Students will also move and copy data, learn about absolute and
relative references, and work with ranges, rows, and columns. This
course also covers simple functions, basic formatting techniques, and
printing. Finally, students will create and modify charts, and learn how
to manage large workbooks.
|
||
|
Microsoft Excel
Level 2 - This course is designed to help you to develop your skills in using the spreadsheet tool Microsoft Excel. You will learn to use more advanced functions and create more complex formulas. You will learn to manage and link together multiple worksheets. You will also learn to apply more advanced formatting to charts and use basic reviewing tools, such as the spelling checker and comments. Download full course outline |
Microsoft Excel 2007 Level 2 - This one-day Tutor led course builds on the skills and concepts taught in Excel 2007: Basic. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques, worksheet auditing and protection, file sharing and merging, and workbook templates.
|
||
|
Microsoft Excel
Level 3- This course is designed to help you to develop spreadsheets in which data on different sheets can be linked, consolidated, summarised, and analysed using a variety of tools. You will learn to apply different formatting options to sheets and charts and how to use LOOKUP functions to extract data from a table. You will also learn to distribute data in different formats, such as publishing an interactive spreadsheet on the web. Download full course outline |
Microsoft
Excel 2007 Level 3- This one-day Tutor led course builds on the skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
|
||
|
Microsoft Excel
VBA- |
|||
|
Microsoft Access
Level 1 - |
Microsoft Access 2007 Level 1
This one-day Tutor led course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports
|
||
|
Microsoft Access
Level 2 |
Microsoft Access 2007 Level 2
|
||
|
Microsoft Access Level 3
- |
Microsoft
Access 2007 Level 3 This one-day Tutor led course builds on the skills and concepts taught in Access 2007: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data.
|
||
|
Microsoft Access VBA - |
|||
|
Microsoft
PowerPoint Level 1 This course is designed to help you to obtain the basic skills required to create and deliver a slide show to accompany a presentation. You will learn to use templates, layouts, and formatting tools to create slides incorporating text and graphics Download full course outline |
Microsoft PowerPoint 2007 Level 1 This one-day Tutor led course covers the basic functions and features of PowerPoint 2007. Students will create new presentations that include text, graphics, WordArt, tables, charts, and diagrams. They will also edit and format slide content, and apply transition effects.
|
||
|
Microsoft
PowerPoint Level 2 This course is designed will help students to obtain the skills required to create customised presentations. Students will learn to add various types of different object to slides, such as charts, tables, and diagrams. In addition, students will learn to customise formatting using master slides and colour scheme. Students will also be able to package and deliver a presentation in different formats and create interactive presentations using action settings and hyperlinks Download full course outline |
Microsoft PowerPoint 2007 Level 2 This one-day Tutor led course builds on the skills and concepts taught in PowerPoint 2007: Basic. Students will customize PowerPoint by modifying the Quick Access Toolbar and creating macros. They will also apply themes and templates, and they will work with SmartArt graphics and tables. Students will add multimedia content and interactive elements to slides, and they will learn about presentation distribution options including PDF and HTML. Finally, students will integrate PowerPoint with Word and Excel.
|
||
|
Microsoft Project Level 1- After completing This one-day Tutor led course, students will know how to: • Apply project management concepts, identify tools in Project 2003, and start Project 2003. You will also know how to open existing files, use the Office Assistant, create, save, and close new project files, and close Project 2003. • Work in Gantt Chart view to add tasks and duration to a task list, insert and delete tasks, add project summary tasks, indent and outdent tasks, hide subtasks, add recurring tasks, view Work Breakdown Structure (WBS) codes, and define and apply WBS codes. • Create task links and unlink tasks, add lead-time, explore Network Diagram view, modify task links in Network Diagram view, insert task types, set milestones, and set task constraints. • Create a new base calendar, task calendar, and resource calendar, create a resource pool in Resource Sheet view, assign resources to tasks, filter for resources, use the Resource Graph to identify resource availability, and work with resource costs. • Examine and customize Calendar view, customize Gantt Chart view and Network Diagram view, and group assignments in Usage view. • Edit task constraints, edit effort-driven schedules, identify and resolve resource overallocation, and adjust resource leveling manually. • Use standard filters and AutoFilters to view data, create interactive filters, use predefined groups, create custom groups, sort task lists and resource lists, and renumber sorted resource lists. Download full course outline |
Microsoft Project 2007 Level 1 In development, contact Melton IT for further details |
||
|
Microsoft Project Level 2 - After completing This one-day Tutor led course, students will know how to: • Use the Project Guide to create project plans; save a baseline and an interim plan; update percentage of tasks completed, actual start date, actual work, and actual costs for a resource; use the Earned Value table to monitor the actual and estimated costs of tasks; and view task progress in Gantt Chart view and Network Diagram view. • Analyze the project by viewing the project status, critical path, and slack in the schedule and by performing a PERT analysis, reschedule the project by splitting tasks, and adjust resource schedules by delaying resource work and assigning overtime. • Format a project file by modifying bar styles and timescale, use the Drawing toolbar to enhance the Gantt Chart information, print views and reports, and create a custom report and a Crosstab report. • Consolidate project files, link tasks across projects, assign task priorities, share and copy project elements and share resources across projects. • Import and export data from and to a Microsoft Excel worksheet and a Microsoft Access database, and copy and paste project information to a Microsoft Word document and a Microsoft Excel worksheet. • Create a custom Network Diagram view and a combination view, create and run macros to automate tasks, create a new toolbar and a new menu, and create a custom table by using the More Tables dialog box. Download full course outline |
Microsoft Project 2007 Level 1- In development, contact Melton IT for further details |
||
|
Microsoft Project Essentials - After completing this two-day course, students will have a broad understanding of the capabilities of Microsoft Project 2003 Download full course outline |
Microsoft Project 2007 Essentials - In development, contact Melton IT for further details |
||
|
Microsoft Outlook - This course will help students to use the email and scheduling application Microsoft Outlook. Students will learn to send and receive emails and instant messages and to manage communications and contacts using Outlook. Students will also learn to use the scheduling component to arrange appointments, meetings, and tasks. Students will be able to customise the view to sort, group, filter, and search for items. Download full course outline |
Microsoft Outlook 2007 Level1 This one-day Tutor led course covers the basic functions and features of Outlook 2007. Students will create e-mail accounts and send e-mail messages using several techniques. They will also learn how to manage e-mail messages, contacts, tasks, and meeting requests. Finally, students will customize Outlook for maximum efficiency.
|
||
|
Microsoft Outlook 2007 Level 2 This one-day Tutor led course builds on the skills and concepts taught in Outlook 2007: Basic. Students will learn how to customize Outlook and work with address books. They will search and filter mail folders, and apply and customize categories. Students will also work with personal, public, and offline folders. Finally, students will organize folders and set rules.
|
|||
|
Microsoft
Outlook 2007 Level 3 This one-day Tutor led course builds on the skills and concepts taught in Outlook 2007: Intermediate. Students will learn advanced techniques for managing stored e-mail messages. Students will create and work with notes and Journal entries, schedule and manage meetings, share Outlook content, and customize templates and forms.
|
|||
|
Microsoft
Publisher Level 1 Students will get the most out of this one day course if their goal is to become proficient using Publisher 2003 to create publications, format text, insert graphics, create tables, and perform other basic-level tasks. Download full course outline |
Microsoft Publisher Level 1 - In development, contact Melton IT for further details |
||
|
Microsoft
Publisher Level 2 - Students will get the most out of This one-day Tutor led course if their goal is to become proficient using Publisher to create newsletters, design Web sites, set up mail merges, and perform other advanced-level tasks. Download full course outline |
Microsoft Publisher
Level 2 - In development, contact Melton IT for further details |
||
|
Microsoft Visio
Level 1 - After completing This one-day Tutor led course, students will know how to: • Create, save and close a file and navigate in Visio's work environment. • Draw and manipulate objects. • Create flowcharts and organization charts. • Use formatting options and dynamic connectors. • Create and print network diagrams. • Use advanced layout techniques, create and work with custom properties, and work with reports Download full course outline
|
Microsoft Visio 2007 Level 1
- In development, contact Melton IT for further details |
||
|
Microsoft Visio
Level 2- After completing This one-day Tutor led course, students will know how to: • Create, assign, and customize layers; modify the drawing scales; and add and modify dimension lines. • Create complex shapes, create and edit formulas and functions by using special drawing operations, add a predefined action and custom shape behavior to a shape, specify a behavior for double-click action, and create custom stencils. • Create block diagrams, flowcharts, organization charts, and project management diagrams. • Create and customize a detailed network diagram, generate a report on network data, generate a Web site map and a report of Web site links. • Create a program window and system diagram, create a database model diagram, and reverse engineer a table from an existing database. • Create and assign a background page, create and apply styles, create a custom template, and create a drawing based on a custom template. • Integrate Visio drawings with other programs, such as Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook and work with Web-enabling features Download full course outline |
Microsoft Visio 2007 Level 2
- In development, contact Melton IT for further details |
||
|
Microsoft Windows Vista New Features This one-day Tutor led course teaches those features and functions of Windows Vista that were not present in Windows XP. Students will learn how to work with the Sidebar, control gadgets, perform content searches, and browse the Web with Internet Explorer 7. They will also learn how to configure the Phishing Filter, view an RSS news feed, use Windows Meeting Space, and scan for spyware. This course is intended to accelerate the transition from Windows XP or Windows 2000
|
||
|
Microsoft Windows Vista Introduction This one-day Tutor led course teaches the core features and functions of Windows Vista. Students will learn how to use the Start menu, move and resize windows, manage files and folders, and perform content searches. They will also create shortcuts, change system settings, and browse the Web with Internet Explorer 7
|
||
|
Microsoft Windows Vista Advanced This one-day Tutor led course builds on the skills and concepts taught in Windows Vista: Basic. Students will learn how to scan for spyware, manage user accounts, change file attributes, and create a complete PC backup. They will also learn how to manage the print queue, enable file sharing, use Windows Meeting Space, and publish a calendar.
|
[Legal Policy] | [ Privacy Policy] Top
