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. Excel basics Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics.

Get data analysis for excel mac 2011