npenergylife.blogg.se - Excel tutorial 2010 for mac

#Excel tutorial 2010 for mac how to
#Excel tutorial 2010 for mac for mac
#Excel tutorial 2010 for mac Pc

Hover over the tab you want to rename, and double Left-click the tab.

Right-click the tab you want to rename if you are using a PC, or control-click the tab you want to rename if you are using a Mac.

To rename a worksheet tab, follow either of these steps: To add a new worksheet, click the Insert Worksheet tab, to the right of the existing worksheet tabs. You can access the different worksheets by clicking the worksheet tabs just above the status bar. When done, simply click Ok.īy default, three worksheets are included in each Excel workbook. Go to the Advanced option, and under Display, you can click the check box for Show formula bar. Getting started with Microsoft Excel and its new features within the Office for Mac.

#Excel tutorial 2010 for mac for mac

Excel Tutorial using Microsoft 2008 for Mac - Duration: 10:17. In order to hide or show the formula bar if it has mistakenly been hidden, go to Excel Options at the bottom right of the menu that opens when you click the Office button. Utilize this tutorial when dealing with Visual Basic macros and Excel 2008 for Mac. It is possible to hide the formula bar, though is not recommended. The formula bar is located below the ribbon and spans most of the window. This is most prominent when using functions, as you do not see the whole equation in the cell in the worksheet, only the result. Whenever you input any information into a cell, the output, or end result is what is shown once you move away from the cell. The formula bar allows you to see all the details and methods used to return what is seen in a cell.

We use the PMT function to calculate the monthly payment on a loan with an annual interest rate of 5, a 2-year duration and a present value (amount borrowed) of 20,000.

#Excel tutorial 2010 for mac how to

This will be one of the most useful tools as you use Excel. This example teaches you how to create a loan amortization schedule in Excel. Each cell on the spreadsheet has a cell address that is the column letter followed by the row number. Cells can contain text, numbers, or formulas for automatic calculations. MS-Off Ver Office 365, Excel for Windows 2010 & Excel for Mac Posts 26,782.

The intersection of a column and a row is called a cell. Another way to trigger a VBA Macro is to get Excel to automatically trigger. The numbers of the rows are indicated in the blue buttons down the left of the worksheet. The letters of the columns are indicated in the blue buttons across the top of the worksheet. The worksheet is a grid of columns (designated by letters) and rows (designated by numbers).

#Excel tutorial 2010 for mac Pc

Office 2010 for PC users, and Microsoft Office 2011 for Mac Users. Spreadsheet BasicsĮach Excel file is a workbook that can hold many worksheets. Office suite contains applications such as Microsoft Word, Excel, and Powerpoint. The options displayed will vary depending on the element you have selected. To access this feature, simply right-click the element you wish to edit if you are using a PC, or control-click the element you wish to edit if you are using a Mac. The most common Excel commands and functions can be accessed quickly by using the shortcut menu.

UW Chief Information Security Officer (CISO).