How to create a Spreadsheet on running costs of a small company. | Small business spreadsheet for income and expenses
How can you create a Spreadsheet on running costs of a small company ?
Small business spreadsheet for income and expenses
Important/Note : This is an on- demand post , I love using computers and its application and know a lot about computers and Microsoft programs .You can request/demand for queries ,doubts if you face any problem . You too can ask for a post related to computers , Microsoft Applications, science,technology,history or anything else by contacting us through the contact form or through mail care.haveprasad@gmail.com
INTRODUCTION
MS Excel 2016,2013 , 2007,2000 are some of the popular spreadsheet from Microsoft, designed for the networked office environment. Spreadsheets are used in areas that involve complex calculations and analysis Spreadsheets are also known as Worksheets. They display data in the form of rows and columns Data is entered in a cell, which represents the intersection of a row and column.
What are spreadsheets ?
SPREADSHEETS
Spreadsheets are used in areas that involve complex calculation and analysis. These packages provide extensive Mathematical Functions that can be used for various tasks in both business and scientific areas. Spreadsheets, also known as Worksheets display data in the form of rows and columns. Data is entered in a Cell, which represents the intersection of a row and column.
Some of the popular spreadsheet packages are MS-Excel, Lotus 123, Supercalc, Visicalc.
Getting started with MS excel
Starting Ms excel : open Ms excel by clicking at the start button ,followed by program option.
A workbook will appear on the desktop.
Start your work !
This first stage spreadsheet is used to
- enter data-labels and values
- editing cell contents and saving a spreadsheet
MINIMUM REQUIREMENTS
MS Office 2000,2013,2017 or any and Windows 98 or any ,on to the computer .
STEPS TO BE FOLLOWED
1. Click at the start button provided at the extreme left hand side at the bottom of the desktop.
2. Go to Program option and then on to MS Excel option.
3. A menu with some options and a worksheet appears on the desktop
4. Start typing "Monthly Costs (Rs)" from the first row and first column.
5. Then the second row can be kept vacant. Then from third row with different column start writing the captions. The first column can have "Item": the second column can have "January", then "February" and "March". Then next row can be
again kept vacant.
6. Then one can write the items like, "Rental" with its expenses in different months like, 48000; 48000, 48000 in the column made for Three months.
7. Similar data can be entered for the rest of the items like Services, Food, Travel. and Insurances with different expenses in Rupees.
An example is given below:
Monthly cost (Rs)
8.Then go to save as option in the file menu and save the spreadsheet as costs in the test folder already made un the hard disk . It will be saved as .xls file.
Program saved as
C: \ Test\Costs.xls
Output
A simple workshhet with data entering is done and is shown in the image .
 |
| How to create a Spreadsheet on running costs of a small company |
