Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
formattingtables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » FormattingTables - 2007

FormattingTables - 2007

ResolvedVersion Standard

Dan has attended:
Excel Intermediate course

FormattingTables - 2007

How do I do this

RE: FormattingTables - 2007

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:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.