formattingtables

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

FormattingTables - 2007

resolvedResolved · Low Priority · Version 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:

Trace Dependents / Precedents without the blue arrows

Rather 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.

View all Excel hints and tips


Server loaded in 0.1 secs.