Lynda - Excel 2016 - Avoiding Common Mistakes
- 收录时间:2018-03-01 14:35:35
- 文件大小:191MB
- 下载次数:249
- 最近下载:2021-01-20 21:55:19
- 磁力链接:
-
文件列表
- 01. Data Entry and Design Tips/05 - Shortcuts, tips, and techniques.MP4 18MB
- 05. Tracking Down Mistake in Large, Complex Spreadsheets/02 - Compare two versions of a workbook with Spreadsheet Compare.MP4 15MB
- 03. Data Validation/03 - Force entries to be picked from a list.MP4 13MB
- 04. Formula Tips/01 - Use row and column references.MP4 12MB
- 04. Formula Tips/02 - Enter function names faster and evaluate portions of formulas.MP4 12MB
- 01. Data Entry and Design Tips/01 - Reducing data entry and typing.MP4 12MB
- 05. Tracking Down Mistake in Large, Complex Spreadsheets/01 - Analyze a workbook with Spreadsheet Inquire.MP4 11MB
- 01. Data Entry and Design Tips/03 - Use shortcuts and automatic features.MP4 11MB
- 01. Data Entry and Design Tips/04 - Structure entries; avoid multiple dates; keep titles in a single row.MP4 10MB
- 03. Data Validation/01 - Restrict data entry with constraints.MP4 10MB
- 04. Formula Tips/05 - Use Range Names.MP4 9MB
- 03. Data Validation/04 - Base entries on formulas.MP4 9MB
- 02. Protecting Worksheets and Workbooks with Prevention Tools/01 - Lock cells with worksheet protection.MP4 8MB
- 03. Data Validation/02 - Prevent duplicate entries.MP4 8MB
- 04. Formula Tips/03 - Detect errors in formulas.MP4 8MB
- 01. Data Entry and Design Tips/02 - Simplify and accelerate date-time entries.MP4 8MB
- 02. Protecting Worksheets and Workbooks with Prevention Tools/02 - Protect workbooks.MP4 6MB
- 04. Formula Tips/04 - Simplify formula entry with AutoSum shortcuts.MP4 5MB
- 00. Introduction/01 - Welcome.MP4 2MB
- 06. Conclusion/01 - Next steps.MP4 848KB
- 00. Introduction/02 - Using the exercise files.MP4 551KB
- Exercise Files/Ch_01.xlsx 328KB
- Exercise Files/Ch_04.xlsx 187KB
- Exercise Files/Ch_02.xlsx 115KB
- Exercise Files/Ch_05a.xlsx 93KB
- Exercise Files/Ch_05b.xlsx 93KB
- Exercise Files/Ch_03.xlsx 30KB
