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

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