Software Training
 
Home
Software Training
Communications
Project Management

 

Choose from several Software Training topics, tailored for your needs:

Each workshop is packed with tons of useful tips and tricks to make you work more efficient. 
Most training is designed to be hands-on to give participants ample opportunity to
experience and practice the concepts learned in each session .

  • Microsoft Office
    No More endless searching for HELP, when you don't even know what you're looking for.  Put the power of Microsoft Office at your fingertips. Getting off the ground is sometimes the hardest part.  This is the perfect workshop for those who have never used Office before, and those who think they know the software pretty well.  Two Days of MS Office Fundamentals, Tips and Tricks.
     
  • Microsoft Word
    It shouldn’t take forever to create a newsletter, write a memo, a letter or a simple fax cover sheet. Learn editing tips and keyboard shortcuts, format bullets, borders, shading, headers and footers, Setup tabs, margins, indents and special document settings, Paste and link an Excel spreadsheet, chart or graph, Create hyperlinks, Insert clipart, graphics and WordArt, Mail merge documents, envelopes and labels, Link and retrieve data from other Office applications.
     
  • Microsoft Excel
    Keeping track of sales figures, statistics or mortgage payments has never been easier, or more difficult. Microsoft Excel gives you the power to develop formulas using built-in functions, Use charts and graphs to predict trends and understand relationships, Consolidate data from several worksheets into one, Find and organize information by filtering, sorting, and grouping, Summarize and analyze data using PivotTables, Learn data entry tips and shortcuts, Use Excel database information for Word mail merges.
     
  • Microsoft PowerPoint
    Make PowerPoint presentations that are informative, easy to read and get your message across to your audience. Learn when to give handouts and when to use notes. Discover ways to quickly change the look of your presentation to match the audience. Go from “yawn” to “yippee”. Create Presentations, Apply Designs, Charts, Graphs and Tables, Setup Slide Transitions, Print Slides, Notes and Handouts for Presentations, Add Special Finishing Touches to Your Presentations, Discover Techniques and Tips for Professional Presentations.
     
  • Microsoft Access
    Understand the Fundamentals of a Relational Database, Learn Database Design Tricks and Shortcuts, Import and Link Data from Other Data Source, Export Data and Use your Data in Other Office Applications, The Functions of the Queries, Design Forms, Sub forms, Report and Setup Macros.
     
  • Microsoft Visio
     
  • Microsoft Project
    Learn the Fundamentals of Project Management, Microsoft Project Menus, Toolbars, Shortcuts and Tips, Creating Task Relationships, Lag Time and Lead Time, Saving a Baseline and Viewing the Critical Path, Tracking, Managing and Reporting Progress of a Project, Importing and Exporting Project Information, Viewing, Printing and Customizing Reports, Printing the Project Layout.
     
  • Microsoft Outlook and Internet Explorer
    The Information Superhighway has given us fast communication and a way to organize our schedules and contacts quickly. Outlook is the way to organize your Email Inbox, Address Book, Calendar and Tasks, Learn to Create Rules and Eliminate Junk Mail, Attach Items to and Email, Setup Calendars, Schedule Appointments and Request Meetings, Manage, or Assign, Tasks.
     

     
  • Microsoft Office
    Get out of this world results with the Microsoft Office Suite
    Three Comprehensive Days of Microsoft Office 2003
    Unit 1: Getting started with Excel and Word; Spreadsheet terminology, Exploring the Excel window, Opening and navigating workbooks, Exploring the Word window, Creating and saving documents, Getting Help
    Unit 2: Entering and editing data in Excel; Creating workbooks, Entering and editing labels and values, Entering and editing formulas, Saving and updating workbooks
    Unit 3: Modifying a worksheet; Moving and copying data, Moving and copying formulas, Absolute references
    Unit 4: Using functions; Entering functions, Using AutoSum, Using AVERAGE, MIN, and MAX
    Unit 5: Formatting worksheets; Formatting text, Formatting rows and columns, Formatting numbers, Using Format Painter and AutoFormat
    Unit 6: Printing; Preparing to print, Page Setup options, Printing worksheets
    Unit 7: Creating charts; Chart basics, Modifying charts, Printing charts
    Unit 8: Editing Word documents; Opening and navigating in documents, Automated tasks, Editing text, The Undo and Redo commands
    Unit 9: Moving and copying text; Selecting text, Cutting, copying, and pasting text, Finding and replacing text
    Unit 10: Formatting characters and paragraphs; Character formatting, Using tabs
    Paragraph formatting, Advanced paragraph formatting
    Unit 11: Creating and managing tables; Creating tables, Working with tables, Modifying tables
    Unit 12: Controlling page layout; Creating headers and footers, Working with margins, and page breaks
    Unit 13: Proofing and printing documents; Checking spelling and grammar, Previewing and printing documents
    Unit 14: Getting started with PowerPoint; Exploring the PowerPoint environment, Closing presentations
    Unit 15: Building new presentations; Creating new presentations, Working in the Outline tab, Rearranging and deleting slides, Using slides from other presentations
    Unit 16: Formatting slides; Exploring text formatting, Setting tabs and alignment
    Unit 17: Working with graphics; Working with WordArt, Adding clip art and Using images
    Unit 18: Creating and modifying charts, Creating organization charts
    Unit 19: Modifying presentations; Using templates, Working with the slide master, Adding transitions and timings, Adding speaker notes and footers, Setting up slide shows
    Unit 20: Printing and delivering presentations; Running, Printing and Saving presentations for Web delivery
    Unit 21: Getting started with Outlook; E-mail basics E-mail messages, Handling messages
    Unit 22: E-mail management; Managing e-mail, Printing messages, Address books
    Unit 23: Contact management
    Unit 24: Appointments and events; Creating and sending appointments, Categorizing appointments, Modifying appointments, Working with events
    Unit 25: Meeting requests and responses; Working with, Responding to and Handling meeting responses

     
  • Microsoft Word
    Getting off the Ground with Microsoft Word Documents
    One Day of Microsoft Word Basic
    Unit 1: Getting started; Exploring Word, Creating and saving documents, Getting Help
    Unit 2: Editing documents; Automated tasks, Editing text, Undo and Redo commands
    Unit 3: Moving and copying text; Selecting text, Cutting, copying, and pasting text, Finding and replacing text
    Unit 4: Formatting characters and paragraphs; Formatting text, Using tabs, Paragraph formatting,
    Unit 5: Creating and managing tables; Creating tables, Working with tables, Modifying tables
    Unit 6: Controlling page layout; Creating headers and footers, Working with margins, Working with page breaks
    Unit 7: Proofing and printing documents; Checking spelling and grammar, Previewing and printing documents
    Unit 8: Web features; Saving documents as Web pages, Working with hyperlinks, E mailing documents

    One Day of Microsoft Word Intermediate
    Unit 1: Working with sections and columns; Creating and formatting sections, Working with multiple columns, Working with text in columns
    Unit 2: Formatting tables, Borders and shading, Table AutoFormat, Drawing tables
    Unit 3: Working with Excel data, Importing data and creating charts, Performing calculations in tables, Linking and embedding data
    Unit 4: Working with styles; Creating styles, Modifying and deleting styles, Navigating in large documents
    Unit 5: Headers and footers; Different headers and footers, Page numbering
    Unit 6: Printing labels and envelopes
    Unit 7: Working with graphics and objects; Working with graphics and clip art, Inserting WordArt and symbols, Customizing the background, Using drawing tools
    Unit 8: Document templates; Template basics, Creating templates
    Unit 9: Managing document revisions; Tracking changes in a document, Working with comments, Comparing document versions

    One Day of Microsoft Word Advanced
    Unit 1: Using Mail Merge; Creating form letters, Working with data sources, Creating mailing labels
    Unit 2: Working with forms; Creating forms, Modifying forms, Protecting and printing forms
    Unit 3: Working with large documents; Master documents, Footnotes and endnotes, Indexes, Bookmarks and cross-references, Web frames
    Unit 4: Creating macros; Recording and running macros, Modifying and deleting macros
    Unit 5: Customizing menus and toolbars; Creating custom menus, Customizing toolbars

     
  • Microsoft Excel
    Diving Into Microsoft Excel Spreadsheets and Workbooks
    One Day of Microsoft Excel 2003 Basic
    Unit 1: Getting started; Spreadsheet terminology, Exploring the Excel window, Getting help, Opening and navigating workbooks, Closing workbooks
    Unit 2: Entering and editing data; Creating workbooks, Entering and editing labels and values, Entering and editing formulas, Saving and updating workbooks
    Unit 3: Modifying a worksheet; Moving and copying data, Moving and copying formulas, Using absolute references, Inserting and deleting ranges
    Unit 4: Using functions; Entering functions, Using AutoSum, Using AVERAGE, MIN, and MAX
    Unit 5: Formatting worksheets, Formatting text, Formatting rows and columns, Number formatting, Using Format Painter and AutoFormat
    Unit 6: Printing; Preparing to print, Page Setup options, Printing worksheets
    Unit 7: Creating charts; Chart basics, Modifying charts, Printing charts
    Unit 8: Web features; Saving workbooks as Web pages, Hyperlinks, Sending workbooks via e-mail

    One Day of Microsoft Excel 2003 Intermediate
    Unit 1: Working with large worksheets; Viewing options, Hiding, displaying, and outlining data, Printing large worksheets,
    Unit 2: Using multiple worksheets and workbooks; Using multiple worksheets, Linking worksheets by using 3-D formulas, Consolidating data, Linking workbooks, Managing workbooks
    Unit 3: Customizing Excel; Using the Options dialog box, Customizing toolbars and menus
    Unit 4: Advanced formatting; Borders and shading, Using special number formats, Working with dates, Working with styles, Other advanced formatting
    Unit 5: List management; Examining lists, Sorting and filtering lists, Advanced filtering
    Unit 6: Advanced charting; Chart formatting options, Using combination charts, Using graphic elements
    Unit 7: Documenting and auditing; Auditing features, Comments and text boxes, Protection
    Workgroup collaboration
    Unit 8: Using templates; Built-in templates, Creating and managing templates

     
  • Microsoft PowerPoint
    Revving up your Microsoft PowerPoint Presentations
    One Day of Microsoft PowerPoint 2003 Basic
    Unit 1: Getting started; Menus, Toolbars, Rulers and Views, Exploring the PowerPoint environment, Getting help, Closing presentations and closing PowerPoint
    Unit 2: Building new presentations; Create new presentations, Saving presentations, Working with Outlines, Rearranging and deleting slides, Using slides from other presentations
    Unit 3: Formatting slides; Formatting and Working with text; Setting tabs and alignment
    Unit 4: Using drawing tools; Drawing objects; AutoShapes, Working with text in objects
    Unit 5: Working with graphics; Working with WordArt, Adding clip art, Using images
    Unit 6: Using tables and charts; Working with tables, Creating and modifying charts, Creating organization charts
    Unit 7: Modifying presentations; Using templates, Working with the slide master; Transitions and timings, Speaker notes and footers, Setting up slide shows
    Unit 8: Proofing and delivering presentations; Running, Printing and Saving presentations

    One Day of Microsoft PowerPoint Advanced
    Unit 1: Building custom presentations; Modifying templates, Building custom templates, Building custom slide masters, Advanced slide master techniques
    Unit 2: Using multimedia in presentations; Advanced clip art and drawing techniques, Adding movies and sound, Using animations, Using photos and scanned images
    Unit 3: Using organization charts and tables; Advanced organization chart options, Formatting and modifying tables
    Unit 4: Advanced presentation techniques; Adding special effects, Slide show options
    Unit 5: Advanced presentation delivery options; Online meetings, Working with shared workspaces, Working with the Package for CD feature, Advanced delivery techniques
    Unit 6: Customizing the environment; Customizing toolbars, Automating your work
    Unit 7: Microsoft Office integration; Working with Excel, Word and MS Project
     
  • Microsoft Access
    Get on Track with Microsoft Access Database Design

    One Day of MS Access Basics
    Unit 1: Getting started; Database concepts, Exploring the Access environment, Getting help, Closing a database and Access
    Unit 2: Tables; Planning and designing databases, Exploring tables, creating tables
    Unit 3: Fields and records; Changing the design of a table, Finding and editing records, Organizing records
    Unit 4: Data entry rules; Setting field properties, Working with input masks, Setting validation rules, Indexes
    Unit 5: Simple queries; Creating and using queries, Modifying query results and queries, Performing operations in queries
    Unit 6: Using forms; Creating forms with the Form Wizard and Design view, Finding, sorting, and filtering
    Unit 7: Working with reports; Creating reports, Modifying and printing reports

    One Day of MS Access Intermediate
    Unit 1: Relational databases; Database normalization, Relating tables, Implementing referential integrity
    Unit 2: Working with related tables; Lookup fields, Modifying Lookup fields, Subdatasheets
    Unit 3: Complex queries; Joining tables in queries, Creating calculated fields, Summarizing and grouping values
    Unit 4: Advanced form design; Adding unbound controls, Graphics, Adding calculated values, Adding combo boxes
    Unit 5: Advanced reports; Customized headers and footers, Adding calculated values, Subreports
    Unit 6: Charts; Charts in forms, Charts in reports
    Unit 7: PivotTables and PivotCharts; PivotTables, Modifying PivotTables, PivotCharts
    Unit 8: Internet integration; Hyperlink fields, Working with data access pages

    One Day of MS Access Advanced
    Unit 1: Querying with SQL; SQL and Access, Writing SQL statements, Attaching SQL queries to controls
    Unit 2: Advanced queries; Creating crosstab queries, Creating parameter queries, Using action queries
    Unit 3: Macros; Creating, running, and modifying macros, Attaching macros to the events of database objects
    Unit 4: Advanced macros; Creating macros to provide user interaction, Creating macros that require user input, Creating the AutoKeys and AutoExec macros, Creating macros for data transfer
    Unit 5: Importing, exporting, and linking objects; Importing objects, Exporting objects, Interacting with the XML documents, Linking Access objects
    Unit 6: Database management; Optimizing resources, Replicating and synchronizing databases
    Unit 7: Security fundamentals; Protecting databases, Encrypting and decrypting databases, User-level security
     
  • Microsoft Visio
    Cruise into Microsoft Visio Drawings
    One Day of Getting Started with Microsoft Visio
    Create and edit Diagrams, Charts, Floor Plans, Maps and Gantt Charts
    Create Shapes and Text Boxes
    Setup Drawings, and use Custom Solutions
    Printing Basics and Minding the Margins
    Importing and Opening Drawings from Other Applications
    Exporting Drawings to Other Applications and Integration with MS Office
    Alignment of Text, Drawings shapes and Graphs

     
  • Microsoft Project
    Making Progress with Microsoft Project
    Two Days of Project Design and MS Project Secrets
    Fundamentals of Project Management
    Menus, Toolbars, Shortcuts and Tips
    Setting up a project for the first time
    Making Use of Templates and Wizards
    Tasks, Duration Outlining the Project
    Creating Task Relationships, Lag Time and Lead Time
    Creating and Assigning Resources
    Different Views for Maximum Understanding
    Saving a Baseline and Viewing the Critical Path
    Tracking, Managing and Reporting Progress of a Project
    Importing Task and Resource Information
    Viewing, Printing and Customizing Reports
    Exporting project files and publishing to a Web Page
    Printing the Perfect Project Layout
    Managing Multiple projects and using MS Project Server

     
  • Microsoft Outlook
    Hit the Open Highway Microsoft Outlook and Internet Explorer
    One Day of Web Basics and Getting Knowledgeable About Microsoft Outlook
    Outlook Overview: Email Inbox, Address Book, Calendar and Tasks
    Create and Organize Contacts
    Send, Receive and Organize Email
    Create Rules and Organize Email into Folders
    Attach Items and Files to Email
    Setup Calendar, Schedule Appointments and Request Meetings
    Insert, Manage, Assign, Follow-up and Complete Tasks
     

Home | Software Training | Communications | Project Management

This site was last updated 03/12/09