longview-logo-white
exact-company

Longview for Excel

Course Code: LVXL71
Program Level: Advanced

Who should take this course?

This course is designed for individuals who want to work with their Longview data within Microsoft Excel.

You will learn about...

  • The different types of queries in the Longview database and how to perform them
  • Submitting data from an Excel workbook
  • Using features like combo boxes with Longview data to improve usability of your Excel workbooks
  • Improving the performance of your Excel workbooks

Additional Information

  • Successful completion of the Longview Analyst course

Agenda

Day 1

  • Excel Queries
  • Symbol Queries
  • Attribute Queries
  • Server Rule Queries

Day 2

  • Longview for Excel Input Workbook
  • Cell-Triggered Symbol Lookups
  • Journal Entry Queries

Day 3

  • Excel Combo boxes
  • Calculation Performance Enhancing Techniques
  • Intercompany Queries

    Course Details - LVXL71

    Upcoming Dates

    Duration

    3 half days

    Materials

    Resource and Task Guide

    Delivery Method

    Web-based instructor-led workshop

    CPE Credits: 12

    Hands-On: 60%


    Pre-Requisites

    • Successful completion of the Longview Analyst course
    • Basic knowledge of Microsoft Excel

    Fees

    Location Cost per Person
    US/Canada  $1400 

    United Kingdom

    £810

    Europe

    €970

    For On Site classroom training please contact us.