Articles tagged with microsoft excel

  1. Spreadsheets to Databases: Exporting and Importing

    Posted on in Programming

    In the early stages of an organization, it is common for most data to be stored in spreadsheets. Spreadsheet applications are common and easily understood by most small business people. Unfortunately, spreadsheets become burdensome when tasks move beyond calculations and into querying (Churcher, 2007). Fortunately, databases are designed with querying …

  2. Microsoft Excel in Your Small Business

    Posted on in Software

    When using Microsoft Excel in a business environment, there are five essential items that every user should be aware of. One of the most basic features that is essential to effective spreadsheet usage is cell referencing. This is the ability for one cell to use the value of another cell …

  3. Tell Me About Lotus 1-2-3

    Posted on in Software

    Lotus 1-2-3, now a part of Lotus SmartSuite, is a direct competitor with Microsoft Excel. Although it's really only a minor competitor today, Lotus 1-2-3 was once one of the most important pieces of software in personal computing (Darrow, 2002). The latest major version of Lotus SmartSuite was released in …

  4. Family Reunion Account Workbook Proposal

    Posted on in Software

    I had to write a proposal for a Family Reunion Account Workbook that would be implemented in Microsoft Excel. Those involved in the project are certainly aware of what all this "Phase 4" business is all about. Enjoy.

    I envision the Family Reunion Account Workbook as having two worksheets. The …

  5. Aunt Sally and Her Stuffed Animals Love Microsoft Excel

    Posted on in Software

    This was written about a fictional character, Aunt Sally, who wants to organize information regarding her stuffed animal collection into a database.

    Aunt Sally sure has a lot of things in mind for her stuffed animal spreadsheet. The first task she needs to accomplish is sorting the data to her …

  6. Microsoft Excel and a Family Budget

    Posted on in Software

    In Microsoft Excel, functions and formulas work closely together. Formulas are simply mathematical operations that may or may not include the contents of cells in the spreadsheet. Functions are very similar in that they are pre-defined formulas which take their input from the parameters passed in to them. Like formulas …

  7. Can I use Microsoft Excel for that...?

    Posted on in Software

    This is about my fictional Aunt Sally who wonders if she can use Microsoft Excel to organize and track her large collection of stuff animals.

    Microsoft Excel would be a great way for Sally to track her stuffed animal collection. With over 800 stuffed animals, finding information about a particular …

My Bookshelf

Reading Now

Other Stuff