Please visit the newer one.
Author | thinkandbegin
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.
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.
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.
You’ll discover how to:
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.
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.
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.
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.
220.127.116.11 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.
Now your excel sheet will look like this:
Now easily we can remove these emai IDs from our database.