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