Excel Tips for Mac and PC Excel for Mac Basic Excel for Mac • 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 • 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. • 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. Mac os x like dock for windows.

Turn 'John' 'Smith' into 'John Smith'. Pivot Tables for Mac • 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.

The default, XML-based workbook format for Excel 2016 for Mac, Excel for Mac 2011, and Excel for Windows. Cannot store VBA macro code or Excel 4.0 macro sheets. Excel 97-2004 Workbook (.xls) Compatible with Excel 98 through Excel 2004 for Mac and Excel 97 through Excel 2003 for Windows. Preserves VBA macro code and Excel 4.0 macro sheets.

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