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