| 01 - Additional resources.mp4 | 1.5 MB | ||
| 01 - Additional resources.srt | 2 KB | ||
| 01 - Analyze your data effectively using Excel for Mac.mp4 | 1.6 MB | ||
| 01 - Analyze your data effectively using Excel for Mac.srt | 1.1 KB | ||
| 01 - Apply fonts, background colors, and borders.mp4 | 13.6 MB | ||
| 01 - Apply fonts, background colors, and borders.srt | 7.5 KB | ||
| 01 - Check spelling.mp4 | 7.7 MB | ||
| 01 - Check spelling.srt | 5.8 KB | ||
| 01 - Create a PivotTable.mp4 | 11.1 MB | ||
| 01 - Create a PivotTable.srt | 5.8 KB | ||
| 01 - Create bar and column charts.mp4 | 10.3 MB | ||
| 01 - Create bar and column charts.srt | 6.7 KB | ||
| 01 - Introduce Excel formulas, functions, and operators.mp4 | 6.9 MB | ||
| 01 - Introduce Excel formulas, functions, and operators.srt | 5.6 KB | ||
| 01 - Open, create, and, save workbooks.mp4 | 8.8 MB | ||
| 01 - Select cells and groups of cells.mp4 | 16.6 MB | ||
| 01 - Select cells and groups of cells.srt | 8.5 KB | ||
| 01 - Sort worksheet data.mp4 | 12 MB | ||
| 01 - Sort worksheet data.srt | 6.8 KB | ||
| 01 - What can you do with Excel for Mac.mp4 | 7.1 MB | ||
| 01 - What can you do with Excel for Mac.srt | 4.6 KB | ||
| 01_01_WhatToDo.xlsx | 14.7 KB | ||
| 01_03_RibbonTour.xlsx | 13.2 KB | ||
| 01_04_Preferences.xlsx | 10.7 KB | ||
| 01_05_GettingHelp.xlsx | 10.7 KB | ||
| 02 - Add a formula to a cell.mp4 | 13.3 MB | ||
| 02 - Add a formula to a cell.srt | 9.6 KB | ||
| 02 - Apply number and date formats to cells.mp4 | 10.8 MB | ||
| 02 - Apply number and date formats to cells.srt | 7.8 KB | ||
| 02 - Copy and paste cell data.mp4 | 18.1 MB | ||
| 02 - Copy and paste cell data.srt | 8.4 KB | ||
| 02 - Create a custom sort order.mp4 | 12.7 MB | ||
| 02 - Create a custom sort order.srt | 8.3 KB | ||
| 02 - Create line charts.mp4 | 9.2 MB | ||
| 02 - Create line charts.srt | 6.2 KB | ||
| 02 - Explore the Excel for Mac program window.mp4 | 7.1 MB | ||
| 02 - Pivot a PivotTable.mp4 | 7.8 MB | ||
| 02 - Pivot a PivotTable.srt | 5 KB | ||
| 02 - Set AutoCorrect and AutoReplace options.mp4 | 9.3 MB | ||
| 02 - Set AutoCorrect and AutoReplace options.srt | 7.9 KB | ||
| 02 - Set workbook properties.mp4 | 7.3 MB | ||
| 02 - Set workbook properties.srt | 5.2 KB | ||
| 02_01_ManageWorkbooks.xlsx | 10.5 KB | ||
| 02_02_Properties.xlsx | 10.4 KB | ||
| 02_03_Template.xlsx | 11 KB | ||
| 03 - Create XY (scatter) charts.mp4 | 5.6 MB | ||
| 03 - Create XY (scatter) charts.srt | 4.7 KB | ||
| 03 - Create and modify templates.mp4 | 9.2 MB | ||
| 03 - Create and modify templates.srt | 6.7 KB | ||
| 03 - Enter data using AutoFill and other techniques.mp4 | 13.2 MB | ||
| 03 - Enter data using AutoFill and other techniques.srt | 10.6 KB | ||
| 03 - Filter worksheet data.mp4 | 11.7 MB | ||
| 03 - Filter worksheet data.srt | 9 KB | ||
| 03 - Introduce the ribbon.mp4 | 9 MB | ||
| 03 - Introduce the ribbon.srt | 5.6 KB | ||
| 03 - Manage subtotals and grand totals.mp4 | 9.6 MB | ||
| 03 - Manage subtotals and grand totals.srt | 7.4 KB | ||
| 03 - Manage text alignment.mp4 | 17.8 MB | ||
| 03 - Manage text alignment.srt | 12.5 KB | ||
| 03 - Manage workbook comments.mp4 | 9.8 MB | ||
| 03 - Manage workbook comments.srt | 7.8 KB | ||
| 03 - Use relative and absolute cell references.mp4 | 16.9 MB | ||
| 03 - Use relative and absolute cell references.srt | 11.9 KB | ||
| 03_01_Select.xlsx | 11.3 KB | ||
| 03_02_CopyPaste.xlsx | 11.3 KB | ||
| 03_03_EnterData.xlsx | 11.3 KB | ||
| 03_04_NamedRanges.xlsx | 11.4 KB | ||
| 03_05_ExcelTables.xlsx | 10 KB | ||
| 03_06_Find.xlsx | 9.9 KB | ||
| 03_07_Validation.xlsx | 9.7 KB | ||
| 03_08_List.xlsx | 10.6 KB | ||
| 04 - Change chart types and layouts.mp4 | 6.1 MB | ||
| 04 - Change chart types and layouts.srt | 4.8 KB | ||
| 04 - Change the data field summary operation.mp4 | 11.2 MB | ||
| 04 - Change the data field summary operation.srt | 7.1 KB | ||
| 04 - Control how Excel copies and pastes formulas.mp4 | 10.9 MB | ||
| 04 - Control how Excel copies and pastes formulas.srt | 8.4 KB | ||
| 04 - Copy cell formats.mp4 | 11.3 MB | ||
| 04 - Copy cell formats.srt | 7.6 KB | ||
| 04 - Create named ranges.mp4 | 14.5 MB | ||
| 04 - Create named ranges.srt | 7.5 KB | ||
| 04 - Insert, move, and delete cells and cell ranges.mp4 | 9.9 MB | ||
| 04 - Insert, move, and delete cells and cell ranges.srt | 6.9 KB | ||
| 04 - Print a worksheet or workbook.mp4 | 10.5 MB | ||
| 04 - Print a worksheet or workbook.srt | 6 KB | ||
| 04 - Set program preferences.mp4 | 12.1 MB | ||
| 04 - Set program preferences.srt | 8.5 KB | ||
| 04_01_Sort.xlsx | 10.6 KB | ||
| 04_02_CustomSort.xlsx | 10.3 KB | ||
| 04_03_Filter.xlsx | 10 KB | ||
| 04_04_ManageCells.xlsx | 10.2 KB | ||
| 04_05_ManageWorksheets.xlsx | 12.8 KB | ||
| 05 - Change the format of a data field.mp4 | 6.8 MB | ||
| 05 - Change the format of a data field.srt | 4.7 KB | ||
| 05 - Create an Excel table.mp4 | 16.3 MB | ||
| 05 - Create an Excel table.srt | 10.5 KB | ||
| 05 - Format chart elements.mp4 | 7.9 MB | ||
| 05 - Format chart elements.srt | 6.3 KB | ||
| 05 - Get help in Excel.mp4 | 7.5 MB | ||
| 05 - Get help in Excel.srt | 4.6 KB | ||
| 05 - Manage cell styles.mp4 | 15.3 MB | ||
| 05 - Manage cell styles.srt | 10.3 KB | ||
| 05 - Manage worksheets.mp4 | 7.8 MB | ||
| 05 - Manage worksheets.srt | 5.5 KB | ||
| 05 - Refer to Excel table data in formulas.mp4 | 9.7 MB | ||
| 05 - Refer to Excel table data in formulas.srt | 6.2 KB | ||
| 05 - Set and remove print areas.mp4 | 6.7 MB | ||
| 05 - Set and remove print areas.srt | 4.6 KB | ||
| 05_01_Introducing.xlsx | 10.7 KB | ||
| 05_02_CreateFormula.xlsx | 10.9 KB | ||
| 05_03_RelativeAndAbsolute.xlsx | 10.2 KB | ||
| 05_04_CopyFormulas.xlsx | 9.3 KB | ||
| 05_05_TableReferences.xlsx | 12 KB | ||
| 05_06_StatusBar.xlsx | 9.7 KB | ||
| 05_07_Conditional.xlsx | 12.2 KB | ||
| 05_08_Tracing.xlsx | 11.3 KB | ||
| 06 - Create a PivotChart.mp4 | 11.1 MB | ||
| 06 - Create a PivotChart.srt | 6.3 KB | ||
| 06 - Create rule-based conditional formats.mp4 | 8.3 MB | ||
| 06 - Create rule-based conditional formats.srt | 5.5 KB | ||
| 06 - Export workbooks to other formats.mp4 | 7.6 MB | ||
| 06 - Export workbooks to other formats.srt | 4.3 KB | ||
| 06 - Locate and change data using Find and Replace.mp4 | 12.9 MB | ||
| 06 - Locate and change data using Find and Replace.srt | 8.8 KB | ||
| 06 - Manage chart axes and numbering.mp4 | 13.4 MB | ||
| 06 - Manage chart axes and numbering.srt | 9.6 KB | ||
| 06 - Summarize data on the status bar.mp4 | 7 MB | ||
| 06 - Summarize data on the status bar.srt | 4.8 KB | ||
| 06_01_BasicFormatting.xlsx | 9.5 KB | ||
| 06_02_Alignment.xlsx | 9.3 KB | ||
| 06_03_NumberFormats.xlsx | 9 KB | ||
| 06_04_CopyFormat.xlsx | 9.5 KB | ||
| 06_05_CellStyle.xlsx | 9.8 KB | ||
| 06_06_Conditional.xlsx | 9.1 KB | ||
| 06_07_DataBars.xlsx | 9.2 KB | ||
| 06_08_ColorScales.xlsx | 9.9 KB | ||
| 06_09_IconSets.xlsx | 9.3 KB | ||
| 06_10_ManageConditions.xlsx | 9.2 KB | ||
| 07 - Create sparkline charts.mp4 | 12.8 MB | ||
| 07 - Create sparkline charts.srt | 8.8 KB | ||
| 07 - Define data bar conditional formats.mp4 | 9.6 MB | ||
| 07 - Define data bar conditional formats.srt | 6.8 KB | ||
| 07 - Guide cell input using validation rules.mp4 | 13.5 MB | ||
| 07 - Guide cell input using validation rules.srt | 10 KB | ||
| 07 - Summarize data using IF functions.mp4 | 20.1 MB | ||
| 07 - Summarize data using IF functions.srt | 12.5 KB | ||
| 07_01_Column.xlsx | 10.2 KB | ||
| 07_02_Line.xlsx | 10.1 KB | ||
| 07_03_XYChart.xlsx | 10.6 KB | ||
| 07_04_Layout.xlsx | 15.5 KB | ||
| 07_05_Elements.xlsx | 15.4 KB | ||
| 07_06_Axes.xlsx | 15.4 KB | ||
| 07_07_Sparkline.xlsx | 10.3 KB | ||
| 08 - Define color scale conditional formats.mp4 | 9.9 MB | ||
| 08 - Define color scale conditional formats.srt | 6 KB | ||
| 08 - Enable data entry using validation lists.mp4 | 10.7 MB | ||
| 08 - Enable data entry using validation lists.srt | 8.1 KB | ||
| 08 - Identify precedents and dependents.mp4 | 9.8 MB | ||
| 08 - Identify precedents and dependents.srt | 7 KB | ||
| 08_01_CreatePivot.xlsx | 42.9 KB | ||
| 08_02_Pivot.xlsx | 61.2 KB | ||
| 08_03_Totals.xlsx | 61.3 KB | ||
| 08_04_Summary.xlsx | 61.7 KB | ||
| 08_05_Format.xlsx | 61.7 KB | ||
| 08_06_PivotChart.xlsx | 42.9 KB | ||
| 09 - Define icon set conditional formats.mp4 | 11.7 MB | ||
| 09 - Define icon set conditional formats.srt | 7.4 KB | ||
| 09_01_Spelling.xlsx | 10.1 KB | ||
| 09_02_AutoCorrect.xlsx | 8.7 KB | ||
| 09_03_Comments.xlsx | 10.1 KB | ||
| 09_04_Print.xlsx | 11.2 KB | ||
| 09_05_PrintAreas.xlsx | 10.4 KB | ||
| 09_06_Export.csv | 1.8 KB | ||
| 09_06_Export.xlsx | 11.2 KB | ||
| 10 - Manage conditional formats.mp4 | 11 MB | ||
| 10 - Manage conditional formats.srt | 7.4 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 178 total files | |||
Excel for Mac Essential Training (Microsoft 365) (2024)
https://FreeCourseWeb.com
Released: 08/2024
Duration: 4h 29m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 630 MB
Level: Beginner + Intermediate | Genre: eLearning | Language: English
Excel for Mac is a powerful tool, but it can be intimidating for new users who either don't know where to start or don't know how to proceed beyond the most basic tasks. In this course, learn how to master the essential tasks in the Mac version of Excel for Microsoft 365. Excel expert Curt Frye shows how to manage workbooks, work with cells and cell data, and sort, filter, and manage worksheets. Plus, learn how to summarize data using core functions and formulas; format worksheet elements; create bar, column, and line charts; create and filter PivotTables; and share your spreadsheets with others.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 week | 1 | 11 |
| 301 MB | freecoursewb | 1 week | 7 | 2 | |
| 2.4 GB | freecoursewb | 3 weeks | 1 | 35 | |
| 3.7 GB | freecoursewb | 4 weeks | 15 | 3 | |
|
Complete Guide to Next Gen Excel Formulas for Data Analysts by Microsoft Press Posted by
freecoursewb in Other
|
823.2 MB | freecoursewb | 4 weeks | 0 | 0 |
All Comments