Tuesday, January 24, 2012

Google Algorithm Names and Algo Updates


·         Panda is to fight against Low quality content and Penguin is to fight against Web Spam.

2012 UpdatesJanuary 30-Pack - January 5, 2012
Updates including image search landing-page quality detection, more relevant site-links, more rich snippets, and related-query improvements.

2011 Updates
Overstock.com Penalty - January 2011
In a rare turn of events, a public outing of shady SEO practices by Overstock.com resulted in a very public Google penalty. JCPenney was hit with a penalty in February for similar bad behavior. Both situations represented a shift in Google's attitude and foreshadowed the Panda update.

Attribution Update
- January 28, 2011
In response to high-profile spam cases, Google rolled out an update to help better sort out content attribution and stop scrapers. According to Matt Cutts, this affected about 2% of queries. It was a clear precursor to the Panda updates.

Panda/Farmer Update
- February 23, 2011
Google Panda was a major algorithm update hit sites hard which seemed to crack down on thin content, content farms, sites with high ad-to-content and a number of other quality issues.

 +1 Button - March 30, 2011
Responding to competition by major social sites, including Facebook and Twitter, Google launched the +1 button directly next to results links. Clicking [+1] allowed users to influence search results within their social circle, across both organic and paid results.

Google Panda 2.0
- April 11, 2011
Google rolled out the Panda update to all English queries worldwide.

Google Panda 2.1
- May 9, 2011
Google appeared to roll out yet another round of minor changes.

Schema.org
- June 2, 2011
Google, Yahoo and Microsoft announced support for a structured data by creating new schemas for richer search results.

Google Panda 2.2
- June 21, 2011
Google Panda 2.2 continued to update Panda-impacted sites and data.

Google+
- June 28, 2011
Google+ was launched for a number of social media failures like Facebook with Google+ around circles for sharing content and was integrated into Gmail and within 2 weeks Google+ reached 10M users.

Google Panda 2.3
- July 23, 2011
It was a simply an update to the Panda data and ranking factors.

Panda Goes Global 2.4
- August 12, 2011
Google launched Panda internationally, both for English-language queries globally and non-English queries except for Chinese, Japanese, and Korean.

Expanded Sitelinks
- August 16, 2011
After experimenting for a while, Google officially rolled out expanded site-links, most often for brand queries.

Pagination Elements
- September 15, 2011
Google introduced the rel="next" and rel="prev" link attributes to fix crawl and duplication problems created by pagination. Google also announced that they had improved automatic consolidation and canonicalization for "View All" pages.

516 Algo Updates
- September 21, 2011
Google CEO Eric Schmidt told Congress that Google made 516 updates in 2010. They tested over 13,000 updates.

Panda 2.5
- September 28, 2011
Google rolled out another Panda update & effected some sites, reported large-scale losses.

Panda "Flux"
- October 5, 2011
Other minor Panda updates occurred on 10/3, 10/13, and 11/18.

Query Encryption
- October 18, 2011
Google announced they would be encrypting search queries, for privacy reasons. In Google Analytics, this disrupted organic keyword referral data, returning "(not provided)" for some organic traffic.

Freshness Update
- November 3, 2011
This update primarily affected time-sensitive results, but signaled a much stronger focus on recent content.

Panda 3.1
- November 18, 2011
After Panda 2.5, Google entered a period of "Panda Flux" where updates started to happen more frequently and were relatively minor. Some industry analysts called the 11/18 update 3.1, even though there was no official 3.0.

December 10-Pack
- December 1, 2011
Updates included related query refinements, parked domain detection, blog search freshness, and image search freshness.

2010 Updates
Google Places – April 2010
·         Google maps rebranded Google Places, integrated places pages more closely with local search results.

May Day
– May 2010
·         Algorithm change impacting the long tail traffic especially large scale thin content

Caffeine (Roll out)
– June 2010
·         Google speed crawling & indexation with a 50% fresher index.

Brand Update
– August 2010
·         Same Domain appears multiple times on a SERP

Google Instant
– September 2010
·         Google instant introduced for displaying search results as a Query.

Instant Preview
– November 2010
·         A magnifying glass icon appeared on Google search result for quick preview of landing page directly from Search Result pages.

2009 Updates
Vince – February 2009
·         Major update that seemed to favor Big Brands

Rel – Canonical Tag – February 2009
·         Google / Yahoo / Microsoft announced support for the canonical tag

Caffeine – August 2009
·         Massive infrastructure change for speed crawling and indexation

Real Time Search – December 2009
·         Real time search was for Real – Twitter feeds / Google News / Newly indexed Content including social media.

2008 Updates
Demey – April 2008
·         Ranking changed drastically. Large differences in ranking between these data centers.

Google Suggest – August 2008
·         Introduced suggested searches in a drop down

2007 Updates
Universal Search
– May 2007
·         Google integrated News / Video / Images / Local and other verticals

Buffy
– June 2007
·         Buffy was just an accumulation of smaller changes

2006 Updates
Supplemental Update – November 2006
·         Changes to supplemental index

2005 Updates

Nofollow – January 2005
·         Google, Yahoo & Microsoft introduced to Control outbound link quality

Allegra
– February 2005
·         Beginning to penalize suspicious links

Bourbon
– February 2005
·         Duplicate content & Non-Canonical like www vs. non-www urls

Xml Sitemap
– June 2005
·         Google allowed XML Sitemaps via Webmasters Tools.

Personalized Search
– June 2005
·         Search History to Automatically Adjust Result

Gilligan
– September 2005
·         Toolbar PR Updates only once every 3 months

Jagger
– October 2005
·         Targeted at low-quality links like Reciprocal links, Link Farms & Paid Links

Big Daddy
– December 2005
·         Infrastructure update,  URL Canonicalization &  Redirects (301 / 302)



2004 Updates
Austin
– January 2004
·         Hilltop Algorithm – Detecting deceptive on-page tactics, invisible text and META-TAG Stuffing

Brandy
– February 2004
·         Latent Semantic Indexing (LSI)
·         Anchor Text Relevance
·         Understand Synonyms and took keyword analysis next level

2003 Updates
Florida Update – November 2003
·         90’s Negative SEO Tactics / Keyword Stuffing

Supplemental Index
– September 2003

Fritz update
– July 2003
·         Index was Changing Daily

Esmerelda
– June 2003
·         Google Dance Replaced Everflux

Dominic
– May 2033

Cassandra
– April 2003
·         Link Quality Issue, Hidden text & Hidden Lines

Boston
– Feb 2003
·         The first Named Google Update

2002 Updates Boston - September 2002
·         Monthly Google Dance

2000 Updates

Google Toolbar PageRank (TBPR) Launched




Friday, December 30, 2011

How to Remove Duplicate Rows in Excel

Apply below given the formula to remove duplicate rows in Excel:



=IF(MAX(COUNTIF(A1:A3306,A1:A3306))>1,"Duplicates","No Duplicates")

A1 is the Column, change to any column based upon your Excel Spread Sheet.

A3306 is the range of rows, change it your range of rows, it could be 100 or 200 or more depends upon the number of rows.

Rest, keep it default, and apply the formula next to the all rows and the duplicate rows will appear.

Cheers!!!




Thursday, December 22, 2011

How to Change the Blogspot (Blogger) Post Title


How to Change the Blogspot (Blogger) Post Title

Generally by default Blogspot (Blogger) Post titles will be prefixed with Blogs Name first then Post Title. If you want to do post title Search Engines Friendly, follow the steps given below:
First Click on Design on the Top Right Corner or try to find Design link based upon your Blog Template, then click on Edit Html link to launch your Blog's html Code.
Look for the below given code in the Html Code.



Now, Replace the above Code with the below given code, and save Template. That's it now you will see that all your Posts Titles changed with your Desired Post Title.



Enjoy!!

Thursday, November 10, 2011

The BIG Keyboard Shortcut List


What is the allure of keyboard shortcuts? Do they really save time? Why bother since my mouse is permanently attached to my hand?


I like to use keyboard shortcuts, especially if someone is watching me, because they make me look like a pro. With just a few key strokes I can leave a mouser spinning his wheel! Whatever your motivation, here's a big list of keyboard shortcuts:


GENERAL SHORTCUTS


ALT- F4 - Quit a program / Shut down
ALT-TAB - Hold down the ALT key and hit tab to cycle through open windows.
CTL-ESCAPE - Display the Start menu
SHIFT - TAB - tab backwards through a form
CTRL - X - Cut
CTRL - C - Copy
CTRL - V - Paste
F1 - Help menu
CTRL - Z - Undo
SHIFT & Restart - To restart just windows and not your whole computer, hold down the shift key when you click the OK button on the shutdown screen. Saves lots of time. (not for XP)
CRTL-TAB - Navigate tabs on a tabbed screen


FILE & DESKTOP SHORTCUTS


Hold SHIFT while inserting a CD - Prevents the CD from "autorunning"
If an item is selected:
CTRL while dragging a file - Copies the file
CTRL - SHIFT while dragging a file - Creates a shortcut to the file
SHIFT - DELETE - Deletes an item without sending it to the recycle bin.
ALT-ENTER - Display a file's properties.
F2 - To rename the file
In Windows Explorer:
LEFT ARROW - Collapse the current selection if it is expanded
NUM LOCK-MINUS SIGN (-) - Collapse the selected folder
RIGHT ARROW - Expand the current selection if it is collapsed -Or- Select the first subfolder
NUM LOCK- * Expand all folders below the current selection
NUM LOCK- PLUS SIGN (+) - Expand the selected folder
F6 - Switch between left and right panes
In My Computer:
BACKSPACE - View the folder one level up
ALT- RIGHT ARROW - Move forward to a previous view
ALT- LEFT ARROW -Move backward to a previous view


INTERNET BROWSER SHORTCUTS


For Internet Explorer 6 and Netscape 7 (may work in older versions)
Open History Window
Ctrl+H
Reload
Ctrl+R
Back (Previous Page)
Alt+Left Arrow or Alt+Backspace
Forward (Next Page)
Alt+Right Arrow
Stop
Esc
Home
Alt+Home
Go to Bottom of Page
End
Go to Top of Page
Home
New Window
Ctrl+N
Close WIndow
Ctrl+W
Go Up one Line
Up Arrow
Go Down One Line
Down Arrow
Full Screen (toggle)
F11
Find on Page
Ctrl+F
Add Current Page to Favorites
Ctrl+D
Print Current Page
or Active Frame
Ctrl+P
Organize Favorites (IE)/
Manage Bookmarks (NS)
Ctrl+B
Maximize a Window
Alt+Space+x
Minimize a window
Alt+Space+N
Scroll page up
Alt+Up Arrow
Scroll page down
Alt+Down Arrow


Internet Explorer ONLY

Open Favorites Bar
Ctrl+I
Select text in address bar
Alt+D

Force Reload (not from cache)               Ctrl+F5

A faster way to type in addresses with IE is to just type in the name of the site:
worldstart
and hit CTRL + Enter. The "http://www. " and ".com" will be added for you!


WINDOWS KEY SHORTCUTS


The Windows key can be used in conjunction with other keys to act as a keyboard shortcut for faster access to menu commands. Now, while the Alt key tends to open program menus (ex: Alt+F opens the File menu and Alt+E opens the Edit menu) and the Ctrl key performs actual operations (ex: Ctrl+C will copy and Ctrl+V will paste), the Windows key will open various Windows tools...
Win key + R will open the Start menu's Run box
Win key + F will open the Start menu's Find window
Win key + E will quickly launch Explorer
Win key + Pause/Break will open the System Properties window
Win key + M will Minimize all windows
Win key + Shift + M will undo Minimize all windows
Win key + D will switch between minimizing all open programs and showing them all
Win key + Tab will cycle through items on the taskbar
Win key by itself will open the Start menu

You can also open programs or folders on your desktop by pressing the Windows key + the first letter of the program/folder/shortcut + Enter . Sounds kinda tedious, but if you're in a bind with your mouse, it can come in quite handy.


ARROW TRICKS


Here's a cool little arrow trick to try with word processing programs. Next time you're using your arrow keys to go from one area of a sentence to another (left and right arrows), hold down your CTRL key. Instead of moving one space at a time, you'll go one word at a time.
If you're using the up and down arrows to go from line to line, holding down the CTRL key will make your cursor jump from paragraph to paragraph (well, from carriage return to carriage return anyway).
One last thing, if you hold down the SHIFT key while you do this (i.e. hold down SHIFT + CTRL at the same time), you select text as you arrow along.
I've tested this in MS Word and Wordpad, but it *should* work no matter what word processing program you use.


HOME / END KEY FUN


Do you ever find yourself scrolling through a huge folder ? Well, if you need to get to the beginning or the end quickly, just press Ctrl+Home . If you want to get to the end, click Ctrl+End.

Hey, that's not all!
This little trick works on more than just folders. If you use the Home key in a word processor, it goes to the beginning of the line you're currently working on. If you hit the END key, it should head to the end of the current line. If you pair Home & End up with the Ctrl key in a word processor, you will be whisked away to the beginning or end of the document. Again, this should work, but it depends on your word processor.


Speedup your work by using keyboard more and mouse less.
 
Useful Shortcut:

Start + M: Minimizes all open windows
Start + Shift + M: Maximizes All Windows
Start + E: Runs Windows Explorer
Start + R: Open the RUN Dialog Box
Start + F: Open the Search Results Dialog box
Start + CTRL + F: Opens the Search Results-Computer dialog Box (if the computer is connected to a network)
Start + Pause (Break): Opens the System Properties Dialog Box


Windows System Key Combinations:

F1: Help
CTRL + ESC: Open Start menu
ALT + TAB: Switch between open programs
ALT + F4: Quit program
SHIFT + DELETE: Delete item permanently


Windows Program Key Combinations:

CTRL + C: Copy
CTRL + X: Cut
CTRL + V: Paste
CTRL + Z: Undo
CTRL + B: Bold
CTRL + U: Underline
CTRL + I: Italic


Mouse Click/Keyboard Modifier Combinations for Shell Objects:

SHIFT + right click: Displays a shortcut menu containing alternative commands
SHIFT + double click: Runs the alternate default command (the second item on the menu)
ALT + double click: Displays properties
SHIFT + DELETE: Deletes an item immediately without placing it in the Recycle Bin


General Keyboard-Only Commands:

F1: Starts Windows Help
F10: Activates menu bar options
SHIFT + F10: Opens a shortcut menu for the selected item (this is the same as right-clicking an object
CTRL + ESC: Opens the Start menu (use the ARROW keys to select an item)
CTRL + ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)
ALT + DOWN ARROW: Opens a drop-down list box
ALT + TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window)
SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature
ALT + SPACE: Displays the main window's System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
ALT +- (ALT + hyphen): Displays the Multiple Document Interface (MDI)child window's System menu (from the MDI child window's System menu, you can restore, move, resize, minimize, maximize, or close the child window)
CTRL + TAB: Switch to the next child window of a Multiple Document Interface (MDI) program
ALT + underlined letter in menu: Opens the menu
ALT + F4: Closes the current window
CTRL + F4: Closes the current Multiple Document Interface (MDI) window
ALT + F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed
ALT + F6: switches between the Find dialog box and the main Notepad window)


Shell Objects and General Folder/Windows Explorer Shortcuts For a selected object:

F2: Rename object
F3: Find all files
CTRL + X: Cut
CTRL + C: Copy
CTRL + V: Paste
SHIFT + DELETE: Delete selection immediately, without moving the item to the Recycle Bin
ALT + ENTER: Open the properties for the selected object
To Copy a File: Press and hold down the CTRL key while you drag the file to another folder.
To Create a Shortcut: Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.


General Folder/Shortcut Control:

F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)
F5: Refreshes the current window.
F6: Moves among panes in Windows Explorer
CTRL + G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only)
CTRL + Z: Undo the last command
CTRL + A: Select all the items in the current window
BACKSPACE: Switch to the parent folder
SHIFT + click + Close button: For folders, close the current folder plus all parent folders

Windows Explorer Tree Control:

Numeric Keypad *: Expands everything under the current selection
Numeric Keypad +: Expands the current selection
Numeric Keypad -: Collapses the current selection.
RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first child
LEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parent


Properties Control:

CTRL + TAB/CTRL + SHIFT + TAB: Move through the property tabs


Accessibility Shortcuts:


Press SHIFT five times: Toggles StickyKeys on and off
Press down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and off
Press down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and off
Left ALT + left SHIFT+NUM LOCK: Toggles MouseKeys on and off
Left ALT + left SHIFT+PRINT SCREEN: Toggles high contrast on and off


Microsoft Natural Keyboard Keys:

Windows Logo: Start menu
Windows Logo + R: Run dialog box
Windows Logo + M: Minimize all
SHIFT + Windows Logo+M: Undo minimize all
Windows Logo + F1: Help
Windows Logo + E: Windows Explorer
Windows Logo + F: Find files or folders
Windows Logo + D: Minimizes all open windows and displays the desktop
CTRL + Windows Logo + F: Find computer
CTRL + Windows Logo + TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)
Windows Logo + TAB: Cycle through taskbar buttons
Windows Logo + Break: System Properties dialog box
Application key: Displays a shortcut menu for the selected item


Microsoft Natural Keyboard with IntelliType Software Installed:

Windows Logo + L: Log off Windows
Windows Logo + P: Starts Print Manager
Windows Logo + C: Opens Control Panel
Windows Logo + V: Starts Clipboard
Windows Logo + K: Opens Keyboard Properties dialog box
Windows Logo + I: Opens Mouse Properties dialog box
Windows Logo + A: Starts Accessibility Options (if installed)
Windows Logo + SPACEBAR: Displays the list of Microsoft IntelliType shortcut keys
Windows Logo + S: Toggles CAPS LOCK on and off


Dialog Box Keyboard Commands:

TAB: Move to the next control in the dialog box
SHIFT + TAB: Move to the previous control in the dialog box
SPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option.
ENTER: Equivalent to clicking the selected button (the button with the outline)
ESC: Equivalent to clicking the Cancel button
ALT + underlined letter in dialog box item: Move to the corresponding item

Thursday, March 10, 2011

Fast Approval Directories List




Here are the list of Fast / Instant Approval Directories List.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49


Kindly Update me if you have any directory which is not listed above and also let me know if you come across any Parked or Broken link websites.