How to work excel sheet tamil tutorial. Httpbitlytech4excel learn the basics of using microsoft excel including the anato. Format text if necessary. But the spreadsheet grid shows few rows columns of active spreadsheet. Thats why weve put together this beginners guide to getting started with excel.
By default the tab for developers is not displayed in excel. Click on the cell where you want the data to go. A beginners guide to getting started. Each excel file can contain several sheets.
To see more rows or columns you can use the scroll bars to the left or at bottom. You can also use conditional formatting to cause your cells to change based on factors in the spreadsheet. Use your pointer to select cell c1 to enter the cell reference in the formula. Excel is a powerful applicationbut it can also be very intimidating.
You do not need to be a programmer or a very technical person to enjoy the benefits of macros in excel. Select cell e1 to make it the active cell and type in the equal sign. If you want to access other sheets just click on the sheet name or use the shortcut ctrlpage up or ctrlpage down. Excel is the most powerful tool to manage and analyze various types of data.
These steps are as follows. How to use excel. Macros are one of the developer features. Read the article on vba for more details.
Type the data into the cell. Microsoft excel is a spreadsheet program. Type a plus sign then use your pointer to select c2 to enter the second cell reference into the formula. Written by co founder kasper langmann microsoft office specialist.
Heres how to do it starting with the spreadsheet from the examples above. It will take you from the very beginning opening a spreadsheet through entering and working with data. Entering data into worksheet cells is always a three step process. We use it to create reports that need calculations and charts.
If you like this video heres my entire playlist of excel tutorials. Entering the tutorial data. This tutorial covers in depth lessons on how to use various excel formulas tables and charts for managing small to large scale business process.