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

Wednesday, September 7, 2016

Hover Text for HTML

GOAL:  Add "hover text" when a mouse hovers over a certain word in an HTML webpage.  

CODE
<p title="Hover Text"> Word <p>


EXAMPLE

Word

Hover over the "Word" above to see "Hover Text".  This is a very simple way of adding hover text using a native part of HTML:  the title attribute.  Note: You can use the "title" attribute with HTML text tags beyond <p> tag, such as <h1>, <h2>, <h3>.

Tuesday, September 6, 2016

Find Color Code of an Image on your Screen

GOAL:  Figure out the color code of something on your desktop screen so that you can use / reference that color in another app or site.  

STEPS

1. Download Color Picker App from Mac App Store

2. Open App & Click "Magnifying Glass" Button

3. Select the colored pixel on your screen that you'd like to reference

4. Copy HEX Code & Paste into another app or webpage


NOTE
This post is specific to MAC.  It can also be helpful for: 
- Finding a color to use when coding webpages
- Finding a color to use on a Google Slide


Monday, August 29, 2016

Cyberduck Permission Denied (Upload Failed in GUI, but not Terminal)

PROBLEM
Cyberduck "Upload Failed" in the Mac GUI.  Permission denied.

SOLUTION
Update Cyberduck to the latest version

STEPS
Cyberduck > Check for updates...


DETAILED PROBLEM 


Editing a file in the Cyberduck Graphical User Interface (GUI) resulted in "Upload Failed.  Permission Denied. Please contact your web hosting service provider for assistance.

Editing that same file through terminal in nano threw no permissions errors.

Specific to:

  • Mac
  • Cyberduck

Monday, May 2, 2016

Keynote Slides: Print Each Page of the Animation

GOAL:  Print each slide of a Keynote, including each step of all animations.

STEPS inside of Keynote

1. File
2. Export To > PDF...
3. Click the checkbox: "Print each stage of builds"

4. Next...
5. Export / Save
6. Open that PDF & Print

Monday, January 18, 2016

Youtube Link to a Specific Time

GOAL:  Send a link to a specific time in a youtube video.

STEPS

1.  Add  #t=10m11s  after your link

                 t = time, m = minutes, s = seconds

2.  Example:  https://www.youtube.com/watch?v=Hs6rzV8nsPY#t=24m35s 


This jumps the person opening the link to that exact minute and second of the video.

Upload Audiobook to Audible

GOAL:  Import or Upload an audiobook from a CD or MP3 to the Audible App.

STEPS


  1. Create an iTunes playlist called "Audiobooks"
  2. When syncing your iPhone to your computer:
    • Inside of the sync settings > under Book:Audiobooks
    • Select checkbox to sync books from that "Audiobooks" playlist
    • When iPhone is synced, the audiobooks transfer from your computer to your phone
  3. A new iTunes tab now automatically pops up in the "Audible" app