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

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 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.

Charts in Excel
Watch Video Tutorials   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.