Whether it be Excel, Word, Access, PowerPoint or a whole load of other programs, here are short video tutorials to help you use these programs with lots of easy, useful tips presented by Gary Schwartz
If you do not have a debit or credit card, perhaps you are not old enough to have one or have some gift certificates, and you want to get content like music, movies, TV shows, apps, books etc then this can be tricky, you cannot just set up an Apple ID there is something you need to do first. Here Gary Schwartz from www.jargonfreehelp.com talks you through doing this.
If you have an Excel spreadsheet and you have lots of data then when you scroll around you probably can't see the important information in the left column or top row. There is thankfully an easy solution. You might also want to split the screen so that you see different information in different part of your worksheet. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how to do both of these with freeze panes and split.
It seems many of you with an iPhone and/or iPad are unaware that there is caps lock on your device. So rather than having to tap on the shift key each time here is how you can avoid that by switching on caps lock. For more tutorials see http://www.jargonfreehelp.com
In part 2 we take a look at how to manage rules and how to customise the formatting of a conditional format. You can also delete and manage rules, change icons in an icon set and see more conditions. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.
Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly drawn to what you are looking for. Here Gary Schwartz from http://www.jargonfreehelp.com gets us started with highlight cells rules, data bars, color scales, icon sets and top-bottom rules. You will also see how to clear a rule. See part 2 for more customising o...
If you are not getting the speed you expect from you wireless connection there are a few things you can try to help speed it up. There are some that are out of your hands and some others that you can try. One major one you can try is changing the channel on your router as they often interfere with other routers or hubs. But how do you know which one to change it to? Here Gary Schwartz explains how.
If you need to capture the screen of what you are seeing on your computer either to save in a presentation or document, perhaps it is to capture an error mesaage or what is happening on screen for some help. You can also email it to someone here is how you can do it in Windows 7.
Want to let someone know you'll call them back soon or set a reminder to call them? Well this is now possible on your iPhone. When you get the call you have options of which message to send which can be preset or customised. You can also set a reminder for 1 hour or when you leave, get home or get to work.
Finally in iOS for iPhone, iPad and iPod touch you can go back more than one page at a time when surfing the internet. Now you can go back through your browsing history and jump to the page with just a couple of taps.
If you need to switch off notifications temporarily in Mac OS X Mountain Lion it is really easy to do. You might want to switch them off so you are not getting distracted, getting fed up of the barrage of notifications or perhaps you are doing a demo or presentation. In this video you will see how quick it is to do.
