
Jun 05, 2015
The ability to add and format tables in OneNote 2013 allows users to create sophisticated tables and store the information required in a very easy to read style.
Office OneNote Gem Add-Ins allows the user to create formulas and it includes a set of formula commands under the Table Tools Tab Layout and Gem.
The Table Tools Layout Tab contains options for selecting, inserting and deleting the table, columns, rows and cells. It also contains options for formatting, aligning and sorting the data in the table. The user can convert the table into an Excel Spreadsheet as well.

The formula cell now can remember the formula used.
The Table Tools Gem Tab contains options for applying table styles, move cells, sort, filter, fix width, use formulas, convert table to text and send a table to Excel.

To calculate in a table using the OneNote 2013 Gem feature, insert a table first:
- Click the “Insert” tab and go to the “Tables” group.
- Click “Table” and then select the “Insert Table” option.
- Type the number of columns and rows you want to insert.
- Click OK.
- Type the data you want displayed in the table
- Add a total row below and to the right of the table and name the labels.



To calculate the totals by day, follow the steps listed below:
- Select the empty cell at the bottom of Monday column.
- Click the “Table Tools Gem Tab.”
- Go to “Formula” group and click on the Formula button. The default ADD function and ABOVE scope are displayed.
- Click “Calculate.” Do the same for the other 4 days. Your table should look like the one below.


The next step is to calculate the totals by subject.
- Click the empty cell below Total by Subject
- Click the TABLE TOOLS GEM Tab
- Go to Formula group
- Click the Formula button. The default ADD function and ABOVE Scope are displayed. You have to change the Scope to LEFT to sum the dollars for the Access subject
- Click Calculate. Do the same for the other subjects. Your table should look like the one below.


Visit the OneNote Gem site to download a trial version or purchase this plug-in:
http://www.onenotegem.com/gem-for-onenote.html
There are other wonderful features of OneNote Gem Add-Ins, which I will discuss in the next few blog posts.
How do your Excel skills stack up?
Test NowNext up:
- Managing mobile devices with Windows Intune and SCCM 2012 R2
- Recording screen action in PowerPoint 2013
- Different communication styles – the best communicators know this, so should you (Part 2)
- Customising the Project 2013 interface
- New features of Microsoft CRM 2013
- Quick ways to automate in Photoshop – Part 3: Batch processing
- What? Cosmic rays?
- How to give a killer presentation or…not let your presentation kill you!
- For Each loops in Excel VBA
- Taking the first step towards power by rooting your mobile device
Previously
- Taking a closer look at Universal Apps
- Who does what in managing change?
- Creating Quick Parts in Microsoft Word
- Troubleshooting an upgrade to Exchange Server 2013
- Troubleshooting Office 365: Real solutions
- Recursive functions in VBA
- PivotTable timelines in Excel 2013
- The science of presenting (Part 3)
- Virtualising SQL Server using Hyper-V 3.0 and SCVMM
- Understanding the difference between Office 2013 and Office 365