FORUM23 Training Part 1:
N-Above Template
An ANOMS Advanced Training Session with Intermediate Excel concepts
Learn how to set up a more advanced Query-Gen Excel Template through the use of Excel and ANOMS Query Gen.
Lesson Time: 35 minutes.
Build templates in Excel with data that is automatically populated from ANOMS. Users will learn more advanced Excel skills to help them create templated tables and charts. Great application for recurring reports, especially those that require a lot of data manipulation to set up.
Helpful Tip
The formula used in the video which automatically adjusts the relevant data range to the amount of data included in the data sheet is provided below for ease of copy/paste. Remember to adjust the final number (currently set to 15) to the amount of columns included in the dataset you are using.
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),15)
For a better understanding of the concepts in this video, we recommend you watch the Creating Template Reports training video.
