You are here

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

Custom Ads