To access the Numero functions in MS Word click on the Numero tab in the ribbon.
There are a couple of ways that you can do basic calculations in Numero. You can use the Evaluate Button, you can do calculations by right clicking in the body of a document, in the Formula Bar or in a table.
In Numero you can do Basic Math, Number Formatting, Unit Conversions and Currency Conversions
In Numero you can use the Formula Bar, the Evaluate Button, AutoSum, AutoCalcs, Number Formatting and Plaintext. You can also use CTRL + 3 to evaluate many calculations in the body of the document.
The Evaluate button will calculate highlighted data in the body of a document or highlighted cells in a table. This could be a mathematical function or a currency conversion. Evaluate will give the relevant answer.
CTRL + 3 will calculate data in the body of a document or cells in a table. You can do a currency or measurement conversion or a basic math calculations. CTRL + 3 will also AutoSum if used in a table as seen below.
To perform basic calculations, such as multiplication, division, addition or subtraction. Select Formula Bar and enter the sum directly into the Formula Bar. Click enter to load the answer.
Alternatively you can highlight the sum in the body of the document and load it into the Formula bar as shown in the animation below. Once the calculation is loaded hit enter to get the answer. The answer can then be pasted back into the document with the paste button.
To perform basic calculations, such as multiplication, division, addition or subtraction in the body of a document. Highlight the sum and right click to reveal the Numero menu.
You can perform many calculations in Tables in Microsoft Word. In the example below we want to find out how much we made on the sale each item and what was the total Revenue amount. Use the formula =L1*L2 which will multiply the content of the cell to the left of the cell you are in by the content of the cell two cells to the left. You must then copy and paste the formula into all the cells that you want to use this calculation in. Once copied highlight the column and either do a CTRL+3 or click on the Evaluate Button.
With tables in Numero we use the following references L, R, U and D. In the example below X marking the cell from which you are referencing, you would use the references given to identify the cells around you.
You can also use the Table Wizard to perform certain calculations. Sum, Average, Min, Max etc. Start by entering an equals sign into the cell you want to perform the calculation in, this will start the wizard. Follow the wizard to complete the calculation.
In the example below you will see how cell referencing is used to sum the two adjacent cells and also to do a cumulative calculation which includes the sum of the cell above. This formula L1+L2+U1 can be copied down through the cells of that column. Each cell is calculated using the Evaluate button or a CTRL+3. The column is then highlighted where an AutoSum calculates the total column.
If you have a row or a column of numbers that you would like to sum, highlight the cells and select the AutoSum Button on the Numero Ribbon. In the example below the rows are calculated using the AutoSum button and then the overall total calculated in the column. AutoSum will place the answer is the next available cell in a row or a column.
We can also get the Average, Count, Max and Min of a group of cells, in the example below you can see by highlighting the column and selecting the different functions under the AutoSum button you can do quick calculations.
AutoCalcs are used in table calculations only. These are a wide array of functions that can be carried out on the data in a table.
Highlight the selection of cells to be included in the AutoCalc. In the example below you will see that when you click on the menu, in this example Order and Sort(a). The drop down box gives you a preview of the numbers sorted from smallest to largest. SortD(a) from Largest to Smallest. When you select the option the array of numbers in the column will be replaced by the selected series.
Another menu is the Statistics menu where you can calculate the Median or Mean. If selected the answer will be inserted in the next available cell in the column.
There are several ways to calculate a percentage, this can be carried out using the Evaluate button, formula bar or by right clicking to access the Numero menu.
You can undo any calculation that you have completed.
Highlight a number in the body of text and either use the Number Format section of the Numero Ribbon, shown in the image to the right or highlight the number, right click to access the Numero menu. The following options are available.
To format a number to percent, right click on the number, select Numero, Number Format and Format as Percent.
To format a number to local currency, right click on the number, select Numero, Number Format and Local Currency Format.
To format a number to thousands, right click on the number, select Numero, Number Format and Format as thousands.
To format a number in Exponential format, right click on the number, select Numero, Number Format and Exponential Format.
To format a number in Scientific Format, right click on the number, select Numero, Number Format and Scientific Format.
To format a number to two decimal places, right click on the number, select Numero, Number Format and format to two decimal places.
To increase decimal places, right click on the number, select Numero, Number Format and select increase decimal places.
To decrease decimal places, right click on the number, select Numero, Number Format and select Decrease decimal places.
Converting to another currency can be done directly in your Word document by typing the amount and currency along with the symbol or abbreviation of the currency you want to convert to. You can also use the Evaluate button, the Formula bar or right click in the body of the text. Numero will recognize the currency symbol and the recognized three letter abbreviation of your currency.
Type currency you want to convert from directly into the Formula Bar. The answer bar will suggest the top ten most commonly used currencies. If your currency is not one of the ones listed continue to type in the Formula bar as shown in the following GIF.
Type currency amount in the body of email. Highlight the text and select the Evaluate button from the Numero Ribbon. The Evaluate button will show top ten currencies.
Type the currency you want to convert from into the body of the email and right click and select Numero. Numero will suggest a number of currencies to you. Click on the correct currency and it will be inserted directly into your email. If the currency you require is not visible. Type directly into the text area the three letters that are associated with that currency.
Numero can be used for unit conversions, you can carry out unit conversions in the Formula bar, by using the Numero menu accessed by right clicking on the highlighted entry or by using the Evaluate button as seen below.
Numero
The leading Microsoft Office productivity add-in for numerate professionals
Follow Us