Total Pageviews

Thursday, 20 June 2013

Freelancer portfolio Tips: Building Your Freelance Portfolio From Nothing

5 Steps to Building Your Freelance Portfolio From Nothing


So you’re a brand-new freelancer with no work for your portfolio. How can you get started building your business?
Low Hanging Fruit
We all know it’s tough to get a job without experience, and tough to get experience without a job. But you can break this cycle and start getting some samples. You really only need three or four to get started marketing your freelance services to paying prospects.
The trick is, your want these samples to look great, so you’ll choose your targets carefully. If you’re a writer, for instance, clips from Associated Content or other content mills are unlikely to impress anyone.
Instead, target small publications, local nonprofits, or small businesses that have a great reputation. How can you find these first gigs? By using what I like to call the low-hanging fruit method.

The Low-Hanging Fruit Method

It works like this: to make this break-in process as easy and fast as possible, you should target clients where you already have some knowledge of what they do. Ideally, these are small businesses where you know the owner, or otherwise have some sort of personal connection to the organization.
Target the low-hanging fruit that relate to your life and work experience, and break in the easy way.
You go after the client where it’s easy to make a strong case that you are the freelancer for them, because of your experience with their topic or type of freelance work.
Your dream niche might be to write about natural pet care, but if you haven’t worked for a company that makes those products or for a pet store and have never owned a pet, it will be harder to jump into that from a cold start. It’ll be easier to get a few initial clips in areas where you can demonstrate you know the subject matter.
So save yourself a lot of agony. Target the low-hanging fruit that relate to your life and work experience, and break in the easy way.

Step 1: Look At Your Life

To find your best targets for creating freebie samples, you first need to discover which types of markets are your personal low-hanging fruit.
Let’s take the example of Cindi, who’s trying to break in as a freelance writer. Here’s her story: She used to work in a restaurant and her dad sold insurance. She’s a longtime Rotarian. She nursed her aunt through two bouts of cancer, so she learned a lot of hospital and medical lingo.
She also took a stab at being a professional home organizer at one point. And she has a personal blog about tattoos.
These life experiences give Cindi an edge with the types of businesses and organizations she knows from her work and life experience. Her categories of low-hanging fruit prospects include:
  • Local restaurants
  • Insurance brokers and insurance companies
  • The national Rotarian magazine or local Rotary club’s website.
  • Local cancer or rehab clinics
  • Professional organizer associations
  • Tattoo parlors
Once you’ve identified the types of clients where you know their industry, you want to identify specific prospects who might be willing to take a flier and let you do a small project for them. Often, this is as easy as walking your main street or city center and noting the business names to spot ones that fit your knowledge.
Likewise, if you’ve volunteered designing newsletters for a local nonprofit, going after other nonprofits that have newsletters that could use design help would be your low-hanging fruit approach.

Step 2: Find Your Opportunity

Now that you have a list of where you have experience and types of clients that are likely prospects, it’s time to research what these various industries pay to see where the opportunity is best. There are many resources for doing this:
  • On the publications side, you could check out the Writers’ Market.
  • If it’s an industry, you can scan your local business pages, pick up a business weekly, or perhaps purchase a Book of Lists for your nearest major city. These guides state revenue for many public and private companies across many industries, so you could get a sense of who might be good future clients, and where the money is in your region. Some cities have a ton of medical facilities, while others are technology hubs, for instance.
  • There are also business databases including Hoovers and Manta that may help you identify businesses and find revenue figures.
  • You can set your Google search on the “News” tab or check PR websites such as PR Newswire for announcements in your industry — sometimes the company will brag about signing a big client or about their rising sales. That’s your cue that they might be a good client.
My newbie writer would probably quickly discover that there’s big money in healthcare and insurance, where right now restaurant is still struggling — and tattoo parlors don’t tend to have huge marketing budgets. So if Cindi wants to maximize her earnings, she might decide to hit those first two niches off the bat.

Step 3: Develop Your Prospect List

Now that you’ve identified your best-money opportunities, it’s time to find specific businesses, nonprofits, publications, or organizations to pitch.
What types of prospects are most likely to hire a newbie freelancer to do a project for them? The type that are too small to hire an in-house designer or writer, and also too small to afford a top-of-the-line $100-an-hour freelance pro. You are a perfect fit for:
  • Mom-and-pop stores you patronize
  • Nonprofits you support
  • Professional organizations you know
  • Small, local publications you read
Once you’ve identified some prospects, start researching their current marketing materials — check out their website, pick up their Chamber of Commerce brochure, or read their newsletter. While you’re doing this, look for holes in their marketing that you might fill. Perhaps their newsletter is plain text and could use a designer, or their blog hasn’t been updated in six months. Armed with this, research information about where your prospects might need your services, and you are ready to try to get a gig.
Two key things to look for: The marketing weakness you’ve spotted involves doing a type of freelancing you want to do more of in future. For example, they need blogging and you want to do that for pay, or they need graphic design and that’s your thing. Don’t get stuck doing a freelance assignment that won’t help you get the gigs you want.
The ideal situation is to approach prospects where you personally know the owner or publications editor, and can casually ask them whether they could use some marketing help. Next best is to have a friend or acquaintance who knows the owner introduce you.
Beyond that, you might send a letter of introduction, call them on the phone, or reach out to them on LinkedIn with your pitch, to name just a few possible marketing approaches.

Step 4: Pitch Without Seeming Desperate

You might think that approaching a small business owner to ask if you can work for them gratis would come off pretty pathetic. But you can make this pitch in a way that sounds professional.
Here’s a sample of how to present a free-work pitch with dignity:
Dear [prospect]:
I’m reaching out to you because I’m a freelance [writer, designer, etc.] looking to build my portfolio in the area of[this type of assignment–grantwriting, newsletter design, etc.,].
[NOTE how this does not say you're brand-new to freelancing and have no clips yet! This isn't a fact you necessarily have to disclose.]
In analyzing your current marketing materials, I noticed your website lacked [case studies, product descriptions, an updated blog, etc.]
[Briefly describe your experience with this industry – why you know their business or type of marketing need from work, hobby, etc.]
Because I want to build my reputation in this area, I’d be willing to do [name your small project here] for you without charge. All I’d ask in return is your willingness to refer and recommend me in future if you’re happy with my work – and not to mention that I did this project for you without charge. I also need to be able to claim credit for this piece.
We both win here – you get free marketing help and I get a valuable portfolio piece to my credit. I’m happy to tell you more about my [your type of freelance niche here - writing, design, etc.] background and discuss this with you further.
Let me know if you’re interested –
[Signature]
However you phrase it, keep it professional and straightforward. This is a mutual-need situation: You need clips, and they need marketing help. Simple as that.

Step 5: Negotiate Your Terms

Once you’ve got a client interested in letting you do a free sample, it’s time to define your relationship. Hopefully, you’ve mentioned what you need from this arrangement in your pitch, as shown above. But even so, before you start working, be sure to get confirmationin writing that the client agrees to your terms:
  • Define a small project. Don’t get sucked into designing a 100-page annual report or sign a contract to blog daily for three months without pay.
  • This client is sworn to secrecy that you did this work without pay. As far as future prospects will know, this was a paying client.
  • If the client is happy with your work, they will give you a testimonial.
  • The client is also willing to refer you to others in their industry or niche.
  • You will be allowed to take credit for this work and use it in your portfolio —do not sign a nondisclosure agreement that forbids you from using the project as a sample.
Beyond these special pro-bono project considerations, be sure to define terms just as you would with a paying client — exactly what you’ll do and when the project is due.
If you set this up right, you’ll execute a small project and the client will be ecstatic. They may well hire you back for pay to do additional work.
In any case, you should end up with a useful sample, a recommendation, and maybe even some referrals to paying clients. Now, you’re on your way to creating a professional-looking portfolio and lining up paying clients.

Tuesday, 18 June 2013

Font: Choice for Book, Website and Print

The difference between 'serif' and 'sans serif' fonts

Serif fonts have little feet and embellishments on the tip and base of each letter, making them more distinct and recognizable. Popular serif fonts are Times New Roman, Palatino, Georgia, Courier, Bookman and Garamond.

Nearly all books, newspapers, and magazines use a serif font. It's popularly accepted that – in print – serif fonts are easier to read. The idea being that the serifs actually make the letters flow together – and subsequently easier on the eyes.

As the name states, 'sans serif' fonts are fonts without serifs. While some sources say sans-serif fonts have existed since the 5th century BC, it wasn't until the 1920s that they became somewhat popular – mostly being used in advertisements.

One of the reasons for their lack of popularity was that typographers stuck with serif fonts because they felt they were easier to read.

It's been said that serif fonts are for "readability," while sans-serif fonts are for "legibility." Which is why, in print, sans-serif fonts are often used as the headline font and serif fonts are used for the body text.

Some popular San Serif fonts are Helvetica, Arial, Calibri, Century Gothic and Verdana.


Best fonts for print

In his book Cashvertising, Drew Eric Whitman cites a 1986 study of fonts (printed on paper) that found only 12 percent of participants effectively comprehended a paragraph set in sans-serif type versus 67 percent who were given a version set in serif typeface.

Those who read the sans-serif version said they had a tough time reading the text and "continually had to backtrack to regain comprehension."

In a test of three different fonts, two serifs (Garamond and Times New Roman) and one sans serif (Helvetica), he found 66 percent were able to comprehend Garamond; 31.5 percent Times New Roman, and 12.5 percent Helvetica (out of a total of 1,010,000 people surveyed).

The conclusion being that serif fonts are easier to read when it comes to fonts on paper. So, if you're sending out a sales letter or brochure in the mail, you probably want to use serif font (but, as mentioned in the first point, you could use sans-serif font for your headlines).

Here are the print font preferences of three of the copywriting greats: 1) advertising great John Caples liked using Cheltenham Bold for headlines; 2) advertising legend David Ogilvy preferred the Century family, Caslon, Baskerville, and Jenson; and 3) direct marketing guru Gary Halbert used Courier in his sales letters.


Best fonts for online

Now, one might assume that what works on the printed page will be similar to what works on the computer screen. But that's not the case.

In order to make the little serifs appear legible, a high degree of resolution is required. The more pixels, the more details of the font you can display.

Back 10 or so years ago, the best computer screen resolution was 800 x 600 pixels – which wasn’t great for defining the intricacies of a serif font. Screen resolution has increased through the years (resolutions of 1024 x 768 pixels or greater have become the norm). This makes serif fonts more legible but still generally not as easy to read as sans-serif fonts.

Plus, now you have to consider how your site or email will look on handheld devices, such as the BlackBerry and iPhone. The latest model of iPhone 4 has a screen resolution of 960 x 640 pixels. The BlackBerry Bold 978 has a screen resolution of 480 x 360 pixels.

So online, the best font to go with is sans serif.

A 2002 study by the Software Usability and Research Laboratory concluded that:

The most legible fonts were Arial, Courier, and Verdana.

At 10-point size, participants preferred Verdana. Times New Roman was the least preferred.

At 12-point size, Arial was preferred and Times New Roman was the least preferred.

The preferred font overall was Verdana, and Times New Roman was the least preferred.

So here are your marching orders:

For easiest online reading, use Arial 12-point size and larger. If you're going smaller than 12 points, Verdana at 10 points is your best choice. If you're after a formal look, use the font "Georgia." And for older readers, use at least a 14-point font.

Best fonts for email

Dr. Ralph F. Wilson, an e-commerce consultant, did a series of tests in 2001. He also came to the conclusion that the sans-serif fonts are more suited to the computer screen.

Some of the highlights of the test results were that at 12 points, respondents showed a preference for Arial over Verdana – 53% to 43% (with 4% not being able to distinguish between the two).

Two-thirds of respondents found that Verdana at 12 points was too large for body text, but Verdana at 10 points was voted more readable than Arial at 10 points by a 2 to 1 margin.

In conclusion, for the best font readability, use Arial 12 point or Verdana at 10 points and 9 points for body text. For headlines, he suggests using larger bold Verdana.

Deciding on a font

So the next time you submit a sales letter or email to your client, it might be a good idea to ask them what font they intend to use.

If they plan to use a serif font online or in an email, you might want to gently nudge them away from it and recommend a more easily readable sans-serif font.

If they also plan to send your copy to their list via regular mail, it's not a bad idea to suggest they switch over to a serif font at least for the body text.

It could mean the difference between a winning piece of copy and one that only delivers so-so results.


5 Great Fonts for Your Book Cover

To get you started, I’ve collected 5 great fonts for book cover design. Even better, three of them are free, and you can download them at fontsquirrel.com, so start experimenting with these for your book cover.

1. Chunk Five (free from fontsquirrel.com): This meaty and emphatic slab serif font is ideal for book titles in numerous genres. Try this font for action-oriented or political stories. Here’s a cover I did for an around-the-world sailing story:
great fonts for book covers
book design for self-publishers
2. League Gothic (free from fontsquirrel.com): This sans serif font is very vertical, which is ideal for book titles. League Gothic would be a great choice for thrillers or business books, and it can be useful if you have a very long title, too. Here’s a sample on Joanna Penn’s terrific thriller.
great fonts for book covers
great fonts for book covers
3. Trajan (available from Adobe): You might recognize Trajan, and that’s because it’s been used for more movie posters than any other font. It works quite well on books, too. This classic font is appropriate for histories, novels, and historical fiction, among others. Check out the French film poster using Trajan.
great fonts for book covers
great fonts for book covers
4. Franchise (free from fontsquirrel.com): Another tall and meaty sans serif, just ideal for the right book cover treatment. Franchise would be a great pick for a historical epic, for mysteries, or for thrillers. Here’s a sample of a novel in a gritty urban setting.
great fonts for book covers
great fonts for book covers
5. Baskerville (many versions available): Sometimes you need to have a straight roman typeface for your title, and in that case I like to use one of the variations of Baskerville, a highly readable typeface. You might find Baskerville perfect for a memoir, a business book, or a historical romance. Here’s a sample, and a cover from Vintage Books that shows how effective it can be.
great fonts for book covers

Fonts That Work in Books

Okay, so now you know how to recognize oldstyle fonts, how is that going to help you? Let’s take a look at some of my favorite fonts for interior book design, and you’ll see.
  • Garamond–There are many versions of typefaces known as Garamond, and this is one of the most popular families of fonts for use in books. A classic oldstyle font, Garamond is named for Claude Garamond, a publisher in 16thcentury France, and has given rise to many other similar typefaces like the also useful Sabon.
  • Caslon–This font originated with William Cason, one of England’s first printers and has been popular ever since. Caslon is one of the most widely-used typefaces for text and works very well in books.
  • Minion–A modern invention, Minion was designed by Robert Slimbach for Adobe Systems and has gone on to become one of the favorite fonts for book designers due to its regular color, interesting letterforms and the variety of weights and styles available.
  • Janson Text–Another Adobe font, Janson is based on a typeface created in the Netherlands in the 17th century, and our recent version was created by famed type designer Hermann Zapf in the 1950s.
  • Palatino–For a long time Palatino was the most popular oldstyle font of all, because it was included in the base set of fonts shipped with every new Macintosh, the original desktop publishing platform. Although it’s a beautiful font with some idiosyncrasies that designer Hermann Zapf included, I no longer use Palatino for books, exactly because it has been so over-exposed. But you might love it, so give it a try.

Top 10 Premium Fonts

This is the list of most popular premium (paid) fonts among designers. Some of them are very expensive but the quality of the font speaks for itself.
  1. Helvetica
  2. Gotham
  3. DIN
  4. Futura
  5. Neo Sans
  6. Adobe Caslon
  7. Skolar
  8. Kautiva
  9. Caecilia
  10. Fedra Sans

Common fonts for websites

Since not everyone is using the same operating system, it’s actually a little challenging to prepare a list of web safe fonts that you can use as pure text on your websites. Some people use Windows Vista or Mac OS X. Others use Linux. And others are still using older versions like Windows 98 or Mac OS 8! So to keep things safe, here is a list of the most common, standard fonts for websites that even people using ancient operating systems can see:
  • Arial
  • Courier New
  • Georgia
  • Helvetica
  • Times New Roman
  • Trebuchet MS
  • Verdana
  • Webdings
Here’s an image of what they look like:
100% safe!


I realize that this is a pretty short list, but remember that these fonts are to be used as pure text and not as logos or other fancy website design elements.
If you’re sure that most of your website visitors are using more recent operating systems, then you can also add these common website fonts to the list:
  • Andale Mono
  • Arial Black
  • Century Gothic
  • Comic Sans MS
  • Impact
  • Tahoma
  • Zapf Dingbats
Here’s an image of what they look like:
Could be safe
(There are a few more, but I’m the kind of website designer who prefers to use fonts that everyone can see.)

What's the difference between TrueType, PostScript, and OpenType fonts?


TrueType fonts can be scaled to any size and are clear and readable in all sizes. They can be sent to any printer or other output device that is supported by Windows. OpenType fonts are related to TrueType fonts, but incorporate a greater extension of the basic character set, including small capitalization, old-style numerals, and more detailed shapes, such asglyphs and ligatures. OpenType fonts are also clear and readable in all sizes and can be sent to any printer or other output device that is supported by Windows.
PostScript fonts are smooth, detailed, and of high quality. They are often used for printing, especially professional-quality printing, such as books or magazines.

Which font will work best for me?

It depends. If you just want a font that prints well and is easy to read on the screen, then consider using a TrueType font. If you need a large character set for language coverage and fine typography, then you might want to use an OpenType font. If you need to print professional quality print publications, such as glossy magazines, or you need to do commercial printing, PostScript is a good choice.

Friday, 14 June 2013

Excel 2010: Functions


  1. search: The syntax for the SEARCH function is: SEARCH( substring, string, [start_position] ) 
    • substring is the substring that you want to find.
    • string is the string to search within. 
    • start_position is optional. It is the position in string where the search will start. The first position is 1.
  2. The first implementation of the INDEX function returns the value from a table or range. The syntax for the INDEX function is: INDEX( array, row_number, [column_number] )
    • array is a range of cells or table. 
    • row_number is the row number in the array to use to return the value.
    • column_number is optional. It is the column number in the array to use to return the value.

Excel 2010: Removing spaces from excel

Tricks:
  1. Copy the column or row you need to remove the space from
  2. Open a .csv file and then paste into destination format. It will remove all the formatting and unwanted spaces.

On a computer, a space between words is not a blank area but a character, and, believe it or not, there is more than one type of space character.
One space character, commonly used in web pages, which TRIM will not remove is the non-breaking space (&nbsp).
 
1
2
3
4
5
A
Data
BD 122
="XY"&CHAR(7)&"453"
 BD    122
MN987
FormulaDescription (Result)
=TRIM(A2)Removes the trailing space from the string "BD 122 " (BD 112)
=CLEAN(A3)Removes the nonprinting BEL character (ASCII value of 7) from the string value created by the expression ="XY"&CHAR(7)&"453" (XY453)
=TRIM(SUBSTITUTE(A4,CHAR(160),CHAR(32)))Replaces each nonbreaking space character (Unicode value of 160) with a space character (ASCII value of 32) by using the SUBSTITUTE function, and then removes the leading and multiple embedded spaces from the string " BD   122" (BD 112)
=CLEAN(SUBSTITUTE(A5,CHAR(127),CHAR(7)))Replaces the nonprinting DEL character (ASCII value of 127) with a BEL character (ASCII value of 7) by using the SUBSTITUTE function, and then removes the BEL character from the string "MN987" (MN987)

Spot the Differences

Working with Excel data can be like one of those “Spot the Difference” puzzles. What’s different between list A and list B? If you’re lucky, the differences are obvious, like the forward slash in column B, and no leading slash in column E. Other times, it’s tougher to find the differences.
A common problem is items with leading or trailing spaces. You can’t see them on the screen, but after you’ve encountered them a few times, you learn to check for them. The LEN function is a great help if you suspect there are hidden space characters.
TRIM02

Thursday, 13 June 2013

MS Excell: Extract email addresses from a excel sheet


Resources:
In order to extract email address from excel cell you need VBA code in VBA Modules. Follow the steps:
  • Enable developer ribbon: File-->Option-->Customized Ribon-->Check the Developer option
  • Copy the following code into VBA Module: Select the workbook and press ALT+F11 or Developer-->Visual Basic-->Select the work sheet you are working on-->Right click-->Insert-->Module-->Copy the code:

Function Getmailid(cell As Range) As String

Dim Textstrng As String

Textstrng = cell.Text
Position@ = InStr(1, Textstrng, "@")
EmStart = InStrRev(Textstrng, " ", Position@)
If EmStart = 0 Then EmStart = 1
EmEnd = InStr(Position@, Textstrng, " ")
If EmEnd = 0 Then EmEnd = Len(Textstrng) + 1

mailid = Trim(Mid(Textstrng, EmStart, EmEnd - EmStart))

If Right(mailid, 1) = "." Then


  • Extract the email: In the empty column, select a cell and write the formula =getmailid(B11). Here B1 is the cell number from where you need to extract email address.  Sample of the data and mail IDs extracted with the UDF is as below



  • Updated formula: =IF((ISERROR(getmailid(A8))),"",getmailid(A8))


Sample:
email-1.png

Answer:
email-2.png


Array formula in D2:

=INDEX(A1:C1, 1, MIN(IF(ISERROR(SEARCH("@", A1:C1)), "", COLUMN(A1:C1))))
*SEARCH( substring, string, [start_position] )