A spreadsheet is a work book, just as the traditional ledger, that mainly used in the manipulation of data especially numbers using user defined formula and functions. First of all, we have to keep in mind that there are several different spreadsheets applications on the market and they may vary in terms of there appearance. However, there are some basic things that cut across all the applications. So without further ado, this spreadsheet tutorial should be very beneficial for beginners.
One has to know some basic names and definitions before venturing into the main application. A cell is the basic component of a spreadsheet. It is here that data is input. It is normally of a rectangular shape but can be adjusted to accommodate even larger amounts of input. A row is a horizontal collection of cell whereas a column is a vertical collection of cells.
A worksheet is the entire collection or rows and columns on a page. The formula bar is a space just on top of the worksheet where functions and formula is input. Formatting is changing the appearance of data in a cell or worksheet and editing is changing the contents. The menu bar is where all the menu options might be selected from.
The first step of course is the launching of the application, usually by double clicking on the icon. Once the program is running, select file from the menu bar. From the drop down menu or dialogue box that appears simply select new workbook or document. A new spreadsheet will be open ready for use.
In the available cell, simply type in the desired data. This input data can be formatted, edited or even manipulated to give information. For example, one might opt to sort the names in the cells in ascending or descending order.
There are formula and functions that assist in the manipulations of the numerical data. The formula might be as simple as addition, subtraction, division or even multiplication. Functions are a complex combination of formula. Examples of functions include; average, count, if, sum, just but a few. The functions and formula are input in the formula bar.
After one is satisfied with the output data and the look of the worksheet, the next step should be saving the document. This option is again available in the drop down menu available form the file tab on the menu bar. From the dialogue box that appears, one can choose the desired location where the document is to be saved then click OK or save. At times, one may wish to print the workbook. Due to the size of the worksheet, one sets up the page and area to be printed from the page set-up menu. The size of the data can be lessened and paper orientation changed to fit smaller areas. Once sure, view the print preview then print.
This basic spreadsheet tutorial will help any novice to quickly get round any spreadsheet program with much ease. Constant practice is essential to sharpen one’s skills and spreadsheet knowledge.
Category: Microsoft Office