To access the Numero functions in MS PowerPoint click on the Numero tab in the Ribbon.
There are a couple of ways that you can do basic calculations in Numero. You can do calculations by right clicking in the body of a presentation, in the Formula Bar by using the Evaluate button or by using CTRL + 3
In Numero we can do Basic Math, Number Formatting, Currency Conversions, and Unit Conversions
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.
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.
To perform basic calculations, such as multiplication, division, addition or subtraction in the body of a document. Highlight the sum and click on the Evaluate button in the Numero Ribbon.
CTRL + 3 will calculate data in the body of a presentation or cells in a table. You can do a currency or measurement conversion or a basic math calculations, CTRL + 3 will recognize the calculation or conversion you want to carry out and insert the answer for you adjacent to your original entry. CTRL + 3 will also AutoSum if used in a table as seen below.
You can perform many calculations in Tables in Microsoft PowerPoint.
In the example below we want to find out how much we made on the sale of each item and what was the total Revenue amount.
Calculate Percentage Markup: Use the formula =L1*L2 to 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.
Calculate Sales Price: We can then use the formula =L1+L3 to calculate the sales price; cost price + mark up percentage.
Calculate Total Sales Revenue: Once calculated we can determine the sales revenue by multiplying the sales price by the quantity of goods sold =L1*L2.
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.
To AutoSum a series of numbers, select the numbers in either a column or a row and click on AutoSum, the answer will appear in the adjacent cell in a column or in a row
By clicking the dropdown menu you can also access other types of auto calculations,
AVERAGE, COUNT, MIN and MAX.
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 etc. When you select the option the array of numbers in the column will be replaced by the selected series. Another example is to use the Maths functions and Log(a) to calculate the base 10 Logarithm for each number in the array selected.
There are numerous ways to do basic calculations with Numero, you can use the Formula Bar, access the Numero Menu by right clicking on the highlighted sum or simply use the Evaluate Button
If you want to calculate a percentage, this can be carried out using the formula bar, the evaluate button or by using the Numero menu accessible by right clicking.
You can change the format of any number in the body of the presentation by highlighting the number to be formatted. Choose the icon that represents the formatting you want from the Numero ribbon, see below. It is also possible to format by using the Numero menu accessed by highlighting the number and right clicking.
Converting to another currency can be done by simply typing in the currency and amount you want converted and clicking CTRL+3. You can also use the Formula bar, the evaluate button or right click in the body of the text. Numero will recognise the currency symbol and the recognised three letter abbreviation of your currency.
The Formula bar can be used as a currency wizard. 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 gif below.
Type currency amount in the body of the presentation. Highlight the text and select the Evaluate button from the Numero Ribbon. The Evaluate button will show top ten currencies. See example below.
Type the currency you want to convert from into the body of the presentation 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 presentation.
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. Want to convert from pounds to kilos, meters to feet or over 800 other conversions, just type the unit that you want to convert and choose one of three ways to find your conversion. The Formula bar, the right click menu or the Evaluate button.
Numero
The leading Microsoft Office productivity add-in for numerate professionals
Follow Us