How to work on an excel file in Google docs

In Google Docs, you can create and share your spreadsheets online. Tracking budgets and calculating values can be done very easily here. You can share your document with anyone and give them the right to edit the sheet. Insert charts and gadgets to express your data in the best manner possible. Use functions to calculate the values by using the specified cells automatically.

Follow this step by step Google Docs tutorial to learn how to work on excel file online in Google docs.


Step # 1 – Freeze the rows

First of all, open the document that you want to work on. In this tutorial, we have selected a spreadsheet by the name of Budget. The freeze option allows you to freeze certain rows or columns. So when you will scroll down the spreadsheet, the headings above the frozen rows will remain fixed and appear all the time. When entering data, you will know exactly under which column you are entering it.

Use the freeze option

Step # 2 – Use the Average Function

Google docs spreadsheet allows you to use some functions which can automatically calculate things instead of doing it manually. In this tutorial, if we want to calculate the average of “Training”, we can select that column and go to the insert tab. When the drop down menu appears, go to the “functions” option and select the “Average” function.

Apply the Average function

Step # 3 – Select the Cells

Customize the Average function by selecting the range for the formula by selecting the cells on which you want to apply the function. When the range has been set, click somewhere outside the formula or press the “enter” button. The average will be calculated. Another way of selecting the cells is by typing in the cell range manually. In the tutorial, we are concerned with the range from C5 to C16. So in the average function, we can write “C5:C16” in the range section of the formula.

Highlight the cells

Step # 4 – Insert a chart

If you want to add a chart to your spreadsheet, first highlight or select the range on which you want to apply the chart. Once the range has been selected, click on the “insert” tab and select the “Chart” option.

Use a chart

Step # 5 – Customize the chart

The “chart editor” will open in a new box. You can choose from a range of different charts. The Title, background features, labels and other settings can be selected and adjusted here. A preview of the chart will be showed to you in this box. When you are done, simply click on the “insert” button to add the chart to your spreadsheet.

Edit chart settings