MS Office

 Microsoft Word Tricks:

Tricks-1. Insert serial number in a table in MS word

1. Insert your table as you normally would.
2. Select the serial number column/ cells in the table that you want to have numbered.
3. Display the Home tab of the ribbon.
4. Click the Numbering tab, in the Paragraph group. Word adds numbering, automatically, to the selected cells.

Tricks-2. To Convert Text to Table

1. Select the text
2. Select the Insert tab
3. In Tables group click the Table command
4. Select the 'Convert Text to Table' option;

Tricks-3. Insert a table of contents

1. Put your cursor where you want to add the table of contents.
2. Go to References > Table of Contents. and choose an automatic style.
3. If you make changes to your document that affect the table of contents, update the table of contents by right-clicking the table of contents and choosing Update Field.

Tricks-4. Insert a page break

1. Put your cursor where you want one page to end and the next to begin.
2. Go to Insert > Page Break.

Tip: If Word puts a new page in your document unexpectedly, it might be because of a page break. To view page breaks so that you can select and delete them, go to Home > Show/Hide  .

Tricks-5. Clear formatting

1. If you want to clear the formatting of a specific part of your document, simply highlight that area and click the Clear Formatting icon. The icon will look like a small eraser next to the letter A. or
2. If you want to clear the formatting of a specific part of your document, simply highlight that area and click together Ctrl+Space or
3. If you would like to clear the formatting on everything in your document, press Ctrl+A to highlight everything in the document and then click the clear formatting icon.

 Microsoft Excel Tricks:

Tricks-1. Add More Than One New Row or Column

You may know the way to add one new row or column, but it really wastes a lot of time if you need to insert more than one of these by repeating this action X number of times. The best way is to drag and select X rows or columns (X is two or more) if you want to add X rows or columns above or left. Right click the highlighted rows or columns and choose Insert from the drop-down menu. New rows will be inserted above the row or to the left of the column you first selected.

Tricks-2. Transpose Data from a Row to a Column

You would use this feature if you want to transpose data to get a better display; however, retyping all data would be the last thing you would need to do if you know how to use the Transpose function in Paste. Here’s how: copy the area you want to transpose, move the pointer to another blank location. Go to Home->Paste->Transpose, please note that this function won’t activate until you copy the data first.

Tricks-3. Input Restriction with Data Validation Function

In order to retain the validity of data, sometimes you need to restrict the input value and offer some tips for further steps. For example, age in this sheet should be whole numbers and all people participating in this survey should be between 18 and 60 years old. To ensure that data outside of this age range isn’t entered, go to Data->Data Validation->Setting, input the conditions and shift to Input Message to give prompts like, “Please input your age with whole number, which should range from 18 to 60.” Users will get this prompt when hanging the pointer in this area and get a warning message if the inputted information is unqualified.

Tricks-4. Compose Text with &

Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol. Below I have four columns with different texts, but what if I want to compose them to one value in one cell? First, locate the cell that is to show the composed result, use the formulation with & as shown in the screenshot below. Click Enter: all texts in A2, B2, C2 and D2 will be composed together to become LizaUSA25@ in F2.

Tricks-5. One Click to Get More Status

Most users know how to check the data status in the bottom of an Excel sheet, like Average and Sum Value. However, do you know you can move the pointer to the bottom tab and right click to get more status, as shown below?

Tricks-6. Use Pivot Tables to recognize and make sense of data.

Pivot Tables are used to reorganize data in a spreadsheet. They won't change the data that you have, but they can sum up values and compare different information in your spreadsheet, depending on what you'd like them to do.

Let's take a look at an example. Let's say I want to take a look at how many people are in each house at Hogwarts. You may be thinking that I don't have too much data, but for longer data sets, this will come in handy.

To create the Pivot Table, I go to Data > Pivot Table. Excel will automatically populate your Pivot Table, but you can always change around the order of the data. Then, you have four options to choose from.

1. Report Filter: This allows you to only look at certain rows in your dataset. For example, if I wanted to create a filter by house, I could choose to only include students in Gryffindor instead of all students.
2. Column Labels: These could be your headers in the dataset.
3. Row Labels: These could be your rows in the dataset. Both Row and Column labels can contain data from your columns (e.g. First Name can be dragged to either the Row or Column label -- it just depends on how you want to see the data.)
4. Value: This section allows you to look at your data differently. Instead of just pulling in any numeric value, you can sum, count, average, max, min, count numbers, or do a few other manipulations with your data. In fact, by default, when you drag a field to Value, it always does a count.

Since I want to count the number of students in each house, I'll go to the Pivot Table and drag the House column to both the Row Labels and the Values. This will sum up the number of students associated with each house.

Tricks-7. Add drop-down menus.

Sometimes, you'll be using your spreadsheet to track processes or other qualitative things. Rather than writing words into your sheet repetitively, such as "Yes", "No", "Customer Stage", "Sales Lead", or "Prospect", you can use dropdown menus to quickly mark descriptive things about your contacts or whatever you're tracking. 

Here's how to add drop-downs to your cells. 

Highlight the cells you want the drop-downs to be in, then click the Data menu in the top navigation and press Validation. 

From there, you'll see a Data Validation Settings box open. Look at the Allow options, then click Lists and select Drop-down List. Check the In-Cell dropdown button, then press OK.

Tricks-8. Line Breaks and Wrapping Text

Typing into spreadsheet cells can be frustrating, as the default for text you type is to continue on forever, without wrapping back down to a new line. You can change that. Create a new line by typing Alt+Enter (hitting Enter alone takes you out of the cell). Or, click the Wrap Text option under the Home tab at the top of the screen, which means all text wraps right at the edge of the cell you're in. Resize the row/column and the text re-wraps to fit.

If you've got multiple cells that have text overruns, select them all before you click Wrap Text. Or, select all the cells before you even type in them and click Wrap Text. Then whatever you type will wrap in the future.

 

 Microsoft Power Point Tricks:

Tricks-1.