Category Archives: Office 2010

Microsoft Access: How to Use the Update Query

Posted on January 2, 2014 by garysch

If you have been following my blog since the beginning of this week you will have seen that I have been looking at action queries in Microsoft Access. These are queries that are using for changing the data sets such … Continue reading →

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

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 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

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

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

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

Excel Formulas, Getting Started with Calculations

Posted on November 17, 2013 by garysch

There are many things that Excel can do but fundamentally it is used for doing calculations. These can be simple or complex. I’ve done quite a few on functions and also some that use multiple functions but I needed to … Continue reading →

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

Recording Macros in Excel to Make Tasks Easier

Posted on September 8, 2013 by garysch

Excel is a great program and it is even better when you get it to do repetitive or complex tasks at a click of a button. You’ve thinking but how is that possible when everyone has different requirements and tasks … Continue reading →

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

Reducing the File Size of a Word Document That Has Images / Photographs

Posted on August 21, 2013 by garysch

Adding images and/or photographs to a Word document can significantly increase the size of the file. In all likelihood the images do not need to be as high quality as you would need if you were printing the image out … Continue reading →

Posted in Office 2010, word, word 2010 | Tagged , , , , , | Leave a comment

Excel 2010: Conditional Formatting

Posted on October 29, 2012 by garysch

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 … Continue reading →

Posted in Excel, Office 2010 | Tagged , , , | Leave a comment