basics of an excel workbook

Excel is one of the most widely used spreadsheet applications, especially in the business world. Working in Excel lets you handle large volumes of data faster and makes you more productive. However, many people get frustrated and confused by Excel’s plethora of seemingly difficult functions and operations. So here are the basics of an Excel workbook for those who are not yet in the know. 

A workbook is a collection of worksheets. It is another name for your Excel file. When you open it, Excel by default creates a blank workbook. To open an existing workbook, click on the “File” tab on the ribbon bar. This will show you all the recently used workbooks as well as give you the option of opening an older workbook saved on your drive. This is the backstage view and contains all the workbook related functions. From this option, you can either select a workbook from the “Recent” list or you can click on “Open” to select a workbook from your older files. People who are new to Excel sometimes think that closing a workbook means that Excel will close automatically, but this is not true.

In your Excel window, you will notice two crosses (×) at the top right corner. The top × is to close the whole Excel program, while the bottom × is to close just that specific workbook. Hence, when you are working on different excel projects, click on the bottom × to close only the specific workbook that you want to close while keeping the others open. If you want to create a new workbook after working on an old workbook, click on “New” in the “File” tab and then select the type of workbook you want to create. You can create a blank workbook or one using recent formats, sample templates or personalized templates. After choosing your option, click on “Create”, which is found in the right corner of the window.

Stay tuned for Microsoft Excel tutorials in our future blog posts.

Microsoft Excel is available through MS Office programs you can purchase from our site. We offer MS Office versions 2010, 2013, 2011 for Mac, 365, and 2016

Image credit: Microsoft Sweden/Flickr (throwback picture, Bill Gates, circa 1992)