How-to videos A series of short videos, showing examples of how to use our custom Excel functions for Xero and QuickBooks. Skip to Videos How to install Scott's add-in A comprehensive training video for Scott's add-in. How to maintain your subscription and billing info. How to disconnect and reconnect an organization to your workbook. How to drill down to transaction detail. Best practices for sharing your workbook with others. How to use the VAL feature to convert cells with =SCOTT functions, to values. How to use the =SCOTT.XGLTRX function to display an array of Xero journal transactions. How to use the various SCOTT functions for accessing budgets in QuickBooks. How to use the =SCOTT.LIST function to generate lists of parameters to feed other functions. How to use the (3) tracking category functions for Xero. XTRACK, XTRACKR, and XTRACKM. How to forecast cash using the add-in.
