#Ms excel 2007 tutorial for beginners how to#

So go ahead and select the blank document option. For our article, we are starting with a blank document and playing around with data and formulas, etc.

#Ms excel 2007 tutorial for beginners how to#

One way of learning how to use Excel is to play with those templates and see what makes them “tick”. The templates themselves may vary between versions of Excel, but you should get some sort of selection. When you click on New you are more than likely going to get some example templates. Note: The above image says Open at the top to illustrate that you can get to the New (left-hand side, pointed to with the green arrow) from anywhere. This may vary, depending on your version of Excel, but is generally in the File area. It is helpful to start with a blank Workbook. We will give you some example steps as we go along in this article so you can try them out for yourself. There are many things you can do with your Excel Worksheet. Creating & Formatting a Worksheet Example When we reference the formula bar, we are simply indicating that we should type the formula in that spot while having the appropriate cell selected (which, again, will automatically happen if you select the cell and start typing). You enter the data in the cell and it will also appear in the formula bar if you have your mouse on that cell. The formula bar is an area that appears below the Ribbon. Those worksheets are the actual spreadsheets with which we work and they are housed in the workbook file. You can add tabs or delete tabs by right-clicking and choosing the delete option. If it is easier to think of it visually, think of the worksheets as those tabs. The Worksheets are the actual parts where you enter the data. Discover the Differences between Google Sheets and Microsoft Excel Workbooks If your version of Excel doesn’t do that, don’t worry, we will learn how to create them. WorksheetsĮxcel documents are called Workbooks and when you first create an Excel document (the workbook), many (not all) Excel versions will automatically include three tabs, each with its own blank worksheet. But we will cover them to be sure and be all set for the rest of the process in learning how to use Excel. More than likely, you have heard these terms (or already know what they are). It really is helpful if we cover a few definitions. Granted, we will not be covering every possible Excel function but we will cover enough that it gives you an idea of how to approach the others.

As a preview of what we are going to cover in this article, think worksheets, basic usable functions and formulas, and navigating a worksheet or workbook.