Standard toolbar: The toolbar that displays the name of the workbook (in this case, Workbook1) and buttons for some of the most common tasks, such as opening, saving, and printing a workbook. Menu bar: The area at the top of the screen where all menus are displayed.The File, Edit, and View menus have the most commonly used menu commands. Let's take a look at some of the Excel user interface elements. However, before you begin entering data, you should familiarize yourself with some of the user interface elements that you can use in all workbooks. Explore the Excel interface In a new blank workbook, you can simply click in a cell and begin entering data. Use the Excel Workbook Gallery to create a new blank workbook.Ģ. To show the Excel Workbook Gallery at any time while using Excel, click File > New from Template.īefore you move on Make sure that you can do the following:
To create a new blank workbook at any time in Excel, on the File menu, click New Workbook (also written as File > New Workbook in this tutorial). Notice that a blank workbook (Workbook1) appears. Tip To always start with a blank document when you open Excel, select the Don't show this when opening Excel check box. Click Excel Workbook, and then click Choose. Tip If you don't see the Workbook Gallery, quit and then reopen Excel. In the Excel Workbook Gallery, under Templates, click All. If you have not already opened Excel, on the Dock, click Excel. Let's use the Excel Workbook Gallery to open a blank workbook. It provides a variety of template choices and quick access to recent workbooks. When you open Excel, the Excel Workbook Gallery opens. You can start with a blank workbook, an existing saved workbook, or a template. Create a new blank workbook In Excel, you create and save data in a workbook. Microsoft Office for Mac 2011 tutorial: Excel basicsġ. Identify user interface elements that you can use to accomplish basic tasks. 21īefore you begin What you'll learn After completing this tutorial, you'll be able to: This tutorial introduces some of the tasks and features that you can use in all workbooks.īefore you begin. If cell A1 does NOT contain "Super", the FIND function will return the #VALUE! error causing the IsError function to evaluate to TRUE and return 0.Excel basics Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. the IsError function evaluates to FALSE) and the formula will return A2. If cell A1 contains "Super", the FIND function will return the numerical position of the value of "Super". Let's just quickly explain how this formula works. In this example, cell A1 does NOT contain the value "Super", so the formula returns 0.
In this case, cell A1 does contain the value "Super", so the formula returns the value found in cell A2 which is 100. I'm unable to use the FIND function because if cell A1 does not contain "Super", the FIND function returns the #VALUE! error which does not let me sum column A.Īnswer: To make sure that do not return any #VALUE! errors when using the FIND function, you need to also use the ISERROR function in your formula.īased on the Excel spreadsheet above, the following FIND examples would return: =IF(ISERROR(FIND("Super",A1,1))=TRUE,0,A2) Objective: If A1 contains "Super", then I want A3=A2. Question: In Microsoft Excel, I have the value "Supermarket" in cell A1 and 100 in cell A2.