Skip to content

Mail Merge – Word and Excel 2016


Doing a mail merge in Word has been the same since version 2002.  Using the wizard, a demonstration of a letter and creating labels is performed.  If you’re merging with an Excel file and have zip codes that begin with a 0, a New England zip code such as 06024 will show up as 6024.  Instructions on how to work around this are demonstrated in this video.

 

Advertisements

Access 2016 – filter data, create a query


The beauty of Access is that you can narrow down thousands of records to a small number of items that match your target.  You can either quickly filter data down that will show results or create queries that will constantly be updated as new data is entered in the database.

Intro to Access Databases


Databases are very powerful – you can narrow down thousands of records down to a few as you target  your search of data – useful for business, those analyzing demographics, or attempting to forecasting trends.

These videos are a supplement to classes being taught.

This video shows tables, creating relationships. Add data from an existing spreadsheet to an Access table (you will see some mistakes which often can occur even for experienced users!). Filter data in a table, add fields to a table, and creation of a simple query.

Photo Art – fitting an irregular sized photo into a standard frame.


Photo Artistry – adding elements to a photo and adjusting it to fit inside a standard sized frame. This is useful to know if you have an irregular photo (i.e. 7 x 4) and you want it to fit in a standard 8 x 10 frame.

A few design tips are also included so that you can make the photo really pop in the frame – great way to make gifts for friends as the holidays will be arriving sooner than we think!

Formatting 101 – Word 365


Discover the basics of fonts, point sizes, borders, shading and more in this tutorial – Word 2016 is very similar in this fashion with earlier versions.   This video demonstrates these features.

Excel – FV (future value) and goal seek


FV allows you to see what the value of an investment would be after x amount of years based on a constant rate of return, based on the same amount of investment.

Example:  Invest $2,000 a year for the next 20 yeas at a 2.5% return.  This video explains it.

Goal seek allows you to set goals – let’s say you only have $42,000 after doing an investment strategy – and you want to have $100,000.  Using goal seek you can determine how much to invest each year, # of years, or the rate of return required to obtain this value.  Video demonstrates this.

Snapseed – a free app to retouch photos


I don’t know how many of you have heard of Snapseed – it’s a free app for both android and IOS systems – it works on cell phones as well as tablets.

Although it is not exactly Photoshop, it is very powerful, creative and allows you to cusotmize effects in your photos – in the few times I’ve used it, not a single popup ad!

For the most part it is self teaching – there are classes being offered on it.  Use Snapseed to improve photos, be creative, or to inspire any other art form such as painting with  any medium, sculpture, and more.  Improve perspective, remove imperfections, create double exposures, vignetting.  What is nice is that  you can save the file as a copy so the original is not damaged.

Be as creative (o conservative) as you want  – get the download and experiment with your photos.  As you can see, they even have a “grunge” effect!

snapseed