Sara's One Stop Computer Shop
COME SOCIALIZE WITH US!
  • Home
    • Contact Us
    • Inside My Store
    • Terabit T-Rex
    • Staff Login
  • Our Services
    • Take A Class
    • Repairs and Maintenance
    • Virus Removal
    • Website Design
  • Support
    • Worry-Free Support
    • Tips & Tricks >
      • iCloud
      • Backing Up Your Computer
    • LastPass
    • Remote Help
  • Online Classes
  • Test Your Skills

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: pdf
Download File

PRACTICE FILE - Add or Replace a Picture
File Size: 649 kb
File Type: docx
Download File

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: pdf
Download File

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: pdf
Download File

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: pdf
Download File

5. Analyze, Share and Collaborate

Protect a Sheet
File Size: 76 kb
File Type: pdf
Download File

Watch this short video for an overview of using small charts known as sparklines to quickly show data trends in Excel for Mac.

4. Spot Trends with Sparklines

1. Summarize Your Data with PivotTables


Sara's One Stop Computer Shop
24056 State Road 35 / 70
Siren, WI 54872

715-349-GEEK (4335)
EMAIL US
CONTACT US
Apple®, iPad® and iPhone® are trademarks of Apple Inc., registered in the U.S. and other countries.
Google®, Gmail®, Drive®, Docs®, Sheets® are trademarks of Google Inc., registered in the U.S. and other countries