Skip to content

Definition of Success

80% of success is being on time.  (Woody Allen)

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!



Creating a simple macro in Excel 2016

There is no visual basic used in this demonstration where a couple of very simple macros are created. Make sure you select “relative reference” when doing this.

Make sure you concentrate while creating a macro – you do NOT want to be distracted!

Very important – when saving the worksheet, make sure you click on NO on the save button – otherwise you’ll save an xlsx file instead of a an xlsm file which contains the macro.

Excel – countif and if statements

If statements are either true or false – can use to determine many items such as raises, bonuses, and more. Countif is not an if statement – what it does is count number of occurrences a word may appear – for example if you want to know # of staff members who have absent more than x amount of days, you can accomplish this very quickly and rapidly!

Sumif function – Excel

Sumif is a powerful function where you can total numbers that meet a specific criteria.  Learn how to do this in 67 seconds!

Excel PMT function

This was done in version 2016/365 = will work with previous versions.

Google Docs – import/export files

More and more people are using Google Docs – files are portable and can be opened any place where there is an internet connection and a computer.

This video shows how to both import and export.  Please note that Google Docs does not have the power of Word which you will see.  However, if files are kept relatively simple (i.e. no excessive formatting or special features), things will work very good.  You can also export the Docs file to a PDF format.

Excel – filter data

This video uses Excel 2016 – will work with any version back to version 2007.  It shows you how to take a large amount of data and narrow it down – in this example, we can look at the number of projects each person did at an appraisal company and find their earnings.  In addition, data can be filtered down from hundreds (if not thousands) of records down to a few by searching different captions or field names.