RSS

Author Archives: thinkandbegin

About thinkandbegin

“think” – “and” - ”begin” “Thoughts are free and subject to no rule. On them rests the freedom of man, and they tower above the light of nature…create a new heaven, a new firmament, a new source of energy from which new arts flow.” Thinking allows beings to make sense of or model the world in different ways, and to represent or interpret it in ways that are significant to them, or which accord with their needs, attachments, objectives, plans, commitments, ends and desires. Thinking as an intellectual exertion aimed at finding an answer to a question or the solution of a practical problem.

shiefted to http://thinkandbegin.com/

Please visit the newer one.

Thank You

Author | thinkandbegin

 
Leave a comment

Posted by on August 26, 2012 in My Home

 

Learn MS Excel 2010 : Recommended Books

Excel 2010 is a spreadsheet software in the new Microsoft 2010 Office Suite. Excel allows you to store, manipulate and analyze data in organized workbooks for home and business tasks. New innovations in Excel 2010 include the enhanced data viewing features of Spark lines and Slicers.

step by stepMS Excel 2010

excel bible 2010Picture yourself learning MS Excel 2010

Note: Hyperlinks have been disabled because neither I am not promoting any site over here or I have any tie up with any books selling company. Take help of Google for more information about the above books.

 
Leave a comment

Posted by on June 15, 2012 in My Home

 

Learn Excel with Dummies

Look at MS Excel 2007, with lot many features as compared to the earlier versions and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here!

If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

Dummies

You’ll discover how to:

  • Rearrange, delete and insert new information
  • Keep track of and organize data in a single worksheet
  • Transfer data between the sheets of different workbooks
  • Create a chart using the data in a worksheet
  • Add hyperlinks and graphics to worksheets
  • And more!

Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.

                                                                                 thinkandbegin

 
Leave a comment

Posted by on June 14, 2012 in My Home

 

Why do we see the particular adds on Facebook?

Facebook wants to show us ads that will be interesting and relevant to us. Here is some of the info that might be used to do this:
1. Information that we have added about our self, like our current city, sex, age, relationship status, jobs or schools
2. Interests that we have listed in our profile (timeline) and the Pages and groups we are connected to
3. Actions we take on Facebook, like the Pages or Groups we visit or the apps that we use.  Keywords from our posts and status updates. This is done using an automated system. No one at Facebook reads our posts.
4. Note that including more content on our profile (timeline) that relates to our interests may improve the relevance or focus of the Facebook Ads we are looking at.

How this works:

Facebook has created ad clusters (ex: sports lover, moviegoer, etc. ) that advertisers can use to target their ads. For example, a theater might want to target moviegoers and we might be a member of the moviegoer cluster if we have Liked a number of Pages associated with movies and if we mention movie in your posts.

Advertisers can also target their ads based on topics and keywords. For example, an advertiser can target their ads to the topic Sports and anyone on Facebook who Likes anything sports-related may see those ads. Or, can use a keyword, like The Sound of Music, which will cause the ad to be shown to Facebook members who have specifically liked The Sound of Music Page or added it as an interest on their timeline.
As always, none of our information is shared with advertisers. All ad targeting is performed by an automated system. Advertisers are also not able to see any information about the people who view or click on their ads.

 
2 Comments

Posted by on June 11, 2012 in Miscellaneous, My Home

 

Run Free E-mail Campaign : Use MS Office

Mail-merge is one of the most useful facilities offered by MS Office. It is the joining together of two sources of information into a single document, usually a list of names and a standard letter/mail to whom a personalized copy of the letter/mail must be sent. This is most commonly done in creating address labels or creating a form letter and most importantly running mail campaign. Only certain details on the mail/letter will change, like having the same mail addressed to a number of different people.

Mail-merge happens with the help of 3 tools i.e. MS Word, MS Excel, MS outlook. Write the body of the mail in word, insert senders list in the form of excel, send mails through outlook. This is the best way to run free mail campaigns.

How to run mail-merge please click here. http://support.microsoft.com/kb/294683

How to handle “bounced back” emails or “unsubscribed” emails

Create few rules in your outlook for different mail groups. For Ex, if the subject line contains “unsubscribe” then push all the mails to a new folder named “Unsubscribed”. Similarly the same can be done for bounced back emails.

In case of mail campaigns you can expect at least 7-10% bounced mails. It means if you are running a campaign of 50K mails, then you can have 3k to 5k bounced mails and few subscriptions. Now it’s the tough time to handle to bounced mail IDs and unsubscribed mail IDs.

Now let’s understand how to handle these bulk bounced mails. Outlook provides an option to export all the mails from a particular folder into an excel sheet. We’ll use this to extract the data into the excel sheet.

It’ll export all the details to an excel sheet. The sheet looks somewhat similar to this.

You’ll find the bounced email IDs from this message in the form of

Hi. This is the qmail-send program at yahoo.com.

 I’m afraid I wasn’t able to deliver your message to the following addresses.

 This is a permanent error; I’ve given up. Sorry it didn’t work out.

<prkbhup.hr@gmail.com>:

 74.125.127.27 does not like rec

 

So now our task is to extract only the email IDs so that we can remove these email IDs from out database for our future mail campaigns with more accuracy.

=FIND(“<“,A17) =FIND(“>”,A17) =C17+1 =D17-E17 =MID(A17,E17,F17) prkbhup.hr@gmail.com

Now your excel sheet will look like this:

Now easily we can remove these emai IDs from our database.

 

 

 

 
1 Comment

Posted by on June 3, 2012 in Miscellaneous, My Home

 

Excellent Representation of Data

 
1 Comment

Posted by on May 7, 2012 in MS Excel

 

ISBLANK()

The ISBLANK function’s job is to check to see if a certain cell is empty or not. If the cell is empty, a value of TRUE is returned by the function.
If data is later added to an empty cell the function will automatically update and return a FALSE value.
The syntax for the ISBLANK function is:
= ISBLANK ( Value )
Value: Refers to the cell reference that is being checked.
Example Using Excel’s ISBLANK Function:
For help with this example, see the image to the right.
  1. Type a number, such as ” 3 “, or a word of text into cell.
  2. Click on cell – the location where the results will be displayed.
  3. Click on the Formulas tab.
  4. Choose More Functions > Information from the ribbon to open the function drop down list.
  5. Click on ISBLANK in the list to bring up that function’s dialog box.
  6. Click on cell, in the spreadsheet to enter the cell reference into the dialog box.
  7. Click OK.
  8. The value FALSE should appear in the resulted cell, because value cell is not empty.
  9. The complete function = ISBLANK ( cell ) appears in the formula bar above the worksheet when you click on cell.
  10. To return a value of TRUE in cell, delete the data in value cell or change the cell reference in the function to a cell that is empty.
 
Leave a comment

Posted by on May 5, 2012 in MS Excel, My Home

 
 
%d bloggers like this: