Tame your computer - totes simple tables

In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to total the data in a table (Microsoft Excel)...

By the way, following feedback from course participants I’ve developed a half-day course to help you understand how to prepare your data and benefit from the powerful Table Tools. Come along on 1 March and save yourself countless hours in calculating and recalculating information. See http://roem.co.uk/msexctables.php for the full course outline. (Only £97 +VAT)

Excel Tables can be used to store and organise your data, any way you wish. You can use its powerful tools to retrieve information and view and summarise it in numerous ways.

For example, did you know you can quickly total data in the table by turning the optional total row on?

Here’s how:

  1. If necessary, format your data as a table. CTRL + T springs to mind
  2. Put your cursor anywhere in the table.
  3. Press CTRL + SHIFT + T.

The total row is added at the end of the table. Simply use the drop-down arrows at the bottom of each column and find the relevant function, such as Sum or Count.

And guess what … it’s a toggle, so if you press CTRL + SHIFT + T again, you switch the total row off.

 

Related tips:

How do I know if a table has been filtered?  

Select rows and columns in a table 

Filter dates by month 

Quickly format and enable filtering of your data 

14 January 2019

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or visit her website at  www.roem.co.uk


Looking for something specific?