|
|
01_01_WhatToDo.xlsx
|
XLSX
|
14.6 KB
|
|
|
01_03_RibbonTour.xlsx
|
XLSX
|
13.1 KB
|
|
|
01_04_Preferences.xlsx
|
XLSX
|
10.7 KB
|
|
|
01_05_GettingHelp.xlsx
|
XLSX
|
10.7 KB
|
|
|
02_01_ManageWorkbooks.xlsx
|
XLSX
|
10.4 KB
|
|
|
02_02_Properties.xlsx
|
XLSX
|
10.2 KB
|
|
|
02_03_Template.xlsx
|
XLSX
|
10.9 KB
|
|
|
03_01_Select.xlsx
|
XLSX
|
11.2 KB
|
|
|
03_02_CopyPaste.xlsx
|
XLSX
|
11.3 KB
|
|
|
03_03_EnterData.xlsx
|
XLSX
|
11.2 KB
|
|
|
03_04_NamedRanges.xlsx
|
XLSX
|
11 KB
|
|
|
03_05_ExcelTables.xlsx
|
XLSX
|
10 KB
|
|
|
03_06_Find.xlsx
|
XLSX
|
9.8 KB
|
|
|
03_07_Validation.xlsx
|
XLSX
|
9.6 KB
|
|
|
03_08_List.xlsx
|
XLSX
|
10.4 KB
|
|
|
04_01_Sort.xlsx
|
XLSX
|
10.4 KB
|
|
|
04_02_CustomSort.xlsx
|
XLSX
|
10.2 KB
|
|
|
04_03_Filter.xlsx
|
XLSX
|
10 KB
|
|
|
04_04_ManageCells.xlsx
|
XLSX
|
10 KB
|
|
|
04_05_ManageWorksheets.xlsx
|
XLSX
|
12.7 KB
|
|
|
05_01_Introducing.xlsx
|
XLSX
|
10.8 KB
|
|
|
05_02_CreateFormula.xlsx
|
XLSX
|
11 KB
|
|
|
05_03_RelativeAndAbsolute.xlsx
|
XLSX
|
8.8 KB
|
|
|
05_04_CopyFormulas.xlsx
|
XLSX
|
9.3 KB
|
|
|
05_05_TableReferences.xlsx
|
XLSX
|
12.2 KB
|
|
|
05_06_StatusBar.xlsx
|
XLSX
|
9.8 KB
|
|
|
05_07_Conditional.xlsx
|
XLSX
|
9.9 KB
|
|
|
05_08_Tracing.xlsx
|
XLSX
|
11.4 KB
|
|
|
06_01_BasicFormatting.xlsx
|
XLSX
|
9.3 KB
|
|
|
06_02_NumberFormats.xlsx
|
XLSX
|
8.8 KB
|
|
|
06_03_Alignment.xlsx
|
XLSX
|
9.2 KB
|
|
|
06_04_CopyFormat.xlsx
|
XLSX
|
9.6 KB
|
|
|
06_05_CellStyle.xlsx
|
XLSX
|
9.7 KB
|
|
|
06_06_Conditional.xlsx
|
XLSX
|
9.1 KB
|
|
|
06_07_DataBars.xlsx
|
XLSX
|
9.3 KB
|
|
|
06_08_ManageConditions.xlsx
|
XLSX
|
9.2 KB
|
|
|
07_01_Column.xlsx
|
XLSX
|
10.1 KB
|
|
|
07_02_Line.xlsx
|
XLSX
|
10 KB
|
|
|
07_03_XYChart.xlsx
|
XLSX
|
10.5 KB
|
|
|
07_04_Layout.xlsx
|
XLSX
|
15.4 KB
|
|
|
07_05_Elements.xlsx
|
XLSX
|
15.3 KB
|
|
|
07_06_Axes.xlsx
|
XLSX
|
15.3 KB
|
|
|
07_07_Sparkline.xlsx
|
XLSX
|
10.3 KB
|
|
|
08_01_CreatePivot.xlsx
|
XLSX
|
43.1 KB
|
|
|
08_02_Pivot.xlsx
|
XLSX
|
61.4 KB
|
|
|
08_03_Totals.xlsx
|
XLSX
|
61.5 KB
|
|
|
08_04_Summary.xlsx
|
XLSX
|
61.8 KB
|
|
|
08_05_Format.xlsx
|
XLSX
|
61.8 KB
|
|
|
09_01_Spelling.xlsx
|
XLSX
|
10 KB
|
|
|
09_02_AutoCorrect.xlsx
|
XLSX
|
8.6 KB
|
|
|
09_03_Comments.xlsx
|
XLSX
|
10 KB
|
|
|
09_04_Print.xlsx
|
XLSX
|
11.2 KB
|
|
|
09_05_PrintAreas.xlsx
|
XLSX
|
10.3 KB
|
|
|
09_06_Export.xlsx
|
XLSX
|
11.2 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
[1] Apply fonts, background colors, and borders.mp4
|
MP4
|
18.7 MB
|
|
|
[1] Apply fonts, background colors, and borders.srt
|
SRT
|
9.9 KB
|
|
|
[1] Check spelling.mp4
|
MP4
|
6.7 MB
|
|
|
[1] Check spelling.srt
|
SRT
|
4.5 KB
|
|
|
[1] Create a PivotTable.mp4
|
MP4
|
14.7 MB
|
|
|
[1] Create a PivotTable.srt
|
SRT
|
6 KB
|
|
|
[1] Create bar and column charts.mp4
|
MP4
|
10.1 MB
|
|
|
[1] Create bar and column charts.srt
|
SRT
|
6.2 KB
|
|
|
[1] Further information.mp4
|
MP4
|
1.7 MB
|
|
|
[1] Further information.srt
|
SRT
|
1.7 KB
|
|
|
[1] Introduce Excel formulas, functions, and operators.mp4
|
MP4
|
8.2 MB
|
|
|
[1] Introduce Excel formulas, functions, and operators.srt
|
SRT
|
5.7 KB
|
|
|
[1] Learn how to succeed with Excel for Mac.mp4
|
MP4
|
2.8 MB
|
|
|
[1] Learn how to succeed with Excel for Mac.srt
|
SRT
|
921.6 B
|
|
|
[1] Open, create, and save workbooks.mp4
|
MP4
|
9.8 MB
|
|
|
[1] Open, create, and save workbooks.srt
|
SRT
|
5.6 KB
|
|
|
[1] Select cells and groups of cells.mp4
|
MP4
|
17.5 MB
|
|
|
[1] Select cells and groups of cells.srt
|
SRT
|
8.3 KB
|
|
|
[1] Sort worksheet data.mp4
|
MP4
|
10.9 MB
|
|
|
[1] Sort worksheet data.srt
|
SRT
|
6.6 KB
|
|
|
[1] What can you do with Excel for Mac.mp4
|
MP4
|
7.2 MB
|
|
|
[1] What can you do with Excel for Mac.srt
|
SRT
|
4.4 KB
|
|
|
[2] Add a formula to a cell.mp4
|
MP4
|
17.9 MB
|
|
|
[2] Add a formula to a cell.srt
|
SRT
|
11.5 KB
|
|
|
[2] Apply number and date formats to cells.mp4
|
MP4
|
10.8 MB
|
|
|
[2] Apply number and date formats to cells.srt
|
SRT
|
6.9 KB
|
|
|
[2] Copy and paste cell data.mp4
|
MP4
|
15.3 MB
|
|
|
[2] Copy and paste cell data.srt
|
SRT
|
7.8 KB
|
|
|
[2] Create a custom sort order.mp4
|
MP4
|
13.7 MB
|
|
|
[2] Create a custom sort order.srt
|
SRT
|
7.7 KB
|
|
|
[2] Create line charts.mp4
|
MP4
|
8.2 MB
|
|
|
[2] Create line charts.srt
|
SRT
|
5.3 KB
|
|
|
[2] Explore the Excel for Mac program window.mp4
|
MP4
|
11.5 MB
|
|
|
[2] Explore the Excel for Mac program window.srt
|
SRT
|
7.1 KB
|
|
|
[2] Pivot a PivotTable.mp4
|
MP4
|
8.9 MB
|
|
|
[2] Pivot a PivotTable.srt
|
SRT
|
5.6 KB
|
|
|
[2] Set AutoCorrect and automatic Replace options.mp4
|
MP4
|
8.4 MB
|
|
|
[2] Set AutoCorrect and automatic Replace options.srt
|
SRT
|
5.6 KB
|
|
|
[2] Set workbook properties.mp4
|
MP4
|
7.2 MB
|
|
|
[2] Set workbook properties.srt
|
SRT
|
4.7 KB
|
|
|
[2] What you should know.mp4
|
MP4
|
1.6 MB
|
|
|
[2] What you should know.srt
|
SRT
|
1.5 KB
|
|
|
[3] Create XY (scatter) charts.mp4
|
MP4
|
6.2 MB
|
|
|
[3] Create XY (scatter) charts.srt
|
SRT
|
4.4 KB
|
|
|
[3] Create and modify templates.mp4
|
MP4
|
6.1 MB
|
|
|
[3] Create and modify templates.srt
|
SRT
|
3.7 KB
|
|
|
[3] Enter data using AutoFill and other techniques.mp4
|
MP4
|
12.4 MB
|
|
|
[3] Enter data using AutoFill and other techniques.srt
|
SRT
|
9 KB
|
|
|
[3] Filter worksheet data.mp4
|
MP4
|
11.3 MB
|
|
|
[3] Filter worksheet data.srt
|
SRT
|
6.6 KB
|
|
|
[3] Manage subtotals and grand totals.mp4
|
MP4
|
11.5 MB
|
|
|
[3] Manage subtotals and grand totals.srt
|
SRT
|
5.7 KB
|
|
|
[3] Manage text alignment.mp4
|
MP4
|
11 MB
|
|
|
[3] Manage text alignment.srt
|
SRT
|
7 KB
|
|
|
[3] Manage workbook comments.mp4
|
MP4
|
6.8 MB
|
|
|
[3] Manage workbook comments.srt
|
SRT
|
4.3 KB
|
|
|
[3] The ribbon.mp4
|
MP4
|
14.2 MB
|
|
|
[3] The ribbon.srt
|
SRT
|
8.1 KB
|
|
|
[3] Use relative and absolute cell references.mp4
|
MP4
|
10.7 MB
|
|
|
[3] Use relative and absolute cell references.srt
|
SRT
|
7.5 KB
|
|
|
[4] Change chart types and layouts.mp4
|
MP4
|
6.3 MB
|
|
|
[4] Change chart types and layouts.srt
|
SRT
|
4.8 KB
|
|
|
[4] Change the data field summary operation.mp4
|
MP4
|
15.8 MB
|
|
|
[4] Change the data field summary operation.srt
|
SRT
|
8.9 KB
|
|
|
[4] Control how Excel copies and pastes formulas.mp4
|
MP4
|
11.9 MB
|
|
|
[4] Control how Excel copies and pastes formulas.srt
|
SRT
|
7.5 KB
|
|
|
[4] Copy cell formats.mp4
|
MP4
|
12.6 MB
|
|
|
[4] Copy cell formats.srt
|
SRT
|
7.8 KB
|
|
|
[4] Create named ranges.mp4
|
MP4
|
16.1 MB
|
|
|
[4] Create named ranges.srt
|
SRT
|
8.2 KB
|
|
|
[4] Insert, move, and delete cells and cell ranges.mp4
|
MP4
|
6.8 MB
|
|
|
[4] Insert, move, and delete cells and cell ranges.srt
|
SRT
|
4.2 KB
|
|
|
[4] Print a worksheet or workbook.mp4
|
MP4
|
7 MB
|
|
|
[4] Print a worksheet or workbook.srt
|
SRT
|
4 KB
|
|
|
[4] Set program preferences.mp4
|
MP4
|
12 MB
|
|
|
[4] Set program preferences.srt
|
SRT
|
6.7 KB
|
|
|
[5] Change the format of a data field.mp4
|
MP4
|
6.2 MB
|
|
|
[5] Change the format of a data field.srt
|
SRT
|
3.1 KB
|
|
|
[5] Create an Excel table.mp4
|
MP4
|
14.3 MB
|
|
|
[5] Create an Excel table.srt
|
SRT
|
8.7 KB
|
|
|
[5] Format chart elements.mp4
|
MP4
|
8.7 MB
|
|
|
[5] Format chart elements.srt
|
SRT
|
6.1 KB
|
|
|
[5] Get help in Excel.mp4
|
MP4
|
9.3 MB
|
|
|
[5] Get help in Excel.srt
|
SRT
|
5.1 KB
|
|
|
[5] Manage cell styles.mp4
|
MP4
|
16.2 MB
|
|
|
[5] Manage cell styles.srt
|
SRT
|
9.7 KB
|
|
|
[5] Manage worksheets.mp4
|
MP4
|
12.6 MB
|
|
|
[5] Manage worksheets.srt
|
SRT
|
7.1 KB
|
|
|
[5] Refer to Excel table data in formulas.mp4
|
MP4
|
7.5 MB
|
|
|
[5] Refer to Excel table data in formulas.srt
|
SRT
|
4.1 KB
|
|
|
[5] Set and remove print areas.mp4
|
MP4
|
3.4 MB
|
|
|
[5] Set and remove print areas.srt
|
SRT
|
2.4 KB
|
|
|
[6] Create rule-based conditional formats.mp4
|
MP4
|
10.5 MB
|
|
|
[6] Create rule-based conditional formats.srt
|
SRT
|
6.2 KB
|
|
|
[6] Export workbooks to other formats.mp4
|
MP4
|
5.9 MB
|
|
|
[6] Export workbooks to other formats.srt
|
SRT
|
3.2 KB
|
|
|
[6] Locate and change data using Find and Replace.mp4
|
MP4
|
11.9 MB
|
|
|
[6] Locate and change data using Find and Replace.srt
|
SRT
|
7.2 KB
|
|
|
[6] Manage chart axes and numbering.mp4
|
MP4
|
12 MB
|
|
|
[6] Manage chart axes and numbering.srt
|
SRT
|
7.8 KB
|
|
|
[6] Summarize data on the status bar.mp4
|
MP4
|
6.4 MB
|
|
|
[6] Summarize data on the status bar.srt
|
SRT
|
4 KB
|
|
|
[7] Create sparkline charts.mp4
|
MP4
|
11 MB
|
|
|
[7] Create sparkline charts.srt
|
SRT
|
6.4 KB
|
|
|
[7] Define data bar, color scale, and icon set conditional formats.mp4
|
MP4
|
21.1 MB
|
|
|
[7] Define data bar, color scale, and icon set conditional formats.srt
|
SRT
|
10.1 KB
|
|
|
[7] Guide cell input using validation rules.mp4
|
MP4
|
13.8 MB
|
|
|
[7] Guide cell input using validation rules.srt
|
SRT
|
9.2 KB
|
|
|
[7] Summarize data using IF functions.mp4
|
MP4
|
13.5 MB
|
|
|
[7] Summarize data using IF functions.srt
|
SRT
|
7.9 KB
|
|
|
[8] Enable data entry using validation lists.mp4
|
MP4
|
11.9 MB
|
|
|
[8] Enable data entry using validation lists.srt
|
SRT
|
7.7 KB
|
|
|
[8] Identify precedents and dependents.mp4
|
MP4
|
9.8 MB
|
|
|
[8] Identify precedents and dependents.srt
|
SRT
|
6 KB
|
|
|
[8] Manage conditional formats.mp4
|
MP4
|
13.4 MB
|
|
|
[8] Manage conditional formats.srt
|
SRT
|
7.7 KB
|
![[ FreeCourseWeb ] Linkedin - Excel for Mac Essential Training (Office 365 - Microsoft 365)](/static/img/no-torrent-image.png "[ FreeCourseWeb ] Linkedin - Excel for Mac Essential Training (Office 365 - Microsoft 365)")
