Have you always wondered how you can transport your report or data on Excel to other Microsoft software with the click of a mouse? This function in Excel is a MUST KNOW and can save a lot of your time. Get ready to flaunt these skills at your workplace!
Generally, when there is heavy data on our Excel Spreadsheet, we convert it into reports on Microsoft Word or presentations on Microsoft PowerPoint for easy understanding of the viewer.
The conventional way of transferring data from MS Excel to either of the two applications is by using the copy-paste option i.e., select the range of cells in Excel -> Ctrl + C -> MS Word/MS PowerPoint -> Ctrl +V or by using the snipping tool/screenshot feature.
The problem with these techniques is that, if the data is changed in the former, there is no change shown in the latter. This is extremely disadvantageous as keeping a track of each cell which was changed becomes a tedious job and is time-consuming.
Let us now learn the easy method of doing this. In this method, any change in the Excel sheet will reflect in the other document you are working on.
Also check out:
Pro Tip: Always update your link before giving your presentation. Any changes in your worksheet which you may have forgotten to include in the report will get updated in the document.
Haven’t seen our YouTube yet?
Check it out here: