academics header
 

Excel for Mac

These pages contain video tutorials and links to our written workshop handouts for Excel for Mac.

Basic Excel
Watch Video Tutorials
  Download Workshop Handout (pdf)

  • Cells, columns, and rows
  • Cut, copy, and paste
  • Basic formulas and autosum
  • Sorting
  • Formatting
  • Getting ready to print

Data Crunching Tool and Tips
Watch Video Tutorials
  Download Workshop Handout (pdf)

  • Import Data from a Text File
  • Filters
  • Relative vs Absolute Cell References
  • Text To Columns Command
  • Handout contains information on the above subjects plus Functions, Subtotals, and Conditional Formatting

Pivot Tables
Watch Video Tutorials  Download Workshop Handout (pdf)

  • Create a pivot table to summarize your data automatically.
  • Re-arrange that pivot table for different views of your data or to add additional criteria.
  • Learn more advanced options, such as adding column labels and grouping.
  • Format your pivot table, and learn some options for sharing or duplicating it.

Charts in Excel
Watch Video Tutorials  Download Workshop Handout (pdf)

  • Create a chart using a table of data.
  • Customize the formatting and what information shows where.
  • Learn more advanced options, such as adding a secondary axis and customizing axis labels.
  • Pick a color scheme: then move, copy or print your chart.
 

Contact Us

Information Technology
Harold F. Johnson Library Center
Hampshire College
893 West Street
Amherst, MA 01002
413.559.5418
Fax 413.559.5419
helpdesk@hampshire.edu
 

© 2013 Hampshire College 893 West Street Amherst, MA 01002 . 413.549.4600