CafeMom Tickers

Tuesday, May 17, 2011

Skeleton

Another practice that I did.
Guide: http://www.blog.spoongraphics.co.uk/tutorials/how-to-create-a-stylish-skull-based-vector-illustration

Sunday, May 15, 2011

Vintage, organic logo through Illustrator and Photoshop

Credit to http://www.blog.spoongraphics.co.uk/tutorials/how-to-create-a-retro-badgeemblem-style-logo

I created the logo by following his instruction/guides. Very good source of Illustrator's lesson

Monday, May 2, 2011

Excel tricks that I fond

Below are collective tutorials that I like: Countif  & find

1) To count if it is apples or oranges

=countif(range, criteria)+countif(range, criteria)

2) To count more than "criteria".
=countif(range, ">"& criteria)

3) To count number of words ending with es
=countif(range, "*es")

4) To find text using formated text data with space 

5) To find text using vlookup & wildcard. *Note: Faster than SEARCH and returns the first value.
= vloopup("*"&target"*",Range,target column,0)
6) To find text using lookup & SEARCH.*Note: Slower than Vlookup and returns the last value
=lookup(2*15, Search(target,range),target column)

7) Dynamic Data extraction

Sunday, May 1, 2011

Learn new software to have fun in life - Illustrator

Here is my result.


The originator is Chris from http://www.blog.spoongraphics.co.uk/tutorials/illustrator-tutorial-create-a-gang-of-vector-ninjas

He is such a great teacher!