Helpful Hints Newsletter

June 14, 2017

Beacon HR Add-in

Do you manually enter data from Beacon HR into an Excel spreadsheet?

Save time by using the Beacon HR Add-in functions to automate your reports! With this powerful and flexible reporting tool, you can easily create customized report templates. Once you've created a report, the Beacon Add-in will refresh your spreadsheet with the most up-to-date data from Beacon HR, no additional work required.

See below to find out how you can get started by adding a Beacon HR function to your workbook today!

Inserting a Function
From a blank cell in Excel, click the fx or Insert Function button.


When the Insert Function pop-up appears, choose the NetComm Beacon HR Functions from the "Or select a category:" drop-down.


From the list of functions, select the function you would like to add and click OK. In this example, we are going to use the Active function to pull a count of our active FTE employees in an Organization.


The Function Arguments window will appear. From here, enter in the parameters for the data you would like returned and click OK.


The formula result will display in the cell.


Congratulations! You have successfully inserted a function using the Beacon Add-in. 

Keep an eye out for more Helpful Hints related to utilizing the full potential of the Beacon Add-in. Next up, using the Beacon Add-in to create report templates!

Please note: The Beacon Add-in must be installed on your workstation in order to utilize the functions. Please contact us at [email protected] if you need assistance with the installation process.