Recent Articles

May 8, 2014

200+ Best Microsoft Excel Books - eBooks

May 8, 2014 - 0 Comments

I think that Excel skills is one of the most important skills not only for students information technology in particular but also for students in general. And I'm believe that most of the companies are using Excel for their business so learning and researching Excel is necessary for yourself and future work. Do you agree with me? :)

The list below is a collection of Excel eBooks that are collected from Internet source.

1. Microsoft Excel 2013 Bible : Excel 2013 Bible is the latest version of the Bible series, designed for beginning, intermediate, and advanced users. This book was written for Excel 2013 for Windows. If you’re using an older version of Excel, I think that you should find a book that’s appropriate for your version of Excel. It covers all the essential components of Excel and provides clear and practical examples that you can adapt to your own needs. We will learn the basics of Excel and then move on to more advanced topics at your own pace and you will also find many useful examples and lots of tips and tricks in this book.
2. Microsoft Excel 2013 VBA and Macros : Microsoft Excel 2013 VBA and Macros is fourth edition of VBA and Macros for Excel series, is designed to work with Excel 2013. We will learn how to write macros that use Excel 2013 enhancements, work efficiently with ranges, cells, etc. We also will build applications with arrays, then write Excel 2013 VBA code that works on older versions of Excel. We will work with both Access and SQL Server databases, learning advanced techniques such as classes, collections, and custom functions, controlling other Office programs, etc.
3. Excel 2013 In Depth : Get more out of Microsoft Excel® 2013: more productivity and better answers for greater success! Drawing on his unsurpassed Excel experience, Bill Jelen (“Mr Excel”) brings together all the intensely useful knowledge you need: insights, techniques, tips, and shortcuts you just won’t find anywhere else. Excel 2013 In Depth is the fastest, best way to master Excel 2013’s full power; get comfortable with its updated interface; and leverage its new tools for everything from formulas, charts, and functions to dashboards, data visualization, and social media integration. Start by taking a quick “tour” of Excel 2013’s most valuable new features.

March 18, 2014

Q&A

March 18, 2014 - 0 Comments

Computer & Internet


Click on the question to get the answer


Q. Word 2010 how to display all types of files when saving a new file?
Q. How build a offline Android app and which software to use this?
Q. I know python now what can i build with it? What can i use to build with it, like what should i make and how would i build what type would i use just make multiple functions or something not sure.
Q. Wordpad document recovery? I was working on 2 new WordPad documents and my laptop went into the blue screen of death. I didn't have a chance to save them. Is there any chance at recovering them?
Q. Can't download SAFARI version 7? I'm trying to download SAFARI 5.1.7 BUT it says I can't because: "This update requires Mac OS X version 10.6. " So when I go to download 10.6 - it says the EXACT same thing which is irratating because that's what I'm doing! Please help! It's kind of urgent!
Q. Is there any way to protect my wi fi password from apps like wifi hacker which can easily crack wifi password?
Q. Samsung galaxy S4 battery problems? I just recently purchased a samsung galaxy S4 two days ago. Everything works great for the most part except battery. I looked up online how save battery and nothing has worked.ive turned on the power save mode, screen brightness all the way down, all of my apps are manual refresh.
i have barely used my phone today besides a couple texts and it's currently at 58% Ive probably lost 3% just typing this message.
Any idea what is going on? Should take it back?
Q. Can Adobe products, specially CS5 ones, run on a windows 8.1 tablet? Touch screen? It also runs as a laptop.
Q. How do you do percent in excel? Cost /unit 2.99. Number of units 25. My total is $74.75 how do you write the percent for this in excel.
Q. How to find your Adobe License? If you have adobe products installed on your computer, is there a folder which contains your licensing information? Not serial numbers, but your licensing info.
Q. I have amounts in one column entered in w/out thousand separators. I'm using a formula to make a sentence in another column and want to reflect those
Q. I have a list of e-mail addresses in a column in an Excel spreadsheet, one address in each cell. I want to use this list to create a text string consisting of all the addresses in a row, separated by comma/space (i.e. "test1@abc.com, test2@def.com, test3@ghi.com, ..."), so I can paste this string into the "To" box of an outgoing e-mail. How can I do this in a way that will be the least labor-intensive?
Q. How do you copy a set of cell values, but not the formatting?
Q. I have a sum of figures in a row and want to calculate how many of the cells in a column are multiples of 250
Q. I have a list of people and a list programs (all words no numbers), I want to be able to type the programs beside a people's names and their names be automatically filled in beside the program that I put beside their name is this possible.
Q. I am trying to create a formula that looks at a date and can tell if it's within 30, 60, and 90 days out. Can you help?
Q. I need a formula to calculate the retail price of an item with a 55% gross margin. I have the Cost of Good Sold amount but can't figure out the formula that would give me the retail accounting for the COGS being 45% of retail price.
Q. I need a formula that calculates the number of additional shares a company must issue to a shareholder in order for that shareholder, plus three additional shareholders, to own 80% of the newly issued shares of the company.
Q. I have a column set up with conditional formatting to color the cell w/in the column a certain color depending on a certain word. Ex)"Post" = Green, "Select"=Blue, "Deny"=Red, "Hold"=Yellow. I need the entire row to change the same color as the one cell w/out merging. How can I format the color to the whole row depending on the status of the one cell?
Q. I have a macro that inserts a row every one minute and populates the first cell of that row with the price of a stock. I'm trying to apply an "average" function to the first 5 cells as the prices come in. However, the range of the average is also moving down as new rows are inserted. The objective is to anchor the range of the average function even as new rows are added. thanks.
Q. Need a formula to pull first and second letter when only one word present and first letter of each word when 2 words are present. "Left" formula solves the problem half the time. Example below: Machaloa MA Santa Barbara SB
Q. how to use if function to calculate commission based on selling price if <=$500,000=3%, selling price >$500,000=3.5%
Q. I know the formula to show today's date on a spreadsheet, but is there a formula to show the current weekday, ie mon, tue or wed etc?
Q. I WANT TO GET THE TOTAL OF A COLUMN WITH POSTIVE AND NEGATIVE DOLLAR AMOUNTS. HOW DO I DO THIS

March 17, 2014

Make Money Online on Elance: Excel Skills Combined with Data Entry & Research

March 17, 2014 - 0 Comments

You are searching a great method to Make Money Online from yourself skills. You are finding an online working environment professional. You are a student and wish find a online job consistent with spare time or you are a person who love making money online.
Well, if the answer is yes so this is just a starting point. Actually, we'll have many things that need to learn in the future. Why? Because we (me and many new beginners) still haven't knowledge and experience. Here we learn and research theory to apply it to the real job and Make Money Online. In other words, from real job we will know what to learn and necessary requirements to complete it.

In this article, we will find out a model online job marketplace trust and safety where connecting between Business (Contractors) looking for to hire Freelancers to complete Projects. A typical representative for this model that I'm referring to Elance.

What is Elance?


Elance is an online work platform for business (contractors) to hire and work with freelancers not only in the United States but also internationally. Elance offers freelancers in various categories of IT & Programming, Design & Multimedia, Writing & Translation, Sales & Marketing, Admin Support, Engineering & Manufacturing, Finance & Management and Legal.
Elance has over 500,000 businesses posting 100,000+ jobs each month and over 2 million skilled freelancers from around the world.

Make Money Online on Elance

As a new Freelancer,



March 14, 2014

Make Money Online: Swagbucks Rewarded Members Over $57,700,000

March 14, 2014 - 0 Comments

You are searching a simple way to Make Money Online. However, you don't have much skills, training, degree or experience. That is not important. Because we only do tasks consistent with our ability. Along with the strong development of Internet, has created a wonderful environment for many people who work hard to can earn money online as a basic source of income.

Indeed, there are many methods to Make Money Online. Each method will has its own requirements. Maybe easily, maybe difficult. Of course, we will begin to do simple things first. Today in this article, we will find out how to earn and redeem gift cards with virtual currency called "Swag Bucks" on http://www.swagbucks.com website.

swagbucks.com
swagbucks.com is an online rewards program website that allows web and mobile members to earn digital dollars called "Swag Bucks" for their online activity daily - searching the web, watching videos, playing games, shopping and earn, voting in the daily polls, trusted surveys, completing special offers, invitting friends, trade-in, coupons, daily deals( limited-time deals), Swag codes, NOSO( No Obligation Special Offers), and Tasks.

Make Money Online: Swagbucks Rewarded Members Over $57,700,000

On February 25, 2008, Prodégé launched swagbucks.com and introduced the "Swag Bucks" as a digital currency earned for activity throughout its network of websites. The company are situated in Los Angeles County, California, United States. Now in March 2014, swagbucks is ranked by Alexa Internet 110 in US and 499 on global rank.


swagbucks.com's social media:
Facebook: https://www.facebook.com/swagbucks
Twitter: https://twitter.com/swagbucks
Flickr: http://www.flickr.com/photos/swagbucks

Well, this is the first important note, now as I know swagbucks.com is available in all of the following countries:
1. US
2. UK
3. Canada
4. Australia
5. Iceland
and 6. India( I'm not sure)

Second, in USA if you under 13 years old, you are NOT permitted to use swagbucks.com. (Age restrictions vary by country).

OK. Now we will come to the main points about our topic to understand how it works and avoid mistakes can happen.

Make Money Online: Swagbucks Do-Don't
Make Money Online: Swagbucks Searching
Make Money Online: Swagbucks Promoting
Make Money Online: Swagbucks Code
Make Money Online: Swagbucks Paticipating 1
Make Money Online: Swagbucks Participating


Now, we'll going deeper how to earn "Swag bucks" by the following ways:

Search:


swagbucks.com has a their own search engine ( you can imagine it similar to the other search engines such as Google Search, Bing, etc). And a great thing when you use Swagbucks Search Engine that is you have the chance to win Swag Bucks randomly between 1 and 1,000 Swag Bucks for a single search. The search results are display on Swagbucks are powered by Google and Bing so you can trust.

There are some methods to access Swagbucks Search:
1. From Search Page:

Swagbucks Search Engine


2. From the Toolbar:

Make Money Online: Swagbucks Toolbar
If you don't like Toolbar you can use plugin. However, using Toolbar will earn many "Swag Bucks" more.
http://www.swagbucks.com/g/toolbars-and-plugins

3. From Smartphone and Tablets:

Make Money Online: Swagbucks Smartphone

On your smartphone and tablet, you can free download and install app "Swagbucks TV", now support on two the popular mobile platforms Android and iOS.

+ Watch video Search with Swagbucks


Swagbucks TV:


Swagbucks TV is a video channel service like Youtube, Vimeo, DailyMotion, etc. You will get rewarded for watching videos online with hundreds of videos are available for viewing and new videos are added every single day. Each time you watch a video, you need to hit 100% then you will automatically be rewarded with Swag Bucks.

+ Watch video Swagbucks TV: Watch Video, Earn Swag Bucks


Playing Game:


swagbucks.com offer a variety of games in different categories such as Arcade Games, Casino Games, Educational Games, etc. Playing free games, you will have a chance to win Swag Bucks. If you don't win while playing one game, either try playing again or play another game. You also see all rankings and entries for each game you have played in "My Games" page.


Make Money Online: Swagbucks Games

For the tournaments, there are three different of types:
Limited Entry - This type of tournament is limited by a set number of entries, and will continue until all available openings have been taken.
Limited Time - It is limited by the time set in the tournament.
Progressive - It is limited by time, but not limited by a certain number of entries. In addition, the prize amount may increase as more entrants join the tournament.
In some tournaments, it sometimes may take up to 2 hours to choose and pay the eligible winners. Rewards are given for the top three plays in that event. You can win big Swag bucks through this but you have to be very good at that game (and somewhat lucky) because you won't know the top score until after you enter.
For free: You will receive 2 Swag bucks every second time you play and you can earn up to 10 Swag bucks per day.


Surveys - Polls and Tasks:



With Paid Surveys, you can earn more than other web activities, from 100-600 Swag bucks's per survey qualified. Each survey usually take up 15 - 20 minutes to complete. Most surveys and offers reward you instantly on completion. However, some can take hours or days, especially if the offer involves shipping or an application that needs approval. swagbucks.com recommended that should complete "deeper profiles" because it help swagbucks.com alert you about surveys for which you qualify and help them serve you with more targeted surveys.
Here usually there are two questions:
Q. "Why am I being prevented from participating in certain surveys?"
A. Because Swagbucks surveys are generally targeted to specific communities of individuals based on demographic data such as age, occupation, personal interest, etc. It will put your data into a "panel" to ensure that you meet all eligibility requirements. We can see this is Part 1 - checking personal information, then we will come to Part 2 - Completing surveys to get Swag bucks.

Q. Why am I not being awarded Swag Bucks for a survey I participated in?
A. There are many reasons:
- Provide false or misleading information in our surveys or profiles.
- Complete a survey more than one time.
- You have only partially completed a survey.
- Complete a survey well under the average length.

For more details, you can see in http://help.swagbucks.com/home

Daily Polls, answer a quick poll question to receive 1 Swag bucks for taking part. You can enter in your own question with the chance to win 100 Swag bucks.
Tasks: You'll need to create an account on CrowdFlower, but it gives you access to several small tasks such as collecting data for various companies(gives 1 - 4 Swag bucks each). The tasks can also be related to foods, recipes and fashion. They will pay out when you reach 20 Swag bucks.

Special Offers - Swag Codes:



Special Offers: Links you to several different companies that use Swagbucks to distribute offers. The offers can be downloading an application, software, purchasing a domain or signing up for other sites. You also should check the offers when you are looking for a service to see whether Swag Bucks has partnered with the particular company.
Swag Codes: By checking the Swagbucks' Facebook, Twitter or Blog, they sometimes release codes that give 3-5 Swag bucks. You have to be quick though, they expire in a few hours.

+ Watch video Special Offers with Swagbucks


Shop and Earn:



You can purchase products on Swag bucks also and you will be credited more than the cost of that product. With shopping you can get the highest number of Swag bucks than other web activities. Shopping includes coupons, daily deals and shop and earn, usually 2-8 Swag bucks per £1.

Make Money Online: Swagbucks Shop


Everyone looks for the best deals and sales on the web, but Swagbucks actually rewards shoppers for the dollars they’re already spending with added value in tangible products,” said Scott Dudelson, COO of Swagbucks.com. "No other site rewards as many routine online activities with as many products from the most popular retail brands.


Referrals and More Online Activities:



Swagbucks's members can earn lots more by referrals. You will be given a link to share with others and if any one registers through your link, you will be paid 1000 Swag bucks or 10% of what each one earns on search.
How to invite someone to join swagbucks.com, there are two option - invite by Facebook or invite by email.

1. On the homepage look for this card in your Earning Feed.

Make Money Online Swagbucks Invite

2a. Clicking Invite by Facebook brings up a list of your friends where you simply click the INVITE button next to their name and a window will pop up where you can write your own message about why that particular friend might like Swagbucks.

Make Money Online: Swagbucks Invite Facebook

2b. Click Invite by friends by email and you will see this window pop up:



You also can see more 30 different helpful tips to understand how to get more referrals and get them active on Swagbucks. Helpful Referral Tips
Beside, there are more other web activities to you can get Swag bucks like NOSO, Trade-in, Trusted survey, Sweeptakes.

How to Redeem and Get Reward


You can redeem your Swag bucks to get rewards like cash or gift cards on Swagbucks. To get rewards go to Rewards Store on swagbucks.com. Redeem generally takes up to 10 business days to receive your reward in the "My Gift Cards" area. Here are common and most redeemed rewards:

$5 Amazon Gift Card = 450 Swag bucks (means you need to have 450 or more Swag bucks to redeem this reward)
$5 Starbucks eGift Card = 500 Swag bucks
$5 Walmart eGift Card = 500 Swag bucks
$10 Starbucks eGift Card = 1000 Swag bucks
$15 Amazon Gift Card = 1500 Swag bucks
$25 Paypal = 2500 Swag bucks
$25 Target eGiftCard = 2500 Swag bucks
$50 ExxonMobil Gift Card = 5000 Swag bucks
$250 Amazon Gift Card = 25,000 Swag bucks

Earnings:


From $5 - $75 a month

Finally, if you are looking for a simple way to make money online, swagbucks.com is definitely worth looking into. It certainly won't make you rich, but it can help you earn little extra money.
We will not stop in here that still will continue to search many good sites. In order to do that need precious opinions from you. Thank you for reading. And

Have fun Make Money Online on Swagbucks

Blogger Templates: VIPfolio Responsive Portfolio Blogger Template

Template Name : VIPfolio Responsive Portfolio Blogger Template
Platform : Blogger / Blogspot
Release date : 03, March 2014
Author : templateism.com

Looking for a professional blogger template that will help you to showcase your portfolios with ease? Here It is a responsive portfolio blogger template from weblogtemplates. It will help you to easily showcase your web design, design or even websites with minimum effort.






Blogger Templates: VIPfolio Responsive Portfolio Blogger Template

Features of Portfolio Blogger template
Full width design: Home page and archive pages coming with a nice option to showcase designs. Create a post in blogger with the main picture that need to showcase as first picture of your article. For fast loading of home page we recommend you to use jump break after first image.
Responsive design: Vipfolio portfolio template always give better user experience in most of devices with its responsive design powered by twitter bootstrap.
Numbered pagination: VIPfolio is having numbered pagination in label search pages, home page and paged pages. We tried our level best to suit it to our template design.
Custom social media sharing buttons
Social media icons
Better comment area to match blog design
Related post widget


MORE INFO

DOWNLOAD


How To Install Blogger Theme : 

Go to Blogger Dashboard click on Template tab. 
Next click on Backup/Restore button. 
Upload XML file of theme .

March 13, 2014

Blogger Templates: HaletanisLux Blogger Template

March 13, 2014 - 0 Comments

Template Name : HaletanisLux Blogger Template
Platform : Blogger / Blogspot
Release date : January 24, 2014
Author : SimpleWpThemes

HaletanisLux Blogger Template has 2 columns Layout with a header banner and 4 columns footer, HaletanisLux Blogger Template has features like magazine style, content slider, navigation menus, header banner, social buttons, right sidebar and more.






Blogger Templates: HaletanisLux Blogger Template


MORE INFO

DOWNLOAD


How To Install Blogger Theme : 

Go to Blogger Dashboard click on Template tab. 
Next click on Backup/Restore button. 
Upload XML file of theme .

Blogger Templates: Awesome Mag Responsive Blogger Template

Template Name : Awesome Mag Responsive Blogger Template
Platform : Blogger / Blogspot
Release date : 03, March 2014
Author : templateism.com

Awesome Mag Blogger Template is fully responsive theme that comes with features that are never seen before in a BlogSpot blogger template. It has a unique fluid design concept with robust elements, which make it a complete package of theme that could be converted into any niche site or blog.





Blogger Templates: Awesome Mag Responsive Blogger Template

Template has 3 columns that can be customized into a portfolio, magazine, personal blog, products, list based sites and etc. It is optimized for both on-page and off-page SEO that gives enough flexibility to rank your post higher in the search engine results, and allows to index your posts 99% faster than the rest of the Blogger templates available on the internet.
Features of Awesome Mag Blogger Template:
100% Pure Responsive: Honestly speaking this is the only 100% responsive blogger template available on the internet. Though, we have published more than 10 Responsive templates, but this is certainly the best out of them all. It supports all devices like iPad, iPhone, Android, Desktop, and Laptop.
Mega Drop Down Menu: A Mashable inspired mega drop down menu is something that every blogger adores to have in his template. It is responsive and extremely flexible to use.
Featured Label Area: It further allows to add Feature posts in the right sidebar of your template allowing more engagement to your featured posts. It is easily customizable and works on jQuery, so it is amazingly fast and reliable to use.
Random Articles Button: This is a handy tool that takes users to a random article every time they “Hit the button”. It is useful for those who are running List based sites or write random content.


MORE INFO

DOWNLOAD


How To Install Blogger Theme : 

Go to Blogger Dashboard click on Template tab. 
Next click on Backup/Restore button. 
Upload XML file of theme .

March 12, 2014

Blogger Templates: Bresponsive Blogger Template

March 12, 2014 - 0 Comments

Template Name : Bresponsive Blogger Template
Platform : Blogger / Blogspot
Author : spicytricks

Bresponsive Blogger Template is a clean and modern Blogger Template. This template is suitable with any niche blogs, magazine blogs, news blogs, etc. The color combination of Bresponsive is too good and reponsive. This template is supported by all browsers and fit on both table and mobile platforms.








Template has 3 column gallery style theme with 1 right sidebar and 4 column footer area. Dual top menu link's with search box placed in top area. Header Right side have 728x90px ads banner.

MORE INFO

DOWNLOAD


How To Install Blogger Theme : 

Go to Blogger Dashboard click on Template tab. 
Next click on Backup/Restore button. 
Upload XML file of theme .

Blogger Templates: Resizable Blogger Template

Template Name : Resizable Blogger Template
Platform : Blogger / Blogspot
Release date : May 23, 2013
Author : Naveed Iqbal / theme-junkie

Resizable blogger template is a magazine style blogger template. This blogger template is loaded with different features along with its eye catchy color combination.
Template have Wordpress look, beautiful image slider, high quality style.






Blogger Templates: Resizable Blogger Template

Template includes 3 column, 4 column footer, search box generates the search results with in a second by utilizing JSON and Ajax. Template also added thumbnails related post widget below each post.
The elegant combination of white background with green in navigation menu make the look of this template awesome. I think that you will like this template.


MORE INFO

DOWNLOAD


How To Install Blogger Theme : 

Go to Blogger Dashboard click on Template tab. 
Next click on Backup/Restore button. 
Upload XML file of theme .

March 11, 2014

Blogger Templates: GoGreen Blogger Template

March 11, 2014 - 0 Comments

Template Name : GoGreen Blogger Template
Platform : Blogger / Blogspot
Release date : 14, August 2013
Author : www.templateism.com

GoGreen Blogger Template is the fantastic template for multipurpose with eye catching color combinations. This blogger template has 2 Columns layout along-with beautiful drop down menu, 3 column footer, 1 sidebar column and threaded comments system.






Blogger Templates: GoGreen Blogger Template

This template has a clean design and white color background. This theme suitable for blogs like portfolio, sports, magazines, gallery and reviews. This theme is also SEO optimized and it also includes Thumbnail Related Posts, Related Posts and much more other features.

MORE INFO

DOWNLOAD


How To Install Blogger Theme : 

Go to Blogger Dashboard click on Template tab. 
Next click on Backup/Restore button. 
Upload XML file of theme .

Excel Formulas: PRODUCT Function

Syntax :

=PRODUCT(number1, [number2], ...)


Parameters or Arguments :
number1 : is the number or range that you want to multiply.
number2 : Optional. Additional numbers or ranges that you want to multiply.
Meaning :
Multiplies the numbers and returns the product.
Example : 
=PRODUCT(12,-8) = -96
=PRODUCT(12,-8,4) = -384
=PRODUCT(12,4) = 48

Note :
- Maximum includes 255 arguments.
- If an argument is an array or reference, only numbers in the array or reference are multiplied. Empty cells, logical values, and text in the array or reference are ignored.
- =PRODUCT(A1, A2) is equivalent to =A1 * A2.
- =PRODUCT(A1:A3, C1:C3) is equivalent to =A1 * A2 * A3 * C1 * C2 * C3.


Excel Formulas: PRODUCT Function

Excel Formulas: MOD Function

Syntax :

=MOD(number, divisor)


Parameters or Arguments :
number : is the number for which you want to find the remainder.
divisor : is the number by which you want to divide number.
Meaning :
Returns the remainder after number is divided by divisor.
Example : 
=MOD(7,3) = 1
=MOD(7,-4) = -1
=MOD(-4,3) = 2
=MOD(-4,7) = 3
=MOD(-4,-5) = -4
=MOD(3,0) = #DIV/0!

Note :
- The MOD function can be expressed in terms of the INT function:
MOD(n, d) = n - d*INT(n/d)

- If divisor is 0, MOD returns the #DIV/0! error value.


Excel Formulas: MOD Function

Excel Formulas: INT Function

Syntax :

=INT(number)


Parameters or Arguments :
number : is the real number.
Meaning :
Returns rounds a number down to the nearest integer.
Example : 
=INT(5.6) = 5
=INT(-5.4) = -6
=INT(-1.5) = -2
=INT(9.2) = 9

Note :
If the number is negative, will return the first negative number that is less than or equal to the number.

Excel Formulas: INT Function

Excel Formulas: SQRT Function

Syntax :

=SQRT(number)


Parameters or Arguments :
number : is the positive number.
Meaning :
Returns a positive square root.
Note :
If number is negative, SQRT returns the #NUM! error value.
Example :
=SQRT(9) = 3
=SQRT(36) = 6
=SQRT(11) = 3.31662479
=SQRT(-9) = #NUM!
=SQRT(-1) = #NUM!


Excel Formulas: SQRT Function

Excel Formulas: ABS Function

Syntax :

=ABS(number)


Parameters or Arguments :
number : is the real number.
Meaning :
Returns the absolute value of a number without sign(-).
Example : 
=ABS(5) = 5
=ABS(-5) = 5
=ABS(0) = 0
=ABS(-1) = 1


Excel Formulas: ABS Function
=ABS(E2) = 5





March 10, 2014

What Does SEO Mean and SEO Techniques on Blogger

March 10, 2014 - 0 Comments

Many people wonder What is SEO and also many people visit Google to search with the phrase "what is SEO" or "what does SEO mean", so exactly What does SEO mean?
Today, I will give you 4 definitions from 4 different sources.

What is SEO, as defined by Google
I quote verbatim

"SEO is an acronym for "search engine optimization" or "search engine optimizer." Deciding to hire an SEO is a big decision that can potentially improve your site and save time, but you can also risk damage to your site and reputation. Make sure to research the potential advantages as well as the damage that an irresponsible SEO can do to your site."
You can see details at https://support.google.com/webmasters/answer/35291?hl=en

What is SEO, as defined by Encyclopaedia Wikipedia
"Search engine optimization (SEO) is the process of affecting the visibility of a website or a web page in a search engine's "natural" or un-paid ("organic") search results. In general, the earlier (or higher ranked on the search results page), and more frequently a site appears in the search results list, the more visitors it will receive from the search engine's users. SEO may target different kinds of search, including image search, local search, video search, academic search,[1] news search and industry-specific vertical search engines."
Refer to details at http://en.wikipedia.org/wiki/Search_engine_optimization

What is SEO, defined "ordinary"
When you want to searching information so immediately you will think to search engines, and in this example we will use Google and then users will enter the phrase that they need to search related to the any field, product or service, etc and Google returns the results that their website appear on top so called SEO.
For example, now I will enter phrase "What is SEO"

What Does SEO Mean and SEO Techniques on Blogger

What is SEO, according to me
Google is the number 1
Google has become a verb. Have you ever asked a friend about something, he/she turned to you "Google it!".<3

1. Basic Settings for a SEO-Friendly blog :

At Blogger Dashboard, click on your blog name, and click Setting => Basic.
And then you can edit your Title, Description and Privacy . Make sure it's relevan and included your main keyword. Remember, click Save changes to save results.

Basic Settings for a SEO-Friendly blog

Next, also in Setting click Search Description to change blog's Search Description. This description will be read as a Meta tag by search engines.

Search Description - Meta tag 2. Blog's Template Settings :

Do know you that, sometimes some search engines like Bing and Yahoo, and social networks like Facebook will read your blog's description from meta tag in HTML Template. So we also need to change in HTML Template.
At Blogger Dashboard, click on your blog name, and then click Template => Edit. You find </head> tag and add meta description and keywords tag(as below image) before </head> tag if you still have them.

Setting Meta description tag

3. Setting SEO-Friendly Content :

- Optimize Title - Label - URL and Search Description:
+ Title : Try keep it short and meaningful.
+ Label : Should suitable the article content.
+ Schedule : You also should set specific date and time to post article.

Setting Schedule

+ Links : If can you should custom permalink to easy understand and SEO-Friendly.

 Links

+ Search Description : I think that it very important because search engine often read this information and display in result page. You should write a relevent description with article content.

Search Description

4. Optimize Link and Image :

- For link, you should add title tag. For example,
<a title="Research and Make Money Online"   href="http://www.researchtowork.info/">researchtowork.info</a>
and add attributes rel="nofollow" at outbound links. It will keep spider point to your website.
ResearchtoWork.info

Links

- For Image, use title and alt tag for your image with proper keywords that may describe your article content. Each image has title and alt tag appropriate. And keep alt tag short in maximum 5 words.

Image

5. Optimize Post Content :

Each post should has inbound anchor links to link to other post help Spider crawl deeper into posts content on your website. Because this inbound(internal) links so you don't need use the attribute rel="nofollow". In post body, you should use H2, H3 or H4 tags to optimize content. H2 almost use for Title Heading, H3 usually use for SubHeading in post content. Beside, we can highlight keywords at important part in post.

Heading

Subscribe

hellooo

© 2014 Research and Money Money Online. All rights reserved.
Designed by SpicyTricks