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.
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.
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.
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
5. Analyze, Share and Collaborate
Watch this short video for an overview of using small charts known as sparklines to quickly show data trends in Excel for Mac.