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

advanced excel ms training - microsoft excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Microsoft Excel 2007

advanced excel ms training - Microsoft Excel 2007

ResolvedVersion Standard

Alex has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course

Microsoft Excel 2007

How do you create a link between a specific table in Excel and PowerPoint so that the PowerPoint table is constantly updated?

RE: Microsoft Excel 2007

Hi Alex

Thanks for your question.

You can import and link an object into a PowerPoint presentation. In PowerPoint
go to Insert - Object then choose Create From File.

Browse to the Excel file which contains the information you wish to link to - this information needs to be stored in the first (top) sheet in the Excel file.

Tick the Link box, then click OK.

I hope this helps.
Amanda


Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

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