Filename Size ~Get Your Files Here !/01 - Introduction/01 - Analyze your data effectively using Excel for Mac.mp4 1.6 MB ~Get Your Files Here !/01 - Introduction/01 - Analyze your data effectively using Excel for Mac.srt 1.1 KB ~Get Your Files Here !/02 - 1. Getting Started with Excel/01 - What can you do with Excel for Mac.mp4 7.1 MB ~Get Your Files Here !/02 - 1. Getting Started with Excel/01 - What can you do with Excel for Mac.srt 4.6 KB ~Get Your Files Here !/02 - 1. Getting Started with Excel/02 - Explore the Excel for Mac program window.mp4 7.1 MB ~Get Your Files Here !/02 - 1. Getting Started with Excel/03 - Introduce the ribbon.mp4 9 MB ~Get Your Files Here !/02 - 1. Getting Started with Excel/03 - Introduce the ribbon.srt 5.6 KB ~Get Your Files Here !/02 - 1. Getting Started with Excel/04 - Set program preferences.mp4 12.1 MB ~Get Your Files Here !/02 - 1. Getting Started with Excel/04 - Set program preferences.srt 8.5 KB ~Get Your Files Here !/02 - 1. Getting Started with Excel/05 - Get help in Excel.mp4 7.5 MB ~Get Your Files Here !/02 - 1. Getting Started with Excel/05 - Get help in Excel.srt 4.6 KB ~Get Your Files Here !/03 - 2. Managing Workbooks/01 - Open, create, and, save workbooks.mp4 8.8 MB ~Get Your Files Here !/03 - 2. Managing Workbooks/02 - Set workbook properties.mp4 7.3 MB ~Get Your Files Here !/03 - 2. Managing Workbooks/02 - Set workbook properties.srt 5.2 KB ~Get Your Files Here !/03 - 2. Managing Workbooks/03 - Create and modify templates.mp4 9.2 MB ~Get Your Files Here !/03 - 2. Managing Workbooks/03 - Create and modify templates.srt 6.7 KB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/01 - Select cells and groups of cells.mp4 16.6 MB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/01 - Select cells and groups of cells.srt 8.5 KB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/02 - Copy and paste cell data.mp4 18.1 MB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/02 - Copy and paste cell data.srt 8.4 KB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/03 - Enter data using AutoFill and other techniques.mp4 13.2 MB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/03 - Enter data using AutoFill and other techniques.srt 10.6 KB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/04 - Create named ranges.mp4 14.5 MB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/04 - Create named ranges.srt 7.5 KB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/05 - Create an Excel table.mp4 16.3 MB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/05 - Create an Excel table.srt 10.5 KB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/06 - Locate and change data using Find and Replace.mp4 12.9 MB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/06 - Locate and change data using Find and Replace.srt 8.8 KB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/07 - Guide cell input using validation rules.mp4 13.5 MB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/07 - Guide cell input using validation rules.srt 10 KB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/08 - Enable data entry using validation lists.mp4 10.7 MB ~Get Your Files Here !/04 - 3. Working with Cells, Ranges, and Data/08 - Enable data entry using validation lists.srt 8.1 KB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/01 - Sort worksheet data.mp4 12 MB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/01 - Sort worksheet data.srt 6.8 KB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/02 - Create a custom sort order.mp4 12.7 MB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/02 - Create a custom sort order.srt 8.3 KB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/03 - Filter worksheet data.mp4 11.7 MB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/03 - Filter worksheet data.srt 9 KB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/04 - Insert, move, and delete cells and cell ranges.mp4 9.9 MB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/04 - Insert, move, and delete cells and cell ranges.srt 6.9 KB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/05 - Manage worksheets.mp4 7.8 MB ~Get Your Files Here !/05 - 4. Sorting, Filtering, and Managing Worksheets/05 - Manage worksheets.srt 5.5 KB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/01 - Introduce Excel formulas, functions, and operators.mp4 6.9 MB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/01 - Introduce Excel formulas, functions, and operators.srt 5.6 KB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/02 - Add a formula to a cell.mp4 13.3 MB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/02 - Add a formula to a cell.srt 9.6 KB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/03 - Use relative and absolute cell references.mp4 16.9 MB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/03 - Use relative and absolute cell references.srt 11.9 KB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/04 - Control how Excel copies and pastes formulas.mp4 10.9 MB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/04 - Control how Excel copies and pastes formulas.srt 8.4 KB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/05 - Refer to Excel table data in formulas.mp4 9.7 MB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/05 - Refer to Excel table data in formulas.srt 6.2 KB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/06 - Summarize data on the status bar.mp4 7 MB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/06 - Summarize data on the status bar.srt 4.8 KB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/07 - Summarize data using IF functions.mp4 20.1 MB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/07 - Summarize data using IF functions.srt 12.5 KB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/08 - Identify precedents and dependents.mp4 9.8 MB ~Get Your Files Here !/06 - 5. Summarizing Data Using Formulas and Functions/08 - Identify precedents and dependents.srt 7 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/01 - Apply fonts, background colors, and borders.mp4 13.6 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/01 - Apply fonts, background colors, and borders.srt 7.5 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/02 - Apply number and date formats to cells.mp4 10.8 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/02 - Apply number and date formats to cells.srt 7.8 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/03 - Manage text alignment.mp4 17.8 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/03 - Manage text alignment.srt 12.5 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/04 - Copy cell formats.mp4 11.3 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/04 - Copy cell formats.srt 7.6 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/05 - Manage cell styles.mp4 15.3 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/05 - Manage cell styles.srt 10.3 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/06 - Create rule-based conditional formats.mp4 8.3 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/06 - Create rule-based conditional formats.srt 5.5 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/07 - Define data bar conditional formats.mp4 9.6 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/07 - Define data bar conditional formats.srt 6.8 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/08 - Define color scale conditional formats.mp4 9.9 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/08 - Define color scale conditional formats.srt 6 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/09 - Define icon set conditional formats.mp4 11.7 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/09 - Define icon set conditional formats.srt 7.4 KB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/10 - Manage conditional formats.mp4 11 MB ~Get Your Files Here !/07 - 6. Formatting Worksheet Elements/10 - Manage conditional formats.srt 7.4 KB ~Get Your Files Here !/08 - 7. Working with Charts/01 - Create bar and column charts.mp4 10.3 MB ~Get Your Files Here !/08 - 7. Working with Charts/01 - Create bar and column charts.srt 6.7 KB ~Get Your Files Here !/08 - 7. Working with Charts/02 - Create line charts.mp4 9.2 MB ~Get Your Files Here !/08 - 7. Working with Charts/02 - Create line charts.srt 6.2 KB ~Get Your Files Here !/08 - 7. Working with Charts/03 - Create XY (scatter) charts.mp4 5.6 MB ~Get Your Files Here !/08 - 7. Working with Charts/03 - Create XY (scatter) charts.srt 4.7 KB ~Get Your Files Here !/08 - 7. Working with Charts/04 - Change chart types and layouts.mp4 6.1 MB ~Get Your Files Here !/08 - 7. Working with Charts/04 - Change chart types and layouts.srt 4.8 KB ~Get Your Files Here !/08 - 7. Working with Charts/05 - Format chart elements.mp4 7.9 MB ~Get Your Files Here !/08 - 7. Working with Charts/05 - Format chart elements.srt 6.3 KB ~Get Your Files Here !/08 - 7. Working with Charts/06 - Manage chart axes and numbering.mp4 13.4 MB ~Get Your Files Here !/08 - 7. Working with Charts/06 - Manage chart axes and numbering.srt 9.6 KB ~Get Your Files Here !/08 - 7. Working with Charts/07 - Create sparkline charts.mp4 12.8 MB ~Get Your Files Here !/08 - 7. Working with Charts/07 - Create sparkline charts.srt 8.8 KB ~Get Your Files Here !/09 - 8. Exploring PivotTables/01 - Create a PivotTable.mp4 11.1 MB ~Get Your Files Here !/09 - 8. Exploring PivotTables/01 - Create a PivotTable.srt 5.8 KB ~Get Your Files Here !/09 - 8. Exploring PivotTables/02 - Pivot a PivotTable.mp4 7.8 MB ~Get Your Files Here !/09 - 8. Exploring PivotTables/02 - Pivot a PivotTable.srt 5 KB ~Get Your Files Here !/09 - 8. Exploring PivotTables/03 - Manage subtotals and grand totals.mp4 9.6 MB ~Get Your Files Here !/09 - 8. Exploring PivotTables/03 - Manage subtotals and grand totals.srt 7.4 KB