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.