Author Archives: garysch

Unknown's avatar

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com

Importing and Exporting Data in Excel

Posted on February 8, 2014 by garysch

Excel does many useful things and entering data so that you can do calculations or manipulate data. However, sometimes you need to bring that data in from somewhere else or you need to export it to be used in another … Continue reading →

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

Getting Started with PowerPoint

Posted on February 2, 2014 by garysch

If you have watched any presentation over the past couple of decades then the chances are you have watched a PowerPoint presentation. If you need to create your own presentation and have either not done one before or need a … Continue reading →

Posted in Microsoft Office, PowerPoint | Tagged , | Leave a comment

Excel: Using Data Tables

Posted on January 13, 2014 by garysch

Analyzing data in Excel is one of its great features and there are a number of tools for doing this, aside from sometimes just changing a value and seeing what happens. If you have done this then there is an … Continue reading →

Posted in Excel, Uncategorized | 1 Comment

Technology I Found Useful in 2013

Posted on January 4, 2014 by garysch

From a technology point of view I didn’t feel that this was a year where there were many “wow” moments, if any at all, and the usual leaders in wow, Apple, seemed a little flat. In fact like many it … Continue reading →

Posted in mac os x, Mavericks, photography, Samsung Galaxy S4, Technology, Windows 8.1 | Tagged , , , , , , , , | Leave a comment

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

IT Tech Tips for the New Year and Relax

Posted on January 1, 2014 by garysch

Happy new year! Here’s to a fabulous 2014. As many make resolutions at this time of year here are some you could add to make your life less dominated by IT and relax a bit more. Let’s face it technology … Continue reading →

Posted in productivity, Smartphone, Technology, travel | 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 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