The Local Non-Award Courses offered are:

This course offers the participant the ability to fine tune and personalize Windows 7 according to their needs. We will be looking at Windows 7 in a networked environment where we will be dealing with file sharing and security issue. Discover the inbuilt services provided by Windows 7 which will enable the participant to be more productive while using Microsoft® Windows 7 and fully use the functionality of Microsoft® Windows 7.

Capabilities Addressed
- Creating desktop shortcuts and folders, and Desktop Personalization options
- Taskbar Customization, locking, moving, hiding and displaying taskbar toolbars
- Adding, removing and re-ordering the course icons in the Quick Launch Tool bar
- Displaying & Customizing Side bar and Adding & Removing Gadgets
- Sharing and Accessing shared folders on your network and mapping a drive
- Using the Security Centre Window, firewall, automatic updating and malware protection
- Opening the Windows photo gallery, adding and deleting tags, thumbnail views, grouping and sorting
- Starting Windows Contacts, Adding, Editing and Removing Contacts
- Learning to use the Windows Calendar, creating new calendar, add appointments and changing the calendar view
- Using the Windows Media Centre, setting up and navigating through Windows media centre, music, pictures and videos
- Customizing the Windows 7 start menu
- Learn how to play a movie DVD and music CD, ripping a CD, burning a CD, using Windows Media Player
- Make your own movies using Windows Movie Maker, importing media and publishing a movie

Target Group
This course is for participants who have been using Windows 7 or have completed the Microsoft® Windows 7 Foundation Course.

This course is designed to help participants obtain the basic skills required to create simple documents using Microsoft® Office Word 2010. Participants will learn to create, edit, format, print, and review short documents such as letters and memos. Participants 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. They will also learn to review a document using features of Word.

Capabilities Addressed
- The Microsoft® Word 2010 screen, levels of command organization, Ribbons, Tabs and groups
- Starting to use Microsoft® Word 2010 , Opening Word document, Saving Word documents and Closing Word documents
- Selecting and formatting text, Using the Undo and redo commands
- Using the Clipboard
- Applying font types, Font Size, Case Changing, highlighting, removing formatting
- Setting paragraph marks, line breaks and text alignment
- Applying and Modifying Borders and Shading
- Using the Find and Replace feature to replace text
- Page Formatting, changing page orientation, adding and removing Headers and Footers
- Inserting, Navigating, Modifying and Deleting Tables
- Using Graphics within Microsoft Word, inserting illustrations- Multiple Documents, switching between Windows
- Using Mail Merge to produce labels and letters

Target Group
For participants who would like to learn the use of a word processor and create a standard, attractive and professional-looking documents and print, save and store them on a PC.

Word intermediate is course designed for office users who need greater degree of knowledge in terms of using word to develop detailed tables in terms of design and structure. Emphasis is also given to design and layout to allow the candidate to develop the knowledge on how to structure and layout information using various charts and design tools.

Capabilities Addressed
- Customization Microsoft® Word 2010, Setting the Username
- Using Microsoft® Word 2010 in the Compatibility Mode
- Spell Checking a Document, Adding & Removing words to the Dictionary
- Applying Line Spacing Formatting Options and using the Widow/ Orphan Control
- Editing pictures in the compatibility mode, Clipping screenshots, compressing and Modifying pictures
- Inserting, Changing and Deleting Section Breaks- Applying Different Headers and Footers to Sections and the First Page
- Adding, Modifying and Removing Watermarks- Applying Table Styles, Merging cells within a Table
- Splitting Cells, Applying Multi-level sorting and Converting Table to a Text
- Applying Text wrapping within Tables
- Applying Column Formatting, Inserting Column Breaks
- Creating, Modifying and Deleting the Autocorrect Entry
- Using the advanced find and replace options, Using the 'Paste special' option

Target Group
Word users concerned with speeding up their work and enhancing the look and functionality of their documents. Participants interested or who have completed the Microsoft® Office Word 2010 Foundation course

The course introduces the candidate to the concept of spreadsheet. The course allows participant to understand the layout of Microsoft® Excel, in addition to the purpose of specific components. Similarly the course provides information in regards to creating functions, needed in complex calculations and determining the outcome of specific values. To add the course also deals with the development of graphs and charts to depict the results of specific values on an excel sheet. The course also provides solutions to reducing the work needed on entering multiple values on the worksheet by utilizing inbuilt options of excel.

Capabilities Addressed
- Starting Excel 2010course, learning to Open, Save & Close Workbook
- Inserting, Modifying or deleting worksheets
- Selecting multiple range of cells, entire worksheet, rows and columns- Inserting, Modifying and Deleting Rows and Columns
- Copying, Cutting, Pasting, Formatting and Editing Cells and Cell Content
- Switch between worksheets, renaming, copying and moving a worksheet
- Font, Number and Alignment Formatting- Freezing and Unfreeze Row and Column
- Creating formulas, Using Operators, relative and Absolute cell referencing
- Using common functions, SUM, AVERAGE, MAX, MIN, COUNT, etc.
- Creating, Editing, Resizing and deleting charts, Changing chart types
- Learning to Modify Basic Excel options

Target Group
The participants should be comfortable using a personal computer. Have little or no experience using Microsoft® Excel. Participants will gain most out of this course if the goal is to become proficient in using Microsoft® Excel 2010. Participants require knowledge on personal computers, keyboard and mouse.

This course is offered to build up on the skills and concepts taught in Excel 2010 Foundation. Participants will learn how to use multiple worksheets and workbooks efficiently. They will start working with more advanced formatting options including styles, themes, backgrounds, and watermarks. Also learn how to create outlines, subtotals, create and apply cell names. 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, protection, file sharing, merging, and workbook templates.

Capabilities Addressed
- Setup Margins & Worksheet Orientation and formatting
- Printing Titles, Row and Column Headings, Spell checking and using printing options
- Using the Nested function and consolidating data using referenced functions
- Inserting Time & Date Functions such as day, month, year, date into worksheets
- Applying Special Mathematical Functions to rows and column data
- Applying Logical Functions to a data set- Use of Statistical Functions such as concatenate, rank, trim, etc.
- Using Financial Functions- Using the VLookup & HLookup Functions
- Using Database Functions to manipulate data sets in an excel worksheet- Naming and removing cell ranges
- Applying styles, conditional and custom formatting to a range
- Copying, Moving, Splitting and hiding Worksheets
- Creating and Editing Excel Templates
- Paste Special Options to add, subtract, multiply and divide

Target Group
This course is designed for participants with some experience using Microsoft® Excel. It is also suitable for school leavers and high school students or anyone wanting to gain proficiency in Microsoft® Office Excel 2010.

This course builds up on the skills and concepts taught in Excel 2010 Intermediate. Participants will learn to work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, participants will learn about data validation and database functions such as DSUM. Participants will learn how to work with PivotTables and Pivot Charts, how to import and export data, how to query external databases and analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.

Capabilities Addressed
- Using Pivot Tables to sort, filter and group data
-  Creating one and two Input Data Tables
- Formatting of Charts and customizing data series
- Inserting, Editing and Removing Hyperlinks
- Linking & Embedding within a Worksheet and between worksheets
- Linking data between Workbooks and Applications (e.g. Excel and Word)
- Importing a delimited text files into Excel
- Sorting and Filtering Data within a Worksheet
- Tracking and Reviewing Changes (Using the 'Track Changes' feature, Sharing, Comparing and Merging Worksheets)
- Using the Scenario Manager and Scenario Summary Reports
- Validating Numbers, Lists, Data, Time, Validation Input message and Error Alert.
- Auditing using the trace precedent command, identifying cells with missing dependents
- Assigning and Deleting Macros- Enabling Passwords Protection in an Excel Worksheet, hiding and un-hiding formulas

Target Group
The participant should have some experience with Excel 2010 and should be familiar with intermediate-level tasks or participants should have completed Excel 2010 (Foundation) and Excel 2010(Intermediate).

New features in Access 2010 include a Web-ready format and an improved macro environment. Participants in the course will learn to create databases, work with tables, fields, records and sort, filter data, and integrate web development. The course will also include implementation of form and structured query language. Participants will also be taught on the integration of office themes allowing the user to change the overall appearance of the database design to make the application more appealing and user-friendly. Concepts that will also be covered are relational database application, and information management tools.

Capabilities Addressed
- Database concepts – database, relational database, table, record, field and data types
- Opening a database & Security issues – opening database, trusted locations, setting default folder location, closing a database
- Tables, Fields and Field Types – create blank database, add fields, set field types, naming and saving table
- Table Navigation & Modification – datasheet view, design view, add, delete records, navigate the records, adjust column widths, rearrange column order
- Field Properties – input masks, validating numbers and dates, data entry required/not required, reference materials, logical operators, format and input mask characters
- Manipulating tables & records – rename tables, edit , delete data within records, delete single or multiple records and table
- Primary keys and Indexing – define primary key, indexing, create and delete single
- field and multiple field indexes
- Filtering, Sorting and Searching – text filters, single and multiple filters sorting records, remove sort, sort on multiple fields, searching through records
- Relationships – one-to-one, one-to-many and many-to-many relationships, create relationships between tables, referential integrity, cascade options, delete relationship
- Forms – create, modify, save and delete forms, form views, modify data within a form, add records using a form, filter form, inserting and modifying a form header and form footer

Target Group
The target audience for the training may include but is not limited to participants from academic institutions, cooperate users, customer service officers, receptionist, clerical officers or typists. It may also include sales persons, medical officers responsible for maintaining inventory.

Target Group

The course is relevant to IT and business skills training providers, schools and colleges or corporate training departments. Content can also be bought and customized by freelance trainers for their own customers. The participant should have knowledge on office products. Participants aiming to become proficient in advanced access features and functions.

Overview

Participants will learn the more complex features such as advanced SQL design; create crosstab, parameter and action queries. Create macros, import, export, and link database objects. Integration of XML documents to database, utilizes Microsoft’s SharePoint Services, optimize databases, implement password-protection and encrypt databases. Configure Access options and properties, create hyperlink fields and use Outlook 2010 to update data. Participants will learn remote database management and understand how to automate business processes by using VBA code. Focus will also be on SQL development such as command usage, sub queries, join, and create. Participants will also test, debug and modify macros.

Target Group

The course is relevant to IT and business skills training providers, it has also been designed for IT specialists who are interested in access based database development, and with the integration of web technologies may be a key component for web developers interested in developing online forms and applications. The participant should have prior knowledge of Access 2010(foundation) and Access 2010 (Intermediate).