Tuesday, October 29, 2013

Sitemap: Informs Search Engines About Pages

Web Logo with Magnifying Glass


All of you are familiar with maps. City Map, World Map etc. etc. But how many of you know about sitemap? Though it's a very common term to the webmasters, general people hardly know about this. Even new bloggers are not conscious about sitemap. The fact is that it's an important part of SEO. Let's take a brief idea on Sitemap.


Well a sitemap is something like City Map! What does a city map tell you? You can find the park, bus stand, university or any other important places from the map. From a World Map, you can find the nations of the world. Similarly, a sitemap includes the posts or pages of a blog or website.


Simply a sitemap can be defined as a list of pages of a site. A sitemap gives access search engines to crawl those pages. And it also let the visitors easily navigate throughout the site. If you submit your site's map to search engines (Google, Bing, Yahoo etc.) then it will be easier to index the site. Search position of the site will also be improved.


Search engines can't index the pages of your site if you don't submit the sitemap regularly. Crawlers discover pages from your site and also from backlinks. Sitemap boosts up the process. It provides additional information about each URL (when it was last updated, how often it usually changes etc.) and thus makes it easier for the search engines to crawl a site properly.


Look at the following URL:

https://www.markspcsolution.com/atom.xml?redirect=false&start-index=1&max-results=500

If you follow the URL, you will get the sitemap of Marks PC Solution. There you will find all the URL(s) of this site with some additional information. Let's have a look at the first few lines of the sitemap -

<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-2515880289700454211</id><updated>2013-10-29T22:07:36.199+06:00</updated><category term="Tips n Tricks"/><category term="Tutorial"/><category term="Microsoft"/><category term="Internet"/><category term="Blogging"/><category term="Windows"/><category term="Software"/><category term="Troubleshooting"/><category term="Download"/><category term="SEO"/><category term="Good to Know"/><category term="Security"/><category term="Hardware"/><category term="Tech News"/><category term="Web Development"/><category term="Uncategorized"/><category term="HTML Tutorial"/><category term="Blogging Tips"/><category term="Alexa"/><category term="Facebook"/><category term="Gaming"/><category term="Troubleshooting."/><category term="Windows 8"/><category term="Blogger"/><category term="IT News"/><category term="Alexa Rank"/><category term="Antivirus"/><category term="Blogger Tips"/><category term="Google"/><category term="Windows 8 Download"/><category term="Windows 8 Features"/><category term="Windows 8 Tips"/><category term="Windows 8 activator"/><category term="blogger widget"/><category term="Adobe Reader"/><category term="Alexa Ranking"/><category term="Apple News"/><category term="Backlinks"/><category term="Basic Parts of HTML Form"/><category term="Computer"/><category term="Copyright"/><category term="Download Windows 8"/><category term="Dxdiag"/><category term="Excel Tips"/><category term="Firefox"/><category term="Foxit Reader"/><category term="Google +"/><category term="Google AdSense Tips"/><category term="Google Calculator"/><category term="How can I see my computer&#39;s information"/><category term="How to remove facebook timeline"/><category term="Internet Tools"/><category term="MS Word Shortcuts"/><category term="MS Word Tips"/><category term="Microsoft Office"/><category term="Mobile"/><category term="Office 2010 activator"/><category term="PDF viewer"/><category term="Paging File"/><category term="Password Reset Disk"/><category term="USB Flash Drive"/><category term="Virtual Memory"/><category term="Windows 8 Tricks"/><category term="YouTube Video Downloader"/><category term="activate windows 8 developer preview"/><category term="alexa toolbar"/><category term="basic HTML document structure"/><category term="how to check password strength"/><category term="notepad tricks"/><category term="password security"/><category term="remove facebook timeline"/><category term="*#06#"/><category term=".net framework 3.5"/><category term="10 GB Storage for Gmail users"/><category term="10 Years of AdSense"/><category term="12 most used facebook shortcuts"/><category term="12 useful tips for blog post writing"/><category term="32-bit Vs. 64-bit Windows"/><category term="5G Network Technology"/><category term="99counters"/><category term="A to Z Shortcuts."/><category term="AMOLED"/><category term="Acer Product"/>

Note: If you follow my sitemap URL - https://www.markspcsolution.com/atom.xml?redirect=false&start-index=1&max-results=500 - different browsers may display this differently. If you view the link in Chrome, you will see the above XML file.  

In my next post, I will show an easy way to create a sitemap even without coding knowledge.

Stay with Marks PC Solution to get more interesting IT topics!

Sunday, October 27, 2013

Creating Column, Bar & Pie Chart in MS Excel (With Sheet)


Creating Column, Bar and Pie Charts in MS Excel


Hello Dudes! Hopefully you're alright and also hope you're enjoying my posts. After a long time, I've come with MS Excel Tips. Couple of Months ago, I shared an Excel Sheet with you that includes - Salary Sheet, Result Sheet, Electric Bill etc. Today I've come with another sheet which will help you to learn how to create Column, Bar and Pie Chart in MS Excel. 


Actually I was planning to share this tips with you for a long time. But I couldn't understand how to start and what to write. Finally, I've decided to share a sheet with you as example. And I will also try to clarify how to create charts in MS Excel. 


Applies to:
  • Office 2007
  • Office 2010
  • Office 2013
But I've used Office 2010. So there might be some changes in other versions. 




For your convenience, you can download the above file and have a look before we start. It's just 22 KB! Remember, it is an .xlsx file and can only be opened with Office 2007 or above. Three charts are in three sheets. You will get the names at the bottom of the worksheet. 

Okay let's begin. I am using Office 2010. 


Column Chart:


Column Chart is a widely used chart which is normally used to show Profit, Growth Rate etc. It is shown as vertical lines. In my example sheet, I showed the pageviews of my site for last five months. To create a column chart, follow the steps below:
  1. Run MS Excel.
  2. Input your data (Maybe you can enter particular in one column and values in other columns). In my example, I showed only a single column value. You can enter multiple columns. Maybe you can show the pageviews of three years while I showed only one year.
  3. Now select your input data (in my example, I selected only data - June to 120000) to avoid the column header to be appeared in the chart. 
  4. Go to the Insert Tab > Find the Chart Section > Choose Column (I've used the first one).
  5. Now you will see a Column Chart in your book. 

Bar Chart:

This is almost similar to Column Chart but gives you a different flavour. It presents data horizontally. Creating a Bar Chart is almost similar to that of Column. After inputting the data, you have to go to the Charts and then choose Bar Chart. 


Pie Chart:

The best example of the use of Pie Chart is the representation of Budget. Without Pie Chart, representation of budget can't be imagined. It is notmally used when something is divided into parts. For example, in a budget, we can see what percentage of money will be spent in a particular sector. 

Such as for Education - 20%, for Defense - 30%, for Industry - 15%, for Power - 20% etc. Only Pie Chart can show this properly. 

To create a Pie Chart (take help of my example sheet), you have to enter the category in one column, and then enter the values in another column. Then select the input data, go to the charts, choose Pie Chart. That's it. 


Customization of Charts:

Creating a chart is not very difficult. But arranging it properly could be a boring task if you don't know how to do it. I'm gonna discuss about customizing the charts in brief:
  • After creating any chart, if you click on it, you will get three new tabs - Design, Layout and Format.
  • From Design Tab, you can change your chart design - Chart Style and Layout. 
  • In Layout Tab, you will find Chart Title, Legend Position, Data Label etc.
  • Format Tab will allow you to perform all kinds of formatting tasks including text color, line color, line style, font style, shape effects etc. 

Of course you can use your mouse to choose a particular part of the chart. Then you can change that part. To select a segment of your chart, click on it and then click again (not double click). If you wanna move any part of your chart, hit on it and move it when you get the moving pointer. 


Stay with Marks PC Solution to get more interesting IT topics!


Friday, October 25, 2013

Microsoft Office Screen Clipping Tool

Take Screenshot from Microsoft Office Programs
 
You can easily insert a screenshot to your Microsoft Office file. Maybe you've many other options to capture screen and then place it to a required place. But isn't it handier if you can do so without leaving your file? 
 
 
In March, 2012, I wrote about Snipping Tool, which is used to take screenshot. And this tool is really handy to work with images also. But when you're working with documents and workbooks, the use of snipping tool is somewhat difficult. First you have to capture the screen and then you have to save it, and finally you paste it. But many people don't know that Office 2010 & 2013 have screen clipping tool! Today, I'm gonna write about this . . .


Applies to:
  • Microsoft Office 2010
  • Microsoft Office 2013

Microsoft Word, Excel, PowerPoint & Outlook have screen clipping tool. Whenever you need to insert any part of your screen, you can use this tool. You should also know some tips to use it perfectly.
 
 
How to Capture Screen by Microsoft Office
  
Instruction:
 
  • Open any of the said programs - I'm using Word.
  • Go to the Insert Tab - Find the Screenshot option.
  • Now hit on the drop down arrow beneath Screenshot option

  • If you've some other windows open in desktop, you will see those in Available Windows - Choose one of them to directly insert that screenshot.
  • If you don't see your necessary window in the list, then you've to hit on the Screen Clipping option.
  • Now your document will be minimized and you will get a cross pointer > Select the necessary part of your screen > That part will be directly added to your file


Tips:

Sometimes, it could be difficult for you to operate this tool properly. To avoid difficulties, you must know the following tips:
 

  • If you need to capture the screenshot of your desktop only, then keep all other programs either closed or minimized except the program from which you're taking screenshot - Suppose MS Word.
  • You can also capture the part of your current program. Suppose you're clipping from MS Word and you've to take the screenshot of this program. When you hit on the Screen Clipping option, MS Word will be minimized - You will get 1 second to restore it. Then you will be able to capture the running document.
  • If you wanna take the screenshot of a particular program, you must keep that program running - Make sure the window of that program is running - It shouldn't be minimized - Thus you can find that program in the list of Available Windows.
  • If you have multiple windows open on your desktop, only maximize the window which you wanna capture - Keep all other windows minimized or closed.
  • Remember, After hitting the Screen Clipping button from the Screenshot option, you will get near about 1 second to choose any screen - Within this time, you've to minimize or maximize a program that you would like to capture. 
  • You can also save the image after clipping a screen. Right click on the clipped image, then choose Save Picture As > Choose Picture Type > Name the Picture > Save the Picture on your hard disk. Applies to MS Word only. 


Good to Know:

If you wanna add any previously stored image from your hard disk in your document, then hit on the Insert Tab > Select Picture option > Choose your picture. 


Hopefully these tips will be helpful for you. If you face any problem - Leave a comment below.

 

Stay with Marks PC Solution to get more interesting Tips!


Saturday, October 19, 2013

Scroll to Top Buttons for Blogger


Scroll to Top Buttons for Blogger
 

After a long time, I'm come with a nice widget for blogger. Maybe you've already got an idea what my today's post is about. From the post title and the image, it is clear enough to guess that you're getting a Scroll to Top script for your blogger blog. I'm gonna share some buttons too. But you can easily replace the default button with your custom image.
Back to top PNG Button for Blogger
This is the default button of the script I'm sharing here. You can view the demo at the bottom right corner of the page. Just scroll down and see the button. Then hit on this to back to the top.  But if you don't like it, or if you wanna use your own button, then you can replace this one. Now follow the procedure below (as simple as adding a JavaScript):
  1. Make sure you're signed in to your blogger account.
  2. Now go to your blogger Dashboard or Control Panel or whatever you call it.
  3. Go to the Layout, and hit on the Add a Gadget button from anywhere.
  4. Choose HTML/ JavaScript gadget.
  5. Copy the following code and paste it in the Content box.
  6. Now Save the gadget and View your site!
<script type='text/javascript'>
$(function(){$(window).scroll
(function(){if($(this).scrollTop()!=0){$("#noop-top").
fadeIn()}else{$("#noop-top").fadeOut()}});$("#noop-top").
click(function(){$("body,html").animate({scrollTop:0},800);
return false})});</script><a href="http://munnamark.blogspot.com">
</a><a id='noop-top' style='display: none; position: fixed; 
bottom: 1px; right:1%; cursor:pointer;font:12px arial;'>
<img src='http://2.bp.blogspot.com/-
ExomXm9BGFw/UmFqgFo-rFI/AAAAAAAAAE4/JMc1KSveWco/s1600/Top.png'/>

There are many codes available throughout the web to add Back to Top button. Almost all of these will ask you manually edit your HTML. But this one very simple just like adding a gadget nothing else. 



Scroll to Top Button

Scroll to Top Button

Back to Top Button

Back to Top Button

Scroll to Top Button

Smooth Scroll to Top Button

Using Custom Image:
At the beginning of this post, I mentioned, you can use your custom image with this script. Look at the blue part of the code. This is actually the link of the button where it is uploaded. If you have any button of your own, then simply replace the blue part of the code with your button image URL (You must need to upload the button image to the server) .  That's all.


Tips:

There are six buttons I've prepared for you. If you wanna use any of them, simply click make a right click on any of them. Copy the image URL. I'm showing you the sample of second one below:

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZj98J7dGO59yjgearAlvpIuteMJ8_0S5HaIBAh9WZljh6cfKhRYXodlNWTVovjHRVvhLXr9AoHnXmvJ80E3HlDedodatAR_FDLX5zhOnrLSP7l-BHlQzJbA8mXJIM3jjRh1HNlGz7J5XN/s1600/Top+2.png

Thus you can find the link of other buttons. Just click right button your mouse over the button you like, then copy the image URL. To make sure whether this is the right URL, paste it in a new tab of your browser to check whether the image is alright.


Remember, sometimes an image may got two links or URLs. One is Image URL and the other is Link URL. You should copy the image URL, not the Link URL. It also depends on your browser sometimes. For exaple, Internet Explorer will only let you copy the link URL. It shows - Copy shortcut. 


Caution:

While replacing the default button with your own you should  be careful enough:

  • Upload the image to a server which is fast and responsive
  • Never try to shorten the URL
  • Try to use the PNG format
  • Keep the image size as minimum as possible (But not at the cost of quality)
  • Don't try to replace any other part of the code if you don't have sufficient coding knowledge


Thursday, October 17, 2013

Convert DOCX to DOC Online - 100% Free !!!


Convert Docx files to Doc for Free


Hello Guys! Eid Greetings for you! Today I'm gonna share a nice tool with you. This is actually based upon the request of Marija Petrovska, an agent of investintech.com. You people know that I often write about PDF tools which are free to use. But she requested to write about a soft which is premium but having much advantages. It's size is 16 MB (Approx). As I like light software, I denied to write about it. Later she shared some light tools with me. And I promise that, I must write about these tools for my valued visitors. And this is the first one you're getting now! 


You've already got an idea about today's post. And you know this is a really really a boring problem that belongs to the file format of Microsoft Office 2007 and 2010. 


Problem Description: 

Most of you are familiar with this issue. Those of you are using MS Word 2003 or earlier version normally don't face it. But if you're using Word 2007 or later version, you might have faced this problem sometimes. 

When you save a file in Word 2007 or 2010, the file will be saved as example.docx. But Word 2003 or earlier version will support only .doc format. And naturally you will not be able to open .docx file in Office 2003.

Suppose you use Office 2010. You save a file as example.docx. You don't have printer. You're going to print your document from a shop. And this is your term paper submission deadline. You're far away of your home. When you're trying to open your document in that shop it shows some random symbols. Because it is Office XP or 2003. What do you do now?

Get back home? (Do you have time enough?) 
Purchase a new CD and install it there? (Will the shop man allow you to do so?) 
Find another shop who use Office 2003? (If you don't find?) 
Trying to collect any tool that allows Office 2003 to open docx format? (Difficult to collect!) 



Simple Solution:

Certainly this is a big problem. But the solution is very simple if you can manage a net connection. Really I mean it! Let's solve it . . . . :) 

Convert Docx file to Doc file Online


  • Hit on the above button, it will take you to a new page
  • Now look at the Step 1 : Convert .docx to .doc
  • Hit on the Browse button to Upload your .docx file
  • After Uploading the file, wait for a few minutes for the Download button to be appeared in the Step 2 (Conversion process will start automatically) 
  • As soon as the Download button appears, hit on it
  • A new window will ask you to share the page on Twitter or Facebook - You may skip
  • Just hit on the Click Here button if the download doesn't start automatically

This is really a handy tool for my personal use. Hopefully this will be helpful for you too. Many many thanks to Marija Petrovska for sharing this amazing site with me. I will try to write about the other tools soon. And you people should also provide feedback by commenting here . . . 


Stay with Marks PC Solution to get more interesting IT topics!

Wednesday, October 16, 2013

Portable Oxford Pocket Dictionary - Free Download !!!




You know the OXFORD is the world's most trusted dictionaries. Maybe many of you got this on your reading table. And some of you may have it in your mobile or computer. But I'm gonna share the Oxford Dictionary (Pocket) with those people who don't have this. 


Advantages:
  • No installation required - Portable
  • Small Download Size - Less than 3 MB
  • Rich- Includes More than 1,40,000 Definitions
  • Converter - Length, Area, Volume, Speed, Temperature, Pressure etc
  • No Special Requirements - Works with most of the Operating Systems 






Manual: 

This dictionary is very easy to navigate as well as operate. But I'd like to introduce the operation for some users who are not familiar with such software. 
  • Download the zipped file from the above link and then unzip it.
  • Double click on POD.EXE and wait a moment for the screen to be appeared.
  • You will see a small search box to find the words. 
  • As soon as you type in the box, the word with definitions will appear. But first time, you may need to press Enter.
  • At the left of the search box, there is a left and right arrow. Use them to see the next and previous words. 
  • Use Up and Down Arrow of the Keyboard to scroll down or up. 
  • There are five buttons next to the search box. Hit these one by one to find what do they do. 
  • You can take help of the menus and learn useful shortcuts to use the dictionary properly.
  • From the Options Tab, you can change font and font size. 
  • Under the Convert Tab, you will get some useful conversion tool - Length, Speed, Pressure etc.  






Stay with Marks PC Solution to get more interesting IT topics!

Sunday, October 13, 2013

Free PDF to Word Converter !!


PDF to Word Converter Logo


Hello Guys! It's been a long time since I wrote about any software. Today I've come with a great tool for you. With this tool, you can easily convert your PDF Document into editable Word Document! And certainly you get this for free!


Look at the screenshot below:

Convert PDF into Editable Word Documents


Instruction:

After installing the software you will get desktop icon. Double click on it to run the software. Then you will get the screen like the image above. Then complete your task as below:
  • Choose the source file (PDF) from the left box.
  • Select the destination folder from the right box.
  • Limit the number of pages from General Options. It could be All Pages or specific range of pages (suppose 1 to 10).
  • Unmark the options (Retains Shapes and Uses Text Box) to avoid unnecessary boxes in the converted document. 
  • You can choose either Times New Roman or Arial as the conversion font. Later you can change it while editing. 
  • As Doc Reader, you can choose either Word Pad or MS Word as your necessity. 
  • When you're ready to go, simply hit on the Convert button and wait for a few moments. 


Advantages:
  • Absolutely Free - No Serial Key Needed !!!
  • Small in Size - Less than 2 MB
  • Fast, Safe and Simple User Interface - No boring options, No Ads







You may also like: 



Stay with Marks PC Solution to get more interesting IT topics!

Friday, October 11, 2013

XPS Documents- Alternative to PDF


Microsoft XPS Logo/ Icon


An XML Paper Specification (XPS) is a document format that you can use to share documents with others. Except few dissimilarities, it is exactly similar to a PDF document. More than a year back, I discussed about PDF file and I've also discussed about how to create PDF file. Today I'd like to talk about XPS. 


Applies to: 
  • Windows 7 
  • Windows 8
  • Windows 8.1


Though XPS is also available with Windows Vista since 2006, still this is not a popular way of sharing documents due to the widely accepted PDF documents. PDF is being used for a long time. Thousands of tools (either Premium, Freeware, Shareware or even Open Source) are available throughout the web for handling PDF documents.

You should notice, PDF viewer is available with any smart phone, tablet, laptop or desktop. It is supported by any operating system. But XPS is not so cheap. It's exclusive for Windows Vista or Above. And that's why it is not a widely accepted medium of sharing documents. 


While most of the people even don't know about XPS document, I really enjoy storing my files in xps format. Believe me- this is safe too! Because a Windows XP user can't open your XPS file normally. You can easily store your information in XPS format and upload these to internet


How to Create XPS Document? 

If you can create PDF documents, then creating XPS is nothing serious for you. But if you don't know how to create PDF, then first you should read this. This will help you to be familiar with the necessary steps.  

By the way I'm showing you how to create XPS documents. Follow the steps below:
  1. Press Ctrl + P from any program you want to create PDF from.
  2. Create Printer > Choose Microsoft XPS Document Writer.
  3. Hit on the Print Button.
  4. Name the file and choose the destination where it should be printed.
  5. Finally hit the Save Button. Your file is ready.
Note: Look at the Save as Type in step 4. You can choose either .xps or .oxps. 


How to View XPS Document? 

To view XPS document, you have XPS Viewer with Windows 7. And in Windows 8 or 8.1, you have XPS Viewer and Windows Reader. Without XPS viewer, you can't open this type of file. 



How to Use XPS Document? 

I never recommend to use XPS document for sharing files with others. Because you know XPS is still unknown or unavailable to most of the people. In case of sharing files, PDF is better. But while sharing an exclusive file, XPS is a better choice for sure. 

You can store your personal information through xps files. You can also upload those files online. This works like printed papers. Like printed files, XPS file doesn't allow you to change the contents easily. So you can protect your contents from alteration or overwriting. 


After reading this article, hopefully you got a better idea about XPS Dcoment, XPS Document Writer and XPS Viewer. Still if you have any query just knock me. I'm ready to reply to your comments . . . :)



Stay with Marks PC Solution to get more interesting IT topics!

Saturday, October 05, 2013

HTML Tutorial 7: Creating HTML List


Sticky Note with Ordered and Unordered List


Hello Guys! This is my tutorial number 7 on HTML. If you would like to read the previous 6 tutorials then please use the search box above, type HTML and get the HTML tutorials list. 

Today I will discuss about a simple topic of HTML. Really this is as simple as I say! :) Okay let's start.


Practice Rules

Practice rules are as usual. Use notepad and a web browser. Save the file with .htm or .html extension. 


HTML List: Ordered and Unordered

There are mainly two types of lists can be created by HTML code. The first one is ordered list and the other is unordered list. 


Ordered List:

In an ordered list, the list items are marked by numbers. This exactly looks like a numbered list created by Microsoft Word or other text editing programs. 

An ordered list starts with <ol> tag and ends with </ol> tag. Each item of the list starts with <li> tag and ends with </li> tag. Look at the code below:

<ol>
<li>Apple</li>

<li>Google</li>

<li>Microsoft</li>
</ol>

    Remember, o indicates unordered (o) and l indicates list. Thus it is written as <ol>. 

    After enter this code, you will get the following output in your browser: 
    1. Apple
    2. Google
    3. Microsoft

    Unordered List:

    In an unordered list, the list items are marked with bullets. Normally small black circles (·

    Code for unordered list is very similar. Instead of typing <ol>, you need to use <ul>. u for unordered and l for list. Follow the code below:


    <ul><li>Apple</li><li>Google</li><li>Microsoft</li></ul>
    Your browser will display:
    • Apple
    • Google
    • Microsoft



    Description List:

    There is another list in HTML which is known as description list. A description list contains a brief description of the list item. 

    But I think you can describe the list item simply typing some texts. This is not very important to create a different type of list to describe list items. That's why I'm not showing the code of description list. 


    Tip: You can use line breaks, text, links or images inside a list item. 




    Tags used in HTML List: 

    By this time you're familiar with the tags used in creating HTML list. Let's check them at once:


    • <ol> - Defines an ordered list
    • <ul> - Defines an unordered list
    • <li> - Defines a list item
    • <dl> - Defines a description list
    • <dt> - Defines a term/ name in description list
    • <dd> - Defines a description of a term/ name in description list. 

    Stay with Marks PC Solution to get more interesting IT topics!