|
|
01 - Additional resources.mp4
|
MP4
|
1.5 MB
|
|
|
01 - Additional resources.srt
|
SRT
|
2 KB
|
|
|
01 - Analyze your data effectively using Excel for Mac.mp4
|
MP4
|
1.6 MB
|
|
|
01 - Analyze your data effectively using Excel for Mac.srt
|
SRT
|
1.1 KB
|
|
|
01 - Apply fonts, background colors, and borders.mp4
|
MP4
|
13.6 MB
|
|
|
01 - Apply fonts, background colors, and borders.srt
|
SRT
|
7.5 KB
|
|
|
01 - Check spelling.mp4
|
MP4
|
7.7 MB
|
|
|
01 - Check spelling.srt
|
SRT
|
5.8 KB
|
|
|
01 - Create a PivotTable.mp4
|
MP4
|
11.1 MB
|
|
|
01 - Create a PivotTable.srt
|
SRT
|
5.8 KB
|
|
|
01 - Create bar and column charts.mp4
|
MP4
|
10.3 MB
|
|
|
01 - Create bar and column charts.srt
|
SRT
|
6.7 KB
|
|
|
01 - Introduce Excel formulas, functions, and operators.mp4
|
MP4
|
6.9 MB
|
|
|
01 - Introduce Excel formulas, functions, and operators.srt
|
SRT
|
5.6 KB
|
|
|
01 - Open, create, and, save workbooks.mp4
|
MP4
|
8.8 MB
|
|
|
01 - Select cells and groups of cells.mp4
|
MP4
|
16.6 MB
|
|
|
01 - Select cells and groups of cells.srt
|
SRT
|
8.5 KB
|
|
|
01 - Sort worksheet data.mp4
|
MP4
|
12 MB
|
|
|
01 - Sort worksheet data.srt
|
SRT
|
6.8 KB
|
|
|
01 - What can you do with Excel for Mac.mp4
|
MP4
|
7.1 MB
|
|
|
01 - What can you do with Excel for Mac.srt
|
SRT
|
4.6 KB
|
|
|
01_01_WhatToDo.xlsx
|
XLSX
|
14.7 KB
|
|
|
01_03_RibbonTour.xlsx
|
XLSX
|
13.2 KB
|
|
|
01_04_Preferences.xlsx
|
XLSX
|
10.7 KB
|
|
|
01_05_GettingHelp.xlsx
|
XLSX
|
10.7 KB
|
|
|
02 - Add a formula to a cell.mp4
|
MP4
|
13.3 MB
|
|
|
02 - Add a formula to a cell.srt
|
SRT
|
9.6 KB
|
|
|
02 - Apply number and date formats to cells.mp4
|
MP4
|
10.8 MB
|
|
|
02 - Apply number and date formats to cells.srt
|
SRT
|
7.8 KB
|
|
|
02 - Copy and paste cell data.mp4
|
MP4
|
18.1 MB
|
|
|
02 - Copy and paste cell data.srt
|
SRT
|
8.4 KB
|
|
|
02 - Create a custom sort order.mp4
|
MP4
|
12.7 MB
|
|
|
02 - Create a custom sort order.srt
|
SRT
|
8.3 KB
|
|
|
02 - Create line charts.mp4
|
MP4
|
9.2 MB
|
|
|
02 - Create line charts.srt
|
SRT
|
6.2 KB
|
|
|
02 - Explore the Excel for Mac program window.mp4
|
MP4
|
7.1 MB
|
|
|
02 - Pivot a PivotTable.mp4
|
MP4
|
7.8 MB
|
|
|
02 - Pivot a PivotTable.srt
|
SRT
|
5 KB
|
|
|
02 - Set AutoCorrect and AutoReplace options.mp4
|
MP4
|
9.3 MB
|
|
|
02 - Set AutoCorrect and AutoReplace options.srt
|
SRT
|
7.9 KB
|
|
|
02 - Set workbook properties.mp4
|
MP4
|
7.3 MB
|
|
|
02 - Set workbook properties.srt
|
SRT
|
5.2 KB
|
|
|
02_01_ManageWorkbooks.xlsx
|
XLSX
|
10.5 KB
|
|
|
02_02_Properties.xlsx
|
XLSX
|
10.4 KB
|
|
|
02_03_Template.xlsx
|
XLSX
|
11 KB
|
|
|
03 - Create XY (scatter) charts.mp4
|
MP4
|
5.6 MB
|
|
|
03 - Create XY (scatter) charts.srt
|
SRT
|
4.7 KB
|
|
|
03 - Create and modify templates.mp4
|
MP4
|
9.2 MB
|
|
|
03 - Create and modify templates.srt
|
SRT
|
6.7 KB
|
|
|
03 - Enter data using AutoFill and other techniques.mp4
|
MP4
|
13.2 MB
|
|
|
03 - Enter data using AutoFill and other techniques.srt
|
SRT
|
10.6 KB
|
|
|
03 - Filter worksheet data.mp4
|
MP4
|
11.7 MB
|
|
|
03 - Filter worksheet data.srt
|
SRT
|
9 KB
|
|
|
03 - Introduce the ribbon.mp4
|
MP4
|
9 MB
|
|
|
03 - Introduce the ribbon.srt
|
SRT
|
5.6 KB
|
|
|
03 - Manage subtotals and grand totals.mp4
|
MP4
|
9.6 MB
|
|
|
03 - Manage subtotals and grand totals.srt
|
SRT
|
7.4 KB
|
|
|
03 - Manage text alignment.mp4
|
MP4
|
17.8 MB
|
|
|
03 - Manage text alignment.srt
|
SRT
|
12.5 KB
|
|
|
03 - Manage workbook comments.mp4
|
MP4
|
9.8 MB
|
|
|
03 - Manage workbook comments.srt
|
SRT
|
7.8 KB
|
|
|
03 - Use relative and absolute cell references.mp4
|
MP4
|
16.9 MB
|
|
|
03 - Use relative and absolute cell references.srt
|
SRT
|
11.9 KB
|
|
|
03_01_Select.xlsx
|
XLSX
|
11.3 KB
|
|
|
03_02_CopyPaste.xlsx
|
XLSX
|
11.3 KB
|
|
|
03_03_EnterData.xlsx
|
XLSX
|
11.3 KB
|
|
|
03_04_NamedRanges.xlsx
|
XLSX
|
11.4 KB
|
|
|
03_05_ExcelTables.xlsx
|
XLSX
|
10 KB
|
|
|
03_06_Find.xlsx
|
XLSX
|
9.9 KB
|
|
|
03_07_Validation.xlsx
|
XLSX
|
9.7 KB
|
|
|
03_08_List.xlsx
|
XLSX
|
10.6 KB
|
|
|
04 - Change chart types and layouts.mp4
|
MP4
|
6.1 MB
|
|
|
04 - Change chart types and layouts.srt
|
SRT
|
4.8 KB
|
|
|
04 - Change the data field summary operation.mp4
|
MP4
|
11.2 MB
|
|
|
04 - Change the data field summary operation.srt
|
SRT
|
7.1 KB
|
|
|
04 - Control how Excel copies and pastes formulas.mp4
|
MP4
|
10.9 MB
|
|
|
04 - Control how Excel copies and pastes formulas.srt
|
SRT
|
8.4 KB
|
|
|
04 - Copy cell formats.mp4
|
MP4
|
11.3 MB
|
|
|
04 - Copy cell formats.srt
|
SRT
|
7.6 KB
|
|
|
04 - Create named ranges.mp4
|
MP4
|
14.5 MB
|
|
|
04 - Create named ranges.srt
|
SRT
|
7.5 KB
|
|
|
04 - Insert, move, and delete cells and cell ranges.mp4
|
MP4
|
9.9 MB
|
|
|
04 - Insert, move, and delete cells and cell ranges.srt
|
SRT
|
6.9 KB
|
|
|
04 - Print a worksheet or workbook.mp4
|
MP4
|
10.5 MB
|
|
|
04 - Print a worksheet or workbook.srt
|
SRT
|
6 KB
|
|
|
04 - Set program preferences.mp4
|
MP4
|
12.1 MB
|
|
|
04 - Set program preferences.srt
|
SRT
|
8.5 KB
|
|
|
04_01_Sort.xlsx
|
XLSX
|
10.6 KB
|
|
|
04_02_CustomSort.xlsx
|
XLSX
|
10.3 KB
|
|
|
04_03_Filter.xlsx
|
XLSX
|
10 KB
|
|
|
04_04_ManageCells.xlsx
|
XLSX
|
10.2 KB
|
|
|
04_05_ManageWorksheets.xlsx
|
XLSX
|
12.8 KB
|
|
|
05 - Change the format of a data field.mp4
|
MP4
|
6.8 MB
|
|
|
05 - Change the format of a data field.srt
|
SRT
|
4.7 KB
|
|
|
05 - Create an Excel table.mp4
|
MP4
|
16.3 MB
|
|
|
05 - Create an Excel table.srt
|
SRT
|
10.5 KB
|
|
|
05 - Format chart elements.mp4
|
MP4
|
7.9 MB
|
|
|
05 - Format chart elements.srt
|
SRT
|
6.3 KB
|
|
|
05 - Get help in Excel.mp4
|
MP4
|
7.5 MB
|
|
|
05 - Get help in Excel.srt
|
SRT
|
4.6 KB
|
|
|
05 - Manage cell styles.mp4
|
MP4
|
15.3 MB
|
|
|
05 - Manage cell styles.srt
|
SRT
|
10.3 KB
|
|
|
05 - Manage worksheets.mp4
|
MP4
|
7.8 MB
|
|
|
05 - Manage worksheets.srt
|
SRT
|
5.5 KB
|
|
|
05 - Refer to Excel table data in formulas.mp4
|
MP4
|
9.7 MB
|
|
|
05 - Refer to Excel table data in formulas.srt
|
SRT
|
6.2 KB
|
|
|
05 - Set and remove print areas.mp4
|
MP4
|
6.7 MB
|
|
|
05 - Set and remove print areas.srt
|
SRT
|
4.6 KB
|
|
|
05_01_Introducing.xlsx
|
XLSX
|
10.7 KB
|
|
|
05_02_CreateFormula.xlsx
|
XLSX
|
10.9 KB
|
|
|
05_03_RelativeAndAbsolute.xlsx
|
XLSX
|
10.2 KB
|
|
|
05_04_CopyFormulas.xlsx
|
XLSX
|
9.3 KB
|
|
|
05_05_TableReferences.xlsx
|
XLSX
|
12 KB
|
|
|
05_06_StatusBar.xlsx
|
XLSX
|
9.7 KB
|
|
|
05_07_Conditional.xlsx
|
XLSX
|
12.2 KB
|
|
|
05_08_Tracing.xlsx
|
XLSX
|
11.3 KB
|
|
|
06 - Create a PivotChart.mp4
|
MP4
|
11.1 MB
|
|
|
06 - Create a PivotChart.srt
|
SRT
|
6.3 KB
|
|
|
06 - Create rule-based conditional formats.mp4
|
MP4
|
8.3 MB
|
|
|
06 - Create rule-based conditional formats.srt
|
SRT
|
5.5 KB
|
|
|
06 - Export workbooks to other formats.mp4
|
MP4
|
7.6 MB
|
|
|
06 - Export workbooks to other formats.srt
|
SRT
|
4.3 KB
|
|
|
06 - Locate and change data using Find and Replace.mp4
|
MP4
|
12.9 MB
|
|
|
06 - Locate and change data using Find and Replace.srt
|
SRT
|
8.8 KB
|
|
|
06 - Manage chart axes and numbering.mp4
|
MP4
|
13.4 MB
|
|
|
06 - Manage chart axes and numbering.srt
|
SRT
|
9.6 KB
|
|
|
06 - Summarize data on the status bar.mp4
|
MP4
|
7 MB
|
|
|
06 - Summarize data on the status bar.srt
|
SRT
|
4.8 KB
|
|
|
06_01_BasicFormatting.xlsx
|
XLSX
|
9.5 KB
|
|
|
06_02_Alignment.xlsx
|
XLSX
|
9.3 KB
|
|
|
06_03_NumberFormats.xlsx
|
XLSX
|
9 KB
|
|
|
06_04_CopyFormat.xlsx
|
XLSX
|
9.5 KB
|
|
|
06_05_CellStyle.xlsx
|
XLSX
|
9.8 KB
|
|
|
06_06_Conditional.xlsx
|
XLSX
|
9.1 KB
|
|
|
06_07_DataBars.xlsx
|
XLSX
|
9.2 KB
|
|
|
06_08_ColorScales.xlsx
|
XLSX
|
9.9 KB
|
|
|
06_09_IconSets.xlsx
|
XLSX
|
9.3 KB
|
|
|
06_10_ManageConditions.xlsx
|
XLSX
|
9.2 KB
|
|
|
07 - Create sparkline charts.mp4
|
MP4
|
12.8 MB
|
|
|
07 - Create sparkline charts.srt
|
SRT
|
8.8 KB
|
|
|
07 - Define data bar conditional formats.mp4
|
MP4
|
9.6 MB
|
|
|
07 - Define data bar conditional formats.srt
|
SRT
|
6.8 KB
|
|
|
07 - Guide cell input using validation rules.mp4
|
MP4
|
13.5 MB
|
|
|
07 - Guide cell input using validation rules.srt
|
SRT
|
10 KB
|
|
|
07 - Summarize data using IF functions.mp4
|
MP4
|
20.1 MB
|
|
|
07 - Summarize data using IF functions.srt
|
SRT
|
12.5 KB
|
|
|
07_01_Column.xlsx
|
XLSX
|
10.2 KB
|
|
|
07_02_Line.xlsx
|
XLSX
|
10.1 KB
|
|
|
07_03_XYChart.xlsx
|
XLSX
|
10.6 KB
|
|
|
07_04_Layout.xlsx
|
XLSX
|
15.5 KB
|
|
|
07_05_Elements.xlsx
|
XLSX
|
15.4 KB
|
|
|
07_06_Axes.xlsx
|
XLSX
|
15.4 KB
|
|
|
07_07_Sparkline.xlsx
|
XLSX
|
10.3 KB
|
|
|
08 - Define color scale conditional formats.mp4
|
MP4
|
9.9 MB
|
|
|
08 - Define color scale conditional formats.srt
|
SRT
|
6 KB
|
|
|
08 - Enable data entry using validation lists.mp4
|
MP4
|
10.7 MB
|
|
|
08 - Enable data entry using validation lists.srt
|
SRT
|
8.1 KB
|
|
|
08 - Identify precedents and dependents.mp4
|
MP4
|
9.8 MB
|
|
|
08 - Identify precedents and dependents.srt
|
SRT
|
7 KB
|
|
|
08_01_CreatePivot.xlsx
|
XLSX
|
42.9 KB
|
|
|
08_02_Pivot.xlsx
|
XLSX
|
61.2 KB
|
|
|
08_03_Totals.xlsx
|
XLSX
|
61.3 KB
|
|
|
08_04_Summary.xlsx
|
XLSX
|
61.7 KB
|
|
|
08_05_Format.xlsx
|
XLSX
|
61.7 KB
|
|
|
08_06_PivotChart.xlsx
|
XLSX
|
42.9 KB
|
|
|
09 - Define icon set conditional formats.mp4
|
MP4
|
11.7 MB
|
|
|
09 - Define icon set conditional formats.srt
|
SRT
|
7.4 KB
|
|
|
09_01_Spelling.xlsx
|
XLSX
|
10.1 KB
|
|
|
09_02_AutoCorrect.xlsx
|
XLSX
|
8.7 KB
|
|
|
09_03_Comments.xlsx
|
XLSX
|
10.1 KB
|
|
|
09_04_Print.xlsx
|
XLSX
|
11.2 KB
|
|
|
09_05_PrintAreas.xlsx
|
XLSX
|
10.4 KB
|
|
|
09_06_Export.csv
|
CSV
|
1.8 KB
|
|
|
09_06_Export.xlsx
|
XLSX
|
11.2 KB
|
|
|
10 - Manage conditional formats.mp4
|
MP4
|
11 MB
|
|
|
10 - Manage conditional formats.srt
|
SRT
|
7.4 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
