academics header
 

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 »

 

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
 

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