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 …
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 …
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 …
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 …
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 …
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 …
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 …
