some charts functions that I fond of

1) Create a dynamic updated chart (for latest data) using Name List &  Offset function,

Many useful worksheet in http://people.highline.edu/mgirvin/ExcelIsFun.htm.

Second active month Report

One month ago, my statistic was 13sales with $6.73 revenue.
Now, it is time to submit another report card.

Accumulated Sales: 22 (increased 69%)
Accumulated Revenue due to Sales $31.96 - (79-2)*0.2 = $16.56 (increased 146%)
 

Thrill from selling images online

Definitely, my case is not a successful case. But, it is fun to learn little by little at a time.
Firstly, I shoot for what I like. I don't shoot to ensure the images deliver the concepts of potential buyers.
Secondly, I didn't study the demand in DT.
Lastly, I simply shoot too little. Time to polish my gears and shoot with stock photography in mind!

Here is my poor statistic.
As of now, the official sales is 13 with $6.73 revenue. Let's see how much I can achieve in 1 month.

Skeleton

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

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

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

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!