Saturday, February 22, 2014

Spreadsheets For Beginners

Spreadsheets for Beginners


Many organizations deal with large quantities of numbers or other information that isn't practical to deal with on paper. Computerized spreadsheets are an excellent tool for storing, interpreting and modifying many different types of information that an individual or company receives from clients or internal reports.


History


Paper spreadsheets have been used as business ledgers for decades, but computerized spreadsheets were not developed until 1969, when a program called LANPAR was created for Bell and ATT to use for balancing their budgets. A program called Visicalc was the first spreadsheet developed specifically for a personal computer and was distributed for the Apple II in 1979. Although there are several major spreadsheet programs available for the personal computer today, such as Open Office and Lotus Symphony, the most popular for the Windows and Mac operating systems is currently Microsoft Excel.


Function


A spreadsheet consists of a grid of rectangular rows and columns called cells in which you can input any alphanumerical character. Either the first column, first row, or both can be used as headers or identifiers and then the remaining portions of the grid can contain the specific information, such as a listing of prices or names.


Features


Spreadsheet programs generally include extra features to further identify information or break up chunks of information into more easily readable groups. The most common features are those normally found in word editing programs such as underlining, adding in bold or italics, or changing the color of text or cells. The border thickness of specific cell ranges can also be changed to either remove the borders or make them much thicker for especially important data.


Benefits


The main benefit of spreadsheet programs is their ability to modify the information contained in the cells. They have functions that allow numbers in the cells to be added, subtracted, multiplied, divided or put together to find an average. Most also sport additional features for creating grids or charts of the information for easy printing or showcasing the information in a presentation.


Potential


The Microsoft Excel spreadsheet has an extra programming feature called Visual Basic for Applications, which allows for even more functionality, such as automating specific tasks that need to occur repeatedly, calculating complex equations or even using information in the spreadsheet in other Microsoft programs such as Access or Outlook. Although using it requires learning parts of the programming language, Visual Basic can be an incredibly powerful tool that has a huge range of applications for both personal and business use







Tags: spreadsheets, beginners, deal with, information that, Microsoft Excel, personal computer, program called, programs such, spreadsheet programs, Spreadsheets Beginners, Visual Basic

Related Posts:




  • Remove Rundll Error

    Rundll.exe files are programs that are directly tied to the registry on Windows computers. Dynamic Link Library (DLL) files contain libraries of information used by other programs running on your...


  • Open Apple Works Files With A Pc

    Open an AppleWorks document on your Windows computer.AppleWorks is the predecessor software for iLife. The software is similar to Microsoft Office and comes with a variety of different program tit...


  • Find Out If Someone Is A Felon For Free

    Maybe you are a landlord or have a question about a future employee's criminal record. How easy is to find out? Easier than you might think. A person's criminal background is a public record, mean...


  • Write A Personal Trainer Bio

    As a personal trainer, you may be asked to write a bio that outlines your credentials.As a personal trainer, you may be asked to write a personal bio for a website, a company newsletter, gym membe...


  • Order Steelers Checks

    Football fans are some of the most loyal fans of any professional sport and that loyalty carries over into a number of different fields, including personal banking. In the past it#x2019;s been fai...