Documentation

Once the add-in has been installed you will see an extra tab appear at the end of your ribbon.

User Guide - Displays a task pane providing quick access to the online user guide.
Sample Data - Drop-Down. Allows you to quickly insert sample data into your worksheets.
Count Functions - Drop-Down. Provides a list of all the functions in the Counting category.
Sum Functions - Drop-Down. Provides a list of all the functions in the Summing category.
Text Functions - Drop-Down. Provides a list of all the functions in the Text category.
Date Functions - Drop-Down. Provides a list of all the functions in the Date & Time category.
Format Functions - Drop-Down. Provides a list of all the functions in the Format category.
Info Functions - Drop-Down. Provides a list of all the functions in the Info category.
Maths Functions - Drop-Down. Provides a list of all the functions in the Maths category.
Other Functions - Drop-Down. Provides a list of all the functions in the Other category.

User Guide

Access the user guide at any time.

Add Sample Data

For example "COUNTRY-VALUE-CITY" will enter a table of data showing 12 countries with a value and a code.
This function populates a range with (3 columns and 12 rows).

Replace Functions

It is possible to quickly replace all the functions with formulas or values.
Quickly replace these functions with temporary values to allow for sharing.
Quickly replace these functions with equivalent Excel formulas (if they exist).
This allows you to share a workbook with someone else who does not have the add-in installed.
<< this is still in development >>

Sharing a File

If you add JS functions to a workbook, that workbook can be shared.
When the workbook is opened , the following task pane will automatically appear if the user does not have the add-in already installed.
Pressing "Accept and Continue" will then load the add-in for that particular user.