Excel - Charts and Graphs - Screenshots in Excel - Episode 1329

Microsoft Excel Tutorial: Charts and Graphs - Screenshots in Excel.

Welcome to another episode of the MrExcel netcast! In this chapter, we will be discussing the use of screenshots in Excel charts and graphs. As always, this episode is sponsored by Excel-XL, the ultimate tool for all your Excel needs.

As many of you know, I am a big fan of Techsmith's Snagit and Camtasia Studio. In fact, I have used Camtasia Studio to produce over 1200 episodes of the MrExcel netcast. But with the release of Office 2010, Microsoft has added some new functionality that allows users to take screenshots directly in Word or Excel, similar to what Snagit does.

To access this feature, simply go to the Insert tab and click on Screenshot. You will see a list of all the available windows, including PowerPoint, webpages, and even the Camtasia recording toolbar. However, I have found that the most useful option is the Screen Clipping tool. This allows you to select a specific area of the screen and insert it directly into your Excel sheet.

Let me show you how it works. First, switch to the screen that you want to take a screenshot of. In this example, I am on a webpage. Then, go back to Excel and click on Insert, followed by Screen Clipping. You will see that Excel automatically goes to the last application that was open, in this case, the webpage. You can then use your mouse to select the specific area you want to capture and it will be inserted as an object in your Excel sheet.

But that's not all! Excel also has a variety of picture tools that you can use to enhance your screenshot. This eliminates the need to switch to Snagit for simple edits like adding arrows or text. So next time you need to take a quick screenshot, remember to use the Screen Clipping tool in Excel. Thanks for watching and be sure to tune in next time for more tips and tricks from MrExcel."

Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Screenshots in Excel
(00:30) Techsmith Snagit for Screenshots
(00:40) Microsoft's similar functionality in Office 2010
(01:00) Available Windows for Screenshot
(01:12) Using Screen Clipping instead
(01:22) How to use Screen Clipping
(01:34) Inserting Screen Clipping in Excel
(01:53) Using all pictures tool
(02:03) Comparison to Snagit
(02:13) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Camtasia Studio
Excel Charts and Graph Chapter 12
Excel-XL sponsorship
Insert Screenshot
Microsoft Excel
Netcast from MrExcel
Office 2010
Screen Clipping
Snagit tools
Techsmith Snagit
Webpage screenshot


Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads/1153009/


Today, in Episode #1329, Bill shows us how to select and paste a screenshot of another application into Excel 2010...
This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel.