Make your own free website on Tripod.com

Home Products Services Technical Support Profiles

References

Computers

Electronics Mechanical Network & Internet

Directory Link

  • Creating Your Own Smart Tags in Excel 2002
    Microsoft Excel provides two smart tag recognizers that allow users a convenient interface for accomplishing tasks or linking to the Web from the worksheet, but it is also possible for organizations to develop smart tags specific to their business or organizational needs.
    (Added: 5-Mar-2002 Hits: 114 Rating: 0 Votes: 0) Rate It | Recommend It
  • Dynamic named ranges
    If you have never used dynamic ranges in Excel then you will after reading about them here. If you have used them, then look here for some news ways and means. There are easy to follow step-by-step instructions. Dynamic ranges are ideal for charts and Pivot Tables.
    (Added: 21-Sep-2001 Hits: 691 Rating: 10.00 Votes: 1) Rate It | Recommend It
  • Excel 2000
    The following pages offer self-guided lessons to make it easy for you to use Excel 2000 as a classroom tool and management tool. Illustrations and steps written in plain language help you to: Gather and enter data. Format data. Work with numbers, formulas, and functions. Use proofing tools. Emphasize your point with charts. Put it all together.
    (Added: 24-May-2000 Hits: 2986 Rating: 7.86 Votes: 7) Rate It | Recommend It
  • Excel 2000 (PDF)
    Fun, fully illustrated, and easy to understand this tutorial covers every aspect of Excel 2000 and is written conform to Microsoft Office User Specialist (MOUS) level I and II exam objectives.
    (Added: 11-Jan-2001 Hits: 2748 Rating: 8.67 Votes: 3) Rate It | Recommend It
  • Excel 97 (PDF)
    Fun, fully illustrated, and easy to understand this tutorial covers every aspect of Excel 97 and is written conform to Microsoft Office User Specialist (MOUS) level I and II exam objectives.
    (Added: 8-Jan-2001 Hits: 1583 Rating: 5.00 Votes: 1) Rate It | Recommend It
  • Excel and Array Formulas
    Important information on using array formulas in your Spreadsheets. Arrays can let you specify more then one criteria to Sum, Average, Count etc by. Many examples of how to...
    (Added: 21-Sep-2001 Hits: 655 Rating: 0 Votes: 0) Rate It | Recommend It
  • Excel Chart Tips and Tricks
    There are many little known tricks that can be used with Excel charts and this is just some of them. If you want your chart to update automatically, not plot zeros, or have scrolling charts etc, then you will find it here!
    (Added: 21-Sep-2001 Hits: 658 Rating: 8.50 Votes: 2) Rate It | Recommend It
  • Excel Tutorial
    This is a basic tutorial of Excel. Specific examples may refer to Excel (but most items discussed should work in other spreadsheets).
    (Added: 19-May-2000 Hits: 1364 Rating: 8.33 Votes: 6) Rate It | Recommend It
  • Excel Tutorial
    What is Excel?, Getting Started, Creating a Simple Workbook, Writing Formulas Using Operators and Functions, Formatting The Appearance of a Workbook, Advanced Excel (Copying Cells), Linking Documents in Excel, Creating Charts
    (Added: 19-May-2000 Hits: 2005 Rating: 8.00 Votes: 5) Rate It | Recommend It
  • Excel VBA Index
    Information on VBA for Excel as well as many macros and code for Excel Spreadsheets. There are also links to Excel custom functions - User Defined Functions or UDF's
    (Added: 21-Sep-2001 Hits: 770 Rating: 10.00 Votes: 2) Rate It | Recommend It
  • Excels Custom Formats
    Excel has custom number formats that can be used on date, times, text and currency. Here I show some practical examples and there is link to Microsofts information on custom number formats that I highly recommend!
    (Added: 21-Sep-2001 Hits: 182 Rating: 0 Votes: 0) Rate It | Recommend It
  • Handy Hints for Spreadsheets
    Here you will find out how to use Excels Conditional Formatting and Data Validation. It explains in detail how you can use these great Excel features to work with duplications in your spreadsheets. Best of all it also shows how they can be used to prevent them!
    (Added: 21-Sep-2001 Hits: 242 Rating: 0 Votes: 0) Rate It | Recommend It
  • Microsoft Excel
    The Microsoft Excel tutorial of Technology SOS is divided into 4 major sections. Each of these sections covers specific features of the program and each of these sections is followed by a quiz.
    (Added: 5-Mar-2002 Hits: 163 Rating: 0 Votes: 0) Rate It | Recommend It
  • Access 2000 favorite
    What you will do: Plan and design a Microsoft Access 2000 database. Create a table using a Microsoft DAtabase Wizard. Modify the table by adding new data categories. Use a form to add data to you database table. Create and run a query. Create and print a new report. Create a Data Access Page.
    (Added: 24-May-2000 Hits: 6182 Rating: 6.91 Votes: 12) Rate It | Recommend It
  • Access 2000 (PDF) favorite
    Fun, fully illustrated, and easy to understand this tutorial covers every aspect of Access 2000 and is written conform to Microsoft Office User Specialist (MOUS) level I and II exam objectives.
    (Added: 11-Jan-2001 Hits: 5508 Rating: 7.40 Votes: 5) Rate It | Recommend It
  • Access 97 (PDF)
    Fun, fully illustrated, and easy to understand this tutorial covers every aspect of Access 97 and is written conform to Microsoft Office User Specialist (MOUS) level I and II exam objectives.
    (Added: 8-Jan-2001 Hits: 2764 Rating: 8.00 Votes: 6) Rate It | Recommend It
  • Creating Data Access Pages
    Data Access Pages provide Microsoft Access 2000 users with a powerful tool for viewing and manipulating database information through the web. This step-by-step tutorial walks you through the creation of a data access page.
    (Added: 12-Feb-2001 Hits: 1408 Rating: 0 Votes: 0) Rate It | Recommend It
  • Creating Queries in Microsoft Access
    Microsoft Access offers a powerful query function that allows you to extract information from your database. In this tutorial you are walked through the creation of a simple query.
    (Added: 11-Dec-2000 Hits: 1330 Rating: 10.00 Votes: 1) Rate It | Recommend It
  • Creating Reports in Microsoft Access
    Would you like to create professional-looking reports from your Microsoft Access database with the click of a mouse? Follow along as we walk through the simple process of designing a reusable report.
    (Added: 24-Dec-2000 Hits: 1075 Rating: 9.75 Votes: 4) Rate It | Recommend It
  • Microsoft Access
    Open an existing database, Create new databases, Create new tables, Work in the table design view, Set field properties, Set table and index properties, Modify a table, Work in datasheet view, Enter and edit data, Manipulate data, Import and export data, Change the datasheet layout, Create forms, Modify a form's design, Create a new query, Explore the query window, Design a query, Create a new report, Modify a report, Create a macro, Program command buttons
    (Added: 31-May-2000 Hits: 2073 Rating: 5.67 Votes: 3) Rate It | Recommend It
  • Microsoft Access
    This tutorial is based on an example that will be similar but not identical to the project that you have been assigned. The example will cover almost all the basics skills you will need to do your project: creating tables, importing data, creating forms, making queries, and using a bit of Access Basic to process the data.
    (Added: 22-May-2000 Hits: 1423 Rating: 1.00 Votes: 2) Rate It | Recommend It
  • Microsoft Access '97 Tutorial
    This tutorial is designed to get the user up and running with MS Access '97 (henceforth simply "Access") in a rapid fashion. The four basic modules of Access are demonstrated: Tables, Forms, Reports and Queries. A business example is discussed first which provides a background for developing a simple database.
    (Added: 19-May-2000 Hits: 1193 Rating: 7.33 Votes: 3) Rate It | Recommend It
  • Microsoft Access 97
    The best way to get to know how to use Access is to implement a test database and to create queries, forms, reports etc.
    (Added: 19-May-2000 Hits: 806 Rating: 0 Votes: 0) Rate It | Recommend It
  • Microsoft Access for Windows 95 Whitepaper(PDF)
    This document provides a brief introduction to the most important concepts of the database world. It begins with a working definition of a database, moves to a short history of database management systems and ends with a glossary of database terminology.
    (Added: 22-May-2000 Hits: 446 Rating: 6.00 Votes: 1) Rate It | Recommend It
  • Modifying Queries in Microsoft Access
    Learn how to apply advanced techniques to refine your database queries. This tutorial provides an introduction to adding and removing fields, adding query criteria and sorting your results.
    (Added: 11-Dec-2000 Hits: 423 Rating: 0 Votes: 0) Rate It | Recommend It
  • Mail Merge
    The easiest way to create a data source in Word is to use the Mail Merge command to start a main document. After you've created the data source, you can delete the blank main document.
    (Added: 19-May-2000 Hits: 774 Rating: 10.00 Votes: 3) Rate It | Recommend It
  • Word 2000
    A practical guide for educators to create and manage written materials, publications, data bases, spreadsheets, and Web pages for use with your students or on your own. When you need to create a test, make a research presentation, help students collect data, or schedule resources, Office 2000 gives you the tools.
    (Added: 24-May-2000 Hits: 1198 Rating: 10.00 Votes: 2) Rate It | Recommend It
  • Word 2000 (PDF)
    Fun, fully illustrated, and easy to understand this tutorial covers every aspect of Word 2000 and is written conform to Microsoft Office User Specialist (MOUS) level I and II exam objectives.
    (Added: 11-Jan-2001 Hits: 1253 Rating: 9.67 Votes: 3) Rate It | Recommend It
  • Word 97 (PDF)
    Fun, fully illustrated, and easy to understand this tutorial covers every aspect of Word 97 and is written conform to Microsoft Office User Specialist (MOUS) level I and II exam objectives.
    (Added: 11-Jan-2001 Hits: 630 Rating: 5.50 Votes: 2) Rate It | Recommend It
  • PowerPoint 2000
    Create a new presentation. Create and edit slides. Print presentation, including slides and handouts. Save a presentation for use on the Web.
    (Added: 24-May-2000 Hits: 1811 Rating: 9.33 Votes: 3) Rate It | Recommend It
  • PowerPoint 2000 (PDF)
    Fun, fully-illustrated, and easy to understand this tutorial covers every aspect of PowerPoint 2000 and is written conform to Microsoft Office User Specialist (MOUS) level I and II exam objectives.
    (Added: 8-Jan-2001 Hits: 1462 Rating: 8.33 Votes: 3) Rate It | Recommend It
  • PowerPoint 2000 (PDF)
    Fun, fully illustrated, and easy to understand this tutorial covers every aspect of PowerPoint 97and is written conform to Microsoft Office User Specialist (MOUS) level I and II exam objectives.
    (Added: 11-Jan-2001 Hits: 787 Rating: 0 Votes: 0) Rate It | Recommend It
  • PowerPoint Guide
    This guide offers PowerPoint beginners an easy and helpful guide for learning the fundamentals of PowerPoint so that you too can create your own WOW presentations. It also serves as a ready reference tool of reminders for the multitude of basic functions and procedures as you explore the vast capabilities of PowerPoint. You will find that PowerPoint has nearly unlimited multi-media capabilities and the only limitations are you and your computer.
    (Added: 19-May-2000 Hits: 1433 Rating: 7.50 Votes: 4) Rate It | Recommend It
  • PowerPoint Tutorial
    Microsoft POWERPOINT is a sophisticated presentation program that you can use to create electronic slide shows, traditional 35-mm slide shows, overheads, paper handouts, speaker notes or a combination of these.
    (Added: 19-May-2000 Hits: 1193 Rating: 6.00 Votes: 1) Rate It | Recommend It
  • Publisher 2000
    What you will do: Create a newsletter using a wizard. Use the Clip Gallery to enhance the newsletter layout. Insert a text file into existing frames. Review and edit existing text, including checking your spelling. Add a "drop cap" to a story to add visual interest. Add or delete extra pages. Convert your newsletter to a Web page.
    (Added: 24-May-2000 Hits: 1011 Rating: 7.00 Votes: 2) Rate It | Recommend It