The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Add an Excel file to a word document

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

excel training program - Add an Excel file to a word document

Resolved · Low Priority · Version Standard

ReplyTue 28 Nov 2006, 14:32Delegate Jenny said...

Add an Excel file to a word document

When I try and add an excel file to a word document (Insert/file) the excel file appears to be corrupted.
Is there a way around this/am I saving the file in the wrond format? Or should I just stick with copy and paste?

Many thanks

Jen

For upcoming training course dates see: Pricing & availability

ReplyTue 28 Nov 2006, 14:37 Edited on Thu 30 Nov 2006, 16:57Trainer Meenesh said...

RE: Add an Excel file to a word document

Try inserting the spreasheet as an object, so click on Insert and then object and then create from file tab. Select the file.
Did this work?

Excel articles

· How To Use Vlookup In Excel
· Why do we even need XML anyway?
· How We Got To The Perfect Spreadsheet: A Brief History
· How To Add Extra Data Ranges To An Excel Chart
· Importing Excel Data Into Access

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

How do i combine two columns into one?

» Forum post: Text function

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions