FreeCourseWeb com Excel for Mac Essential Training Microsoft 365 2024

FreeCourseWeb com Excel for Mac Essential Training Microsoft 365 2024

Name	[ FreeCourseWeb.com ] Excel for Mac Essential Training (Microsoft 365) (2024)	DOWNLOAD Copy Link
Total Size	661.2 MB
Total Files	178
Last Seen	2024-09-19 04:12
Hash	536843D8E47F2CCE44B62805DCEE729AF7ACA917

/
Get Bonus Downloads Here.url	0.2 KB
/01 - Introduction/
01 - Analyze your data effectively using Excel for Mac.mp4	1.7 MB
01 - Analyze your data effectively using Excel for Mac.srt	1.1 KB
/.../02 - 1. Getting Started with Excel/
01 - What can you do with Excel for Mac.mp4	7.4 MB
01 - What can you do with Excel for Mac.srt	4.7 KB
02 - Explore the Excel for Mac program window.mp4	7.4 MB
03 - Introduce the ribbon.mp4	9.4 MB
03 - Introduce the ribbon.srt	5.8 KB
04 - Set program preferences.mp4	12.6 MB
04 - Set program preferences.srt	8.7 KB
05 - Get help in Excel.mp4	7.8 MB
05 - Get help in Excel.srt	4.7 KB
/.../03 - 2. Managing Workbooks/
01 - Open, create, and, save workbooks.mp4	9.3 MB
02 - Set workbook properties.mp4	7.6 MB
02 - Set workbook properties.srt	5.3 KB
03 - Create and modify templates.mp4	9.6 MB
03 - Create and modify templates.srt	6.9 KB
/.../04 - 3. Working with Cells, Ranges, and Data/
01 - Select cells and groups of cells.mp4	17.4 MB
01 - Select cells and groups of cells.srt	8.8 KB
02 - Copy and paste cell data.mp4	19.0 MB
02 - Copy and paste cell data.srt	8.6 KB
03 - Enter data using AutoFill and other techniques.mp4	13.8 MB
03 - Enter data using AutoFill and other techniques.srt	10.9 KB
04 - Create named ranges.mp4	15.2 MB
04 - Create named ranges.srt	7.7 KB
05 - Create an Excel table.mp4	17.1 MB
05 - Create an Excel table.srt	10.7 KB
06 - Locate and change data using Find and Replace.mp4	13.5 MB
06 - Locate and change data using Find and Replace.srt	9.0 KB
07 - Guide cell input using validation rules.mp4	14.1 MB
07 - Guide cell input using validation rules.srt	10.3 KB
08 - Enable data entry using validation lists.mp4	11.2 MB
08 - Enable data entry using validation lists.srt	8.3 KB
/.../05 - 4. Sorting, Filtering, and Managing Worksheets/
01 - Sort worksheet data.mp4	12.6 MB
01 - Sort worksheet data.srt	7.0 KB
02 - Create a custom sort order.mp4	13.3 MB
02 - Create a custom sort order.srt	8.5 KB
03 - Filter worksheet data.mp4	12.2 MB
03 - Filter worksheet data.srt	9.2 KB
04 - Insert, move, and delete cells and cell ranges.mp4	10.3 MB
04 - Insert, move, and delete cells and cell ranges.srt	7.1 KB
05 - Manage worksheets.mp4	8.2 MB
05 - Manage worksheets.srt	5.6 KB
/.../06 - 5. Summarizing Data Using Formulas and Functions/
01 - Introduce Excel formulas, functions, and operators.mp4	7.2 MB
01 - Introduce Excel formulas, functions, and operators.srt	5.7 KB
02 - Add a formula to a cell.mp4	14.0 MB
02 - Add a formula to a cell.srt	9.8 KB
03 - Use relative and absolute cell references.mp4	17.7 MB
03 - Use relative and absolute cell references.srt	12.2 KB
04 - Control how Excel copies and pastes formulas.mp4	11.5 MB
04 - Control how Excel copies and pastes formulas.srt	8.6 KB
05 - Refer to Excel table data in formulas.mp4	10.2 MB
05 - Refer to Excel table data in formulas.srt	6.4 KB
06 - Summarize data on the status bar.mp4	7.4 MB
06 - Summarize data on the status bar.srt	4.9 KB
07 - Summarize data using IF functions.mp4	21.1 MB
07 - Summarize data using IF functions.srt	12.8 KB
08 - Identify precedents and dependents.mp4	10.3 MB
08 - Identify precedents and dependents.srt	7.1 KB
/.../07 - 6. Formatting Worksheet Elements/
01 - Apply fonts, background colors, and borders.mp4	14.3 MB
01 - Apply fonts, background colors, and borders.srt	7.6 KB
02 - Apply number and date formats to cells.mp4	11.4 MB
02 - Apply number and date formats to cells.srt	8.0 KB
03 - Manage text alignment.mp4	18.7 MB
03 - Manage text alignment.srt	12.8 KB
04 - Copy cell formats.mp4	11.8 MB
04 - Copy cell formats.srt	7.8 KB
05 - Manage cell styles.mp4	16.1 MB
05 - Manage cell styles.srt	10.6 KB
06 - Create rule-based conditional formats.mp4	8.7 MB
06 - Create rule-based conditional formats.srt	5.6 KB
07 - Define data bar conditional formats.mp4	10.1 MB
07 - Define data bar conditional formats.srt	7.0 KB
08 - Define color scale conditional formats.mp4	10.4 MB
08 - Define color scale conditional formats.srt	6.1 KB
09 - Define icon set conditional formats.mp4	12.2 MB
09 - Define icon set conditional formats.srt	7.5 KB
10 - Manage conditional formats.mp4	11.6 MB
10 - Manage conditional formats.srt	7.6 KB
/.../08 - 7. Working with Charts/
01 - Create bar and column charts.mp4	10.8 MB
01 - Create bar and column charts.srt	6.9 KB
02 - Create line charts.mp4	9.6 MB
02 - Create line charts.srt	6.3 KB
03 - Create XY (scatter) charts.mp4	5.9 MB
03 - Create XY (scatter) charts.srt	4.8 KB
04 - Change chart types and layouts.mp4	6.4 MB
04 - Change chart types and layouts.srt	4.9 KB
05 - Format chart elements.mp4	8.3 MB
05 - Format chart elements.srt	6.5 KB
06 - Manage chart axes and numbering.mp4	14.0 MB
06 - Manage chart axes and numbering.srt	9.8 KB
07 - Create sparkline charts.mp4	13.4 MB
07 - Create sparkline charts.srt	9.0 KB
/.../09 - 8. Exploring PivotTables/
01 - Create a PivotTable.mp4	11.7 MB
01 - Create a PivotTable.srt	5.9 KB
02 - Pivot a PivotTable.mp4	8.2 MB
02 - Pivot a PivotTable.srt	5.1 KB
03 - Manage subtotals and grand totals.mp4	10.1 MB
03 - Manage subtotals and grand totals.srt	7.6 KB
04 - Change the data field summary operation.mp4	11.7 MB
04 - Change the data field summary operation.srt	7.3 KB
05 - Change the format of a data field.mp4	7.2 MB
05 - Change the format of a data field.srt	4.8 KB
06 - Create a PivotChart.mp4	11.6 MB
06 - Create a PivotChart.srt	6.4 KB
/.../10 - 9. Reviewing and Sharing Your Spreadsheets/
01 - Check spelling.mp4	8.1 MB
01 - Check spelling.srt	5.9 KB
02 - Set AutoCorrect and AutoReplace options.mp4	9.7 MB
02 - Set AutoCorrect and AutoReplace options.srt	8.1 KB
03 - Manage workbook comments.mp4	10.2 MB
03 - Manage workbook comments.srt	8.0 KB
04 - Print a worksheet or workbook.mp4	11.0 MB
04 - Print a worksheet or workbook.srt	6.1 KB
05 - Set and remove print areas.mp4	7.0 MB
05 - Set and remove print areas.srt	4.7 KB
06 - Export workbooks to other formats.mp4	7.9 MB
06 - Export workbooks to other formats.srt	4.4 KB
/11 - Conclusion/
01 - Additional resources.mp4	1.6 MB
01 - Additional resources.srt	2.0 KB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter01/
01_01_WhatToDo.xlsx	15.1 KB
01_03_RibbonTour.xlsx	13.5 KB
01_04_Preferences.xlsx	11.0 KB
01_05_GettingHelp.xlsx	11.0 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter02/
02_01_ManageWorkbooks.xlsx	10.7 KB
02_02_Properties.xlsx	10.6 KB
02_03_Template.xlsx	11.3 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter03/
03_01_Select.xlsx	11.6 KB
03_02_CopyPaste.xlsx	11.6 KB
03_03_EnterData.xlsx	11.6 KB
03_04_NamedRanges.xlsx	11.7 KB
03_05_ExcelTables.xlsx	10.2 KB
03_06_Find.xlsx	10.2 KB
03_07_Validation.xlsx	10.0 KB
03_08_List.xlsx	10.8 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter04/
04_01_Sort.xlsx	10.9 KB
04_02_CustomSort.xlsx	10.6 KB
04_03_Filter.xlsx	10.3 KB
04_04_ManageCells.xlsx	10.4 KB
04_05_ManageWorksheets.xlsx	13.1 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter05/
05_01_Introducing.xlsx	11.0 KB
05_02_CreateFormula.xlsx	11.2 KB
05_03_RelativeAndAbsolute.xlsx	10.4 KB
05_04_CopyFormulas.xlsx	9.6 KB
05_05_TableReferences.xlsx	12.3 KB
05_06_StatusBar.xlsx	9.9 KB
05_07_Conditional.xlsx	12.5 KB
05_08_Tracing.xlsx	11.6 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter06/
06_01_BasicFormatting.xlsx	9.7 KB
06_02_Alignment.xlsx	9.5 KB
06_03_NumberFormats.xlsx	9.2 KB
06_04_CopyFormat.xlsx	9.7 KB
06_05_CellStyle.xlsx	10.1 KB
06_06_Conditional.xlsx	9.4 KB
06_07_DataBars.xlsx	9.4 KB
06_08_ColorScales.xlsx	10.1 KB
06_09_IconSets.xlsx	9.6 KB
06_10_ManageConditions.xlsx	9.4 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter07/
07_01_Column.xlsx	10.4 KB
07_02_Line.xlsx	10.3 KB
07_03_XYChart.xlsx	10.8 KB
07_04_Layout.xlsx	15.9 KB
07_05_Elements.xlsx	15.8 KB
07_06_Axes.xlsx	15.8 KB
07_07_Sparkline.xlsx	10.5 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter08/
08_01_CreatePivot.xlsx	43.9 KB
08_02_Pivot.xlsx	62.7 KB
08_03_Totals.xlsx	62.8 KB
08_04_Summary.xlsx	63.2 KB
08_05_Format.xlsx	63.2 KB
08_06_PivotChart.xlsx	43.9 KB
/.../Ex_Files_Excel_for_Mac_Essential_Training/Exercise Files/Chapter09/
09_01_Spelling.xlsx	10.4 KB
09_02_AutoCorrect.xlsx	8.9 KB
09_03_Comments.xlsx	10.4 KB
09_04_Print.xlsx	11.5 KB
09_05_PrintAreas.xlsx	10.6 KB
09_06_Export.csv	1.9 KB
09_06_Export.xlsx	11.5 KB
Total files 178