Lynda Excel 2016 Avoiding Common Mistakes | 1CA5A0C1DB20FE3FB2E8FEB52B7B6B811DBD37E5

Lynda Excel 2016 Avoiding Common Mistakes

Name	Lynda - Excel 2016 - Avoiding Common Mistakes	DOWNLOAD Copy Link
Total Size	199.9 MB
Total Files	27
Hash	1CA5A0C1DB20FE3FB2E8FEB52B7B6B811DBD37E5

/Exercise Files/
Ch_03.xlsx	30.6 KB
Ch_05b.xlsx	95.1 KB
Ch_05a.xlsx	95.4 KB
Ch_02.xlsx	117.4 KB
Ch_04.xlsx	191.1 KB
Ch_01.xlsx	335.5 KB
/00. Introduction/
02 - Using the exercise files.MP4	564.5 KB
01 - Welcome.MP4	2.1 MB
/06. Conclusion/
01 - Next steps.MP4	868.2 KB
/04. Formula Tips/
04 - Simplify formula entry with AutoSum shortcuts.MP4	5.5 MB
03 - Detect errors in formulas.MP4	8.1 MB
05 - Use Range Names.MP4	9.7 MB
02 - Enter function names faster and evaluate portions of formulas.MP4	12.3 MB
01 - Use row and column references.MP4	12.6 MB
/02. Protecting Worksheets and Workbooks with Prevention Tools/
02 - Protect workbooks.MP4	6.8 MB
01 - Lock cells with worksheet protection.MP4	8.9 MB
/01. Data Entry and Design Tips/
02 - Simplify and accelerate date-time entries.MP4	8.0 MB
04 - Structure entries; avoid multiple dates; keep titles in a single row.MP4	10.9 MB
03 - Use shortcuts and automatic features.MP4	11.7 MB
01 - Reducing data entry and typing.MP4	12.3 MB
05 - Shortcuts, tips, and techniques.MP4	19.3 MB
/03. Data Validation/
02 - Prevent duplicate entries.MP4	8.9 MB
04 - Base entries on formulas.MP4	9.4 MB
01 - Restrict data entry with constraints.MP4	10.2 MB
03 - Force entries to be picked from a list.MP4	13.6 MB
/05. Tracking Down Mistake in Large, Complex Spreadsheets/
01 - Analyze a workbook with Spreadsheet Inquire.MP4	11.9 MB
02 - Compare two versions of a workbook with Spreadsheet Compare.MP4	15.2 MB
Total files 27