Category Archives: Office

Office

How to Change the Line Spacing in Microsoft Word 2010

Microsoft Word is a free word processor with options that allow its user to edit the text in a number of ways. In Ms Word, one may perform a variety of functions such as adding tables, graphs, charts etc. You use different fonts, colors, and styles etc that make the text stand out. The line spacing option is used to improve variability and to alter the page layout. This allows text to look more complete and organized. It adds extra space between the lines in a paragraph in order to arrange the text in a manner that makes it look highly presentable.
In this tutorial, you will learn how to change the line spacing options in MS Word.


read more »

Office

How to Create Footnotes and Endnotes in MS Word 2010

You can create Footnotes and endnotes in Word documents. There is a slight difference between footnotes and endnotes. Footnotes in Word appear on the same page as the reference while endnotes appear at the very end of any document. They are mostly used in printed documents to explain, comment on or provide references for the text in the document. You might want to use footnotes for detailed comments and endnotes for citation of sources in your text documents.
In this tutorial, you will learn how to create footnotes and endnotes in MS Word.


read more »

Office

How to Create an Index in Microsoft Word 2010

An index is a different from a table of contents, since it appears at the end of the document as a list of items paired with the page numbers the items appear on. This table is usually arranged in an alphabetical order, which makes it easier for the reader to figure out where each part of the document is present. The index in Word serves more or less the same purpose as a table of contents. MS Word allows you to create index by marking important text in the document using special index fields.
In this tutorial you will learn how to create an index in Microsoft Word.


read more »

Office

How to Create a Table of Contents in MS Word 2010

Table of contents also known as “Contents” and abbreviated informally as TOC, is a list of the parts or sections of a book or a document organized in the order in which the parts appear. It is extremely helpful for a reader to quickly skim through the contents of the document or book.
In this tutorial, you will learn how to create a table of contents in Word.


read more »

Office

How to Password-protect Documents in Microsoft Word 2010

Microsoft Word for windows is a comprehensive word processing program that allows one to edit text in a number of ways. It also ensures privacy and protection for information you don’t wish to share. You can password protect word documents to save them from being edited or formatted and thus, this prevents loss or breach of data. It therefore secures documents by assigning a password to them.
In this tutorial, you will learn how to password-protect documents in Microsoft Word.


read more »

Office

How to Work with Pictures and Clip Art in Microsoft Word 2010

It is usually said that pictures have more impact on a reader than mere words do. Ms Word allows its user to insert pictures and clip art in word documents. So in this tutorial, you will learn not only how to insert clip art and pictures in your text but also how to edit the pictures that you have inserted.
So in this tutorial, you will specifically learn how to work with Pictures and Clip Art in Microsoft Word.


read more »

Office

How to set the Document Proofing Options in Microsoft Word 2010

It is important that you download Microsoft Word which is useful word processing software. For instance, you may type one word twice or type two capital letters at the beginning of a word. Once you check the option of automatically correcting such silly errors, you won’t need to correct them manually over and over again. You can even check word spelling.
In this Microsoft word tutorial, you are going to learn how to set the document proofing options in Ms Word.


read more »

Office

How to Use IF Function in Excel 2010

In Excel, there are more than 300 functions. There is one called the “if” function. It allows you to apply logical reasoning into the data and by that you can perform various tasks. It allows you to test an argument; the argument can either be true or false. We can apply a condition which will be tested. If it is true or false, different results will be shown accordingly. Such kind of logical tests can be applied by using the “if” function.
Follow this step by step tutorial to learn how to use if function in excel.


read more »

Office

How to Name and Use Cell Ranges in Excel 2010

While working with spreadsheets in Ms Excel, using a variety of shortcuts and cell references can save you a lot of time. You can name cell ranges and use that name later on instead of typing out the range over and over again. Moreover, the cell names can also be used while entering a function or formula.
Follow this step by step Ms Excel tutorial to learn How to Name and use cell ranges in Excel.


read more »

Office

How to Use SUMIF and AVERAGEIF in Excel 2010

MS Excel allows one to use a variety of functions and excel formulas when working with data and carrying out various calculations. You can even choose to test a statement to see if it is true or false. The if function allows you to apply conditional formulas that check the validity of a certain condition and test it for the data range you have applied it on.
Follow this step by step tutorial to learn How to use sumif on excel along with averageif.


read more »