Company Logo MS Trainer LogoMS Pro Logo
Home PageAudit ServicesSoftware ServicesSupport ServicesTraining ServicesWeb Design

 

 

 

Microsoft Windows
Microsoft Word
Microsoft Excel
Microsoft Powerpoint
Web Design
Outlook
Other Software
Download

 

 

 

 

Training Services

We offer a comprehensive range of training, from basic through advanced level, to individual customised personal training programs. This page gives an overview of standard training, but many other applications can be catered for on request. Please note that all training should be prefaced by a full Training Needs Analysis to ensure a good match between skills and needs.

All training is carried out in a 'hands-on' style, and concentrates on completing exercises designed to demonstrate specific functions and skills. All sample files are presented in 'before and after' versions so that progress can be checked against the ideal solution.

Each training course is available in pdf format, with all supporting files, and may be purchased as is, or customised to your specific requirements. The courses may also be delivered by one of our instructors on-site at your location.

Microsoft Windows

The user interface of Windows is very richly featured and also quite confusing to the new user. For new users, this course covers the basic topics to enable efficient use of this operating system.

  • Introduction to the components of a computer - processor, memory, disks, i/o devices, keyboard, mouse, start-up and shutdown
  • The windows user interface - Window layout, control menus, TaskBar and Start menus
  • Desktop components- Recycle Bin, Network Neighbourhood, My Computer, Control Panel
  • The Windows Help system
  • Windows Explorer - hard disk organisation, folder structure, managing files and folders, running drive diagnostics
  • Finding files and folders
  • Using the Network - using network drives, printers and applications
  • Customising Windows - the Desktop, the Start Menu, display options
Top of Page

Microsoft Word

Microsoft Word is capable of almost any type of text manipulation from a simple memo to a graphic layout that approaches the complexity which would have formerly needed a separate Desktop Publishing Package.

Fundamentals

  • Introduction - screen, menus and help System
  • Creating documents - inserting text, saving, printing
  • Editing - text selection, find and replace, simple formatting
  • Page and paragraph layout - margins, page numbers, indents, tabs, fonts and character effects, creating and applying styles
  • Document views - normal, print, web and outline views
  • Headers and Footers
  • Creating and drawing tables
  • Mail merge to labels and standard letters
  • Spelling and Grammar checking
  • Customising Word

Advanced

  • Top-down document formatting - rulers, gutter and mirror margins, page and section breaks, header and footer control
  • Paragraph format - text alignment, line spacing, text flow, borders and shading, bullets, numbers and outlines
  • Styles - built in, user defined, modifying, attaching to global template
  • font decoration - colour, special effects, spacing, position, kerning, highlighting, AutoFormat and AutoText entries
  • Advanced table design, manipulating columns and rows, table, cell and text alignment, freehand tables, inserting Excel worksheets
  • Text columns
  • Inserting graphics - flowing text round pictures, text boxes and AutoShapes
  • Creating forms and saving form data
  • Advanced mail merge, using word, Outlook and Excel
  • Simple VBA macros
  • Creating and editing Normal, Global and Document templates
  • Managing large documents with Master and Sub documents
  • Footnotes, Endnotes, Bookmarks, cross references, table of contents, table of figures and table of authority
Top of Page

Microsoft Excel

Excel is one of the most commonly used applications and is capable of a wide range of functions other than simple manipulation of rows and columns of figures.

There are three courses available, from basics to using Visual Basic macros.

Fundamentals

  • Introduction - screen, menus, worksheets and cells, toolbars
  • Creating a worksheet - entering text and numbers, AutoComplete and AutoCorrect,fonts, copying cells, entering formulae, editing and aligning cells, printing, saving and closing
  • Editing worksheets - date formats, borders and patterns, styles, cell references, using functions and names
  • More editing - rounding numbers, correcting formulae errors, inserting rows and columns, AutoFormat, managing files and folders
  • Using Excel Charts - chart components, embedded charts, chart menus and toolbars, the chart library
  • Printing charts and worksheets - headers and footers, page breaks and the print area
  • Manipulating worksheets - AutoFill, the Format Painter, moving formulas, sorting, splitting, freezing and zooming worksheets
  • Multiple workbooks - inserting and deleting worksheets, copying between workbooks, group editing

    Advanced

  • Complex worksheets - absolute and relative references, cell names, array formula, custom number formats, styles, special text effects
  • Viewing and outlining - hiding rows and columns , using views and reports
  • Manipulating Charts - chart types, moving and sizing, adding chart items, changing axes, changing values, plot order, adding data series to a chart
  • Chart formats - AutoFormat, multiple chart types and axes, formatting chart items
  • Analysing data - forecasts and trends, pivot tables and pivot charts
  • Problem solving - scenarios and data tables
  • Simple excel macros
  • Creating and using forms
  • Worksheet consolidation - 3-D formulas, external references, linking consolidated worksheets
  • Data handling - creating a data list, looking up values, sorting and filtering, data validation and tracking
  • Workbook, worksheet and cell security
  • Sharing workbooks on the web
  • Customising Excel

    Excel VBA

This course is a basic introduction to the use of Visual Basic for Applications (VBA) macros within Excel. It is not a traditional programming course, but concentrates on providing the ability to edit and improve simple macros created by the Excel Macro Recorder

  • Recording and editing macros - absolute and relative recording, running macros from menu, toolbar, or graphic button
  • The Visual Basic Environment - modules, the Visual Basic Editor, the Help system
  • Definition of variables, arrays, constants, operators, expressions and functions
  • Object Oriented Programming - objects, properties and methods
  • User interaction - message boxes, input boxes and data validation
  • Flow control Statements - if, go to, select case, for, do
  • Debugging and error handling
  • Custom forms and dialogue boxes
  • Custom menus and toolbars
  • Sample projects
Top of Page

Microsoft Access

Access is an extremely powerful database, but only a large portion of its function is 'hidden' behind its user interface. The main limitation to its efficient use is that it does require an understanding of database design principles. These skills are a main feature of the courses offered

Fundamentals

  • Introduction and overview - terminology, relational database concepts viewing a sample database
  • Creating a database - creating a table and adding fields, setting field properties, importing tables
  • Editing records, formatting the datasheet, selecting, sorting and filtering records
  • Queries - query types, creating select queries, adding criteria, queries on multiple tables
  • Form design - using the form wizard, changing the form in design view, selecting and moving form controls, adding calculated controls, combo boxes and lookup tables
  • Creating end editing reports
  • Using the database wizard

Advanced

  • Database design concepts - the design window, fields and properties
  • Table design - fields, formats, masks, caption, default values, validation rules, required property, indexes, key fields, lookup fields
  • Functions and expressions - using the Expression Builder, calculated controls, text functions, date and time functions, domain Aggregate functions
  • Queries - Make Table, Update, Delete, Append, Crosstab, Find Duplicates, Find Unmatched, Multi-table, Concatenation queries
  • Forms - control properties, macros, Combo Boxes, main and subforms, search combos, command buttons, adding domain aggregate controls
  • Reports - Group and Totals, sorting and grouping, running reports from forms
  • Database Maintenance - building menus, automatic macros, backup, repair and compacting, security
  • Sample projects - password protection, linked combo boxes, finding missing items
Top of Page

Microsoft Powerpoint

Powerpoint is one of the most popular presentation packages currently in use. This course is based around preparing a complete presentation from scratch. It starts with a single slide and finishes with a fully customised presentation of around 15 slides

  • Starting Powerpoint and running a presentation
  • Overview - the screen, menus, toolbars and views
  • Title Slides - adding titles and bullets, outline levels, rearranging slide items, formatting text, indents, line spacing and tabs
  • The Help system - context help and searching
  • Drawing - drawing tools, creating shapes, selecting and moving, adding text to shapes, adding clip art, aligning with guides
  • Adding an organisation chart - entering the chart text, formatting
  • Graphs - the chart and datasheet windows, default graph, editing the legend, axes and chart type
  • Importing Excel data as a chart
  • Using the Templates and the Slide Masters - applying a template, editing the Slide Master, adding and removing Master objects, inserting background text and headers / footers
  • Standard Templates and Presentation Designs - using and modifying standard presentations
  • Running a slide show - hiding slides, adding transitions animation and builds, setting slide timings for automatic presentations
  • Printing - slides, speaker notes, handouts and outlines
  • Tabular text - creating with Powerpoint and inserting Word text
Top of Page

Web Design

Designing web sites is not a difficult procedure as there are a considerable number of packages available which are very similar in use to document creation within Microsoft Word. It is not possible however to get beyond very basic site design without having a simple working knowledge of the HTML mark-up language used to create web pages. For this reason, we offer three courses. An introduction to HTML gives the minimum required knowledge to create and publish a web site with very simple text and graphics. For more complex sites, we offer either Macromedia Dreamweaver or Microsoft Frontpage.

HTML Fundamentals

This course demonstrates simple web page design using a text editor such as Notepad and concentrates on HTML syntax. It is a prerequisite to obtaining full function from standard web design packages

  • Overview of the Internet - how it works, browser types, HTML versions, script languages
  • Creating a web page - using logical tags, formatting using physical tags
  • Hyperlinks - types of hyperlink, linking to documents, mail addresses, bookmarks and external web sites
  • Adding graphics - graphic file types, creating and editing images inserting and aligning, background colour and images
  • Using Microsoft Word as a web page editor - creating the page, adding titles, headings, text, images, lists and links
  • Publishing the web - web site structure, using FTP to transfer the site to a server
  • Browsing the finished site

Web Site Design

This course can be based around Frontpage 98, Frontpage 2000 or Dreamweaver In each case, a complete web site is developed and published.

  • Introduction to the design package - preview of the finished site, overview of the package interface
  • Creating a new site - using a template, inserting external text, files and web pages
  • Organising site folders and creating a correct structure
  • Inserting mail, bookmark and web links, text Vs graphics links
  • Page formatting - Text format, in-line styles, spelling checks, search and replace functions, Cascading Style Sheet styles, common text and library items
  • Multimedia - graphics, sound movies, image position and transparency, image maps, Macromedia Fireworks and Flash
  • Forms - creating forms, adding fields, field types, data validation, data collection, server side scripts for form handling
  • Frames - purpose of a frame, frame pros and cons, creating the frameset and adding pages to it, navigating frame pages
  • Publishing guidelines - choosing an ISP, getting server script support
Top of Page

Microsoft Outlook

Outlook is a superb e-mail package, equally at home for thousands of users in a large company, or a private user with only a few messages each week.

  • Overview of Outlook - the folder groups, toolbars, folder list
  • Creating and sending messages - addressing, formatting, adding a signature, spelling, message options, attaching files, inserting hyperlinks and mail addresses
  • Reading mail - replying, sorting the display, finding items, printing and deleting messages
  • Folders and Address Books - creating folders, using the contacts folder, creating nicknames, using a distribution list
  • Diaries and Meetings - the calendar, adding appointments, setting reminders, printing, requesting meetings, inviting attendees, accepting meeting requests
  • Personal folders - how to use them, location, creating and moving item to them, archiving
  • Remote access - getting the mail on the move
  • Dial up access from a laptop - off-line folders, global address list
  • Advanced topics - recalling messages, voting messages, grouping and organising and filtering messages, junk mail, creating message handling rules, recurring appointments and tasks, file import and export, sharing mail folders, delegating mail to others, mail merge from the Contacts folder
Top of Page

Other Applications

On request, we will attempt to arrange training on most standard software, Quicken, Quickbooks, Tax packages, disk partitioning utilities, antivirus programs, backup software etc.

Top of Page

Download

A sample of our workshop style training material may be downloaded here

 

Contact: - info@deepol Services
©Copyright Deepol Services - All Rights Reserved