Lynda - Excel 2016 - Avoiding Common Mistakes
File List
- 01. Data Entry and Design Tips/05 - Shortcuts, tips, and techniques.MP4 18.4 MB
- 05. Tracking Down Mistake in Large, Complex Spreadsheets/02 - Compare two versions of a workbook with Spreadsheet Compare.MP4 14.5 MB
- 03. Data Validation/03 - Force entries to be picked from a list.MP4 13.0 MB
- 04. Formula Tips/01 - Use row and column references.MP4 12.1 MB
- 04. Formula Tips/02 - Enter function names faster and evaluate portions of formulas.MP4 11.8 MB
- 01. Data Entry and Design Tips/01 - Reducing data entry and typing.MP4 11.7 MB
- 05. Tracking Down Mistake in Large, Complex Spreadsheets/01 - Analyze a workbook with Spreadsheet Inquire.MP4 11.3 MB
- 01. Data Entry and Design Tips/03 - Use shortcuts and automatic features.MP4 11.1 MB
- 01. Data Entry and Design Tips/04 - Structure entries; avoid multiple dates; keep titles in a single row.MP4 10.4 MB
- 03. Data Validation/01 - Restrict data entry with constraints.MP4 9.8 MB
- 04. Formula Tips/05 - Use Range Names.MP4 9.3 MB
- 03. Data Validation/04 - Base entries on formulas.MP4 9.0 MB
- 02. Protecting Worksheets and Workbooks with Prevention Tools/01 - Lock cells with worksheet protection.MP4 8.5 MB
- 03. Data Validation/02 - Prevent duplicate entries.MP4 8.5 MB
- 04. Formula Tips/03 - Detect errors in formulas.MP4 7.7 MB
- 01. Data Entry and Design Tips/02 - Simplify and accelerate date-time entries.MP4 7.6 MB
- 02. Protecting Worksheets and Workbooks with Prevention Tools/02 - Protect workbooks.MP4 6.5 MB
- 04. Formula Tips/04 - Simplify formula entry with AutoSum shortcuts.MP4 5.3 MB
- 00. Introduction/01 - Welcome.MP4 2.0 MB
- 06. Conclusion/01 - Next steps.MP4 847.9 KB
- 00. Introduction/02 - Using the exercise files.MP4 551.3 KB
- Exercise Files/Ch_01.xlsx 327.6 KB
- Exercise Files/Ch_04.xlsx 186.6 KB
- Exercise Files/Ch_02.xlsx 114.7 KB
- Exercise Files/Ch_05a.xlsx 93.1 KB
- Exercise Files/Ch_05b.xlsx 92.9 KB
- Exercise Files/Ch_03.xlsx 29.9 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.