Ms Excel introduction Lesson 1

Excel Introduction

Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of writing this tutorial the Microsoft excel version was 2010 for Microsoft Windows and 2011 for Mac OS X.

Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs.

By default, documents saved in Excel 2010 are saved with the .xlsx extension whereas the file extension of the prior Excel versions are .xls.

Audience

This tutorial has been designed for computer users who would like to learn Microsoft Excel in easy and simple steps. It will be highly useful for those learners who do not have prior exposure to Microsoft applications.

Prerequisites

Before proceeding with this tutorial, you should have a basic understanding of Computer peripherals like mouse, keyboard, monitor, screen etc. and their basic operations. You should also have the basic skills of file management and folder navigations.

Ms Word Lesson 41

Create Table of Contents in Word

A table of contents (or TOC) is a list of the headings in the order in which they appear in the document. You can set a list of headings which should be part of table of contents. Let us learn how to create a Table of Contents. A table of content helps in navigating a word document by providing associated page numbers and direct links to various headings available on those pages.

Create Table of Contents:

Following are the simple steps to create Table of Contents in your Microsoft Word using various levels of headings.

Step (1): Consider a document having different levels of headings.

Step (2): You can insert a table of content anywhere in the document, but the best place is always at the beginning of the document. So bring your insertion point at the beginning of the document and then click the References tab and next Table of Content button which will display a list of Table of Contents options.

Step (3): Select any of the displayed options by simply clicking on it. A table of content will be inserted at the selected location.

Step (4): You can select number of levels of headings in your table of content. If you click on Insert Table of Content option available in the option menu then it will give you a dialog box where you can select number of levels you want to have in your table of content. You can turn ON or OFF Show Page Numbers option. Once done, click OK button to apply the options.

Now if you press Ctrl key and then click over the any link available in the table of content, it will take you directly to the associated page.

Update Table of Contents:

When you work on a word document, then number of pages and their content keep varying and accordingly you need to update your Table of Contents. Following are the simple steps to update an existing Table of Contents in your Microsoft Word.

Step (1): Consider you already have a table of content as shown above. Click the References tab and next Update Table button which will display Update Table of Contents dialog box with two options.

Step (2): If you want to update just page numbers then select first option Update page numbers only available in the dialog box but if you want to update page numbers as well as if there is any change in headings then select second options Update entire table and you will find your table of content updated with all the latest changes.

Delete Table of Contents:

Following are the simple steps to delete an existing Table of Contents from your Microsoft Word.

Step (1): Consider you already have a table of content as shown above. Click the References tab and next Table of Contents button which will display a list of Table of Contents options along with Remove Table of Contents option available at the bottom.

Step (2): Click over Remove Table of Contents option to delete the existing table of contents.

Ms Word Lesson 40

Auto Formatting in Word

The AutoFormat feature automatically formats a document as you type it by applying the associated styles to text. Let us learn how to use auto format option available Microsoft Word 2010 to format the typed content. For example if you type three dashes -- and press enter, Word will automatically create a line for you. Similarly word will automatically format two dashes -- into an em dash (—).

Setting AutoFormat:

Following are the simple steps to set AutoFormat feature in your Microsoft Word.

Step (1): Click the File tab, click Options, and then click Proofing option available in the left most column, it will display Word Options dialog box.

Step (2): Click the AutoCrrect Options button which will display AutoCorrect dialog box and then click AutoFormat As You Type tab to determine what items Word will automatically format for you as you type.

Step (3): Select from among the following options, depending on your preferences.

Option and Description

1."Straight quotes" with “smart quotes”

This option will be used to replace plain quotation characters with curly quotation characters.

2.Fractions (1/2) with fraction character (½)

This option will be used to replace fractions typed with numbers and slashes with fraction characters.

3.*Bold* and _italic_ with real formatting

This option will be used to format text enclosed within asterisks (*) as bold and text enclosed within underscores ( _ ) as italic.

4.Internet and network paths with hyperlinks

This option will be used to format e-mail addresses and URLs as clickable hyperlink fields.

5.Ordinals (1st) with superscript

This option will be used to format ordinal numbers with a superscript like 1st becomes 1^st.

6.Hyphens (--) with dash (—)

This option will be used to replace a single hyphen with an en dash (.) and two hyphens with an em dash (—).

7.Automatic bulleted lists

This option will be used to apply bulleted list formatting to paragraphs beginning with *, o, or - followed by a space or tab character.

8.Automatic numbered lists

This option will be used to apply numbered list formatting to paragraphs beginning with a number or letter followed by a space or a tab character.

9.Border lines

This option will be used to apply paragraph border styles when you type three or more hyphens, underscores, or equal signs (=).

10.Tables

This option will be used to create a table when you type a series of hyphens with plus signs to indicate column edges. Try with +-----+------+ ) and then enter.

11.Built-in heading styles

This option will be used to apply heading styles to heading text.

12.Format beginning of list item like the one before it

This option will be used to replace plain quotation characters with curly quotation characters.

13.Set left- and first-indent with tabs and backspaces

This option sets left indentation on the tab ruler based on the tabs and backspaces you type.

14.Define styles based on your formatting

This option automatically creates or modifies styles based on manual formatting that you apply to your document.

Step (4): Finally click OK to close the AutoCorrect Options dialog box and again click OK to close the Word Options dialog box.

Ms Word Lesson 39

Auto Correction in Word

The AutoCorrect feature automatically corrects common typographical errors when you make them. Let us learn how to use auto correction option available Microsoft Word 2010 to correct the spelling automatically as you type the words in your documents.

Setting AutoCorrect:

Following are the simple steps to enable AutoCorrect feature in your Microsoft Word.

Step (1): Click the File tab, click Options, and then click Proofing option available in the left most column, it will display Word Options dialog box.

Step (2): Click the AutoCrrect Options button which will display AutoCorrect dialog box and then click AutoCorrect tab. Now you have to make sure all the options are enabled specially Replace Text as you type option, if any of the options needs to be turned off then be careful before turning it off. If you are beginner then I'm sure you would not need to turn it off.

Step (3): Select from among the following options, depending on your preferences.

Option and Description

1.Show AutoCorrect Options Buttons

This option will be used to display a small blue button or bar beneath text that was automatically corrected. Click this button to see a menu, where you can undo the correction or set AutoCorrect options.

2. Correct TWo INitial CApitals

This option changes the second letter in a pair of capital letters to lowercase.

3.Capitalize first letter of sentences

This option capitalizes the first letter following the end of a sentence.

4.Capitalize first letter of table cells

This option will be used to capitalize the first letter of a word in a table cell.

5.Capitalize names of days

This option will be used to capitalize the names of the days of the week.

6.Correct accidental usage of cAPS LOCK key

This option will be used to correct capitalization errors that occur when you type with the CAPS LOCK key depressed and turns off this key.

7.Replace text as you type

This option replaces typographical errors with the correct words as shown in the list beneath it.

8.Automatically use suggestions from the spelling checker

This option tells Word to replace spelling errors with words from the dictionary as you type.

Although Word comes preconfigured with hundreds of AutoCorrect entries, you can also manually add entries using following dialog box and use Replace and With text boxes to add more entries. I added an entry for Markiting which should be replaced with Marketing. You can use Add button to add multiple entries.

Step (4): Finally click OK to close the AutoCorrect Options dialog box and again click OK to close the Word Options dialog box. Now try to type Markiting and as soon as you type this word, Microsoft Word auto correct it with correct word Marketing word.

Ms Word Lesson 38

Use Graphics in Word

You can beautify your Microsoft Word documents by inserting a variety of graphics. There are slight differences in adding graphics in your word document. This chapter will teach you two ways of adding graphics and rest will leave up to you to try. further

Adding Picture in Document:

Following are the simple steps to add an existing picture in your word document. It is assumed that you already have a picture available on your PC before you add this picture in your word document.

Step (1): Click in your document where you want to add a picture.

Step (2): Click the Insert tab and then click Picture option available in illustrations group, which will display Insert Picture dialog box.

Step (3): You can select a required picture using Insert Picture dialog box. When you will click Insert button, selected picture will be inserted in your document. You can play with your inserted picture in different ways, like you can apply quick styles to your picture, you can resize it, or you can change its color it. To try it, just double click your inserted image and Word will give you numerous options available under Format tab to format your inserted graphics.

You can try yourself to insert other available graphics like Clip Art, Different Shapes, Charts and Smart Art or Screenshots. Just click over them and you will find your way very easily.

Adding WordArt in Document:

Word Art provides a way to add fancy words in your word document. You can document your text in a variety of ways. Following are the simple steps to add a WordArt in your document.

Step (1): Click in your document where you want to add a WordArt.

Step (2): Click the Insert tab and then click WordArt option available in Text group, which will display a gallery of WordArt.

Step (3): You can select any of the WordArt style from the displayed gallery by clicking on it. Now you can modify the inserted text as per your requirement and you can make it further beautiful by using different options available. To try it, just double click your inserted WordArd and Word will give you numerous options available from Format tab to format your image. Most frequently used options are Shape Styles and WordArt Styles.

You can try yourself to apply different options on the inserted WordArt by changing its shape styles, colors, WordArt Styles etc.