Monthly Archives: December 2013

Microsoft Access: How to Use the Append Query

Posted on December 31, 2013 by garysch

So you’ve imported some data into your Microsoft Access database and now need to add that data to an existing table. It would be handy to copy and paste but using an append query does the trick and you can … Continue reading →

Posted in Microsoft Access, Microsoft Office, Office 2010 | Tagged , , , , | Leave a comment

Microsoft Access: How to Use the Delete Query

Posted on December 30, 2013 by garysch

As the names suggests this type of action query is going to delete data so if you are doing this for the first time try this on some data you are not worried about losing or on a copy of … Continue reading →

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

Microsoft Access: How to Use Make Table Query

Posted on December 29, 2013 by garysch

Microsoft Access has different types of queries to do everything from just viewing selected data to archiving it using a make table query, deleting data, appending data and updating data. For the next few days I will be adding video … Continue reading →

Posted in Microsoft Access, Office 2010 | Tagged , , , , , , | 1 Comment

Excel Using Text Functions

Posted on December 28, 2013 by garysch

Excel is great for dealing with numbers but it also has functions for dealing with text. You can check in a bit of the text by extracting it using one of the functions like LEFT, RIGHT and MID.  You can … Continue reading →

Posted in Excel | Tagged , | 1 Comment

Excel How to Use Subtotals

Posted on December 27, 2013 by garysch

Excel is packed with lots of great tools. One of my favourites is the Subtotals. Here you can take a list, sort it into order so that appropriate items are grouped together, then click a button and it will determine … Continue reading →

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

Combining VLOOKUP and HLOOKUP Functions

Posted on December 26, 2013 by garysch

HLOOKUP and VLOOKUP functions are very useful functions on their own but if you combine them together you can do even more. If you are using VLOOKUP rather than having the two columns one with the value to lookup and … Continue reading →

Posted in Excel, Office 2010 | Tagged , , , , | 2 Comments

Free Apps, Songs, Books, TV Shows and Movies for your iPhone and iPad…

Posted on December 25, 2013 by garysch

…with the free 12 days of Christmas app from iTunes. Everyday from the 26th December for 12 days there is one free item. I have done this now for the past few years and although not everything is something I … Continue reading →

Posted in iOS, iOS 7, iOS6, iOS7, iPad, Iphone, iTunes | Tagged , , , , , | Leave a comment

Excel Database Functions

Posted on December 24, 2013 by garysch

So this week I’ve had a bit of inspiration creating some Excel tutorials but don’t worry I’ve also started others including the photography and video podcasts which will be with you in January 2014. But here is one Excel one … Continue reading →

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

Excel: Using the HLOOKUP Function

Posted on December 23, 2013 by garysch

Some time ago I did a tutorial on VLOOKUP and have finally got around to doing one on the HLOOKUP function. It is very similar except that the data is in columns as opposed to rows as you would find … Continue reading →

Posted in Uncategorized | Leave a comment

Remove Duplicates in Excel

Posted on December 22, 2013 by garysch

I’m often asked how to remove duplicate entries in an Excel list or database, they are the same thing but Microsoft have more recently called them lists. Thankfully it is easy to do, particularly on more recent versions of Excel. … Continue reading →

Posted in Excel, Office 2010 | 1 Comment