vba-excel-training - MS Excel 2007

The UK's most regular instructor-led training courses.
Training information: vba-excel-training · Excel courses london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

MS Excel 2007

Stewart has attended:
Excel Intermediate course

by - delegate Stewart [2 posts] (2007 Nov 13 Tue, 17:10) Reply

How do you convert a special table to a normal table?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: MS Excel 2007

by - trainer Amanda diamond contributer [1297 posts] (2007 Nov 29 Thu, 13:17) Reply

Hi Stewart

Thanks for your question. Apologies for the delay in replying.

To convert a table into a normal range of cells in Excel 2007, you can right-click within the table area, and from the shortcut menu go to Table then select Convert Table to Range. Click OK when the message comes up asking you to confirm this action. Then the data will be converted to a 'normal' cell range.

Amanda

· Excel and Inventory Management
· Microsoft Excel's Best Kept Secret
· Microsoft Excel Training: Essential for Today's Employees
· How to Create Better Excel Spreadsheets: Part One
· Training Budgets In A Bad Economy

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)