 |
| Microsoft Excel |
|
Beginner Day 1
Entering, Copying, Data, Moving Data, Undo, Saving Workbooks,
Previewing Print Jobs, Rows and Columns, Column Widths and Row
Heights, Numeric Formats, Alignment of Data, Conditional Formatting,
Previewing Print, Using Page Break, Page Setup Options, Headers
and Footers, Printing Worksheets |
|
Beginner Day 2
Creating, Editing Formulas, Using Relative, Absolute, and Mixed
Cell References, Using Functions and AutoSum, Using AutoCalculate,
Moving Between Multiple Worksheets, Inserting, Deleting, Moving,
Renaming and Copying Worksheets, Grouping Worksheets, Creating
3-Dimensional Formulas, Enhancing Text, Changing Text and Font
Attributes, Adding and Modifying Borders, Creating and Modifying
3-Dimensional Objects, Creating and using Styles, AutoFormats,
Creating, Formatting, and Modifying Charts |
|
Advanced Day 1
Naming Cells and Formulas, Listing Names and References, Named
Ranges, Advanced Functions (NOW, DATE, VLOOKUP, IF, PMT, FV),
Advanced and Custom Number Formats, Applying and Creating Outlines,
Collapsing, Expanding and Removing Outlines, Finding and Replacing
Data and Text |
|
Advanced Day 2
Formatting Zero Values, Print Options to Print Multiple Worksheets,
Using Comments, Using Worksheet, Range and Password Protection,
Hiding, Multiple Workbooks, Freezing Worksheet Panes, Customizing
Toolbars, Importing Text Files, Exporting Data to Other Applications,
Linking Workbooks, Creating Templates, Working with Macros,
Recording, Executing, and Editing Macros, Creating Custom Lists |
|
| Microsoft PowerPoint |
|
Beginner
Creating Presentations, Adding and Modifying Slides, Editing
text, Modifying Bullets, Font Attributes and Alignment, Printing
Slide Shows, Proofing tools, Working with Drawing Objects, Inserting
AutoShapes and Arranging Objects |
|
Advanced Day 1
Using WordArt and Clip Art, Re coloring Clip Art, Expanding
slides, Summary Slides, Transition Effects, Hiding slides, Controlling
slide shows, Annotating slide shows, Outline view, Creating
and customizing charts, Creating Tables, Organization Charts,
working with color schemes and templates |
|
Advanced Day 2
Working with Color Schemes and Templates, Create Custom Templates,
Animating Text and Objects, Linking Slides, Preparing Presentations,
Save Presentations in Other Formats |
|
| Crystal Reports |
|
Beginner Day 1
Creating Simple Reports, Using Crystal wizards, Entering, editing and moving text and database fields, Layout options, Field attributes, Editing i, preview mode, Using guidelines, Selecting records, Selection rules, Using multiple fields, Date ranges, Using the OR connector, Using wildcards |
|
BeginnerDay 2
Totals and Counts, Creating grand total sums, counts and averages, Creating subtotals, Formatting numeric fields, Distinct counts, averages, Editing a text object, Using the highlighting expert, Creating Page Breaks, Creating A Summary Report, Sorting and Grouping, Creating sections, Formatting sections, Changing the sort order, Creating groups, Using group names, Exporting data to a spreadsheet, Creating a report from a spreadsheet |
|
| |
|
|
| Excel Filters, Subtotal ,Pivot Table |
|
Day 1
Data Table set-up, Autofilter,Advanced Filter, Advanced Sorting, Automatic Subtotaling, Multiple Summary Functions,Hide and Display Details
|
|
Day 2
Review Subtotaling, Pivot Tables vs. Excel Database Functions, Creating Pivot Tables, Pivot Charts, Scenarios |
|
| Microsoft Word |
|
Beginner Day 1
Using Toolbars, Menus, Opening/Viewing/Creating/ Saving Documents,
Previewing and Printing Documents, Finding Documents, Navigating
Through Documents, Editing Text, Using Repeat, Undo, Redo, Selecting
Text, Moving , Copying Text, AutoText and AutoComplete, AutoCorrect
|
|
Beginner Day 2
Formatting Toolbar, AutoFormat As You Type, Format Painter,
Margins and Hyphenation, Changing Line and Paragraph Spacing,
Character Spacing, Setting Tabs, Indenting, Nonprinting Characters,
Text Flow, Aligning Text, Page Orientation, Finding and Replacing
Text and Word Forms, Go To Feature, Checking Spelling and Grammar,
Thesaurus. |
|
Advanced Day 1
Using, Creating and Deleting Templates, Creating Letters, Envelopes,
and Mailing Labels, Applying, Defining, Modifying, and Deleting
Styles, Creating and Using Outlines, Formatting/ Editing Documents
in Outline View |
|
Advanced Day 2
Headers and Footers, Page Numbering, Creating Tables, Entering
into Table, Calculations on Table, Column Widths and Row Heights,
Formatting Table,, Inserting and Formatting Sections as Multiple
Columns, Lines and Objects, Pictures and Clip Art, WordArt,
Watermarks, Borders and Shading |
|
| Windows 2000 / XP |
|
Beginner Day 1
Logging On ,Viewing Windows Desktop, Identifying Windows Objects,
Using the Start Menu, Opening and Closing Windows ,Using Window
Buttons , Working with the Taskbar Using the Quick Launch Bar
, Logging Off and Shutting Down, Working with the Desktop and
Windows , Working with Folders and Files, Using the Help, Shortcuts
and Compressed Folders, Customizing Windows, Using Windows Accessories
,Internet Explorer, Web Integration Features |
|
Beginner Day 2
Outlook Express , Adding Attachments to Messages, Organizing
Messages, Avoiding Viruses, Changing File Attributes, Changing
Recycle Bin Properties, Registered File Types, Starting Programs
Automatically , the Run Command, the Send To Menu, the Command
Prompt , Windows Task Manager , User Accounts,Using Passwords
,Switching Users, Sharing Files and Folders, Backing Up and
Restoring Data,Desktop Cleanup ,Disk Cleanup,Disk Defragmenter,
System Information , Troubleshooters,Checking for Disk Errors,
Scheduling Tasks, Synchronization Manager,Windows Update, Using
Remote Features, System Restore |
|
| Custom Build a Website |
|
10 week course
Includes domain name (yourcompany.com) and 1 year of webhosting with email.
When you complete this course, your custom website will be live on the web! Programs you will use include Adobe PhotoShop, Adobe ImageReady, Macromedia Dreamweaver, HTML coding, FTP software. |
| |
|
|
| Microsoft Access |
|
Beginner Day 1
Database Components, Relational Data Tables, Creating Databases,
Creating Tables, Table Design Window, Field Names and Data Types,
Assigning a Primary Key, Table Wizard, Modifying Datasheet Layout,
Adding, Editing, Deleting and Sorting Records, Modifying Table
Design, Field Properties, Limiting Field Size, Setting Field
Formats |
|
Beginner Day 2
Finding Records, Comparison Operators, Filters, Creating and
Modifying Queries, Criteria, AutoForm , Form Wizard and Design
View, Control and Form Properties, Adding Records, Printing
Forms, AutoReport and Design View for Reports, Sections, Control/Report
Properties, Printing Reports, AutoFormat, Formatting Reports,
Adding Graphics, Lines and Rectangles |
|
Advanced Day 1
Table Relationships, Enforcing Referential Integrity, Printing
Relationships, Lookup Wizard, Modifying Lookup Fields, Adding
Data to Related Tables, Subdatasheets, Creating Subforms, Displaying
and Adding Information with Subforms, Field Properties, Input
Masks, Setting Required Properties, Using Validation Rules |
|
Advanced Day 2
Adding Pictures to Records, Calculated Controls, Improving Accuracy
in Forms, Using the Report Wizard, Customizing Headers and Footers,
Concatenating Text Fields, Adding Calculated Value, Forcing
Pagination, Subreports, Joining Tables in a Query, Calculations
in a Query, Displaying Special Records, Crosstab Queries, Parameter
Queries, Action Queries, Using Indexes, Creating and Customizing
Charts |
|
| Microsoft Publisher |
|
Beginner
Publisher Wizards, Creating, Saving and Printing a Letterhead,
Flyer, Creating a Newsletter, Design Gallery, Working with Shapes,
Custom Shapes, Setting Up/Formatting a Table, Creating a Web
Site, Creating and Applying a Style, Finding and Replacing Text,
Customizing Publisher |
|
| Internet Basics |
|
Beginner
Internet Protocols, Domain Name System, Intranets And Extranets
Web Browsers, Home Page, History Folder, Favorites ,E-Mail,
E-mail Address Format, Attachments, Mailing Lists, Newsgroups,
File Transfer Protocol (FTP), Telnet, Search Engines,Searching
for Graphics, Adding a Web Site to a Search Engine, Advanced
Searches, Configure Internet Explorer For Multimedia, Such As
Realplayer, Shockwave And Flash Content,Basics Of Electronic
Commerce ,Security Issues,Cookies, Viruses, Firewalls |
|
| Word Using Forms and Mail Merge |
|
1 Day Class
Design and format a word form. Enter form data,Calculate field results. Insert merge fields, Use external data sources,Filter a data source, and Mail Merge to create letters,envelopes, and Labels |
|
| MSOffice Basic Training Series |
|
7 week course
An Introduction to the Microsoft Office Applications Series.
Class 1- Introduction to Windows and Internet
Class 2- Introduction to Outlook Email, Contacts and Calendar
Class 3- Word Beginner 1
Class 4- Word Beginner 2
Class 5- Powerpoint Beginner 1
Class 6- Excel Beginner 1
Class 7- Excel Beginner 2 |
|