Synopsis:

This class is intended as the first in a series of three: Beginner, Workshop and Advanced. Whether you are a new user or a user seeking to build a solid working knowledge of Office Connector concepts, this is the class for you! This class will offer an introduction to the software and its components as well as introduce the core concepts needed to obtain proficiency in this Excel-based integration tool:

• Office Connector Queries
• Office Connector Worksheet Functions
• Excel Techniques

Course Goal: Develop a solid understanding of Office Connector - Query essentials.
Course Objectives:
Upon completion of this course you will be able to:

• Leverage the various types of technical resources that are available to you.
• Determine when it is best to query data, import data or utilize worksheet functions.
• Create new queries or modify existing ones.
• Change the results of queries and worksheet functions by applying criteria to them.
• Explore and utilize your data by applying database concepts covered in this class.
• Utilize each of the Office Connector worksheet functions.
• Effectively use Excel features in conjunction with Office Connector queries and worksheet functions.

Please note: Rescheduled classes will incur a 15% administrative fee. Payment must be received prior to attendance.

Synopsis:

This class is intended as the second in a series of three: Beginner, Workshop and Advanced. This class is for users who understand Office Connector Query basics and want the opportunity to apply their knowledge by creating full Excel solutions under the guidance of a qualified trainer. During this workshop you will create the following Excel solutions:

• Vendor Inquiry Form
• Cost to Complete (Construction)
• Financial Statement
• Simple Rent Roll (Property Management)

Course Goal: Augment and apply your existing Office Connector Query skills.
Course Objectives:
Upon completion of this course you will be able to:

• Determine the Timberline tables and fields needed to build the desired Excel solution.
• Use Excel features to effectively present your information and enhance the usability of your Excel solution.
• Create an Office Connector template from an existing Excel solution.

Overview

The Office Connector Query – Workshop class is specifically designed to offer you the benefits of a hands-on workshop and the effectiveness of an online training presentation. This online workshop allows you the opportunity to practice concepts and techniques used in the Beginner class to create real world Excel solutions. It also introduces you to the advanced Office Connector Query and Excel concepts covered in the Advanced class.

A Unique Approach:

To simulate the hands-on benefits of a standard workshop class, course material is provided to you one week prior to the actual class. The material provides you with step-by-step instructions on how to create each of the outlined Excel solutions as well as a completed example of each solution for reference. During this week, you can work through each example, practice the techniques covered and take notes on topics you would like to discuss in the online portion of the class. Qualified support staff is available prior to the class to help you successfully complete each solution.

The class itself is dedicated to covering the overall design concepts behind each Excel solution while introducing alternatives that may be available. The trainer also explains new concepts introduced in the materials, providing preparation for the Advanced class. Your feedback and questions greatly influence the concepts covered, providing a unique and individualized experience to each class.

Please note: Rescheduled classes will incur a 15% administrative fee. Payment must be received prior to attendance.

Recommended class(es):

• Office Connector Query: Beginner

Synopsis:

This class is intended as the third in a series of three: Beginner, Workshop and Advanced. Experienced Excel and Office Connector - Query users will benefit greatly from the concepts covered in this intensive advanced user course.  This class covers concepts that help you build sophisticated Excel solutions:

• Structured Query Language (SQL)
• Advanced Office Connector features
• Advanced Excel techniques

Course Goal: Master sophisticated Office Connector - Query techniques.
Course Objectives:
Upon completion of this course you can expect to:

• Apply SQL to Office Connector queries and worksheet functions.
• Use multiple Timberline tables in a single SQL query.
• Include scalar functions inside of SQL queries.
• Apply proven techniques to retrieve your data faster.

Please note: Rescheduled classes will incur a 15% administrative fee. Payment must be received prior to attendance.

Recommended class(es):

• Office Connector Query: Beginner
• Office Connector Query: Workshop