Thursday, March 19, 2009

MS Excel

So by far the most interesting thing I've learned to do with Excel is the Special paste technique. It seriously blows my mind to Narnia and back when the data changes as soon as the original source is changed in someway. Once you've copied a graph or a chart, you look under the Home tab, click the arrow under Paste, and click 'Paste Special' and pick the option to paste it as a link in a Powerpoint presentation.

So, no matter where you place it, as long as you have the source there, you can alter it. This would come in handy if say you were giving a presentation that involved charts and someone asks you at the end how a change in the data would affect the numbers. If you have both the Excel file and the Powerpoint presentation on a pen drive, you could load the Excel with the PowerPoint still open, change the data the question is referring to, and talk about what differences there may be.

I have laid awake many a night wondering how the scientists of Microsoft dreamed of making such things or if they even dreamed it all. Or if they're just machines.

If you'd like to see more of my views and work, I've got another blog hurr :
http://erratikinertia.blogspot.com/

Enjoy. Thanks for reading.
- Adain

No comments:

Post a Comment