Training School:
Jobs & Resumes: Newcastle Houses & Roommates: Newcastle
Total 16 program(s)/course(s) available.
OUTLOOK 2007 This course covers all aspects of using an electronic mail / diary system.
Content ;
Create / Send Electronic Mail
Store Messages
Read A Mail Message
Delete Messages
Reply To A Message
Using The Calendar
Forward A Message
Create An Appointment
Add An Attachment
Create A Recurring Appointment
View An Attachment
Print Out Your Calendar...
VISIO 2007This course covers all aspects of using this technical drawing package.
Content ;
Using Stencils / Tools
Adding Connectors
Inserting Text
Inserting Graphics
Adding Objects
Using Layers
Aligning Objects
Distributing Objects
Creating Flow / Organisation Charts
Copying To MS Office Packages...
FRONTPAGE 2007This course covers the procedures involved in planning and managing a company
intranet / internet site.
Content ;
Creating a Home Page
Adding Text to a Page
Applying Text Formatting
Modifying a Page Layout
Apply a Background Image
Adding Pages
Adding Hyperlinks to Pages
Adding a Picture to a Page
Using the Drawing Tools
Inserting a Table
Editing a Table Structure
Formatting ......
POWERPOINT 2007 ADVANCEDA good working knowledge of MS Project is assumed & ideally prior attendance on an MS Project course.
Content ;
Setting / Changing / Assigning Calendars
Outlining Tasks
Task Types �Work / Duration / Units
Tracking Projects / Baseline
Levelling Projects
Critical Path
Inserting Custom Fields
Templates
Working with Multiple Projects
Linking Projects
Sharing Resources
Customisin......
POWERPOINT 2007 INTRODUCTIONThis course covers the procedures involved in planning and managing a project.
Content ;
Creating / Linking Tasks
Filtering Data
Dependency Links
Working With Views
Gantt / PERT Chart
Assigning Resources
Monitoring A Project
Resource Overallocation
Printing & Reporting
Tracking Project Progress / Costs...
POWERPOINT 2007This course covers all aspects of creating a presentation.
Content ;
Creating Slides
Formatting Text
Inserting Bullet Points
Formatting Bullet Points
Creating Tables
Creating Graphs
Creating Organisation Charts
Adding Graphics
Using Clipart
Adding Animations
Creating Slide Transitions
Running A Slide Show...
ACCESS 2007 ADVANCEDIt is assumed that you are a regular user of MS Access or have attended either of the above courses.
Content ;
Building Relational Databases
Types Of Relationship Links
Bound And Unbound Controls
Creating Calculated Controls
Using Tab Pages
Creating Option Groups
Creating / Modifying Macros
Creating Command Buttons
Designing Application Menus Compacting Databases
Setting Password......
ACCESS 2007 INTERMEDIATEUsers should have attended the MS Access Introduction course or be familiar with the ‘basics�
Content ;
Importing Data
Creating Input Masks / Expression Builder
Adding Combo Boxes To A Form
Multi-Table Forms
Cross-Tab Queries
Summary Queries
Using Calculations In Queries
Action Queries
Applying Sorting And Grouping To Reports
Performing Calculations On Reports
Using The Chart ......
ACCESS 2007An Introductory course for new users of this database package.
Content ;
What Is A Relational Database ? MS Access Concepts / Terminology
Creating Database Tables
Setting Data Types
Using Validation Rules
Using Lookup Fields
Sorting & Filtering Data
Creating Select Queries
Designing And Setting Criteria
Creating And Modifying Forms
Creating Reports
Designing And Modifying Reports...
EXCEL 2007 VISUAL BASICIt is assumed that you are a regular user of MS Excel or have attended an Excel course.
Content ;
Recording macros
Absolute and relative recording
Where macros are stored
Assigning macros to buttons
The VB code editor
Using Project Explorer
Creating modules
Basic subroutines and comments
Input boxes and message boxes
Declaring variables
Assigning macros to events
Declaring fu......
EXCEL 2007 ADVANCEDIt is assumed that you are a regular user of MS Excel or have attended one of the above courses.
Content ;
Named Ranges Advanced
Sorting / Filtering Data
Nesting Functions Data Validation
SUMIF / COUNTIF / LOOKUP Functions Statistics / Advanced Functions
Scenarios
Customising Menu Bars
Pivot Tables Macros �Creating / Modifying...
EXCEL 2007 INTERMEDIATEUsers should have attended the MS Excel Introduction course or be familiar with the ‘basics�
Content ;
Relative And Absolute References
Copying / Linking Worksheets & Workbooks
Data Form Creating / Using Templates
IF / MAX / MIN Functions Conditional
Formatting
Freeze Panes / Split Screen
Sorting / Filtering Data
Charts �Adding Trendlines
Protecting Cells / Sheets...
EXCEL 2007An Introductory course for new users of this spreadsheet package.
Content ;
What Is A Spreadsheet ?
Entering / Formatting Data
Opening / Saving Workbooks
Copying / Pasting Data
Increasing Column Width / Row Height Automatic Procedures
AutoFill / AutoCorrect / AutoComplete Simple Formulae / Calculations
Creating Graphs / Charts
Modifying Chart Data Set
Cell Comments...
WORD 2007 ADVANCEDIt is assumed that you are a regular user of MS Word or have attended either of the above courses.
Content ;
Styles �Creating & Modifying
Creating Tables Of Contents
Mail Merge Working With
Tracking Changes
Linking To Other MS Office Applications
Creating / Using Templates
Document Protection
Creating / Using Macros...
WORD 2007 INTERMEDIATEUsers should have attended the MS Word Introduction course or be familiar with the ‘basics�
Content ;
Creating on-line Forms
Adding Text Boxes
Using Graphics / Watermarks
Inserting Objects
Footnotes / Endnotes
Working With Column Layout
Formatting Complex
Tables AutoText
Numbered Lists / Multilevel Lists
Finding and Replacing Text...
WORD 2007An Introductory course for new users of this package.
Content ;
Entering Text
Formatting Text
Automatic Procedures �AutoCorrect
Moving Around A Document
Moving / Deleting Text
Printing Documents
Page Setup �Margins, Orientation
Headers & Footers
Creating Simple
Tables Spell Check...
Pages:- 1
School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent. |
|
|