--
--
Microsoft Excell 2007 Shortcuts and Its Commands
CTRL combination shortcut keys
Microsoft Excel 2007
CTRL+SHFT+( Unhides any hidden rows within the selection.
CTRL+SHFT+) Unhides any hidden columns within the selection.
CTRL+SHFT+& Applies the outline border to the selected cells.
CTRL+SHFT_ Removes the outline border from the selected cells.
CTRL SHFT ~ Applies the General number format in Microsoft Excel.
CTRL+SHFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHFT+% Applies the Percentage format with no decimal places.
CTRL+SHFT+^ Applies the Exponential number format with two decimal places.
CTRL+SHFT+# Applies the Date format with the day, month, and year.
CTRL+SHFT+@ Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+SHFT+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.
CTRL+SHFT+: Enters the current time.
CTRL+SHFT+ Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL SHFT Plus ( ) Displays the Insert dialog box to insert blank cells in Microsoft Excel.
CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells.
CTRL+; Enters the current date.
CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+' Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+1 Displays the Format Cells dialog box.
CTRL+2 Applies or removes bold formatting.
CTRL+3 Applies or removes italic formatting.
CTRL 4 Applies or removes underlining in Microsoft Excel.
CTRL+5 Applies or removes strikethrough.
CTRL+6 Alternates between hiding objects, displaying objects, and displaying placeholders for objects. –
CTRL+8 Displays or hides the outline symbols. + –
CTRL+9 Hides the selected rows.
CTRL 0 Hides the selected columns in Microsoft Excel.
CTRL+A Selects the entire worksheet. If the worksheet contains data,
CTRL+A selects the current region. Pressing
CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. CTRL+SHFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
CTRL+B Applies or removes bold formatting.
CTRL+C Copies the selected cells.
CTRL+C followed by another
CTRL+C displays the Clipboard.
CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F Displays the Find and Replace dialog box, with the Find tab selected. SHFT+F5 also display this tab, while SHFT+F4 repeats the last Find action. CTRL+SHFT+F open the Format Cells dialog box with the Font tab selected.
CTRL+G Displays the Go To dialog box. F5 also displays this dialog box.
CTRL+H Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL I Applies or removes italic formatting in Microsoft Excel.
CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N Creates a new, blank workbook.
CTRL O Displays the Open dialog box to open or find a file.
CTRL SHFT O selects all cells that contain comments in Microsoft Excel.
CTRL+P Displays the Print dialog box.
CTRL+SHFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S Saves the active file with its current file name, location, and file format.
CTRL T Displays the Create Table dialog box in Microsoft Excel.
CTRL+U Applies or removes underlining.
CTRL+SHFT+U switches between expanding and collapsing of the formula bar.
CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. CTRL+W Closes the selected workbook window.
CTRL+X Cuts the selected cells.
CTRL Y Repeats the last command or action, if possible in Microsoft Excel.
CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed.
CTRL+SHFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
Other useful shortcut keys
Microsoft Excel 2007
ARROW KEYS Move one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet.
SHFT+ARROW KEY extends the selection of cells by one cell.
CTRL+SHFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell
BACKSPACE Deletes one character to the left in the Formula Bar in Microsoft Excel. Also clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point.
DELETE Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point.
END Moves to the cell in the lower-right corner of the window when
SCROLL LOCK is turned on. Also selects the last command on the menu when a menu or submenu is visible.
CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar,
CTRL+END moves the cursor to the end of the text.
CTRL+SHFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CT
ENTER Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). In a data form, it moves to the first field in the next record. Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button). ALT+ENTER starts a new line in the same cell.
CTRL+ENTER fills the selected cell range
ESC Cancels an entry in the cell or Formula Bar in Microsoft Excel. Closes an open menu or submenu, dialog box, or message window. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again.
HOME Moves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the first command on the menu when a menu or submenu is visible.
CTRL+HOME moves to the beginning of a worksheet.
CTRL+SHFT+HOME extends the selection of cells to the beginning of the worksheet.
PAGE DOWN Moves one screen down in a worksheet.
ALT+PAGE DOWN moves one screen to the right in a worksheet.
CTRL+PAGE DOWN moves to the next sheet in a workbook.
CTRL+SHFT+PAGE DOWN selects the current and next sheet in a workbook.
PAGE UP Moves one screen up in a worksheet.
ALT+PAGE UP moves one screen to the left in a worksheet.
CTRL+PAGE UP moves to the previous sheet in a workbook.
CTRL+SHFT+PAGE UP selects the current and previous sheet in a workbook.
SPACEBAR In a dialog box, performs the action for the selected button, or selects or clears a check box.
CTRL+SPACEBAR selects an entire column in a worksheet.
SHFT+SPACEBAR selects an entire row in a worksheet.
CTRL+SHFT+SPACEBAR selects the entire worksheet. If the worksheet contains data, CTRL+SHFT+SPACEBAR selects the current region. Pressing
CTRL+SHFT+SPACEBAR a second time selects the current region and its summary rows. Pressing
CTRL+SHFT+SPACEBAR a third time selects the entire worksheet. Wh
TAB Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialog box.
SHFT TAB moves to the previous cell in a worksheet or the previous option in a dialog box in Microsoft Excel.
CTRL TAB switches to the next tab in dialog box.
CTRL SHFT TAB switches to the previous tab in a dialog box.
Nicrosoft Excell 2007 Shortcuts
Google Introduces G Mail Themes for Classical Look
Excellent themes for G mail.
Yesterday 20/11/08 Google have introduces new one that is Themes for G mail Account. Google introduced 31 excellent mail themes to choose. To enable your themes go to
Setting -> Themes where you can find 31 themes layout once choose your new theme i will give the conformation all you can access your G mail Account color fully. Note it will ask for your location also. Hans up to Google
Once you Signed In you can view a new update in the top. You can in above IMage
See the Image below to See the Number of themes available
Enjoy with Google. Peoples will Enjoy
SEO Introduction To Start - Sathiya
Search Engine Optimization
A form of online marketing, search engine optimization SEO (or search engine marketing) is the process of making a site and its content highly relevant for both search engines and searchers. Successful search marketing helps a site gain top positioning for relevant words and phrases.
Search Engine:-
Search engine is a website or program that helps user find related information related to their query. Search engine maintains database of websites and use program (spiders) to collect information which are then indexed by the search engines. Without search engines, Its basically impossible to locate anything on the Web without knowing a specific URL. Some popular search engines are Google, Yahoo and MSN .Google is the most popular of the lot.
Search Engines And Directories:-
Search engine as it has been stated earlier is a program that helps user find information related to your query. Now directory is almost similar to search engines but here human beings are involved in collecting and updating information. It’s basically a collection of website address organized in categories and each category into sub-categories. The only difference between a search engine and directory is that all webpages are selected manually whereas search engine uses software programs (spiders) to automatically index the WebPages.
Meta Search Engine:-
Meta Search Engines are search engines that display results from more than one search engines.They don't have a database of their own, they send the search terms to the databases maintained by different search engines and display results taken from them. Examples: Mamma, WebCrawler, Dogpile etc.
Few Important Terms Related To Search Engine:-
Crawling:-
The process by which search engine spiders visits your website and reads each page by following the links within your site and then add them in their database is called Crawling or search engine indexing.
Ranking:-
This is a term often confused with search engine indexing. A site indexed doesn’t necessarily means that its ranking well. Ranking means, certain position where a website appears in the Search Engine Result Page(SERP),(This is where SEO is required)
Search Engine Algorithm:-
Before answering this question, A question that comes to everybody's mind: That why different search engines produces different results. Search Engine algorithm is a complex mathematical formula used by search engines to rank the WebPages. Now not all indexes (Search Engine Database) are going to be exactly the same.It depends on what the spiders find or what the humans submitted. But more important, not all search engine uses the same algorithm to search through the indexes. The algorithm is what the search engines use to determine the relevance of the information in the index to what the user is searching for.So the search engines use their own algorithm and searches their own database and comes out with relevant results. Search Engine Spiders:- Its a program that automatically fetches webpages and add them in their database.It's also called robot or crawler.
Search Engine Optimization Can Be Broadly Divided Into Two Categories :-
(1)ON PAGE OPTIMIZATION:-
(2)OFF PAGE OPTIMIZATION:-
(1)ON PAGE OPTIMIZATION:-
On page optimization means optimizing the meta tags and the on page contents of a webpage. These includes the following:-
1.Title
2.Description
3.Keywords
4.Header tags
5.Alt Text
6.Keyword Prominence
7.keyword proximity
8.Keyword Density
9.Body Content
Let us understand the importance of each of these factors and how to optimize them in details:-
1.Title:-
Page title is probably one of the most important factors in getting high search engine rankings. Choosing the right title for your webpage is very important; your title must include the targeted keyword for your webpage. Search engine gives importance to keyword placed in title and it also help to increase the Click Through Rate (CTR) from the search engine result page. Always give unique title for each page, giving the same title in more than one page will raise duplicate content issues and Google might penalize your site and you might find your site in the supplemental index of Google. A title should contain a maximum of 60-66 character(including spaces).
2.Description:-
Meta description is the snippet that search engines show while listing your site in the SERP. Always give unique description to each of the pages you have in your site. Make your description short and relevant your page content and don’t stuff keywords in your meta description so that your left with keywords only and nothing else. Make sure that the description don’t exceed 100-150 characters(including spaces) Nowadays Meta descriptions are not required for pages that have large amount of textual content(In that case search engines will automatically make one for you.)
3.Keywords:-
Nowadays search engines don’t give importance to meta keywords but still I prefer using them because you never know in future search engines might again start giving importance to them. Meta keywords should be kept within 20 keywords and it should not exceed 200-225 characters(including spaces).Can use commas or spaces as keyword separators. Use only those keywords which are relevant to your page content and don't stuff it.
4.Header Tags:-
Page headers are another important aspect of on-page optimization. Search engines assign a higher importance on keywords placed within the page headers. So use the header tags wisely to boost up your search engine rankings. For a particular page always use this order H1 to H6.Use only one header tag almost two preferably the and tag and don't use too many unnecessarily.
5.Alt Text:-
Search Engine Cannot read the text within an image, for that purpose alt text(Alternative Text) is used. Search engines crawls and index what is written within the alt tags and hence uses that text while ranking the site. Use alt texts which are relevant to the image, and don’t unnecessary stuff it with keywords.
6.Keyword Prominence:-
Search engine spiders read pages from the top left to the bottom right. So its always a good idea to place keywords at the top and also at the end of the page, this is what is known as the Keyword Prominence. Search engines weigh heavily keywords that are placed at the beginning of the page and therefore assign a higher relevancy score against those keywords.
7.keyword Proximity:-
Keyword proximity refers to the closeness between two or more keywords. In general, the closer the keywords are, the better. Always keep your targeted keyword for a particular page as close as possible. For example: Using Spam Techniques Affects Search Engine Rankings. Using Spam Techniques Affects Rankings In Search Engine. In the above two sentences, if someone searched for "Search Engine Rankings," a web page containing the first sentence is more likely to rank higher than the second.
8.Keyword Density:-
Keyword density is defined by the number of times a keyword is repeated within a document with respect to the total number of words in the document. keyword density for a page should not exceed (3-7)% within your document. The various search engines, including Google, Yahoo, and MSN Search consider keyword density as part of their search algorithm. Each search engine has a different mathematical equation regarding the density of keywords that is rewarded with higher search ranking placement. But nowadays keyword density are not of much importance and to me keyword should be used according to the necessity.
9.Body Content:-
Search engines appreciate rich content so build good quality relevant content in your site and keep them as updated as possible because search engines appreciate rich content. And don't unnecessary stuff your keyword in the body. Remember one thing its the quality of the content that is going to attract visitors and will surely help your search engine rankings.
OFF PAGE OPTIMIZATION:-
Like On Page Optimization, Off page factors are important too. Off page factors should be carefully considered and implemented to achieve high search engine rankings. The most important Off page factor is the link popularity of a site(inbound links and outbound links) and the sites link popularity can be increased by building links. Some of the advantages of link exchange are: Increase Traffic. Increase link popularity. Search Engine benefits. Increase Page Rank.
Some of the factors considered important by search engines while evaluating off page optimization are:
1.Its crucial that the websites linking to your site are relevant to the content on your site.
2.The number of sites linking to your site matters.
Quantity of the links will boost your Page Rank whereas quality of the links will boost your search engine rankings so the choice is yours. From my experience suppose a site abc.com is linked to 10 org authority sites and there is a another site cba.com whose back link is showing 100 with most of them as the .com extension. Abc.com is going to rank higher than bca.com and its a fact. So building Quality content in your site is the only way of getting links from such authority sites.
3.The anchor text which you are using in your links is important. The anchor text indicates the area of relevance the linking site places on your site. This anchor text should include your targeted keyword for the webpage. The text in the linking anchor text should not be the same in every site linking to your site. This is not seen as natural linking by the search engines. You need to get variability in the anchor text.
4.Is the link to your site a reciprocal link, one-way link or a three way link? Few important terms as far as off page factors are concerned:- Inbound link:- When site a.com links to site b.com, site a.com has an outbound link and site b.com has an inbound link. Outbound link:- When site b.com links to site a.com, site b.com has an outbound link and site a.com has an inbound link.
Anchor text:-
A visible text in hyperlink.ABC[The anchor text in this example is ABC]. So for a site to do well in search engines I think both off page and on page optimization plays an important part.
Am Sathiya i hope these topics will be usefull Comments are Welcome. Catch you all by next topic soon
Learn HTML for Begineers
Let me start wit a small introduction lesson.
I red an articles a business man was searching for website designer atlast he got a man, but where much costlier than his over all one month profit. Then he dropped making a site for his business.
Mean while he was trying to search for a product. He got a search result in the side he saw some sponsored link ie: PPC like " learn webste designing" Then he came to know about HTML.
He started to learn It was very helpful to him design his own website.
People often think it is extremely difficult to make a website. That is not the case! Everyone can learn how to make a website. And if you read on, you will have made one in just one hour.
Others believe - just as mistakenly - that expensive and advanced software is needed to make websites. It is true that there are lots of different programs that claim they can create a website for you. Some come closer than others. But if you want it done right, you must do it yourself. Fortunately, it is simple and free and you already have all the software you need.
The aim of this tutorial is to give you an easy, yet thorough and correct introduction to how to make websites. The tutorial starts from scratch and requires absolutely no prior knowledge of programming.
The tutorial cannot show you everything. So some engagement and a will to experiment are required. But don't worry - learning how to make websites is a lot of fun and gives a tremendous amount of satisfaction when you get it right.
How you choose to use the tutorial is up to you. But we suggest you read only two or three lessons a day and take time to experiment with the new things you learn in each lesson.
About Us
Hi every one, we tried to catch you all in all by means of this blog. We planned to educate about all courses which will help you to improve your knowledge. Here you can get all details about all courses and also you can download study material as well tutorials and interview questions. We also planned to publish you all with the upcoming trends in software as well in hardware where you all can get a clear idea.