[Pluralsight] Managing Excel Workbooks for Analytics [2020, ENG]

Содержание

Course Overview 1m 21s Course Overview 1m 21sCreating a Workbook 17m 38s Introduction 2m 42s Demo Files 43s Demo: Input, Process, Output 1m 56s Excel Tables and Workbook Management 1m 36s Demo: Excel Tables 4m 6s Demo: Named References 5m 24s Summary 1m 7sManaging Workbooks 34m 51s Introduction 2m 20s Demo: Organizing Worksheets in a Workbook 6m 20s Demo: Viewing Worksheets in a Workbook 6m 39s Demo: Grouping Worksheets in a Workbook 5m 15s Demo: Summarizing with 3-D References 3m 56s Demo: Returning References with INDIRECT() 4m 21s Demo: Referencing Worksheets from a Different Workbook 4m 39s Summary 1m 19sForcing Workbooks to Recalculate 18m 4s Introduction 2m 1s Demo: Workbook Calculation Options 4m 23s Demo: Tracking Values with the Watch Window 2m 40s Demo: Debugging with Formula Audit 8m 8s Summary 50sSecuring and Restricting Workbooks 24m 15s Introduction 1m 7s Demo: Data Validation 7m 20s Demo: Protecting Ranges and Worksheets 4m 46s Demo: Protecting Workbooks 5m 17s Demo: Removing Workbook Metadata 4m 7s Summary 1m 36sRecovering Workbooks and Comparing Workbook Versions 34m 11s Introduction 1m 24s Demo: Recovering Workbooks 5m 8s Demo: AutoSaving Workbooks 4m 31s Demo: Tracking Workbook Changes 6m 35s Demo: Workbook Co-authoring 5m 2s Demo: Spreadsheet Compare 6m 35s Conclusion 1m 59s Course Wrap-up and Further Learning 2m 54s

Скриншоты