Course Description
Learn how to download the Solovis Excel Plugin and how you can use the Excel Export options available in Gateway Portal reports to export data to Excel workbooks - either as raw data tables or tables with references to the data stored in Solovis. This course also includes a full walk-through example of how to link an Excel output report to Solovis data sets, incorporating the use of Excel's INDEX, MATCH, and INDIRECT formulas to do so.
Course Curriculum
-
1
Excel Plugin Basics
17:16-
Excel Plugin Report Course Intro
-
How to Download the Solovis Excel Plugin
-
Troubleshooting Solovis Excel Plugin
-
How to Create an Excel Plug-In Key for API Key Login Type Plugin Authentication
-
How to Export Raw Data to Excel (Quick Excel Export)
-
Excel Plug-in Export (Copy Table Reference as Data Set in Excel)
-
How to Refresh Data Sets using Download Options (Download Current/Download All)
-
How to Get the Report Link from a Data Set in Excel
-
-
2
Parameter Permutations for Solovis Excel Data Sets
07:47 -
3
Example of Linking an Excel Output Report to Solovis Data Sets
14:49 -
4
Quiz & Reference Material