Creating ANOMS Template Reports
An ANOMS Advanced Training Session with Basic Excel concepts
Learn how to set up a Query-Gen Excel Template through the use of Excel, file explorer, and ANOMS Query Gen.
Lesson Time: 18 minutes.
Benefits include learning how to easily populate and create simple tables and graphs with data with Excel. These skills can be used as a stepping stone to building regular reports that require minimal effort to generate. This skill has a wide range of applications to build templates in Excel with data that is automatically populated from ANOMS.
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 4) to the amount of columns included in the data set you are using.
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),4)
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 4) to the amount of columns included in the data set you are using.
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),4)
