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 to produce its output. This [...]
Tag Archive 'excel'
Tell Me About Lotus 1-2-3
Posted in tech on Aug 8th, 2008
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 2002. Updates to that release [...]
Family Reunion Account Workbook Proposal
Posted in tech on Aug 2nd, 2008
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 first worksheet is called “Family Summary” [...]
Aunt Sally and Her Stuffed Animals
Posted in tech on Jul 29th, 2008
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 specifications. She can do this [...]
Microsoft Excel and a Family Budget
Posted in tech on Jul 22nd, 2008
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, functions may act on data [...]