630 – slimming your PPT

Piles of documentsPowerPoint files can get big. In the scale of small vs large, sending a many-megabyte PPT file around between a few people might not matter much, but if you’re building a presentation that is going to be widely shared, it could cost actual money – data storage costs, bandwidth charges on a website, carbon footprint for transmitting and storing etc.

Estimates of the energy cost to transmit and store data vary wildly, but if 1 GB cost 1 kWh power and the average CO2 output for generation was ~500g/kWh, then even shaving 10MB off a file can make a material difference if it’s going to be heavily used.

There are a few tricks you can follow to make your PPTs less massive – like compressing the images within, meaning that an embedded picture which was originally sized to print on a poster could be re-sized to fit on a screen.

File sizes sortedIf you see a few-slide presentation file and it’s dozens of MB in size, then there’s probably other info in the deck which is not necessary for your presentation. Even more likely is that there are some embedded graphic or video assets which are bloating the size of it. Quickly identifying the cause of such largesse might allow you to ditch the offending slide or resize/remove the content.

A somewhat cavalier way of looking for large things you can torch, is to make a copy of your PPTX file and then rename it so you can look within. The OfficeXML file formats (prevalent in Office 2007 and onwards) use the same compression as ZIP files, so if you rename your file as such, you’ll be able to open it in Windows Explorer or other ZIP handling utilities, to see its innards. Opening the file shows you a folder structure, and if you navigate into ppt \ media then sort by Size, you’ll quickly see what’s making your file so big.

File Name extensions optionActually doing the rename might be trickier than you think, since Windows hides by default such grubby detail as file extensions. One trick is to flip the switch to show extensions again (in Windows Explorer, look under View menu / Show / File name extensions), then it’s a simple matter of changing the file in Explorer by editing the last part of its name from .pptx to .zip.

Renaming file in ExplorerOnce you’ve confirmed in the warning dialog that the apocalypse is nigh and you really do want to change file type, open the new ZIP file and you’re off. Remember to go back in and switch off the Show > File name extensions option if you’re so inclined.

Renaming file, command lineIf you’re still unsure about these new-fangled “gooey” interfaces, you could crack open the command line to do it quickly.

Slide master viewIf all this grubbing about inside PowerPoint files makes you feel uneasy, there is one other trick that could yield dividends – look inside the Master. Since many people create a new presentation by starting with an old one, they liked, it’s very possible there are slide layout templates with embedded graphics that you no longer need – especially if the originating deck was produced for a conference.

Go into View menu and look under Slide Master, which will open a whole new tab specific to the management of these template slides that form the bones of the presentation. You may well see lots of title slides or similar, which have embedded background images – if you know you don’t need those graphics or those layouts, just delete them.

Closing Master viewPowerPoint generally won’t let you ditch a master layout which is being used to format the current slide deck; so, if you have your deck already built and want to distribute it, just go into the Slide Master view, delete everything which looks unnecessary and that PowerPoint will allow you to, then Close the Master view to return to the main menu. Once you’ve checked that the presentation format hasn’t been garbled, go File > Save As and give it a new name. Now compare the size of the new and old files.

Super Massive background graphic

This title slide in the Slide Master view had a graphical background which was 17Mb in sizefile sizes compared; just deleting all the unnecessary visual slide templates dropped the size of the original file from 110MB to 26MB.

Compress pictures dialogRunning the Document Inspector to remove other content further dropped another 1.5MB.

Selecting an image from one of the 70-odd slides in the deck, and choosing Compress Pictures from the Picture Format tab reduced it again to only 11MB, or 10% of the original file size – all for a few minutes’ effort.

Tools from Save As dialogGoing back to the original 110MB file and opening File > Save As, then choosing More options… will open a traditional Save As dialog box; on the bottom is a Tools > submenu which allows you to run the Compress Pictures function at the point of saving the file, so reducing it to 1/3 of the original size, for literally 15 seconds’ work.More options of Save as dialog

NB: the irony of sending a 2MB email to thousands of people, and sharing online and on LinkedIn, is not lost.

Tip o’ the Week 458 – Grabbing pictures from websites

clip_image001There are plenty of reasons why you might want to get the URL of a picture that is embedded on a web page, and some of them don’t even risk breaching the copyright of the image’s owner or page author!

Legitimate examples might include things like downloading a company logo from its website so you can include it in a PowerPoint slide; try going to just about any major company site and you’ll probably find it’s not straightforward to save the image file. Ditto all sorts of clever pages that might stop you simply saving the picture to your PC.

clip_image003clip_image005Normal behaviour is, mostly, to just right-click on an image and in Edge, you’ll be able to save the picture (or use Cortana to try to give you more details on the image, even trying to guess what’s in the image depending on how straightforward it is – it’s surprisingly good). Ditto, if you’re using Chrome, except you can search Google instead. Try the same on a company logo, and you may find you won’t get the option to save or search.

If you want to grab the actual URL for an image on a web page, the clip_image006foolproof way of getting it is to look at the source – if you don’t mind fishing through maybe a few thousand lines of HTML. It’s not too bad if the image is at the top of the page, but it could prove tedious if elsewhere. In Edge, an easier solution would be to right-click on the image and choose, Inspect element. You may need to press F12 to get these options in your right-click menu. Chrome has a similar thing, simply called Inspect, and can be invoked by CTRL-SHIFT-I.

The Inspect Element funciton in browsers is designed to help web page debugging; it’ll let a user or designer jump straight to the section of a web page’s source, and inspect or even modify the code behind the page.

clip_image008As an example, right-click on the logo on www.microsoft.com and Inspect Element. You’ll see the highlighted section is the bit where the logo sits on the page, and immediately next in the hierarchical representation of the page code, you’ll see the <img> tag, denoting that this pertains to the image itself.

Look for the src= part, double-click on it and you’ll see the URL of the image in an editable text box, meaning you can easily copy that to the clipboard and get ready to paste it wherever you need it clip_image010to go. Try pasting it into a new browser tab just to check that all you’re getting is the logo.

clip_image011

Using a search engine

Of course, there may be easier ways to get an image – using Bing or Google search, for example.

Bing is actually quite a bit better in this regard. When you click on an image in the results from Bing’s Image search, you’ll see a larger preview of the picture along with a few actions you can take – like jump to the originating page; search for other sizes of the same image; use Visual Search to run a query on just some selectable portion of the image; or simply just view it in the browser, thereby opening just that image and showing you the direct URL to it.

In the case of both Google and Bing, if you click on “Share”, then you’ll get a link to the search result of that image rather than the picture itself – so if your plan is to embed the image in another web page or upload it to some other place, then you’ll be frustrated.

clip_image012Another legitimate use of the original URL for a logo might be to change the icon in Teams – assuming you have permissions to Manage a team site (click the ellipsis to the right of the clip_image013name and if you’re suitably perm-ed up, when you click on the Manage Team option, you’ll see a little pencil icon on the logo if you hover over it. Click that to change the picture).

Simply choose Upload picture, paste in the URL of the logo you want to use and you’re off to the races.

Figuratively speaking, anyway. You might have to jigger about with the proportions of the image by downloading it first and editing it elsewhere, as the image will need to be more-or-less square. Built-in icons in Teams appear to be 240×240 pixels in size so you could try to target that if you’re resizing.

Tip o’ the Week 395 – Resizing pictures in Windows 10

clip_image002As smartphone cameras get better, it’s very common to have snaps with dimensions of 4,000 x 3,000 pixels, sized in multi-megabytes – great for capturing a bit more detail, but potentially tricky when handling the photos given the file size as well as their width & height.

This is especially the case if you’re sharing pictures with others – though it does rather depend on how. Email programs usually have ways to reduce the size of images, varying in method but increasingly very integrated to the sending process, and often with little real control of what’s going on. clip_image004Outlook, for example, lets you drag images around by resizing handles, or if you right-click on an inserted image, choose Size and Position then look on the Size tab, you can alter the scale of an image for display purposes.

This doesn’t make the image smaller in the number of bytes it takes up, however – so you might think you’ve made your massive picture a nice thumbnail, only to find it’s still actually 7MB in size. In order to make the image data size get smaller in Outlook, select it by left-clicking, then from the Picture Tools | Format menu, you’ll find a Compress Pictures com  mand that lets you make this image (or every other one in the mail), smaller.

clip_image006If you look on the File menu before doing so, you’ll see the size of the email before, and presuming you’ve hit “Save” after the compression, you can compare the size afterwards too.

The same thing happens in PowerPoints as well – tiny little watermarks on the background of a presentation making the file too big to ever email to anyone. A similar process can radically reduce the size of your presentations by compressing the size of images before saving.

Files

If you have pictures in the file system, there used to be a variety of ways for Windows to offer resize capabilities – one of which was to install the now-defunct Windows Live Photo Gallery, which had a nice wizard to resize images to standard sizes. Now, in Windows 10, there’s no easy, out-of-the-box way of doing it, as the Photos app doesn’t offer resizing and nothing shows up in the desktop / file system mode.

If you have a habit of uploading photos you’ve taken to online forums and the like, some of them will deal with resizing for you (as does Facebook, Yammer etc too), but if they don’t, you may find you’ll need to radically reduce the dimensions of your pic before you can share it.

clip_image008One of the joys of writing Tip o’ the Week is that readers often send their tips just after the mail has gone out – welcome but not always practical to share on, as the same topic might not return for a while. In this example, there will no doubt be a plethora of fave image resizing methods, but a simple one for mortals with less time on their hands is to just go to @Brice Lambson’s site on http://www.bricelam.net/ImageResizer/ and install the quick & simple resizer tool.

Afterwards, right-click within Windows Explorer on your chosen image – or select several and do the same – and resize the image(s) to a given set of dimensions in a trice. Then you’re ready to upload the resulting new pics to your online forum of choice.

clip_image009Remember another  handy tip (as covered in ToW #373 and others) is the Copy as path command – hold SHIFT as you right-click on any file and you’ll see it appear in the drop down list. What this does is copy the exact file and pathname to the thing you’ve just right-clicked on (remember, kids, it works with any file, so uploading docs to a SharePoint is just as relevant) into the clipboard, so you can instantly point the File -> Open dialog on your other app or browser straight to the thing you want.