5. Add or Replace a Picture
The Photo Browser helps you browse through existing photo sets on your computer, such as photos that you have in iPhoto or Photo Booth.

Add or Replace a Picture | |
File Size: | 52 kb |
File Type: |

PRACTICE FILE - Add or Replace a Picture | |
File Size: | 649 kb |
File Type: | docx |
Excel provides two ways to create a PivotTable report. When you use an automatic PivotTable, Excel evaluates both the structure and kind of data in your range and creates the PivotTable for you. This takes the guesswork out of designing the PivotTable because Excel determines which fields are most likely to be rows, columns, or values.
Watch this short video for an overview of using Pivot Tables to quickly summarize and analyze large amounts of data in Excel for Mac 2011.
Watch this short video for an overview of using Excel for Mac to open and edit workbooks that are located on OneDrive.

Create a PivotTable | |
File Size: | 141 kb |
File Type: |
4. Predict Data Trend Lines
You can extend a series of values that fit either a simple linear trend or an exponential growth trend by using the fill handle.

Predict Data Trends | |
File Size: | 69 kb |
File Type: |
3. Access Your Workbooks Anywhere
2. Create a PivotTable
When you save your document to SharePoint or OneDrive, you can access your workbook anywhere that has an internet connection.
5. Save a Document to SharePoint or OneDrive

Save a Document to SharePoint or OneDrive | |
File Size: | 68 kb |
File Type: |
5. Analyze, Share and Collaborate

Protect a Sheet | |
File Size: | 76 kb |
File Type: |
Watch this short video for an overview of using small charts known as sparklines to quickly show data trends in Excel for Mac.