Link To AVC Home Page         Business & Computers - RESOURCES

  Hot Links to sections of this page  -      RESOURCES   (last revised 10/29/2008 - corrected some failed links)

Business and Accounting Resources
   -  Glossaries SoftwareBusiness PlansFinancial Calculators Government
General Business/Accounting Info    --  Accounting / Finance / Business Careers  
 -  ECommerce -  
Free Business-Related Tutorials & Courses
Stock Market info and tutorial sites


    - Software Specific   -    Hardware & Ergonomics Specific
    -  Networking & Telecommunications
    - Free General Computer and Software and How-To Tutorials

    - Computer Ethics    -    Computer Security & Privacy


General Excel Resources      -      Free Excel-Specific Tutorials  
    - Functions & Formulas   -   
NEW !   Math Order of Operations
Specialized Tools   -       Linear Regressions with Excel
   Charts -


GENERAL INFO SITES   (Check out ASSIST.ORG for transfer courses)
 -  Other Sites




SEARCH & WEB INFO SITES  including list of Other Browsers




Do you want to use your home computer for this course?
VERY GOOD DEALS on MS Windows XP (FREE fully licensed version)
and MS Office 2003 Professional  (fully licensed version about $83 total incl tax & s/h)
 - - link to the Systems Requirements page
 - - - - - (it's located in the CLASSROOM area - Course Info & Instructions page)

The following list contains some excellent links to resources which will support you in your business career.

Please send an email to me if you discover additional relevant sites. I'll add them to this list if they check out. Also, please let me know if any of the links have died. That happens frequently online, especially with dynamic topics such as this.

These links to external resources will open a new browser window. When you've finished with the external site, CLOSE the new browser, and you will return to this page in your virtual classroom

This page contains useful links to resources to support your continuing business career.

Save this page (HOW TO SAVE WEB INFO below), and refer to it when a question comes up about "How do you do............??? some task???" or "Where did I see that great tip or solution?"

Referenced sites include info about software, small business assistance, mail lists, tutorials, tips, FAQs, specific step-by-step solutions, info about new versions/releases, and much much more. Some are links to publications with some online info and back issues plus information about subscriptions. Some provide info about support via news/discussion groups and list servs. Some provide info about additional software designed to enhance your productivity or with special capabilities for specific functionality.

Many of the sites have been provided by students in my classes. Please share with the class, or send a message to me additional relevant sites to add to this list. Also, please let me know if any of the links have died. That happens frequently online, especially with dynamic topics such as these.

Note: The following links open a NEW browser window, so you may easily return to this page by CLOSING the new browser window when you're through. If the resource is one that you think you might want to use in the future, be sure to ADD it to BOOKMARKs (Netscape Navigator) or to FAVORITES (MS Internet Explorer).


GLOSSARIES - Accounting and Financial Terms

is the most comprehensive Financial Glossary you'll find anywhere, online or off, with over 6,000 definitions and 20,000 links between related terms -


    Venture Line Corp  -    




Peachtree site with a newsletter that was interesting and helpful.  -
Peachtree Knowledge Center
- useful hints for getting started with your new software, "how-to" tips, frequently asked questions, and more - free registration


QuickBooks (Intuit) site  -
       View QuickBooks Videos -- provides information and links to publishers of all sorts of computerized accounting software, including many specialty categories:




Little Business for Geeks (actually it's for everyone who's serious about: starting a business - lots of excellent links - pay special attention to the Business Plan links - that's a very important component of starting any business - PLANNING!!


SBA Business Plans Basics - 


Business Plan Software, Samples, and Strategy - demos, downloads -


American Express - Small Business Plan Resources - 




FinAid - The Smart Student Guide to Financial Aid - financial aid calculators -   (not "business" but very important business!)


Business Planning Experts - breakeven, starting costs, cash flow, credit cards, investment, etc  - - small business, investing, managing your money, financing, etc  - -  financing, saving, investing, managing money, etc.  -


USA Today -  financing, saving, investing, managing money, etc.  - - 


Altamira Financial Services Ltd is a financial and investment website with great into & links & useful investment downloads   -  Click Education and Calculators Home Finance
  with all sorts of calculators -


ANZ - Benchmark your business - many calculators - 


GOVERNMENT (and Govt Related) SITES


General Accounting Office - one purpose is to make funding decisions related to Federal Gov't with actual audits and cases to determine what's legal and what's not. -


Small Business and Self-Employed One-Stop Resource - Starting a Business, Employer ID, Tax Aspects of hiring employees, independent contractors, scams, and more at


Small Business Administration - 

SBA Online Women's Business Center: Bookkeeping and Accounting - -- a text-based online accounting course training course on bookkeeping and accounting for a small business, covering such topics as keeping good records, financial statements, cash vs. accrual accounting, balance sheet accounts, basic types of business records, basics of budgeting, estimating profits and much more


Minimum Wage Laws by State - 


Internal Revenue Service -


Internal Revenue Bulletins  - All kinds of Tax Info, Downloadable IR Bulletins,..  -


Employee or Contractor? "The Definition Is Changing-- Again!"


TechProse summary of employee/contractor issue:


IRS on Small Business - -


Securities and Exchange Commission -


Tax and Accounting Directory with many links on it -


Directory of tax and accounting sites for information -


Payroll Tax info site that contains addresses, phone numbers, form numbers, and filing dates for federal and state taxing authorities.   -

GENERAL BUSINESS/ACCOUNTING INFO SITES  -- critical tools, services and information to help you start, manage and grow your business  -


Venture Line Corp -- offers info and services and links for accounting for businesses


Big Eye - list of Financial Megasites and Directories --


Fortune 500 Magazine - Includes Fortune 500 Small Business Magazine Archives Boards & Chat, plus Free Trial Issues Subscriptions, and free articles - --- current business news - 


Toolkit Site explains why we do things and ways to do them is with several links that go through state and federal taxes as well as payroll.  -- News, information, products and value-added services for CPAs and the organizations they serve -


Dun & Bradstreet - The Dun & Bradstreet Web site allows you to run a report on a certain company or register and update your own company with D&B. You can obtain business and financial information on vendors and customers as well as finding information on a registered company. -


Public Register's Annual Report Service - The Public Register's Annual Report Service Web site allows the user to obtain free annual reports for public corporations in order to obtain information about a company's financial performance. -


SmartPros LTD   - various categories -


WebCPA - - publications and latest news relating to accounting.


FASB (Financial Accounting Standards Board) - Summary and status of all FASB statements, exposure drafts, documents...


Edgar online  - Corporation filings with SEC...  -


Recent Tax Development  - Proposed regulations, court rulings...  -


Rutgers Accounting Web  -  Lots of accounting info and links...  -


Environmental Accounting and Auditing Issues - Dr. L. Murphy Smith, Professor:


Kaplan's AuditNet Resource List Online  - An exhaustive list of resource for auditors and accountants  -


Accounting for Non-Accountants' BLOG - good info - here's a discussion on Finding and Correcting Accounting Errors - up-to-date happenings related to Fixed Assets accounting. Even includes a Depreciation Calculator:


Accounting / Finance / Business Careers


American Institute of Certified Public Accountants -  The American Institute of Certified Public Accountants (AICPA) Web site provides a multitude of information from continuing education for accountants and updated news of the industry to providing services to students interested in becoming accountants.


AAA (American Accounting Association)   - Very useful info including summary and status of all FASB statements, exposure drafts, documents...  -


Accounting: A Career Without Limits -  -- A complete overview of the accounting profession from the American Institute of Certified Public Accountants designed for those who are considering it as a career, covering how to become an accountant and/or CPA, the wide array of job types and how to get a job, top accounting technologies and much more  


CPAnet - The CPAnet Web site provides numerous links that allow you to gain access to online forums and online publications, the Web sites of the big accounting firms, state accounting societies' Web sites, as well as other useful information and resources. - 


California Board of Accountancy -


Practitioners Publishing Company    for accounting professionals.   Subscribers receive many services, training, support, etc.  Check out the Online Demos and also the Most Popular Products links. 


Association of Certified Fraud Examiners - The Association of Certified Fraud Examiners Web site offers the latest news about fraud, a free newsletter, and links to seminars and events to help educate businesses about how to combat fraud. 


American Management Organization - The American Management Organization Web site offers information about seminars, courses, on-line classes, and resources regarding career development, career guidance, and career skills. -


IMA (Institute of Management Accountants) - IMA publications, membership info...  -


Accounting, Finance and Banking Career Center Network (one of many such sites, but a very good one) -


ANet (Part of International Accounting Network) - Info on various accounting related mailing lists - 




REVISED URL   Federal Trade Commission for the Consumer - ECommerce - use the SEARCH tool in top right corner, key words e-commerce e-business, to get links about Federal Trade Commission's Business Consumer Protection service's current problems and issues.  


The ECommerce Guidebook - has extensive articles about ECommerce - 


Webopedia - Top 20 ECommerce terms - - B2B ECommerce news -


Other current, relevant ECommerce online publications:


REVISED URL   E-Commerce-  for a listing of various E-Business topics and resources.


 How E-Commerce Works – from - 


 REVISED URL  Web Store Features - online business solutions options for technologies such as shopping carts - what's available - prices, etc..


Can prospective customers “Froogle” your website? -   


Solutions from VeriSign to make Internet and telecommunications networks more intelligent, reliable, and secure –   


The Different Ecommerce Habits Of Men And Women  -  


Women Business Owners and Ecommerce -  “ . . . what is the best way for women to capture the potential of this huge market? Probably one of the best ways is to leverage the power of the net to enter into an online marketplace . . “  


Online Minority Business Owners Organization website with lots of useful info – especially points out the power of putting business online –   

                see others at

Accounting Tutorial -  -  an introductory text-based tutorial on the basics of bookkeeping and accounting, complete with integrated self-examination questions, and covering the accounting cycle, adjusting entries, bad debts, debits and credits, end of period adjusting entries, financial statements, general journal entries, asset account names, liability account names, owner's equity account names, petty cash, reconciling a bank statement, understanding debits and credits and more


Accounting Concepts Tutorial -  -  brief, text-based tutorials with quizzes on key accounting concepts, including the accounting equation, debits and credits and more  

Bean Counter Accounting -  -  sequential online bookkeeping lessons, covering bookkeeping language and terminology and definitions, bookkeeping systems, debits and credits, double entry bookkeeping, financial statements, how business transactions are properly analyzed, recorded and summarized, property & property rights, the accounting equation, the cash and accrual basis of accounting, the general ledger and journals, types of business activities, types of business organizations and more  


Intro to Accounting - Simple -  -  a complete online accounting course for beginners with sample problems and their solutions, covering what accounting is and its role, accrual accounting, costs vs. expenses, credit purchases, debit and credit, deferrals, depreciation methods, double-entry accounting system, financial statements preparation, general journal records, historical cost of assets, intangible assets and amortization, inventory cost flows methods (FIFO, LIFO, etc.), perpetual and periodic inventory methods, product vs. selling and administrative costs, revenue and expenses, service vs. merchandising companies, single- and multistep income statements, tangible vs. intangible assets, the elements of financial reporting and more


Payroll Basics - -  Payroll 101 is a text-based tutorial designed to help familiarize visitors with the basic concepts of payroll management and introduce options to facilitate the process, with an emphasis on using Intuit / QuickBooks products    Also includes Tax Info, FAQs Troubleshooting for common payroll problems, and New Hire Setup


Accounting and Excel Tutorial - accounting uses for Excel. Build an A/R system. Learn about forecasting techniques, comparative ratio analysis, ROI analysis, and more. Also, fee for service online Excel project assistance.


FREE Accounting resources that may help as refreshers, or be an online reference if you don't have your accounting manual or installed Accounting Primer handy  -


Interactive Accounting, Business, Computer terminology and concepts exercises - - free tutorials - this one is on Fixed Assets & Depreciation: 


Accounting for Non-Accountants' BLOG - good info - here's a page on Finding and Correcting Accounting Errors 




AVC Online Learning (OLL) Resource Center for novice, intermediate and power users

Welcome to Triumph of the Nerds! -

Intro to Computers - A Beginners Guide - 

PC Magazine  -  how to articles, new technologies, comparisons of software and hardware

PC World Magazine  - how to articles, new technologies, comparisons of software and hardware

How Stuff Works - about ...anything!  Recently getting more commercial, but that's how these resources can remain free for our use ...... -

PC Guide - you need to register - free - but the info is terrific! -

ZDNet: Hardware reviews - 

< Go to TOP >


HowStuffWorks - Software Channel -

NEW ! REVISED site info:     Solve IT! for Office - 
       no longer free but you can view a demo and use a trial version 

REVISED site info:     ZDNet: Software reviews - - Windows XP home page - - Office 2003 home page -

MS Office 2003 - Help / Support Center -

Woody's Watch website is a very useful FREE service of e-zines (electronic magazines) for beginners and pros with terrific info about Microsoft Windows OS and Office apps., providing "Advice, tips and news from author, guru, curmudgeon, and Microsoft software victim, Woody Leonhard, and friends" -- - - -


Everything about Computers - Free Help - How To's - General Info -

HowStuffWorks - Hardware Channel  -

How RAM Works - 

Your Basic Hardware Page -  How To's - 

What is Hardware - select from Hardware Device Listing 

Beginning Computer Hardware Guide - old (2000) but generally useful info  -- 

Take Good Care of Your Computer Software, Data, & Hardware:



Ergonomics - important for comfort and health - much more than just Carpal Tunnel Syndrome -

OSHA Ergonomics Employee Health -

Office Ergonomics Training - 

Ergonomics at Work - -

National Institute for Occupational Safety and Health - 

The Carpal Tunnel Syndrome Information Home Page- Ergonomics and Musculoskeletal Disorders -   -

< Go to TOP >


Networking:  How Ethernet Works -

Networking:  Wireless Networking - Several very useful articles/sites - 

Networking:  How Home Networking Works

Networking:  How hard is it to set up a network between two computers in my home? 

Home Network Security -


Networking/Telecommunications:  How Ubiquitous Networking Will Work 

Telecommunications:  How Internet Infrastructure Works 

Telecommunications:  How Carnivore Worked  (FBI)

Telecommunications:  Why was 911 chosen as the emergency phone number? 

Telecommunications:  International Telecommunication Union 

Telecommunications:  How Location Tracking Will Work

Telecommunications / Telephony:  How VoIP Works 


Microsoft TRAINING home page: 

NEW !  Microsoft AUDIO courses  about  all things Microsoft! 

PC Computer Notes & Hardware Tutorials  -  Start with "My Computer" Tutorials

Computer Training Tutorials - Tutorials about everything related to computer hardware - some with interactive learning activities - 

REVISED site info:   Tech Tutorials: Free tutorials about computer technologies -   

Intro to MS Windows Tutorial - ver 2000 but much of it applicable to later versions - 

Intro to Computers - A Beginners Guide - 

Microsoft in Education - Educator's Guide  -- Resources, including in-depth step-by-step tutorial guides for students, teachers, and staff on basics of MS Office, Excel & others - - provides very good  FREE tutorials/courses for MS Windows, Office, and lots of other software. 

Education Online for Computers - -   this site offers "Free Access To Over 500 Standard Courses  and Free Newsletter Subscription - as our thank you, we give you access to a ton of free templates and forms to use with your Office software!".  Here's a page of links to various services that provide free online tutorials/courses.

Useful Tips - Computer / Windows / Excel / Word by Karen Ellis  - has specific lessons/tutorials for various Word tasks, such as text alignment, special effects, inserting a symbol, etc.  click Computers link, Search "tutorial office" key words

Karyn's Toolkit - provides free MS Office tutorials, focusing on specific skills, such as Word shortcuts, using Clipart, using Autocorrect, etc. 

NEW !! -   Word and other MS Office and miscellaneous tutorials - basics and a "Beyond the Basics" section

Interactive Keyboard Graphic - What do those keys do? 

Learn2Type - Typing Test & FREE Typing lessons   - 

The Personal Computer and Its Construction - select SITE  MAP link for listing of tutorials -

With a bit of knowledge, you can do even more with computer systems:

Build your own computer -- --  

Building the Perfect PC -- --  

Installing a battery -- -- 

PC Show and Tell - Online Software How-To Tutorials - register for 24-hr free trial - 1 user ($30) -


REVISED site info:    The Brookings Institution - Computer Ethics Institute - includes NETIQUETTE - Ten Commandments


Centre for Applied Ethics - Global issues  - covers ethics in many areas, not just business and computers -


Ethics in Computing  - Risks, Social Justice, Privacy, Commerce, etc - provides useful lessons and resources about Basics of Ethics in Computing, Risks, Computer Abuse, Social Justice, Intellectual Property Rights, Speech Issues, Commerce, Privacy, etc. 


Think Quest - Computer Ethics -


Computer Ethics Institute:  Intellectual Property Rights -


Ethics on the World Wide Web site provides links to resources dealing with ethics in many areas, not just business and computers:  - CSU Fullerton -


Centre for Computing and Social Responsibility  
Its mission is to undertake research and provide teaching, consultancy and advice to individuals, communities, organisations and governments at local, national and international levels on the actual and potential impacts of computing and related technologies on society and its citizens.

Privacy: Can your PC be subpoenaed?  By Michael McCarthy The Wall Street Journal Online May 23, 2000 


An On-line Interactive Course in Internet Ethics


Computer Ethics, Laws, Privacy Issues -  © Virginia Montecino

CA221 - ENCORE CD - provided with Computers Understanding Technology - Second Edition -
View and hear the Tech Demo videos for Chapter 14 - Computer Ethics

  • 14-1 Ethical Choices

  • 14-2 Personal Privacy

  • 14-3 Free Speech

  • 14-4 Digital Divide

COMPUTER - SECURITY - PRIVACY  - National Cyber Security Alliance  - 


Microsoft Security at Home page  - protect computer, yourself, and your family - 



Home Computer Security -


IEEE Computer Society Technical Committee on Security and Privacy


Computer Security Institute -


Home Computer Security - - free assistance -


CERIAS Hotlist: Computer Security, Law and Privacy, Education, Organizations, Solutions


Yahoo! Directory - Security & Encryption - links


Computer Systems Security & Privacy Advisory Board/CSSPAB Home Page - established by the

Computer Systems Security Act of 1987 


Ethics in Computing  - Privacy & Risks & Abuse  &  &


A Guide to Your Child's Safety on the Internet - 


Home Network Security -


Desktop Security Resources -







    NEW !    Ten Commandments of PC Security --  by Paul Gil - Unearthed in a garage near Cupertino, California, experts have found special tablets. With decrees on how to deliver us from computer evils and save us from computer viruses and hackers, these Ten Commandments are good news for everyone. 
    Read and follow the commandments.  And honor thy firewall! 


    NEW !    CyberAngels - volunteer organization, originally a group of parents whose children had been victimized.  Homefront site is their training courses for parents, children, etc.  


    NEW ! - reviews various software, including: 

    < Go to TOP >


    General Excel Resources

    Microsoft Excel Home Page -- info, support, updates, solutions, examples, templates,...See links in section at bottom - Tools to Help You Work Smarter in Excel

    Microsoft in Education - Educator's Guide
    Resources, including in-depth step-by-step tutorial guides for students, teachers, and staff on basics of MS Office, Excel & others

    MS EXCEL2003 - Help / Support Center -

    Comprehensive Spreadsheet Resource - Excel -
    Comprehensive is an understatement! - San Diego's JWalk & Associates, Inc. provides one of the best sites on the WWW covering all facets of all major spreadsheets. - Learning > Newsletters > Excel directory - The technical computing portal for all your scientific and engineering needs - featuring Microsoft Excel

    Learning Microsoft Excel - basics and useful tips -

    Pearson Software Consulting, LLC - Expert Excel & VBA Consulting -
    This web site is provided as a public service.  It includes terrific Excel, Office, and Visual Basic solutions.  Search for the skill/task you need to learn. 

    Excel Worksheet Basics with Sample worksheets to download --   for lots more

    Excel & Excel VBA Help.. Free MS Office Support -
    Use the forums to get answers to questions -

    Advanced Excel Add-Ins  & Tips -  - 

    Ask - get useful responses -
       and strange Excel Function Clock :-) 

    Excel - Free MS Office Support - Basic thru Advanced - register free
    Use the forums to get answers to questions -

    Free Email Newsletter - Sign up at -

    Joseph Rubin's Excel Tips .com Free -

    FREE Email TIPS on Excel &/or other apps - Sign up at -

    Cal Poly  Excel Resources - an incredibly wide variety of useful and fun stuff!

    Excel - Various Ways To Do Tasks  -  Use Mouse or Menu Bar or ShortCut Menu or Keyboard ShortCut to do all sorts of Excel tasks 

    Excel Tutorials

    Basic Excel Tutorials - Free
      -  - Intro Level - includes functions
      - -
    - good graphics
      -  - Excel 2003 Tutorials
      - - Very detailed steps with skills exercises
      -  - step-by-step intro skills with detailed graphics

     Example:   -- Hands-on Tutorial Packs -- Analyzing Data with Excel 2002 -- Learn How To:

    • Gather real-world data from different sources, including text files, databases, and the Web

    • Use PivotTables® and PivotCharts® to ask questions of complex data

    • Save your analysis as an interactive Web page

    For basic steps to put various kinds of Excel object on the web, click on -- About Putting Excel data on the Web 

    For steps in creating and enhancing Excel worksheets, click on -- Publish interactive data to the Web using Excel and FrontPage

    NEW !  - Excel 2003 Tutorial courses

    Put EXCEL OBJECTS ON THE WEB - basic steps tutorial
    About Putting Excel data on the Web 

    For steps in creating and enhancing Excel worksheets, click on -- Publish interactive data to the Web using Excel and FrontPage -- Free Excel tutorials  -- Functions & Formulas - basic, intermediate, and advanced levels.*+-buy

    Some Excel Keyboard Shortcuts for commands -

    PC Show and Tell - How-To Tutorials for a wide variety of software - register for 24-hr free trial - 1 user ($30) -  e.g. Excel XP = 1584 objects in this library as of 2/17/2005.

    Accounting Tips - Tutorial of accounting tips for Excel. Build an A/R system. Learn about forecasting techniques, comparative ratio analysis, ROI analysis, and more. Also, fee for service online Excel project assistance. -

    Interactive Accounting, Business, Computer terminology and concepts exercises -

    NEW !   Go to CHARTS section below for chart tutorials

    <Go to Top>

    Functions & Formulas

    Excel Functions  & Formulas
       - & common error messages


    Excel Function - Calculate the business hours between dates  -

    Using an Excel worksheet - Basics of Using Functions - Internet4Classroom -

    Excel Functions - used for Sampling Data

    Financial Functions in Microsoft Excel - handouts including Excel Basics

    Selected Excel Financial Functions - And more, some rather exotic, Excel functions

    Pearson Software Consulting, LLC - Expert Excel & VBA Consulting - Macros & Functions - - Excel Functions on Ranges -

    Excel  - select Formulas & User-Defined Functions -
    A list of hard to find, hard to write Excel formulas to solve common problems:

    • Formula FAQs

    • Grab the last part of a string into a new formula

    • Extract and count the number of like elements in the middle of a string

    • A customer wanted to show both the formula and results in the same cell. It’s not very smart or useful but it works.

    • Compare 2 columns of numbers and count if a condition exists

    • Longest formula I ever created

    • Functions - basic to esoteric and combinations

    • Using external number templates in a spreadsheet

    • Determine number of working days between 2 days excluding holidays

    • Determine exact date for company holidays into the future

    • Convert a Gregorian date to Julian date

    • Figure how many hours someone worked

    • Build better Array functions

     VLOOKUP - Microsoft tutorial page


    VLOOKUP - Step-by-step tutorial - example to determine the letter grade for numeric scores 


    About.Com - Mathematics - Tutorial - very straightforward

    The Math Forum @ Drexel - What is the correct order of operations?  The purpose for this section is to understand how to build formulas and to avoid incorrect an over use of  parentheses.

    Order of Operations & Evaluating Expressions -  rules, self-scoring practice, learn it.  OK, so it's from a K-12 math course - if we do not know something well, a good resource is a good resource! 

    <Go to Top>

    Specialized Tools

    Solver Help  -
    Comprehensive Solver information, answers, how tos, tips, such as:

    • Help with specific Solver messages

    • If you aren't getting the solution you expect (12K)

    • If the solution process takes a long time (10K)

    • If you've exceeded problem size limits

    • Known problems in Microsoft Excel Solver

    • Hints on Using Specific Solver Features

    • Understanding the Solver Reports

    • Understanding the Solver Options

    • How the Solver handles constraints (10K)

    • Hints for building readable, manageable models (25K)

    • Controlling the Solver with macros and VBA

    • Optimization Concepts (from the Tutorial)

    • Elements of Solver models

    • Linear and nonlinear functions

    • Discontinuous and non-smooth functions

    • Algorithmic methods used by the Solver

    Excel-VBA Tips and more -

    Free VB code - search "Excel" -

    EXCELTIP.COM on VBA Macros - Custom Functions -

    Pearson Software Consulting, LLC - Expert Excel & VBA Consulting -
    This web site is provided as a public service.  It includes terrific Excel, Office, and Visual Basic solutions.  Search for the skill/task you need to learn. 
    e.g. Macros & Functions -

    Excel & Excel VBA Help.. Free MS Office Support -  - register free
    Use the forums to get answers to questions -

    NEW !     VBA for Microsoft Excel - tutorial

    NEW !     Excel VBA - Variables and Data Types 

    NEW !     Excel VBA Examples

    NEW !     Anthony's VBA Page - Excel VBA tutorials, projects, etc.   

    NEW !     Introduction to VBA Excel - .pdf file tutorial.    

    NEW !     Indigoware - how to add context-sensitive HELP to Excel VBA applications  

    Macro Viruses
    Solid info from Microsoft about viruses written into Excel macros. As viruses are discovered, Microsoft provides add-in utilities to detect the virus, and has built-in those utilities for subsequent versions and releases. 

    Microsoft Developer Network (MSDN) Forum - Office - Excel
    Home page for Developers who want to create custom solutions using MS Office products.  Search keyword "Excel". -

    Risk Management - Product information on Financial CAD, a risk management add-in for Excel  (Free Trial available). FinancialCAD for Excel/PLUS for Excel - includes purchasing info. Everything you need to work with financial instruments and derivatives in Microsoft Excel. - 

    Excel with Exl-Plan -- fastest, best way to prepare financial projections
    Entire business built on MS Excel technology. Some FREE stuff you can try out.

    PsyFunc Psychrometric Functions for Excel -- Add in for Excel  - download a full-featured free demo -

    <Go to Top>

     Linear Regressions with Excel

    Analyse-It - Linear Regression for Microsoft Excel - free trial download

    Multiple Linear Regression - free trial download

    Linear Regression - downloadable .PDF files

    Linear Regressions - Using Excel 

    Graphing Linear Regressions in Excel

    Essential Regression and Experimental Design --

    Slide Show - Linear Regression with Excel --

    Regression Using Excel's Solver -- 

       Excel Charts - What to use & when?  Types & Sub-types

    NEW !  - Overview tutorial - How to CREATE A CHART in EXCEL 

     NEW !     Univ of Texas - Useful graphics and basic tips for Creating an Excel Chart (old but still good)  

     NEW ! - Another useful How To Create Excel Charts with very good graphics and tips  

    NEW !   Microsoft tutorial about CHARTs of various types, including combination charts, and charts with secondary axes  

    This page includes how to differentiate chart SUB-TYPES


    NEW !      Univ of Vermont -  Limited graphics but precise steps to Create and Manipulate an Excel Chart 

    NEW !   LabWrite Resources - I like this q - quick tutorial - they use the correct terminology - GRAPHS 

    NEW !   Better  -  Excel Charts HOW TO, from very basic, click F11 to create a quick chart, thru very detailed information, including how to effectively use the Chart Tool Bar



    College View -- A great resource for students. It gives great info about, you guessed it, colleges :-) 

    *****  ASSIST.ORG - See if courses you take at AVC or any other CA public college or university are articulated (will transfer easily) to another CA public college or university.
       ASSIST is a computerized student-transfer information system that displays reports of how course credits earned at one California college or university can be applied when transferred to another.
       ASSIST is the official repository of articulation for California’s colleges and universities and therefore provides the most accurate and up-to-date information available about student transfer in California.


    Greetings site - is not business related but - all work and no play ....

    Accounting Jokes - 

    Business Jokes  -

    Computer Jokes -

    < Go to TOP >



    NEW !   Internet for Beginners - by Paul Gil - sign up for free newsletter  

    including Student's Quick Reference Guide to Internet Research  

     NEW !  - tutorials about all-things Internet and World Wide Web 

     NEW !   Library at University at Albany - How to use Internet / WWW tutorials:  

     NEW ! - Computer section - lots of useful tutorials/info 

      NEW ! - Interactive, illustrated guides 




    For those wondering how to go about a search, here are some tips:

    For our topics - business, accounting or bookkeeping, computers, small business startup, management, online e-commerce business, etc., - you would go to one of the search tools listed below and either (1) select a topic such as BUSINESS or eCOMMERCE or COMPUTER, then a subtopic such as ACCOUNTING or SMALL BUSINESS or HARDWARE or SOFTWARE, until you see links to websites that look promising;
    or (2) input key words or phrases, such as ACCOUNTING or COMPUTERS;
    or (3) in AskJeeves input a question, such as HOW DO IT START A SMALL BUSINESS? or HOW DO I UPLOAD A WEB PAGE?

    A list of sources will be provided, some with useful information.

    SINK OR SWIM site -- A good workshop on searching the Internet is at

    Search About - useful search site - - all about, well, you know  ....

    NEW !     ISP Comparisons 

    BASIC INFO ABOUT SEARCH TOOLS see Search Internet course page

    SEARCH INDEXES / DIRECTORIES - these create their own indexes of popular topics. So, if we're looking for general information about a fairly normal topic, like we are, we can usually get reliable results just by going to the site and selecting a topic, then a sub-topic -some good ones are

    GoTo --
    Lycos --
    Open Directory -
    Yahoo which calls the AltaVista search engine if there are few or no sites in its directory-

    META SEARCH ENGINES - send queries simultaneously to multiple Web search tools. When looking for specific or exotic information, using one of the following will generate large-scale searches utilizing several search tools at once:
    Ask Jeeves - : just ask a question
    Cyber411: - Searches 16 search tools
    Dogpile: - searches newsgroups, too
    SavvySearch: - full-featured
    ProFusion -

    INDIVIDUAL SEARCH ENGINES - Search engines check your key words against a database most often created automatically, by "spiders" or "robots" - with these you are not searching the web "live"

    AltaVista -
    Excite -
    Google -
    HotBot -
    Infoseek -

    OTHER BROWSERS instead of MS Internet Explorer or Mozilla Firefox:

    C|Net Latest in Browsers
    The latest news about browsers from C|Net.

    Cello Web Browser
    A multipurpose Internet browser that allows access to the myriad information resources of the Internet.

    HotJava Web Browsers
    A lightweight, highly customizable solution for OEMs and developers creating Web-enabled devices and applications.

    Lynx Web Browser
    Possibly the most widely used text mode browser on the Internet.

    NCSA Mosaic Web Browser
    The last version of NCSA Mosaic for Windows was version 3.0.  It should be noted that version 3.0 is Windows 95/NT specific.

    Opera Web Browser
    A refreshingly different Internet Client that has a number of features that undoubtedly make it the Number 1 for the serious online computer user.

    < Go to TOP >


    Paperless Copies of Web Pages & Email and Discussion Messages

    Select the Email or BB message you want to save. Be sure to Click once inside the message to be sure the frame it's in is selected. Then from the FILE menu, select SAVE FRAME AS if this command is available, else use SAVE AS, select FILE, choose the location to which you want the document to be saved.

    If you are in EMAIL or Discussion Forums, the default filename will refer to the server and will not identify the message.  So, change the name to something that describes what you're saving. I always include  _em for email and _bb for forums messages to help remember the source.

    Don't type the file extension and don't use periods (dots).

    Then to view the file later, either Option (1) find the file in My Computer or Windows Explorer and double click on it to open your browser and open the file. Yes, you can use your browser OFFLINE - without dialing up your ISP - howabouthat!!

    Option (2) would be to open your browser, or use one that's open and select FILE, OPEN, BROWSE to find the file you want to view and double click on it to view it in the browser.

    Cool, huh!! Let me know if any questions - Kathy Moore

    < Go to TOP >

    This page is ALWAYS under construction.  SHARE if you find any good Excel Project or other resources, by posting the info as a message into the Blackboard Communication area / Discussion Board /  Dialogue Chamber Q&A forum.
    Also, let me know if there are any broken links.  Websites come and go, and get revised all the time.

    For more information please use following Links graphic - not a link:       <Go to Top>


    FAQs (Frequently Asked Questions) - Assignments, DUE dates, Download Data Files

    Special Projects & Computer Report Instructions
    Submit Assignments as Attachments / Using File Compression - WinZip or WinXP  

    Kathy's Courses Welcome Page

    CA221 Welcome Page


    Last Updated 10/29/2008
    By K
    E MOORE   Copyright 2005