Zooming in on a PowerPoint Slide

Ever been doing a presentation and you have a chart, image or data you want to zoom in on. Perhaps you just want to make it stand out or get your audience to focus on it or perhaps it is a little difficult to read. 

If you are using the Windows version of PowerPoint then you can do just that, zoom in during a presentation. Here’s a video to show you how to do it. 

Posted in PowerPoint, Microsoft Office | Tagged , , , , | Leave a comment

How to Enter a Series of Dates in Excel That Are Only Weekdays

Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays. 

All you have to do is enter the start date and then drag using the right mouse button. This works on all versions for Windows and Mac. 

Here’s a short video showing you how it works. 

Posted in Excel, Microsoft Office | Tagged , , , , , | 1 Comment

Excel: How to Enter the Same Day but Different Month and Year

We all want faster ways to enter data and you’re probably already aware of the autofill feature in Excel. To enter a series of consecutive dates you just need to enter the one date and then click and drag on the bottom right of the cell when the crosshair appears. But you can do some clever things like just get the month to increase or the year. You can also get it to just fill the weekdays and leave off the weekends. 

These options are available if you use the right mouse button to autofill rather than the left. When you use the right mouse button a menu will appear when you finish dragging with these options. 

You can see how this works in the video tutorial below. 

Posted in Excel, Microsoft Office | Tagged , , , , | Leave a comment

Reinstalling Plug-ins After Updating Photoshop CC 2015

Adobe have done another update to Photoshop CC and as always just as I thought I’d learnt enough there is more to learn. This software just gets better and better

One thing that did happen on this update, because it was a big one, was that the plugins stopped working but don’t worry it’s an easy fix. I use Google’s Nik Collection and that was quite straightforward, all I had to do was copy the folder over, you can see how to do that in the video below.

I did discover that to future proof it and to make it available to other potential Adobe apps I should copy it to the shared Creative Cloud folder. Again how to this is in the video below.

Adobe has helped out with these useful links:

Location of plug-ins – adobe.ly/28OBbkg

List of plug-ins to reinstall and links – adobe.ly/28LNvFp

Here is the video to show you what to do.

Posted in adobe creative cloud, Photoshop | Tagged , , , | Leave a comment

How to do a Screen Recording in PowerPoint

If you are doing a PowerPoint presentation you may want to show how something works like a website or some software. You could open the website or software and switch to it during the presentation. However, that can be time consuming and your computer may not want to play ball. However, you could record it in advance and have it as a movie in your presentation. 

PowerPoint has a screen recorder built in to do this, although the Mac versions do not but I will tell you how you can do that in a moment. 

The screen recording allows you to record the audio too and the mouse pointer. You can choose to not record those and just what is happening with the software. 

If you are using a Mac, and this includes the new 2016 version, there is no built in screen recorder but there are lots of screen recording/screencasting software available. My favourite is Camtasia (Techsmith website), there are a lot of editing options and can add in lots of graphics later, you may want this even if you have Windows. It comes in both Windows and Mac versions. There is a 30 day free trial. 

Techsmith also do a cheaper version called Snagit. Click here for more about Snagit on their website

A free option is to use QuickTime Player that comes with your Mac. You can choose New Screen Recording in the File menu. If you need to edit you will need to use something like iMovie, should also be free with your Mac. 

Here is a video, made with Camtasia, to show you how to do the screen recording in PowerPoint. 

Posted in Microsoft Office, PowerPoint, Screencast | Tagged , , , , | 1 Comment

Embed a YouTube Video into a PowerPoint Presentation

Switching from PowerPoint to a browser in the middle of you presentation to show a YouTube can be messy and time consuming. So wouldn’t it be better if you could just embed the YouTube video into your PowerPoint presentation? It also saves time not having to load up your clips in advance. 

If you’re using the Windows versions of PowerPoint, and there is an Internet connection, then this is possible. Unfortunately this does not work on any of the Mac versions including 2016. 

You should be able to embed other online video but it works best with YouTube. I tried it with Vimeo and another media server called MediaCore and it didn’t like it. 

Anyway, here is a video to show you how to do this. 

Posted in Microsoft Office, PowerPoint, YouTube | Tagged , , | Leave a comment

Copy Video to Your iPad or iPhone All Photos Using iCloud Photo Library

Copying video to your iPhone or iPad so that you could use it in apps for sharing like on WordPress, Facebook, Twitter, Instagram etc or for editing in something like iMovie meant storing videos in the right folder and then syncing with your computer. 

Videos for many of these apps are only available when they are visible in All Photos. With the iCloud Photo Library it is now easy to get both photos and videos from you computer, Windows and Mac, to your iOS device. 

The latest iPad Pro has highlighted that it is possible to edit video on these mobile devices including the iPhone and have done this myself using both an iPhone and iPad. I needed this as I had created a title video on my computer and needed to add it to my iPad so I could complete a video. I used the iCloud Photo Library for this. 

You do need to look out for large files as it syncs over the internet so can take some time. Also if you can’t see you video it could be that it is in date order and it is based on the date the files was created and modified not when you added it, so you may need to scroll through your album to find it. 

Here is a video tutorial to show you how it is done. 

Posted in iCloud, iCloud Photo Library, iPad, Iphone, video | Tagged , , , , | Leave a comment