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:
- If necessary, format your data as a table. CTRL + T springs to mind
- Put your cursor anywhere in the table.
- 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
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