Recording the Screen on Your iPhone and iPad

How often have you needed to show someone how to do something on their iPhone or iPad. Maybe you want to show them how to change a setting or use an app. Maybe it is a family member,  friend or colleague. Thankfully you can do this using a built-in feature in iOS, then you can edit it a bit and send it.

If you are working from home this could really help your colleagues too.

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

Posted in iOS, iPad, iPad Pro, Iphone, productivity, Working from home | Leave a comment

Filming Tips When Working from Home #filmingfromhome

For many of us we are now working from home and that has many challenges including staying engaged with your customers, students, colleagues and workforce.

A great way to do this is to create videos,  something that I usually do for people. I have professional cameras to do this but not everyone does, some have just their camera they use for fun like a mirrorless or DSLR and others a smartphone or webcam. In the videos above I have some tips to help make them a little bit more professional without needing all the gear and lighting.

Here is the gear I mentioned in this video:

Posted in Filming from home, filmmaking, photography, Uncategorized, Working from home | Leave a comment

Excel’s Newest Function XLOOKUP

VLOOKUP and HLOOKUP are two popular functions in Excel and a new one has come along to replace them, don’t worry they haven’t gone away. The new function is XLOOKUP it is easier to use and has some additional features such as what to do if it doesn’t find a match and also can look either to the left of the lookup value or above, something not possible with the other functions mentioned.

If you want to see how it works check out the video below.

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

Adjust Your AirDrop Settings to Stop Cyber-Flashing

AirDrop is a great feature in iOS as it allows you to share files like photos with people you are with or transfer from one device to another. The problem is when someone you don’t know sends you a file using AirDrop, is has been in the news recently as people have had this happen on public transport. It’s known as cyber-flashing. You can stop this from happening by adjusting your settings on your iOS device like your iPhone or iPad.

You will want to change the settings to stop anyone from sending you files. You need to set them to Contacts Only or Receiving Off.

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

Posted in iOS, iPad, iPad Pro, Iphone, Uncategorized | Tagged , , , , , | Leave a comment

Powering Your Smartphone or Tablet When You Are Running Low on Battery

There are not many of us with a smartphone who doesn’t get to some point in the day hunting around for a plug socket or to see who has the same phone so that we can borrow their charger. Smartphones whether they be an iPhone, Android or something else, can struggle with battery life, they are useful tools for both work and pleasure. Some say the answer is to use it less but that kind of defeats the purpose.  And it is not just the smartphone, what about if you have a tablet too.

Now in my job I can be out and about one day after the next without a desk of my own. I had these little power packs that have enough power to recharge your phone, but only once, so when I get home I now have that to charge up.

So I got a bigger power pack, it has two USB sockets so I can charge two devices at once, I can also use it to charge my camera batteries too. I also don’t need to charge it everyday. Depending on how I use it I may only need to charge it once a week. But I should be able to charge my iPhone at least four times before needing to charge the power pack.

The one I have is this one the RAVPower 16750 mAh power bank portable phone charger,  although it will charge pretty much anything USB. including my GoPro

You can get them here.

Amazon UK:
Amazon US:

Now there are new versions of the RAVPower like this one which has a lot more power.

Power Bank RAVPower 26800 Portable Charger 26800mAh Total 5.5A Output 3-Ports External Battery Packs (2.4A Input, iSmart 2.0 USB Power Pack) Portable Phone Charger iPhone, iPad Other Smart Devices)

Amazon UK:
Amazon US:


Posted in battery power, iPad, iPad Pro, Iphone, mobile devices, photography, Smartphone, Tablet, Technology | Tagged , , , , , , | Leave a comment

How to Crop Photographs and Images in Word

If you are adding a photograph, image or picture to Microsoft Word and you need to crop it you don’t need to do that before you insert it into your document you can crop it directly in Word. The advantages are you can see how it looks and fits directly in the document and it does not affect the original. In fact even after you have cropped it in Word you can change your mind.

Here is a video I made to show you how to crop a photo, picture or image in Word and some of the options available to you such as adding rounded corners.


Posted in Microsoft Office, microsoft word, productivity, Uncategorized, word | Tagged , , , , , , , , , , , , , , | Leave a comment

How to Save Files from a Dropbox Link without Filling Up Your Dropbox Account

Have you ever received a Dropbox link to some files or a folder but the problem is that they fill up your Dropbox account or you just don’t have enough space on your account anyway. Well there is a way to do this without affecting your own account.

What you need to do is download them to your hard drive rather than add them to your Dropbox account.

Here is a little video I made to show you how.

Posted in cloud, Computing, Dropbox, file management, Uncategorized | Tagged , , , , , , | Leave a comment

How to Look at Film Negatives Using Your iPhone

I was sorting out all these old photos and scanning them in as I went, and yes, there are still lots more to scan in. Whilst doing this I also came across lots of negatives and was wondering what was on them. Holding them up to a light you can kind of make out what is on them and really wanted to know as it might be worth getting a film scanner. Then it dawned on me, what if I use the magnifier on the iPhone, I seem to remember it having an invert option to switch colours from positive to negative so it makes sense that if I choose that option then bingo, I should see my negatives as they were intended.

You guessed it, it works and now I know I do need a film scanner as there are some negatives that I do not have as prints.

Here is a little video I made to show you how to do it. Must get back to sorting those prints.

Posted in Apple, digital photography, iOS, Iphone, photography | Tagged , , , , , | Leave a comment

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