Login 
Password
  
 


Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Homepage
Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Microsoft Office 2003
Office 2007
Office 2010
Windows Vista
Windows 7
Visio 2003 & 2007
OneNote 2003 & 2007
Project 2007
SharePoint 3.0 User
Access 2007
Excel 2007
Outlook 2007
PowerPoint 2007
Word 2007
Office For Mac 2008
Acrobat 8 Pro
ADO .NET 2.0
Crystal Reports XI
Flash 8

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


 

Order NCSA OnDemand today and get access to over 7500 quality instuctor led videos and training courses covering today's most popular software programs and programming languages including:

          many more!

PlanComparison

Customers Include:

  • Texas Education Foundation
  • Job Corps
  • Piggly Wiggly
  • Texas A&M Corpus Christi
  • Airsplat
  • Asian College of Technology
  • INOVA Federal Credit Union
  • Capital Area Career Center
  • Las Positas College
  • Many More!

Course Highlights

  • Prepare professional charts and share data with coworkers, customers, and business partners with Excel.
  • Create and share documents through the new, easy-to-use interface of Word.
  • Create presentations with pictures, shapes, animation, and advanced delivery options in PowerPoint.
  • Follow basic and advanced functions of e-mail, planning/scheduling features, and customizing the interface in Outlook.
  • Track and report information with ease, modify pre-built applications, and share database information with Access.

About This Course


This Microsoft Office 2003 contains customized instruction on the entire Microsoft Office suite including Excel, Word, PowerPoint, Outlook and Access. The course topics appeal to all Office users – beginner through advanced. With multiple levels of instruction, you will walk through (at your own pace) performing many time-saving tasks in each of these programs.

With comprehensive lessons and engaging quizzes, new users will be guided through the fundamentals of the Office interface, while experienced users will be brought up to speed on the new navigation and functionality of this popular software.

In Excel, you will learn everything from creating professional-looking spreadsheets to sharing data and managing your spreadsheets more effectively. And, you will learn about harnessing the power of Excel with lessons devoted to cell references, auditing and advanced functions.

Through quick tips and detailed instruction in Word, you will learn how to capture the strength of this word processing program that lies beyond typing simple letters and memos. Use this course to go beyond creating simple documents to working with Mail Merge, tables and master documents.

In PowerPoint, you will learn how to maximize the built-in slide show features to develop engaging and interactive presentations through topics that include working with tables, graphics and slide animation.

With a simulated email environment in Outlook, you will learn how to maximize your productivity using built-in features like maintaining calendars, tasks, appointments and contacts.

Microsoft Access 2003 is a powerful database solution used to store and analyze important information such as customer databases, inventory tracking and enterprise level applications recording hundreds of records. In Access, you will learn how to use this program to collect, organize and manipulate data.

There are over 250 lessons in this Office course – all designed to increase your productivity.

Complete Course Outline

Word 2003: Beginner Level


1.0 Getting Started
1.1 Starting Word 2003
1.2 Touring the Word Window
1.3 Help in Word 2003
2.0 Creating New Documents
2.1 Starting a New Document
2.2 Entering Text, Delete Keys and Capital Letters
2.3 Saving Your Work
2.4 Printing & Closing a Document
2.5 Using a Template
2.6 Using a Wizard
2.7 Exiting Out of Word
3.0 Revising Your Documents
3.1 Opening Documents
3.2 Navigating Documents
3.3 Basic Editing Skills, Click and Type
3.4 Smart Tags
3.5 Adding a Date
3.6 Adding an Envelope
3.7 Multiple Page Documents
4.0 Shortcuts
4.1 Shortcut Menus/Customizing Toolbars
4.2 Keyboard Shortcuts
5.0 Essential Skills
5.1 Selecting Text
5.2 Copying & Moving Text
5.3 Clipboard Task Pane
5.4 Undo, Redo & Repeat
5.5 AutoCorrect
5.6 AutoComplete
6.0 Formatting Text & Paragraphs
6.1 Working with Fonts
6.2 Symbols & Special Characters
6.3 Document Layout and Page Setup
7.0 Proofreading & Printing Documents
7.1 Spelling & Grammar
7.2 Thesaurus & Word Count
7.3 Previewing & Printing a Document


Word 2003: Intermediate Level


1.0 Managing Documents
1.1 Document Views
1.2 Working with Multiple Documents
1.3 File & Folder Management
1.4 Search Task Pane
2.0 Additional Editing Tools
2.1 Find & Replace
2.2 AutoText
2.3 Format Painter
3.0 Page Layout
3.1 Margins & Page Setup
3.2 Page Breaks
4.0 Customizing Word
4.1 Menus & Toolbars
4.2 Changing Defaults
4.3 User Options
5.0 Understanding Formatting in Word
5.1 Formatting Choices
5.2 Reveal Formatting Task Pane
6.0 Paragraph Formatting
6.1 Tabs
6.2 Indents
6.3 Bullets & Numbering
6.4 Line Breaks
6.5 Spacing Before & After
6.6 Styles & Formatting
6.7 Sorting Text
6.8 Borders & Shading
7.0 Document Formatting
7.1 Numbering Pages
7.2 Headers & Footers
8.0 Mail Merge Basics
8.1 Understanding Mail Merge
8.2 Form Letters
8.3 Labels
9.0 Introduction to Graphics
9.1 Inserting Clip Art
9.2 Drawing & Modifying Shapes
10.0 Organizing Content
10.1 Use automated tools for document navigation


Word 2003: Advanced Level


1.0 Tables
1.1 Creating Tables
1.2 Navigating in a Table
1.3 Modifying Tables
1.4 Formatting Tables
1.5 Perform calculations in Tables
2.0 Formatting with Styles & Themes
2.1 Applying Styles
2.2 Styles & Formatting Task Pane
2.3 Creating & Modifying Styles
2.4 Applying a Theme
3.0 Document Templates
3.1 Personalizing Word’s Templates
3.2 Automating & Sharing a Template
3.3 Create and Modify diagrams and charts using data from other sources
4.0 Section Formatting
4.1 Formatting a Section
4.2 Working with Columns
5.0 Long or Complex Documents
5.1 Bookmarks & Cross-references
5.2 Document Map
5.3 Footnotes
5.4 Table of Contents & Index
5.5 Outlines
5.6 Master Documents
6.0 Creating & Using Macros
6.1 Creating & Running Macros
6.2 Editing Macros
6.3 Automatic Macros
6.4 XML
7.0 Collaborating
7.1 Modify track changes options
7.2 Publish and edit Web documents
7.3 Manage document versions
7.4 Protect and restrict forms and documents
7.5 Attach digital signatures to documents
7.6 Customize document properties


Excel 2003: Beginner Level


1.0 The Excel Screen
1.1 Overview � Loading Microsoft Excel 2003
1.2 Screen Elements � Menu and Button Bars
1.3 Screen Elements � Workbook and Spreadsheet Properties
2 .0 Creating Data and Content
2.1 Enter and edit cell content
2.2 Navigate to specific cell content
2.3 Locate, select and insert supporting information
2.4 Insert, position and size graphics
2.5 Saving, closing and opening files
3.0 Analyzing Data
3.1 Filter lists using AutoFilter
3.2 Sort lists
3.3 Insert and modify formulas
3.4 Create, modify, and position diagrams and charts based on worksheet data
4.0 Formatting Data and Content
4.1 Apply and modify cell formats
4.2 Apply and modify cell styles
4.3 Modify row and column formats
4.4 Format worksheets using AutoFormat


Excel 2003: Intermediate Level


1.0 Collaborating
1.1 Insert, view and edit comments
2.0 Managing Worksheets
2.1 Create new workbooks from templates
2.2 Insert, delete and move cells
2.3 Create and modify hyperlinks
2.4 Organize worksheets
2.5 Preview data in other views
2.6 Customize window layout
2.7 Setup pages for printing
2.8 Print data
2.9 Organize workbooks using file folders
2.10 Save data in appropriate formats for different uses
3.0 Organizing and Analyzing Data
3.1 Use subtotals
3.2 Define and apply advanced filters
3.3 Group and outline data
3.4 Use data validation
3.5 Create and modify list ranges
3.6 Using statistical, date and time, financial, and logical functions
3.7 Add, show, close, edit, merge and summarize scenarios
3.8 Perform data analysis using automated tools
3.9 Create PivotTable and PivotChart reports
3.10 Use Lookup and Reference functions
3.11 Use Database functions
3.12 Trace formula precedents, dependents and errors
3.13 Locate invalid data and formulas
3.14 Watch and evaluate formulas
3.15 Define, modify and use named ranges
3.16 Structure workbooks using XML


Excel 2003: Advanced Level


1.0 Formatting Data and Content
1.1 Create and modify custom data formats
1.2 Use conditional formatting
1.3 Format and resize graphics
1.4 Format charts and diagrams
2.0 Collaborating
2.1 Protect cells, worksheets, and workbooks
2.2 Apply workbook security settings
2.3 Share workbooks
2.4 Merge workbooks
3.0 Managing Data and Workbooks
3.1 Import data to Excel
3.2 Export data from Excel
3.3 Publish and edit Web Worksheets and workbooks
3.4 Create and edit templates
3.5 Consolidate data
3.6 Define and modify workbook properties
4.0 Customizing Excel
4.1 Customize toolbars and menus


PowerPoint 2003: Beginner Level


1.0 Getting started
1.1 What is PowerPoint?
1.2 Starting PowerPoint
1.3 Touring the PowerPoint Window
2.0 Creating a New Presentation
2.1 New Presentation Task Pane
2.2 Creating a Blank Presentation, New Slides, and Slide Types
2.3 Saving and Closing
2.4 Opening an existing presentation
2.5 Creating a presentation using Design Templates
2.6 Creating a presentation using Auto Content Wizard
3.0 Revising Presentations
3.1 Navigating in a presentation
4.0 Getting Help
4.1 Ask a Question Box
4.2 Office Assistant
4.3 PowerPoint Help Window
5.0 Outline View
5.1 Entering Text in an Outline
5.2 Formatting Text
6.0 Inserting and Editing Text Based Content
6.1 Speaker Notes
7.0 Inserting Tables and Diagrams
7.1 Inserting Tables
7.2 Inserting Diagrams
8.0 Inserting Pictures, Shapes and WordArt
8.1 Inserting Pictures
8.2 Inserting Shapes
8.3 Inserting WordArt
9.0 Previewing a Presentation
9.1 Previewing a Presentation


PowerPoint 2003: Intermediate Level


1.0 Formatting Text Based Content
1.1 Formatting Text Based Content
2.0 Formatting Pictures, Shapes and Graphics
2.1 Clip Art, Photographs, and Animations
3.0 Formatting Slides
3.1 Color, Texture, and Templates
4.0 Applying Animation Schemes
4.1 Applying Animation Schemes
5.0 Applying Slide Transitions
5.1 Applying Slide Transitions
6.0 Working with Slide Masters
6.1 Slide Masters
7.0 Tracking, Accepting and Rejecting Changes
7.1 Tracking, Accepting and Rejecting Changes
8.0 Adding, Editing and Deleting Comments
8.1 Adding, Editing and Deleting Comments
9.0 Comparing and Merging Presentations
9.1 Comparing and Merging Presentations


PowerPoint 2003: Advanced Level


1.0 Organizing a Presentation
1.1 Setting up the slide show for delivery
1.2 Rehearsing Timings
2.0 Delivering a Presentation
2.1 Delivering a Presentation
3.0 Preparing Presentations for Remote Delivery
3.1 Preparing Presentations for Remote Delivery
4.0 Saving and Publishing Presentations
4.1 Copying to a CD
5.0 Printing Slides, Handouts and Speaker Notes
5.1 Printing Slides, Handouts and Speaker Notes
6.0 Exporting a Presentation to Another Microsoft Program
6.1 Exporting a Presentation to Another Microsoft Program


Outlook 2003: Beginner Level


1.0 What’s New for 2003
1.1 A tour of Outlook 2003
1.2 Editing the Outlook 2003 Toolbars, Task Panes and Mail Views
2.0 Introduction to MS Outlook
2.1 Creating a message
2.2 Replying to and Forwarding messages
2.3 Deleting messages and emptying the Deleted Items folder
2.4 Using Word as the message editor
3.0 Messaging
3.1 Organizing
3.2 Attaching files
3.3 Create and modify a personal signature
3.4 Modify e-mail message settings and delivery options
3.5 Create and edit contacts
3.6 Creating Personal Folders
3.7 Personal Distribution Lists
3.8 Accept, decline, and delegate tasks


Outlook 2003: Intermediate Level


1.0 Scheduling
1.1 Create and modify appointments, meetings, and events
1.2 Update, cancel, and respond to meeting requests
1.3 Customize Calendar settings
1.4 Create, modify, and assign tasks


Outlook 2003: Advanced Level


1.0 Organizing
1.1 Create and modify distribution lists
1.2 Link contacts to other items
1.3 Create and modify notes
1.4 Organize items
1.5 Search for items
1.6 Save items in different file formats
1.7 Assign items to categories
1.8 Preview and print items


Access 2003: Beginner Level


1.0 Introduction
1.1 Starting Access
1.2 The Access Window, Menu Bar, Tool Bars and Task Pane
1.3 Help in Access
1.4 Creating a Database � Fields, Properties, and Datasheet View
1.5 Copying Databases
2.0 Working with an Existing Database
2.1 Viewing & Navigating Table Data
2.2 Widening Datasheet Columns and Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting & Deleting Records
2.5 Find & Replace
2.6 Modifying the Appearance of a Datasheet
2.7 Spell-Check & Auto-correct
3.0 Form Basics
3.1 Using a Form Wizard and Moving from Record to Record
3.2 Finding Data
3.3 Sorting Data
3.4 Filtering Data
3.5 AutoForms
4.0 Report Basics
4.1 AutoReports & the Report Wizard
4.2 Zooming In & Out
4.3 Moving from Page to Page
4.4 Viewing Multiple Pages
4.5 Printing


Access 2003: Intermediate Level


1.0 Planning & Designing a Database
1.1 Evaluating Inputs & Outputs
1.2 Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch
2.0 Building & Modifying Tables
2.1 Creating Tables Using a Wizard
2.2 Creating Tables without the Use of a Wizard
2.3 Setting Primary Keys
2.4 Field Properties
2.5 Input Masks
2.6 The Lookup Wizard
2.7 Indexes
3.0 Working with Relationships
3.1 Introduction to Relationships
3.2 Types of Relationships
3.3 Referential Integrity
3.4 Indexes & Relationships
3.5 Printing Relationships


Access 2003: Advanced Level


1.0 Designing Simple Queries
1.1 Selecting Fields
1.2 Ordering the Query Result & Refining Queries with Criteria
1.3 Updatability of Query Results
1.4 Queries Based on Multiple Tables
2.0 Building & Modifying Forms
2.1 Adding Controls
2.2 Selecting Controls
2.3 Moving, Sizing, & Deleting Controls
2.4 Aligning Controls
2.5 Changing Control Properties
2.6 Changing the Tab Order Controls
2.7 Form Properties
2.8 Working with Combo Boxes & List Boxes
3.0 Building & Modifying Reports
3.1 Understanding Report Bands
3.2 Working with Controls
3.3 Creating Groups & Total Reports
3.4 Working with Report Properties
3.5 Modifying Selection Criteria
4.0 Managing Databases
4.1 Identify Object Dependencies
4.2 View Objects and Object Data in Other Views
4.3 Import Data to Access
4.4 Export data from Access
4.5 Create and Modify Calculated Fields and Aggregate Functions
4.6 Create a Data Access Page
4.7 Back up a database
4.8 Compact and repair databases

 

 



Web-based Training Courses, including 7,500+ Videos & Articles, covering:

Microsoft Office
2010 | 2007
Microsoft Windows
7 | Vista
Visio
2003 / 2007
OneNote
2003 / 2007
Project
2003 | 2007
Sharepoint
3.0
Access
2010 | 2007
Excel
2010 | 2007
Outlook
2010 | 2007
PowerPoint
2010 | 2007
Word
2010 | 2007
Office for Mac
2008
Excel for Mac
2008
Entourage for Mac
2008
PowerPoint for Mac
2008
Word for Mac
2008

Acrobat 8 Professional ADO.NET 2.0 ASP.NET 2.0 for Visual Basic 2005
C# 2005 Crystal Reports XI Exchange Server 2003
Flash 8 ActionScripting Flash 8 for Designer FrontPage 2003
Mind Manager 7 Pro + Project 2007 Mind Manager 7 Pro Fundamentals Office 2007 - What's New
Photoshop CS2 PHP Programming QuickBooks Pro 2006
SharePoint End User: Administrator SharePoint End User: Contributor SharePoint End User: Reader
Small Business Server 2003 SQL Server 2005 Visual Basic 2005
Windows Server 2003


Typing Speed Test
Test your typing speed with our certified typing speed test today.



  
HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

© 2002-2011 National Computer Science Academy, All Rights Reserved.