[E301] Workbook Resilience Course Content Expand All [E301.1] Overview [E301.2] Data Structure 8 Topics Expand Lesson Content 0% Complete 0/8 Steps [E301.2] The data [E301.2] External data sources [E301.2] Getting the facts tables [E301.2] Getting the dimensions table [E301.2] Table relationships [E301.2] Tables [E301.2] Pivot tables [E301.2] Data models [E301.3] Workbook structure 5 Topics Expand Lesson Content 0% Complete 0/5 Steps [E301.3] Data sheets [E301.3] Control sheets [E301.3] Analysis sheets [E301.3] Output sheets [E301.3] Doc sheets [E301.4] Worksheet structure 2 Topics Expand Lesson Content 0% Complete 0/2 Steps [E301.4] Named ranges [E301.4] Row and column visibility [E301.5] Cell Structure 5 Topics Expand Lesson Content 0% Complete 0/5 Steps [E301.5] Avoiding formulas [E301.5] Auxiliary calculations [E301.5] Error handling [E301.5] Nested IFs [301.5] The GETPIVOTDATA() function [E301.6] References 1 Topic Expand Lesson Content 0% Complete 0/1 Steps [E301.6] External links Login Accessing this course requires a login, please enter your credentials below! Username or Email Address Password Remember Me Lost Your Password? Register Don't have an account? Register one! Register an Account Username Email Registration confirmation will be emailed to you.