vba-excel-training - ms excel
Microsoft Office Training McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams add this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - MS Excel 2007

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

resolvedResolved · Low Priority · Version Standard

MS Excel 2007

Stewart has attended:
Excel Intermediate course

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

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

Excel Advanced 1 day course
Version Date Location Places
available
Book Next place rate:
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) replyReply

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


Related articles

· 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)

View all Excel hints and tips

Rate this page:
3.0/5 (5 votes cast)
Institute of IT Training - Accredited Training Provider Microsoft Certified Partner
microsoft office
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Training venues
Client list
FAQ
Pricing and availability
Course details / Syllabus

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London
Microsoft Office training

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
Microsoft access courses · Microsoft training access course
Microsoft+access+training · Access courses in london

Training Information
Training Articles

AddThis Social Bookmark Button What's this?
Add to: Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo