Spreadsheet from the previous tutorial have a title in cell C1. In this tutorial, you will know, how to use auto fill function of Microsoft Excel. Click inside cell B2 and type Monday, as the figure shown below: In this spreadsheet, now we have to enter name of all days of the week in rowRead more »

From previous tutorial, you should be know about the basic of Microsoft Excel. In this section, we will build a complex spreadsheet. In this section, you will learn about: How to use auto-fill in a spreadsheet. How to insert a row or column in a spreadsheet. How to add up a numbers in a column.Read more »

This tutorial is about to merge the cells in Microsoft excel for this see spreadsheet, shown below:   Look at the row 1, you will see that the “Customer Bill” heading stretches across three cells. This is not three different separated cells but cell B1, C1 and D1 were merged. To merge the cells higlightedRead more »

Look at the following spreadsheet, which you will be shortly creating:   The column D has a heading of “Price”. The all prices have the currency symbol. To insert the new currency symbol, highlighted the cells to change or insert currency symbol. With the cells highlighted, locate the Number panel on the Excel ribbon. DropRead more »

You want to save your work in Microsoft Excel, for this just following these steps: Microsoft Excel 2010 Users: For Excel 2010 users, click “File” option which is at the top of the left side of the Excel. And you will see options like this: You will find “save” option at the top in theRead more »

In the previous tutorial  you saw how to change the font and font size in Microsoft Excel. In this lesson, you will see how to change the color of a cell. Change the Background Color of a Cell: To change the background color of cells, you first have to highlight the ones you want toRead more »

If you have been following along with the previous tutorials, you should now have a spreadsheet that looks like this:   In this tutorial you will be able to Microsoft Excel font formatting. Choosing a font in Microsoft Excel 2010: In Microsoft Excel, you can pick a different font for the data you enter into cells,Read more »

By clicking inside of a cell it makes it active, and changes will be making if you want. We want to center all our numbers and the text. Here’s the spreadsheet we have: So we need cells C1, C2, C3 and C4 to be active. In Excel, you can do this by highlighting the cells.Read more »

In this tutorial you will learn about what is Microsoft Excel? Why we use it and how to use Microsoft Excel. How to create new file, insert data in Microsoft Excel spreadsheet ,to save it ,how to align text and much more. Microsoft Excel is a spreadsheet program. A spreadsheet is a computer software programRead more »

Microsoft Excel is a spreadsheet program from Microsoft.Microsoft Excel is an automated version of the paper-based spreadsheet that makes it easier to manipulate, process, and view the data. Microsoft Excel implemented a graphical user interface and the ability to point and click using a mouse. Microsoft Excel is important because it is the basic spreadsheet program used inRead more »