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.

Beginner excel guide