NSS offers customized on-site computer training courses.   Training sessions are available in a one-on-one or group environment.   Course content is designed based on individual customer requirements and can be for a single, specific topic or multiple topics.   Customized workbooks/manuals include Tips & Tricks, step-by-step instructions, and exercises (dependent on course topic and length).   Course offerings range from Microsoft Office (Word, Excel, PowerPoint, Access, Front Page, Outlook, Publisher) to Simply Accounting and more.

	Access
	Email
	Excel
	Front Page 2002 and 2003
	Internet Explorer, Firefox & Netscape
	Office Integration (MS)
	Office 2007 & Vista: What's New and Different
	Outlook
	Outlook Express
	PowerPoint
	Project (MS)
	Publisher
	Simply Accounting
	Windows XP and Vista etc.
	Word

• What is a database? What is Access?
• Steps to Create a Database
• The Main Access Window
• Basics of Access
• Defining/Designing a Table
• Table Fields and corresponding Data Types and Lookup Properties
• Data Manipulation (including Sorting)
• Forms: Designing, Single Table & Multiple Table, Calculating Controls, Subforms
• Queries: Select, Parameter, Update, Append, Total, Delete, Crosstab, Inserting Calculating Fields
• Reports: Designing, Sorting and Grouping, Calculating Controls, etc.
• Formatting Fields
• Input Masks
• Text Boxes
• Combo Boxes, Lookups
• Check boxes, Option Buttons
• Relationships
• Importing and Exporting
• Linking to Word and Excel
• Organizing Database Objects
• Command Buttons
• Basic Macros
• Startup Properties
• Switchboards

• Sending, Replying, Forwarding
• Attachments: Sending and Receiving
• Spell Check
• Privacy/Confidentiality
• Address Book, Group Distribution Lists
• Signatures, Stationery, Options
• Organizing Email: Finding/Sorting, Renaming Folders, Deleting Email
• Preferences/Options
• Mail Rules (e.g. Blocking Senders, Colour Coding Incoming Messages, Moving Incoming Message to a Folder)

• What is a Spreadsheet?
• Basics of Software Package
• Entering & Editing Data
• Cut, Copy & Paste
• Formulas & Functions (e.g. Vlookup, IF, Counts)
• Editing Worksheets
• Worksheet Properties
• Spell Check
• Printing (Print Preview, Page Break Preview)
• Page Set up
• Inserting and Formatting Headers/Footers
• Formatting Text and Cells (including Borders and Shading)
• Password Protecting Worksheets and Workbooks
• Find and Replace
• Sorting
• Comments
• Graphics & Objects (Drawing)
• Charts
• Paste Links
• Hyperlinks
• Range Names
• Creating, Revising Templates
• Conditional Formatting
• Data Validation
• Auditing Formulas
• Goal Seek/Solver
• Filtering
• List Boxes
• Macros
• Merging Workbooks
• Pivot Tables
• Data Tables
• Access/Word/PowerPoint: Importing/Exporting

• The Front Page Window
• Views
• Spell Check
• Navigation
• Adding New Pages
• Renaming, Deleting Pages
• Organizing Pages and Images: Creating Folders
• Adding/Formatting Text
• Backgrounds
• Page Properties (Page Titles etc.)
• Bulleted and Numbered Lists (using Graphics and Symbols)
• Shared Borders
• Customize Navigation Bars
• Hover Buttons
• Backgrounds
• Previewing Site
• Publishing Site
• Inserting Graphics & Objects: resampling, formatting, etc.
• Drawing Toolbar
• Tables
• Web Components (Include Page Contents, Link Bars, Hover Buttons etc)
• Frames
• Style Sheets
• Forms
• Meta Tags (Keywords)
• Relative versus Absolute Addressing
• Hyperlinks & Bookmarks
• Reports
• MS Office and Front Page

• Surfin', Exploring and Searching Tips & Tricks
• Favourites and Bookmarks
• Downloading objects and files
• Maintenance: Deleting Temporary Downloaded Files and Cookies

• Mail Merging Outlook Contacts Into Word
• Copying Portion of Excel Spreadsheet Into Word
• Creating an Excel Spreadsheet in Word
• Linking Excel Files to Word or PowerPoint
• Merging Access Objects Into Word
• Inserting Access Data Into Word
• Publishing Access Data to Word
• Exporting Excel Data Into Access
• Exporting Access Data Into Excel
• Linking Access and Excel With and Without Query Properties

• What is Outlook?
• Basics of Outlook
• Email: Send, Reply, Forward, Attachments, Signatures, Spell Check, Finding/Sorting, Stationery etc
• Contacts: Emailing Contacts, Group Distribution Lists, Merging with Word
• Calendar: Scheduling & Meetings, Recurring Appointments, Views, Printing etc
• Tasks: Setup, Delegating
• Notes
• Journals: Utilizing with Contacts
• Creating, Renaming and Deleting Calendar, Email, Task & Notes Folders
• Copying/Moving/Deleting Emails, Calendars, Tasks, Notes, Contacts, Journals
• Preferences/Options: Email, Calendar, Tasks, Notes, Journals
• Mail Rules (e.g. Blocking Senders, Colour Coding Incoming Messages, Moving Incoming Message to a Folder)

• Basics of an Effective Presentation
• Basics of Software Package
• Copying/Moving Slides
• Views
• Spell Check
• Hiding Slides
• Adding Text, Formatting
• Bulleted and Numbered Lists
• Standard and Custom Colour Schemes
• Inserting Objects/Graphics
• Inserting Charts & Tables
• Importing from Word/Excel
• Master Slide and Title Master
• Summary/Agenda Slides
• Action Buttons
• Transition Effects and Sound/Movies
• Chart Effects
• Animating Slides
• Rehearsing Slide Show
• Running the Slide Show: Pen and Mouse Pointer, Moving Around Slide Show
• Handouts and Speaker Notes

• What is Project Management? What is MS Project?
• Defining Task Types
• Entering and Organizing Tasks
• Deleting Tasks
• Task Constraints
• Linking Tasks
• Overlaps and  Delays in Tasks
• Splitting Tasks (Interrupting Tasks)
• Setting up & Defining Resources
• Assigning Resources
• Calendars: Project, Resource, Task
• Tracking and Reviewing/Adjusting
• Editing, Customizing
• Printing
• Reporting
• Exporting Into Excel
• Sorting, Filtering, Grouping
• Critical Path
• Multiple Project Linking

• What is Desktop Publishing? What is Publisher?
• Basics of an Effective Publication
• Basics of Publisher
• Adding Text, Formatting (including Borders and Shading)
• Spell Check
• Cut, Copy & Paste
• Newsletters, Brochures etc
• Inserting Tabs, Tables
• Inserting Objects/Graphics
• Utilizing the Background/Master Page
• Linking
• Connecting Frames
• Grouping Objects
• Page Numbering
• Creating, Revising Templates

• The Simply Window and Modules
• Views, System Settings, Preferences, Options
• Creating New Company
• Account Numbering
• Creating/Revising/Deleting Accounts, Suppliers, Vendors, Employees
• Accounts Payable
• Accounts Receivable
• General Journal Entries
• Memorized Transactions
• Payroll
• Adjusting Posted Entries
• Reversing Posted Entries
• Setting up Credit Cards
• GST, Source Deductions, PST etc
• Reconciliation
• Projects: Setting Up, Allocating
• Inventory
• Reports & Financial Statements
• Back-up, Restore, Maintenance

• The Desktop Screen (Recycle Bin, My Computer etc.)
• The Window (Minimize, Maximize, Title Bar etc.)
• Start Menu, Taskbar
• Settings: Control Panel (including screensavers, wallpaper etc)
• File Management: My Computer and Windows Explorer, Creating New Folders, Renaming Folders and Files, Deleting Folders and Files, Moving/Copying Files and Folders
• In MS Office: Creating New Folders, Deleting/Renaming/Copying/Cutting Files and Folders
• Selecting drives, Saving to Floppy Disks
• Copying files to CD's/Retrieving files from CD's
• Creating Desktop Shortcuts
• Maintenance: Scandisk, Defrag, Deleting Temp Files
• What's New (Office & Windows XP & Office 2003 - refer to XP/2003: What's New and Different)

• Word Processing Basics
• Basics of Software Package
• Views
• Entering, Editing Text
• Spell and Grammar Check
• Thesaurus
• Formatting Text
• Page Set up: Margins, Paper Size and Orientation
• Cut, Copy & Paste
• Find and Replace
• AutoCorrect, AutoText
• Tabs (including Dot Leaders), Indents
• Bulleted and Numbered Lists
• Tables
• Envelopes and Labels
• Headers and Footers (inserting and formatting)
• Borders and Shading
• Inserting Graphics, Clip Art, Text Boxes and Objects (Drawing)
• Symbols
• Watermarks
• Mail Merge
• Creating, Revising Templates
• Comments
• Password Protecting
• Reviewing/Tracking Changes
• Hyperlinks
• Sections
• Forms
• Styles
• Bookmarks
• Table of Contents, Indexes
• Captions
• Reviewing/Tracking Changes
• Inserting an Excel Spreadsheet or Chart
• Importing/Exporting with other MS Office products
• Macros

• Vista: File Management, Control Panel, Help and Searches, Desktop
• Office 2007: Word, Excel, Access, Outlook, PowerPoint and Publisher - what's new and different in each software package

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer