In this free Excel 2016 tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets. Excel for Mac 2011 uses the same date system as Excel on Windows, the 1900 date system, which bases dates on the number of days since January 1, 1900. Older versions on Mac, however, use the 1904 date system, causing potential problems if you started a workbook on Excel for Mac 2008 or earlier.
Items you will need. Microsoft Excel application. Macintosh computer Excel is a Microsoft application and a component of the Microsoft Office suite that handles spreadsheet functionality. It is widely considered the most used spreadsheet program and, though it runs natively on Windows, has been ported to the Macintosh OS X platform.
This document details the basic steps needed to open Excel on a Mac, create a new spreadsheet and save the spreadsheet. When working with a complex application such as Excel, you should save your work frequently to avoid loss of data. Using Excel Open Excel. From the Mac OS X desktop, double click on the hard drive icon in the top right corner.
![Learn how to use excel online for free Learn how to use excel online for free](https://xltools.net/wp-content/uploads/2016/08/Add-Export-to-CSV-Add-in-from-the-Office-Store-to-Excel-Online.png)
From the list of folders, select 'Applications' and then select 'Microsoft Office.' The Excel application will be identified by an animated, cartoonish green 'X' and can be opened by double clicking this character. Create a new spreadsheet. When Excel first opens, a new, blank spreadsheet will be automatically created and given a default name of 'Worksheet 1.'
As such, no steps are required to create a basic new spreadsheet. Save the spreadsheet. From the Apple menu at the top of the screen, select 'File' and then select 'Save As' to indicate to Excel that you want to save your spreadsheet. A dialogue box will appear in which you can give your file a name and select a location on your hard drive or network to save the file. Click 'OK' to save your worksheet. Performing Basic Functions in Excel: Finding the Sum of Data Commands are similar to Windows. Excel for Mac works much like the original Excel for Windows program and uses most of the same commands.
If you are familiar with the Excel application in Windows, you will be able to use many of the same commands in Excel for Mac. Enter the command '=SUM(' in the cell where you would like the sum displayed. To find the sum of data in Excel, first identify where you would like the sum displayed. In the cell where you want to display the sum, enter the following command: =SUM( Select the data you wish to add. To select multiple consecutive values, simply hold down the 'SHIFT' key and click the first value followed by the last value in the list; holding down the 'SHIFT' key will tell Excel that you wish to select those two values and all values between them. If the values you wish to select are not consecutive in Excel, simply hold down the 'Command' key and click each value you wish to add.
Press 'Enter.' When you have selected all of the data you want to add together, press 'Enter.' Excel will complete the formula you started in Step 2 (by adding a right parentheses to close the formula) and display the sum of the values you selected. Performing Basic Functions in Excel: Finding the Average of Data Enter the command '=AVERAGE(' in the cell where you would like the sum displayed. To find the sum of data in Excel, first identify where you would like the average displayed. In the cell where you want to display the average, enter the following command: =AVERAGE( Select the data you wish to add. To select multiple consecutive values, simply hold down the 'SHIFT' key and click the first value followed by the last value in the list; holding down the 'SHIFT' key will tell Excel that you wish to select those two values and all values between them.
If the values you wish to select are not consecutive in Excel, simply hold down the 'Command' key and click each value you wish to include in the average. Press 'Enter.'
When you have selected all of the data you want to average, press 'Enter.' Excel will complete the formula you started in Step 2 (by adding a right parentheses to close the formula) and display the average of the values you selected.
I mean, this is Excel we’re talking about here. Hitting the Delete key is supposed to delete the contents of the active cell, for cryin’ out loud. In Excel for Mac it does that, but the cursor also gets stuck inside the cell in edit mode. You have to hit the enter key to finish deleting the contents, but this act also moves the active cell to the next cell down. And if you’ve selected a range and hit the Delete key, the active cell contents are deleted and the cursor is stuck inside the cell in edit mode.
You have to hit the Enter key, which does nothing but take you to the next cell. The range contents are still there, with the exception of the active cell. Not the kind of behavior that occurs in Excel for Windows. How to Delete Cell and Range Contents in Excel for Mac The trick is to remember that fn+Delete is really a keyboard shortcut to the Delete key on a Mac. Then the world rights itself and the planets align. Frustration abates. You’ve finally found the magic.
Your mojo is back! Watch this 54 second video to see what I’ve been babbling about for the past 454 words. I know this is an old thread, but I just spent the last few weeks assembling a list of Windows and Mac Excel shortcuts. Right now, the list is just over 200. shortcuts: Seems like every time I look at the list, I find a problem to fix, but it’s a start. Hope it’s useful for those who need to use both platforms. I took a pretty granular approach, so some shortcuts are near duplicates (e.g.
Selecting columns in a table and selecting columns in the worksheet are listed separately, but the behavior is a little different). Phil Paradis Note that there is a Windows-style “Delete” key on the full-size Mac keyboards, in it’s usual place to the left of the End key. (It’s labeled with a funny-looking symbol instead of “Delete”, and is referred to in most documentation as “Forward Delete”.) This key functions exactly as Delete on a Windows keyboard and Fn-Delete on the laptop/wireless Mac keyboards.
The full-size model also has a 10-key number pad for those who prefer them, though some of the operator keys are misplaced relative to the PC layout which can take some getting used to.