Recorded Training for Office Connector

Play Video

Duration: 2 minutes

Learn how to use tools in Office Connector Query Designer to get a list of internal field names that can be used in Office Connector Query worksheet functions.

Play Video

Duration: 2.5 minutes

When utilizing the queries that are created using the Query Wizard, it is common to add other columns that contain formulas. This video discusses how to do this correctly so that formulas are automatically copied down to new rows when the data in the query is refreshed.

Watch and learn how to create the vendor list report based on Exercise 1 of Office Connector Query Getting Started.

Click here for the step-by-step instructions and try it yourself!

Play Video

Duration: 1.5 minutes

This video shows how you can use Office Connector's Lookup Wizard to insert TSLookup functions into your worksheet. TSLookup functions allow you to retrieve data from any field in any table by using the primary key (identifier such as an account number) to locate the record you want.

Play Video

Duration: 3.5 minutes

When designing a report that includes a query, you may sometimes wish to have data-entry columns. This video addresses how to use the OCRetain function to keep your manually input values on the correct rows when the query inserts rows for new data.

Play Video

Duration: 3.5 minutes

Learn how to use the Query Wizard to create a simple report showing Job Cost transactions for any job you choose. In the process, you'll also learn about named cells in Excel and how to add multiple conditions in the Query Wizard.