Excel spreadsheet microsoft for free#
Excel spreadsheet microsoft how to#

For convenience, some useful Excel to PDF converters convert Excel to PDF files for free while maintaining the original formatting. Once you create an Excel Spreadsheet, you can convert it to a universally accepted format like PDF. Step 13: Double-click on the chart title and change the name of the bar chart. The bar chart has been changed to the new style format. Step 12: Select the desired design format under the “ Chart Styles” group of the “ Chart Design” tab. Step 11: Select the result table, go to the “ Insert” tab, and select the desired option of the bar chart under the “ Charts” group. Let’s make a pie chart to make this result table more attractive.

Step 10: You can also create a result table to display only the total projected cost, total actual cost, and the difference between them. The image below shows that the dollar symbol is assigned to every data cell. Step 9: Select the whole data, go to the “ Home” tab, and select the dollar sign under the “ Number” group. We will add a dollar sign to all cells of the data. The formula will display the difference between projected and actual costs. Step 6: Enter the below formula in “ Cell D2” to calculate the difference. The formula will display the total actual cost. Step 4: Select “ Cell C10” and enter the formula: =SUM(C2:C9) The formula will display the total projected cost in Cell B10. Note: The SUM function adds all the data of the selected range and returns its total. Step 6: Enter all data, as shown in the below image. Move this arrow to the desired width, as shown below. Step 5: To fit it, select the border between column A and column B. Step 4: Enter “Student Name” as shown below.Īs you can see, the word “Student Name” didn’t fit properly in the cell. Here, we have selected “ Cell A1” and will add headings for our table. Step 3: Select any cell and start typing. Step 2: Select “ New” and click “ Blank workbook”, as shown below.Ī new workbook is created, and “ Sheet1” is open, as shown below. Let’s see how we can do this by opening a new spreadsheet. In this example, you will learn to enter data in a worksheet and calculate the total marks of students.

Excel spreadsheet microsoft how to#

The spreadsheet’s name will be Book 1 if you open it for the first time.Įxample #1: How to Enter Data in a Worksheet Step 3: By default, Sheet 1 will be created as a worksheet in the spreadsheet.

OR – Press Ctrl + N: To create a new spreadsheet. Step 2: Go to Menu and select New > Click on the Blank workbook to create a simple worksheet. You can download this Create Spreadsheet Excel Template here – Create Spreadsheet Excel Template