Creating a Chart in Excel When Data is Not Next to Each Other

Excel has some great features for creating charts, I remember when I first started using it and saw how easy it was to create one. You would not believe what I had to do to create a chart before then on a computer. You pretty much had to program it yourself.

The quickest way to create a chart is when all the data is next to each other in adjacent rows and columns. But what if they aren’t, how do you select data that is not adjacent to each other. Well that can easily done by using the Control key on a Windows PC or CMD on a Mac. In the video below you can see how to do this.

Posted in Excel, Microsoft Office | Leave a comment

Looping a YouTube Video

Do you have a video that you want to loop indefinitely and you’ve uploaded it to YouTube, or perhaps it is a video that you’ve found you want to play repeatedly.

It’s really easy, all you have to do it right click and select loop. That’s it. Oh yeah, you might need to press play.

Posted in Presentation, video, YouTube | Tagged , , , , , , | Leave a comment

How to Create a PDF on Your iPad or iPhone

Sometimes I need to save an email or webpage as a PDF and I’m sure you do too. It helps if there is some important information such as instructions, agenda, schedule, recipe etc that you might want to access offline or just quickly without having to look through your emails or keep a webpage open. 

I usually then add to Acrobat Reader on my iPhone or iPad and can get to it quickly.

Thankfully you don’t need any special software. Have a look at the video below to see how its done.

Posted in ios 10, iPad, iPad Pro, Iphone, PDF | Tagged , , , , , , , , , , , | Leave a comment

How to Check the Battery Level on Your Apple Pencil

If you have an iPad Pro then like me you probably got an Apple Pencil, which I have to say was a really good idea. 

The great thing about the Apple Pencil is that it charges so quickly and you can do that by just plugging it into the Lightning port. However, there was one thing that was bugging me. How do you know the battery level? Yes, it tells me when it is down to 5% and I can quickly plug it in to boost it. 

Thankfully there is a widget you can add to you Notifications Center. 

In the video below you can see how to do it. 

Posted in Apple, iPad, iPad Pro, Tablet | Tagged , , , , , , , | Leave a comment

Finding Your Parked Car

It turns out that we lose up to four days a year looking for where we have parked our car. http://news.sky.com/story/drivers-waste-four-days-a-year-looking-for-parking-spaces-new-research-shows-10751024

People often laugh at me but one way around this is to take a photo of where you have parked, make sure you include a street sign. In a car park I find this particularly useful as it helps remember the level and what row I’m in. I make sure I have the sign with the row information in it. Believe me this simple method has saved me a lot of time. 

If you have an iPhone 6 or newer and iOS 10 then if you have your iPhone connected via Bluetooth to your car’s audio system for calls or music it will remember where you parked your car in the Maps app, I spotted this when iOS 10 was first launched and was surprised when I opened Maps to see where I had parked and how long to get there. Here is how to make sure it is switched on if you want to use it. https://support.apple.com/en-gb/HT207227

Hopefully this will save you time and not spend up to four days a year looking for where you have parked your car. 

Posted in Uncategorized | Leave a comment

Video Editing Shortcuts

If you are into making videos here are some keyboard shortcuts that work the same across many video editing programs including Final Cut Pro, iMovie, Adobe Premiere Pro and Adobe Premiere Elements. I find that they speed up how I work particularly when playing back and reviewing clips or the time line. You do need to make sure that the clip or timeline is selected. 

Space bar = play and pause. Each time you press this is will either play or pause. Works on lots of software including QuickTime, VLC, Windows Media and all the video editing software I mentioned above. 

L = fast forward. First time you press it if the video is paused it will play the video, each time you press it after that it will fast forward faster until is hits the maximum speed. The space bar stops it fast forwarding. 

J = rewind. Each time you press it it rewinds faster up to the maximum speed. The space bar stops it rewinding. 

Right arrow = moves play head forward one frame at a time. 

Left arrow = move play head one frame at a time backwards. 

I = in point. This selects the in point of a clip. 

O = out point. This selects the out point of a clip. 

Posted in adobe creative cloud, Adobe Premiere Elements, Adobe Premiere Pro, Final Cut Pro, iMovie, Video editing | Tagged , , , | 1 Comment

New Magnifier in iOS 10

This is a really handy feature that Apple didn’t make a big fuss about but I have found useful. It is a magnifier that can help if you are trying to get a closer look at something, read something small or perhaps make it easier to read something when it is dark. 

Some friends I was with found this useful in a restaurant trying to read a menu and they had forgotten their reading glasses. You can also use the light and that helped them too. 

Here’s a short video I made to show you how it works. 

Posted in iOS, ios 10, Iphone | Tagged , , , , , | Leave a comment