Find Menu
student in media lab

Excel Tips for Mac and PC

Jump to Excel for Mac
Jump to Excel for PC



Excel for Mac


Basic Excel for Mac

Download Workshop Handout (pdf)

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

Basic Excel for Mac Tutorial Videos:

View the YouTube Playlist

Data Crunching Tool and Tips for Mac

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

Data Crunching Tutorial Videos for Mac:

View the YouTube playlist

Pivot Tables for Mac

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.

Pivot Tables Tutorial Videos for Mac:

Click here to view the YouTube playlist of all these videos, or preview them below.

Charts in Excel for Mac

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.

Charts Tutorial Videos for Mac:

  • Create Your Chart - Pick a chart type, learn about the different chart elements, and find out what Excel puts where.
  • Formatting In this segment, we cover formatting and tweaking your existing chart and its elements.
  • Advanced options Create a secondary axis, and fix your chart when Excel makes "wrong guesses" about layout.
  • Final steps Pick a color scheme and style visual elements, and move or copy your chart to a new sheet or another document.

View the YouTube playlist


Excel for PC


Basic Excel for PC

Download Workshop Handout (pdf)

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

Basic Tutorial Videos for PC:

View the YouTube playlist

Data Crunching Tool and Tips for PC

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

Data Crunching Tutorial Videos for PC:

 View the YouTube playlist

Pivot Tables for PC

Download Workshop Handout (pdf)

  • Create a pivot table to automatically summarize your data.
  • 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.

Pivot Tables Tutorial Videos for PC:

  • Get started Create your pivot table.
  • Refine or re-define your table Use filters and sorting, add a secondary criterion, display values as percentages.
  • Advanced options Add column labels, groups, report-wide filters.
  • Slicers A new feature in Office 2010 that lets you quickly filter data. (Video by Microsoft.)
  • Final steps Format numbers, pick a color scheme, copy a pivot table, "paste special" to paste values only.

View the YouTube playlist

Charts in Excel for PC

Download Workshop Handout (pdf)

  • Create a chart from a data table.
  • Format your chart with an eye toward ease of understanding.
  • Add more advanced options like a secondary axis, learn more about changing how a chart displays information.
  • Give your chart some finishing visual touches, then print it or use it in another document.

Charts Tutorial Videos for PC:

  • Create Your Chart Pick a chart type, learn about the different chart elements, and find out what Excel puts where.
  • Formatting In this segment, we cover formatting and tweaking your existing chart and its elements.
  • Advanced Options Create a secondary axis, and fix your chart when Excel makes "wrong guesses" about layout.
  • Final Steps Pick a color scheme and style visual elements, and move or copy your chart to a new sheet or another document.

View the YouTube playlist

Stay In Touch
With Information Technology Staff
Snail Mail
Information Technology
Hampshire College
893 West Street
Amherst, MA 01002
Phone + Email
413.559.5418
Fax: 413.559.5419
helpdesk@hampshire.edu