MS Excel Home Menu Explained: Basic Formatting & Editing Tools//How to Use the MS Excel Home Menu (Step-by-Step Tutorial)

 

MS Excel Home Menu Explained: Basic Formatting & Editing Tools//How to Use the MS Excel Home Menu (Step-by-Step Tutorial)

Introduction:

Microsoft Excel is one of the best Text editors in application software list. You can learn the use of Home Menu of Ms Excel in detail by reading the article “MS Excel Home Menu Explained: Basic Formatting & Editing Tools”. The article will acquaint about all command tabs and their command sets under Home Menu with simple explanation.  

 

MS Excel Home Menu Explained: Basic Formatting & Editing Tools

Command Tabs or Menus:

Each menu under menu bar is called Command Tab. Home menu of menu bar is also a command tab which comprises many command sets like Clipboard, Font, Alignment, Number, Styles, Cells and Editing. Let us discuss all command sets and their uses with short cut keys.

 

Clipboard:

This tab contains cut, copy, paste, and format painter option. To perform any of these commands, the user must select the required text at first.

Ø Cut: It is used to remove or delete text from source; (Ctrl + X).

Ø Copy: It is used to copy selected text but doesn’t delete text of source; (Ctrl + C)

Ø Paste: It is used to paste copied text at the location of cursor; (Ctrl + V)

Ø  Format painter: It copies format (designs like colour, size, and type of font) only and then applies to other type text; (Ctrl + Shift + C/V)

 

Font:

Font tab is a very crucial command sets which have commands for font editing like type of font, size of font, colour of font, background of font etc. The font command set is one of the frequently used commands of Ms Excel application software. To apply all the commands on text, user must select the text at beginning.

Ø Font Type: To change font as you require; like Times New Roman, Book Antique etc. (Ctrl + Shift + P)

Ø Grow Font: To increase the size of font; (Ctrl + shift + >) / (Ctrl + ])

Ø Shrink Font: To decrease the size of font; (Ctrl + Shift + <) / (Ctrl + [ )

Ø Font Type: To select predefined size of font like 20, 22, 24 etc.

Ø Font Case: To change case appearance of text like UPPER Case, lower case, Title Case etc.

Ø  Clear formatting: To clear all format applied selected text.

Ø Bold: To change the typed text into bold. (Ctrl + b)

Ø Italic: To change the typed text into italic design. (Ctrl + i)

Ø Underline: To place underline below text. (Ctrl + u)

Ø Strikethrough: To draw a horizontally line through the middle of text.

Ø Subscript: To make a letter smaller in size and appear below next to a normal text like in H₂O, 2 is in subscript form. (Ctrl +=)

Ø Superscript: To make a letter smaller and appear above next to a normal letter like in X². 2 is in superscript form. (Ctrl + Shift + +).

Ø Format Cell: There are certain commands to edit each cell like placing border, alignment and filling colour in cell.

Ø Font colour: To change font colour as you want.

 

Alignment:

This command set brings us amazing features like text alignment horizontally and vertically.

Ø Decrease Indent: To decrease the indent level of paragraph from left margin. It means moving the paragraph far from left toward right margin.

Ø Increase indent: To increase indent level of paragraph towards left margin. It means expanding paragraph toward left close to left margin.

Ø Align Left: To align text to left side. (Ctrl + L)

Ø Align Right: To align text to right side. (Ctrl + R)

Ø Align Centre: To align text at centre of page. (Ctrl + E)

Ø Align Justify: To align text to each side of margin of paper adjusting gaps between Excels. (Ctrl + J)

Ø  Align Angular Basis: To align selected text at any angle.

 

Numbers:

Under this command set user can apply fixed types of data to be used for certain cells. The data types can be number, text, decimal, percentage, currency, fraction, scientific, accounting and date etc.

Ø General: No specific data applied, it means any type of can be type in the cell.

Ø Number: It can hold only numbers means digits.

Ø Currency: It can hold only currency type data of different countries.

Ø Percentage: It allows you to store only percentage data.

Ø Scientific: It can hold data related to science with specific unit applied on it.

Ø Text: It can store only text type data.

Ø Fractions: It will store only fraction type data.

 

 

Styles:

This command set is full of different formatting styles to be applied on text or data.

Ø Conditional Formatting: It can change the design of appearance of data on the basis of condition given to it.

Ø Format Table: It allows you to format table. There are some predesigned tables that user can apply on data directly.

Ø Cell style: It can help you to give different colour to cell and font in cell.

 

Cells:

Under this command set user can insert and delete cell, row, columns in a document.

Ø Insert: It helps to insert new row or column at a certain place.

Ø Delete: It allows user to delete particular row or column.

Ø Format: Under this command there are height increasing and decreasing option to edit height of cells in a row or width of column.

Ø Rename sheet: You can change the name of sheet using the command.

 

Editing:

This command tab contains auto sum, fill and Clear commands.

Ø AutoSum: It will sum out the given numerical data,

Ø Average: It will find out average of a give series of data.

Ø Clear: It will remove all applied formats on text.

Ø Sorting and filter: This option will help to arrange data alphabetically, in ascending or descending order.

Ø Find: This option is to find and replace certain data like formula and comment etc. from file.

 

 

Conclusion:

In the article “MS Excel Home Menu Explained: Basic Formatting & Editing Tools” we come to know how the home tab is helpful to us for text editing. If you want to improve your skill, please practice all shortcut keys mentioned in this article. Thank you.

 

 

 

MS PowerPoint Home Menu Explained: Basic Formatting & Editing Tools// MS PowerPoint Home Menu (Step-by-Step Tutorial)

 

MS PowerPoint Home Menu Explained: Basic Formatting & Editing Tools// MS PowerPoint Home Menu (Step-by-Step Tutorial)

Introduction:

Microsoft PowerPoint is one of the best presentation application software of MS Office. You can learn the use of Home Menu of Ms PowerPoint in detail by reading the article “MS PowerPoint Home Menu Explained: Basic Formatting & Editing Tools”. The article will acquaint about all command tabs and their command sets under Home Menu with simple explanation.  

 

Command Tabs or Menus:

Each menu under menu bar is called Command Tab. Home menu of menu bar is also a command tab which comprises many command sets like Clipboard, Slides, Font, Paragraph, Drawing and Editing. Let us discuss all command sets and their uses with short cut keys.

 

Clipboard:

This tab contains cut, copy, paste, and format painter option. To perform any of these commands, the user must select the required text at first.

Ø Cut: It is used to remove or delete text from source; (Ctrl + X).

Ø Copy: It is used to copy selected text but doesn’t delete text of source; (Ctrl + C)

Ø Paste: It is used to paste copied text at the location of cursor; (Ctrl + V)

Ø  Format painter: It copies format (designs like colour, size, and type of font) only and then applies to other type text; (Ctrl + Shift + C/V)

 

Slides:

Slides command set allows user to add new slide to presentation, change the layout and reset the selected slides of the presentation document.

Ø New Slide: you can select a new slide from this group and add to page for presentation. (Ctrl + M)

Ø Layout: You can use this option to change the layout of inserted slide of page.

Ø Reset: This helps you to set changed placeholder as it was means to go back to default setting.

Ø Section: You can use this command to arrange slide pages in to many sections.

 

 

Font:

Font tab is a very crucial command sets which have commands for font editing like type of font, size of font, colour of font, background of font etc. The font command set is one of the frequently used commands of Ms Word application software. To apply all the commands on text, user must select the text at beginning.

Ø Font Type: To change font as you require; like Times New Roman, Book Antique etc. (Ctrl + Shift + P)

Ø Grow Font: To increase the size of font; (Ctrl + shift + >) / (Ctrl + ])

Ø Shrink Font: To decrease the size of font; (Ctrl + Shift + <) / (Ctrl + [ )

Ø Font Type: To select predefined size of font like 20, 22, 24 etc.

Ø Font Case: To change case appearance of text like UPPER Case, lower case, Title Case etc.

Ø  Clear formatting: To clear all format applied selected text.

Ø Bold: To change the typed text into bold. (Ctrl + b)

Ø Italic: To change the typed text into italic design. (Ctrl + i)

Ø Underline: To place underline below text. (Ctrl + u)

Ø Strikethrough: To draw a horizontally line through the middle of text.

Ø Text Effect: It is a set of predefined designs like Outline, Shadow, Reflection and Glow.

·      Shadow: It helps to apply shadow type you want to apply on text.

Ø Font colour: To change font colour as you want.

 

Paragraph:

This command set brings us amazing features like bullet setting, numbering, multilevel list, text alignment, line spacing, placing boarder around text etc.

Ø Bullet setting: To place bullets (Symbols) at the beginning of each sentence.

Ø Number list: To place serial number to make a list of items.

Ø Multilevel list: To place multilevel number to make list

Ø Decrease Indent: To decrease the indent level of paragraph from left margin. It means moving the paragraph far from left toward right margin.

Ø Increase indent: To increase indent level of paragraph towards left margin. It means expanding paragraph toward left close to left margin.

Ø Sort: To sort alphabetical data or to sort in ascending or descending order.

Ø Align Left: To align text to left side. (Ctrl + L)

Ø Align Right: To align text to right side. (Ctrl + R)

Ø Align Centre: To align text at centre of page. (Ctrl + E)

Ø Align Justify: To align text to each side of margin of paper adjusting gaps between words. (Ctrl + J)

Ø  Line and Paragraph Spacing: It allows you to insert space between rows of a paragraph as well as allow inserting space between two paragraphs horizontally.

Ø Shading: To colour the background of selected text of paragraph.

Ø Columns: Split text into many columns as available in application.

Ø Text Direction: Change the direction of selected text vertically, horizontally.

Ø Align text: It helps you to place text at top, bottom or middle vertically.

Ø Convert to smart art: It allows you to convert text into smart arts suitable to your contents.  

 

Drawing:

This command tab comprises with drawing shapes, colour, Shape outline, Shape effect command sets.

Ø Shapes list: You can insert required shape in to slide and edit it.

Ø Quick style: It is ready made styles of place holders. You can choose any one of it any apply.

Ø Arrange: Use this option to arrange the inserted object on slide.

Ø Shape colour: Use this option to colour the text and place holders.

Ø Shape effect: It helps to change the effect of inserted text, object and images etc.

 

Editing:

This is one of the review features of word editing software. Here you can use options like Find, Replace, and Select etc.

Ø Find: It is used to find a certain text or word or phrase in a paragraph throughout the whole document.( Ctrl + F)

Ø Replace: It allows you to find a particular word or phrase then replace it with a new word or phrase as you want. (Ctrl + H)

Ø Select: To select all press (Ctrl + A), To select a portion ( Shift + use arrow mark).

 

Conclusion:

In the article “MS PowerPoint Home Menu Explained: Basic Formatting & Editing Tools” we come to know how the home tab is helpful to us for presentation. If you want to improve your skill, please practice all shortcut keys mentioned in this article. Thank you.

 

Ms PowerPoint Home Menu 

 

MS WORD INSERT TAB: Step-by-Step complete Guide

 MS WORD INSERT TAB: Step-by-Step complete Guide

Introduction:

                   Microsoft Office application software includes MS Word Editor which can help you to create effective pages with various contents in it. You can’t imagine designing a page without using command sets of Insert Tab of MS WORD. The article “MS WORD INSERT TAB: Step-by-Step complete Guide” will guide you properly regarding creating page, inserting table and images, inserting links between two file, inserting header & Footer, placing designed text and symbols and many more.

 

Insert Tab:

Ms Word menu bar contains insert tab and this tab displays some command sets within ribbon like pages, Tables, Illustrations, Links, Header & Footer, Text and Symbols. There are some sub commands under each command set. We will study about all command sets with definition and application methods.

 

 

Pages:

Ø Cover page: These are the fully predesigned pages used to create cover page of a document. You just fill the blank columns or place holders shown in page.

Ø Blank page: Using this option user can insert one new blank page to your present document.

Ø Page Break: You can break the page from the current position of cursor on the page.

 

Note: once you insert cover page, you will see two additional command tabs on menu bar named “Table Tool (Design & Layout)” where you can find many commands. Those commands are used to edit pages as you like.

 

 

Tables:

Ø Insert Table: You can insert table specifying number of rows and columns you want in your table.

Ø Draw Table: You can draw a table using pencil tool as you want. You can design table sales according to your requirement. You can apply colourful border as well.

Ø Quick Table: There you can find predefined and predesigned table formats. You can insert one of those and fill the contents as you like.

Ø Excel Spread sheet: You can insert part of excel sheet in a table format and you can type data into it.  

 

Note: When you insert or draw table or select inserted table, you can see additional command tabs named “DESIGN” and “LAYOUT” on menu bar where you can find command sets to edit table. Use those tools to edit effectively inserted table.  

 

 

Illustrations:

Ø Picture: Under this option you can insert pictures from your computer to the open document. You can resize, and edit pictures with some limited features.

Ø Clip Art: These are the inbuilt sketches and images of computer. You can insert by searching from search bar.

Ø Shapes: Here you can find number of ready-made blank shapes (place holders) in different shapes like rectangle, square, oval, circle, stars, flowcharts, arrows, and many more, that you can insert on your document. These shapes are editable. That means you can colour it, resize it, and design it.

Ø SmartArt: There user can find diagrams, charts and graphs of all types that can be inserted as well as can be filled up with data in it. Also you can edit those smart arts slightly.

Ø Charts: Here, user can insert different types of charts according to suitablity of data. These charts can be of various category like pie, area, bar, column, line and stock etc.

Ø Screenshot: Using this command you can take screenshot of any page then crop it and insert wherever you want on your document. Press “Print Screen” key on your keyboard then paste it on Ms Paint file. Than crop or keep the original image and save it in png mode to insert in your document.      

 

Note: When you insert picture, clip art, shapes, smart art, chart and screen shot on your document, you can see additional command tab named “FORMAT” on menu bar, where you can find many command sets to edit inserted object as you wish.  

 

Links:

Ø Hyperlink: It is a type of link of text or image with a file, webpage or email address etc. inside the same document. Ctrl + K to insert hyper link. Follow the instructions to insert link.

Ø Book Mark: You can set name to a certain paragraph or portion of page or document using this command. Then you can access directly to that portion using book mark option whenever you want. For this purpose you have to select the name and click.

Ø Cross-Reference: It helps to insert reference between text and image, image and table, text and table, text and figure, heading and table etc. It is used for better explanation of anything else.

 Ms Word Home Tab

Header & Footer:

Ø Header: Using this command you can edit header position of a page. It means you can insert Text and Design it which will than appear in header position of each page of the same document. It is printable.

Ø Footer: Use this command to edit footer position of a page. Where you can place quotations, page numbers etc. And that will continuously appear in all subsequent pages of the same document. It is also printable.

Ø Page Number: You can insert serial page number starting from 1 to end page of the document. There are many formats of page number, you can choose that suits your page. They page numbers can be inserted on top, on bottom, and on margin of the page.

 

 

Note: Once you insert heard, footer and page number, you can see “DESIGN” tab that you can use to edit your text, image and number etc.

 

Text:

Ø Text Box: Using this command you can insert predesigned text boxes where you can type your contents and edit it.

Ø Quick Parts: You can use this command to insert reusable contents like Auto texts, fields etc.

Ø WordArt: Using this command you can insert decorative text on your page as well as you can edit it as you like. After inserting WordArt, you will be prompt “Format” tab where you can find number of command to edit your text inside WordArt text box.

Ø Drop Cap: It helps to create a large capital letter at the beginning of a paragraph. It should be the first letter of first row in a paragraph. You can increase the size of Capital letter up to covering height of two to three or more lines. But it should look attractive, keep in mind. These are specially used in News Paper and Magazines to attract attention of reader.

Ø Signature Line: You can insert a blank signature line with the designation of the person just below it.

Ø Date & Time: Use this command to insert current date and time at the cursor position.

Ø Object: you can insert OLE object like image or text file from any source of your computer directly to the cursor position.

 

Symbols:

ØEquations: Insert common mathematical equations and write your own equation and make necessary changes as well. It covers wide range of equations that is almost used in mathematics.

ØSymbols: Insert special symbols that do not appear on your keyboard. Like copyright symbol, trademark symbol etc.

 Ms Word Basics   

Conclusion:

We can conclude by reading the article “MS WORD INSERT TAB: Step-by-Step complete Guide” that Insert Tab is very useful for user to insert various images, tables, designed text etc. So you must learn it carefully to improve your skill in computer application. Thank You.

Ms Excel Basics