Posts

, , ,

What is INSERT Tab and it's uses in Office Excel

We use Insert tab to insert the picture, charts, filter, hyperlink etc. We use this option to insert the objects in Excel. To open the insert tab, press shortcut keys Alt+N. Insert tab contains 10 (ten) groups: Tables Apps…
, , ,

What is HOME Tab and it's uses in Office Excel

Home tab contains the most frequently used options such as cut-copy-paste, font formatting, alignment, Number, Conditional formatting, etc. All the options are used to format the data.  Home tab contains 7 (Seven) groups: Clipboard…
, , , ,

What is REVIEW Tab in Office Excel

Review tab contains the editing feature, comments, track changes and workbook protection options. These features make it easy to share the data with the proper information whilst ensuring the security of data.Review tab contains 4 (four)…
, , , ,

Use Page Layout view to fine-tune pages before printing in Office Excel

Before you print a Microsoft Office Excel worksheet that contains a large amount of data or multiple charts, you can quickly fine-tune it in the Page Layout view to achieve professional-looking results. As in Normal view, you can change the…
, , , ,

How To: Copy "Page Setup" (Margins) to All other Worksheets in Office Excel

When we have a workbook with multiple worksheets & we need to print them neatly and prettily, with the same headers, footers, margins, page orientation and so on. If there is one worksheet, we can setup the page settings for the worksheet…
microsoft office excel word power-point
, , ,

How To: Remove Automatic Horizontal Line in Office Word

Word automatically formats items like quotes, bulleted and numbered lists, and horizontal lines. When you type at least three dashes, underscores, or equal signs in a paragraph by themselves and press “Enter”, the characters are automatically…
Microsoft Office - kamiltech
, , , ,

Add or Remove Protection in Microsoft Office Word document, Excel worksheet & PowerPoint presentation

In Microsoft Office, you can use passwords to help prevent other people from opening or modifying your documents, workbooks, and presentations. WARNING: It's important to know that if you don't remember your password Microsoft can’t retrieve…
microsoft office excel word power-point
, ,

Complete list of Keyboard Shortcuts for Microsoft Office Powerpoint, let's create a presentation more faster

Using Microsoft Office Powerpoint for making presentation is great but very tedious sometimes if you don't find anything that you want in Ribbon.When we present something in Office Powerpoint, it's really good if we don't use mouse. With…
Microsoft Office - kamiltech
, , ,

How To: Use HLOOKUP Function in Office Excel

HLOOKUP function in Excel is a sibling of VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called as Horizontal Lookup.HLOOKUP is a very useful function for creating horizontal lookups, but as most…
microsoft office excel word power-point
, , ,

What is Page Layout in Microsoft Office Excel

Many of the commands you'll use to prepare your workbook for printing and PDF export can be found on the Page Layout tab. These commands let you control the way your content will appear on a printed page, including the page orientation and margin…