excel training uk - Excel from Powerpoint

Resolved · Low Priority · Version Standard

Excel from Powerpoint

Damon has attended:
Excel Introduction course

by - delegate Damon [1 post] (2007 Oct 10 Wed, 15:39) Reply

How can I link from Powerpoint from an Excel Spreadsheet?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel from Powerpoint

by - trainer Pete platinum contributer [801 posts] (2007 Oct 11 Thu, 10:22) Reply

Hi Damon, Thanks for the post, I am assuming that you wish to place a link into your PowerPoint presentation that will display an Excel spreadsheet and give the latest update when you open the presentation. Follow these steps:
Menu command Insert, Object. In the dialog box choose Create from file, and press Browse button. Navigate to your chosen Excel Spreadsheet, click OK, and then click the "Link" check box to create your link. To edit the Spreadsheet double click on it to open the link. If changes are made in the spreadsheet you will notice the changes immediately if both are open, if they are not both open when you open PowerPoint presentation you will be asked if you wish to update the spreadsheet.

· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Microsoft Excel's Best Kept Secret
· How to Create Better Excel Spreadsheets: Part One

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips

Rate this page: