Skip to content

Definition of Success


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

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.

Punctuality


If you’re not early, you’re late

(unknown – let me know who said that) pu