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

excel software training london - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training london - Excel

excel software training london - Excel

ResolvedVersion Standard

Simon has attended:
Excel Introduction course

Excel

How do you import and excel table into powerpoint?

RE: Excel

Hi Simon, Thank you for your post: This question has two answers; 1. If you wish to import an Excel table into powerpoint as a graphic and not have it linked to the original in Excel, follow this option: Select the area to be imported in Excel, Copy it (Edit, Copy), switch to Excel and Paste it, (Edit, Paste). This will create a one time image of the Excel Table.
2. If however you wish to have an active spreadsheet, (one that can be updated), follow these steps: In PowerPoint, choose the menu option, Insert, Object, from the dialog box that opens, choose Create From File option, Click Browse button, you will now have to navigate to find the file you wish to import from, when you have located the file, double click its icon and it will be brought onto your slide. To edit the Excel Table, double click it in PowerPoint (Normal view) and it will open an Excel applette to allow you to make any changes. Note: these changes will not affect the original.

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

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.11 secs.