Excel for Mac Training and Tutorials. Learn how to use Excel for Mac. Tutorials range from beginner to advanced, covering a wide range of topics, including how to create Excel formulas, understand Excel functions, create an Excel spreadsheet or pivot table, and more. Technology Tutorials Excel Worksheet Basics. Using Excel X for Mac Using an Excel worksheet - Basic terminology Step 1 - Launch Excel - Automatically the project gallery opens. Step 2 - Select Excel.
Using Excel X for Mac
Using an Excel worksheet - Basic terminology
Excel 2008 For Mac Tutorials
Step 1 - Launch Excel - Automatically the project gallery opens.
Step 2 - Select Excel Workbook, the highlighted choice. You may click on the OK button of press the Return key.
An Excel workbook is made of several sheets. Unless you have changed the default setting you will have three sheets.
Step 3 - Changing the name of the worksheets - Each of the three sheets is a full spreadsheet. Having a workbook with multiple sheets allows you to easily establish relationships from one sheet to another.
The name of the sheet may be changed. Double-click the name of the sheet in the tab at the bottom, and type the new name.
Step 4 - Inserting additional worksheets - If you need additional worksheets, go to the Insert menu and select Worksheet . It will be placed before the selected sheet.
You may also insert a worksheet by right-clicking on the name of the sheet in the tab and selecting Insert... (Macintosh users, Hold down the Ctrl key while clicking. If you want more information on this see a module about teaching your Mac to right-click .)
As you can see from the graphic above, renaming the worksheet can also be accomplished by right-clicking the tab containing sheet names.
Step 5 - Cells - Rectangles in a spreadsheet are called a cell. Cells are designated by the column and row in which it is located. By default, the top left cell, A1, is highlighted.
Try the following ways to move from cell to cell:
- Hit the Return/Enter key to move down to the row below
- Hold down the Shift key, then hit the Return/Enter key to move up to the row above
- Hit the Tab key to move over to the column to the right
- Hold down the Shift key, hit the Tab key to move back to the column to the left
- Move the cursor to any cell and click there
- Use the arrow keys to move up, down, left, or right.
Step 6 - Recognizing cursor styles - There are four common cursor styles used in Excel.
Click and drag to highlight multiple cells with this cursor, or click in a cell to select the single cell |
Click and drag the contents of the selected cell to any other cell. |
Excel For Mac Free
Click and drag with this cursor to fill cell contents into cells below or to the right. |
Click to place the cursor into the Formula bar so that you can edit an equation or function. |
Download Excel For Mac
Step 7 - Entering data - Move to the cell where you want to enter data and enter words or numbers. If data is already in the cell it will be replaced without having to cut or delete the previous data.
Excel 2008 For Mac Tutorial
Next module: Worksheet Basics - Entering and editing data