Lynda Excel for Mac 2016 Essential Training | C930931D4350FE72EA3E1893E7865A1B267F91E7

Lynda Excel for Mac 2016 Essential Training

Name	Lynda - Excel for Mac 2016 Essential Training	DOWNLOAD Copy Link
Total Size	936.7 MB
Total Files	101
Hash	C930931D4350FE72EA3E1893E7865A1B267F91E7

/01. Introduction/
01_01-Welcome.mp4	5.2 MB
01_02-Using the exercise files.mp4	1.0 MB
/02. Getting Started with Excel/
02_01-What you can do with Excel 2016.mp4	6.7 MB
02_02-Exploring the Excel 2016 program window.mp4	12.3 MB
02_03-Introducing the Ribbon for the Mac.mp4	10.2 MB
02_04-Setting program preferences.mp4	10.7 MB
02_05-Getting help in Excel.mp4	8.3 MB
/03. Managing Workbooks/
03_01-Opening, creating, and saving workbooks.mp4	8.7 MB
03_02-Setting workbook properties.mp4	6.5 MB
03_03-Creating and modifying workbook templates.mp4	9.0 MB
03_04-Managing workbooks across multiple versions of Excel.mp4	7.2 MB
/04. Working with Worksheets, Cells, and Cell Data/
04_01-Selecting cells and groups of cells.mp4	10.3 MB
04_02-Copying and pasting cell data.mp4	10.4 MB
04_03-Entering data using AutoFill and other techniques.mp4	9.2 MB
04_04-Inserting symbols and special characters.mp4	12.7 MB
04_05-Creating named ranges.mp4	15.4 MB
04_06-Creating an Excel table.mp4	11.0 MB
04_07-Locating and changing data using Find and Replace.mp4	14.5 MB
04_08-Restricting input using validation rules.mp4	17.7 MB
04_09-Using lists to limit data entered into a cell.mp4	7.3 MB
/05. Sorting, Filtering, and Managing Worksheets/
05_01-Sorting worksheet data.mp4	7.8 MB
05_02-Creating a custom sort order.mp4	12.0 MB
05_03-Filtering worksheet data.mp4	9.2 MB
05_04-Inserting, moving, and deleting cells and cell ranges.mp4	10.2 MB
05_05-Splitting and freezing rows and columns.mp4	15.9 MB
05_06-Managing worksheets.mp4	12.0 MB
05_07-Creating, editing, and deleting headers and footers.mp4	8.7 MB
/06. Summarizing Data Using Formulas and Functions/
06_01-Introducing Excel formulas and functions.mp4	7.1 MB
06_02-Adding a formula to a cell.mp4	9.5 MB
06_03-Introducing arithmetic operators.mp4	10.5 MB
06_04-Using relative and absolute cell references.mp4	13.8 MB
06_05-Controlling how Excel copies and pastes formulas.mp4	10.8 MB
06_06-Referring to Excel table data in formulas.mp4	8.7 MB
06_07-Creating an AutoSum formula.mp4	9.9 MB
06_08-Summarizing data on the status bar.mp4	5.5 MB
06_09-Summarizing data using an IF function.mp4	11.3 MB
06_10-Summarizing data using SUMIF and other conditional functions.mp4	15.1 MB
/07. Analyzing Data and Formulas/
07_01-Creating formulas to count cells.mp4	6.3 MB
07_02-Rounding cell values.mp4	9.5 MB
07_03-Joining text in cells with concatenation.mp4	8.5 MB
07_04-Finding data using VLOOKUP and HLOOKUP.mp4	8.1 MB
07_05-Auditing formulas by identifying precedents and dependents.mp4	7.1 MB
07_06-Managing Excel formula error indicators.mp4	10.6 MB
07_07-Managing scenarios.mp4	16.7 MB
07_08-Performing Goal Seek analysis.mp4	7.0 MB
/08. Formatting Worksheet Elements/
08_01-Applying fonts, background colors, and borders.mp4	12.4 MB
08_02-Applying number and date formats to cells.mp4	12.5 MB
08_03-Managing text alignment.mp4	11.1 MB
08_04-Copying cell formats.mp4	8.3 MB
08_05-Managing cell styles.mp4	11.1 MB
08_06-Managing Office themes.mp4	14.3 MB
08_07-Creating rulebased conditional formats.mp4	11.2 MB
08_08-Defining top 10 conditional formats.mp4	11.5 MB
08_09-Defining data bar, color scale, and icon set conditional formats.mp4	16.7 MB
08_10-Editing, ordering, and deleting conditional formats.mp4	10.1 MB
/09. Working with Charts/
09_01-Creating bar and column charts.mp4	12.5 MB
09_02-Creating pie charts.mp4	5.8 MB
09_03-Creating line charts.mp4	7.8 MB
09_04-Creating XY scatter charts.mp4	5.9 MB
09_05-Creating stock charts.mp4	6.2 MB
09_06-Changing chart types and layouts.mp4	6.1 MB
09_07-Changing the appearance of chart elements.mp4	8.5 MB
09_08-Managing chart axes and numbering.mp4	7.1 MB
09_09-Adding trendlines to charts.mp4	8.3 MB
09_10-Creating sparkline charts.mp4	10.3 MB
/10. Working with External Data/
10_01-Importing data from commaseparated value CSV or text files.mp4	9.4 MB
10_02-Connecting to an external data source.mp4	3.6 MB
10_03-Using hyperlinks.mp4	10.0 MB
10_04-Including an Excel workbook in another Office document.mp4	8.5 MB
10_05-Linking to an Excel chart from another Office program.mp4	6.0 MB
/11. Working with Objects/
11_01-Creating and formatting shapes.mp4	13.3 MB
11_02-Adding and adjusting images.mp4	13.7 MB
11_03-Manipulating text boxes.mp4	8.3 MB
11_04-Cropping, compressing, and removing image backgrounds.mp4	12.5 MB
11_05-Creating SmartArt graphics.mp4	10.0 MB
11_06-Creating WordArt.mp4	6.6 MB
11_07-Aligning and layering objects.mp4	12.6 MB
/12. Exploring PivotTables/
12_01-Introducing PivotTable reports.mp4	7.0 MB
12_02-Creating a PivotTable report.mp4	7.8 MB
12_03-Pivoting a PivotTable report.mp4	7.7 MB
12_04-Managing subtotals and grand totals.mp4	8.2 MB
12_05-Summarizing more than one data field.mp4	4.8 MB
12_06-Changing the data field summary operation.mp4	12.5 MB
12_07-Changing the data field number format.mp4	4.9 MB
12_08-Filtering a PivotTable report.mp4	15.6 MB
12_09-Applying a PivotTable style.mp4	6.7 MB
/13. Reviewing and Sharing Your Spreadsheets/
13_01-Checking spelling.mp4	6.8 MB
13_02-Setting AutoCorrect and automatic Replace options.mp4	10.5 MB
13_03-Managing workbook comments.mp4	7.8 MB
13_04-Tracking and reviewing changes.mp4	10.4 MB
13_05-Printing a worksheet or workbook.mp4	7.0 MB
13_06-Setting and removing print areas.mp4	6.4 MB
13_07-Exporting to other formats.mp4	7.0 MB
13_08-Protecting a workbook.mp4	7.9 MB
/14. Automating Workbooks Using Macros/
14_01-Running an existing macro.mp4	8.2 MB
14_02-Recording a macro.mp4	6.7 MB
14_03-Renaming, viewing, and deleting macros.mp4	6.4 MB
14_04-Adding comments to a macro.mp4	5.9 MB
14_05-Turning off screen updating in a macro.mp4	8.1 MB
/15. Conclusion/
15_01-Next steps.mp4	3.4 MB
/Exercice Files/
Ex_Files_ExcelMac2016_EssT.zip	1.4 MB
Total files 101