91èÏÈÉú

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:

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:

• Take data from a .txt or .csv and bring it into Excel. Here's a practice .csv file.
• Easily and quickly sort your data or view records for only certain criteria.
• Choose whether the cells a formula refers to move when it moves, or stay fixed in place.
• Take data in a cell and split it out into multiple cells. Turn "John Smith" into "John" "Smith".
• Automatically add subtotals to your spreadsheet.
• Take data in multiple cells and combine it in one cell. Turn "John" "Smith" into "John Smith".

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:

• Create your pivot table.
• Use filters and sorting, add a secondary criterion, display values as percentages.
• Add column labels, groups, report-wide filters.
• Format numbers, pick a color scheme, copy a pivot table, "paste special" to paste values only. Ìý Ìý Ìý

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:

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

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:

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:

• Take data from a .txt or .csv and bring it into Excel, and have it look nice! Here's a practice .csv file.
• Easily and quickly sort your data or view records for only certain criteria.
• Choose whether the cells a formula refers to move when it moves, or stay fixed in place.
• Take data in a cell and split it out into multiple cells. Turn "John Smith" into "John" "Smith".
• Automatically add subtotals to your spreadsheet.
• Take data in multiple cells and combine it in one cell. Turn "John" "Smith" into "John Smith".

Ìý

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:

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

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:

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