Lynda - Excel 2016 - Avoiding Common Mistakes
File List
| File | Size |
|---|---|
| Exercise Files/Ch_03.xlsx | 29.88 KB |
| Exercise Files/Ch_05b.xlsx | 92.89 KB |
| Exercise Files/Ch_05a.xlsx | 93.15 KB |
| Exercise Files/Ch_02.xlsx | 114.67 KB |
| Exercise Files/Ch_04.xlsx | 186.61 KB |
| Exercise Files/Ch_01.xlsx | 327.64 KB |
| 00. Introduction/02 - Using the exercise files.MP4 | 551.29 KB |
| 06. Conclusion/01 - Next steps.MP4 | 847.89 KB |
| 00. Introduction/01 - Welcome.MP4 | 2.03 MB |
| 04. Formula Tips/04 - Simplify formula entry with AutoSum shortcuts.MP4 | 5.29 MB |
| 02. Protecting Worksheets and Workbooks with Prevention Tools/02 - Protect workbooks.MP4 | 6.49 MB |
| 01. Data Entry and Design Tips/02 - Simplify and accelerate date-time entries.MP4 | 7.62 MB |
| 04. Formula Tips/03 - Detect errors in formulas.MP4 | 7.73 MB |
| 03. Data Validation/02 - Prevent duplicate entries.MP4 | 8.47 MB |
| 02. Protecting Worksheets and Workbooks with Prevention Tools/01 - Lock cells with worksheet protection.MP4 | 8.47 MB |
| 03. Data Validation/04 - Base entries on formulas.MP4 | 8.98 MB |
| 04. Formula Tips/05 - Use Range Names.MP4 | 9.27 MB |
| 03. Data Validation/01 - Restrict data entry with constraints.MP4 | 9.77 MB |
| 01. Data Entry and Design Tips/04 - Structure entries; avoid multiple dates; keep titles in a single row.MP4 | 10.36 MB |
| 01. Data Entry and Design Tips/03 - Use shortcuts and automatic features.MP4 | 11.13 MB |
| 05. Tracking Down Mistake in Large, Complex Spreadsheets/01 - Analyze a workbook with Spreadsheet Inquire.MP4 | 11.33 MB |
| 01. Data Entry and Design Tips/01 - Reducing data entry and typing.MP4 | 11.73 MB |
| 04. Formula Tips/02 - Enter function names faster and evaluate portions of formulas.MP4 | 11.77 MB |
| 04. Formula Tips/01 - Use row and column references.MP4 | 12.06 MB |
| 03. Data Validation/03 - Force entries to be picked from a list.MP4 | 12.96 MB |
| 05. Tracking Down Mistake in Large, Complex Spreadsheets/02 - Compare two versions of a workbook with Spreadsheet Compare.MP4 | 14.54 MB |
| 01. Data Entry and Design Tips/05 - Shortcuts, tips, and techniques.MP4 | 18.43 MB |
Trackers
No trackers found.