Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » FormattingTables - 2007
Resolved · Low Priority · Version Standard
Dear Dan
Thank you for attending Excel 2007 Intermediate course. I hope you enjoyed the training.
Format as table in the previous versions of Excel was called Creating List. There are various advantages of formatting the range of data into a table. Following are some of them:
* The table looks more professional
* You can perform calculations such as Sum, Average, etc
|
Excel tip:Trace Dependents / Precedents without the blue arrowsRather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula. |
We'll call during UK business hours
Server loaded in 0.1 secs.