Monday, October 17, 2016

Digitize Your Handwriting into a Font


GOAL:  Digitize your handwriting and turn it into a font.  Made possible by www.MyScriptFont.com.

STEPS

1.  Print this template and fill out all of the squares with a black marker.

2. Scan it as a Photo (at 300 dpi) in grayscale, not color.  Save as JPG.

3. Upload the JPG, PNG, or PDF template to www.MyScriptFont.com.

4. Choose .TTF file format + Download

5. Mac Steps: Go to Apps > Font Book

6. Drag & drop your .TTF file into the Font Book App

Now, open up Word and use your new font!

Friday, October 7, 2016

Copy Unique Values in Google Sheets


GOAL
Copy unique values from one column to another column in Google Sheets (or Excel).


SOLUTION

=UNIQUE(A1:A10)

A1:A10 is the range of cells you hope to narrow to only unique values


EXAMPLE
Column A:
Column B: Use this formula:
=UNIQUE(A1:A13)
and get the following:
Dogs
Dogs
Cats
Dogs
Dogs
Dogs
Cats
Snakes
Cats
Turtles
Dogs
Dogs
Cats
Dogs
Cats
Snakes
Turtles