Sort by more than one column or row

You may want to sort by more than one column or row when you have data that you want to group by the same value in one column or row, and then sort another column or row within that group of equal values. For example, if you have a Department column and an Employee column, you can first sort by Department (to group all the employees in the same department together), and then sort by name (to put the names in alphabetical order within each department). You can sort by up to 64 columns.

Note: For best results, the range of cells that you sort should have column headings.

1. Select a range of cells with two or more columns of data, or make sure that the active cell is in a table with two or more columns.
2. On the Data tab, in the Sort & Filter group, click Sort.
3. Under Column, in the Sort by box, select the first column that you want to sort.
4. Under Sort On, select the type of sort. Do one of the following:
* To sort by text, number, or date and time, select Values.
* To sort by format, select Cell Color, Font Color, or Cell Icon.
5. Under Order, select how you want to sort. Do one of the following:
* For text values, select A to Z or Z to A.
* For number values, select Smallest to Largest or Largest to Smallest.
* For date or time values, select Oldest to Newest or Newest to Oldest.
* To sort based on a custom list, select Custom List.
6. To add another column to sort by, click Add Level, and then repeat steps three through five.
7. To copy a column to sort by, select the entry and then click Copy Level.
8. To delete a column to sort by, select the entry and then click Delete Level.

Note: You must keep at least one entry in the list.

9. To change the order in which the columns are sorted, select an entry and then click the Up or Down arrow to change the order.  Entries higher in the list are sorted before entries lower in the list.
10. To reapply a sort after you change the data, click a cell in the range or table and then, on the Data tab, in the Sort & Filter group, click Reapply.

Copy Formulas with the Fill Handle

1. Create the formula in the appropriate cell on the spreadsheet.

2. Click on that cell to make it the active cell.

3. Click and hold down the mouse pointer on the fill handle in the bottom right corner of the active cell.

4. Drag the fill handle to copy the formula to as many cells as needed.

Link or Embed Excel Data into Microsoft Project

You can insert data from Microsoft Office Excel into Microsoft Project as a linked object that will be updated dynamically by changes made in the source file. You can also embed the data independent of its original file.

1. In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then click Copy.
2. In Project, on the View tab, click the view that you want.

To use a view that is not on the View tab, click the arrow on Other Views, then select More Views. From the list on the More Views dialog, select the view that you want, and then click Apply.

3. In Project, select the location where you want to insert the data.
4. Right-click to select Paste Special.
5. On the Paste Special dialog, do one of the following:
* To paste the data, without a link to the source document, click Paste.
* To link the inserted data to the data in the source document, click Paste Link.
6. From the list, select Text Data and then click OK.

Add a command to the Quick Access Toolbar

1. On the ribbon, click the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar.
2. Right-click the command, and then click Add to Quick Access Toolbar on the shortcut menu.

Restrict changes in Word 2010

1.  On the Review tab, in the Protect group click Restrict Editing.
2. The Restrict Formatting and Editing pane appears.
3. In Formatting restrictions, Editing restrictions and Start enforcement, you can make selections that meet your formatting and editing needs.

Change the Appearance of Your Calendar: Change the Background Color

1. On the Tools menu, click Options, and then click Calendar Options.
2. Under Calendar options, in the Background color list, click the color that you want.

Notes:
* The color that you choose is applied to the Day and Work Week views. The Week and Month views use system background colors, which are gray and white, by default.
* The color that you choose is applied to weekday hours. A darker shade of the background color is applied to night and weekend hours.

Print Blank Calendars
You can use Microsoft Outlook to print a blank calendar. Blank calendars may be useful to take notes on or to consult when you meet to discuss a project with your team.

1. On the File menu, point to New, and then click Folder.
2. In the Create New Folder dialog box, in the Name text box, type a name for the folder.
3. In the Folder contains list, click Calendar Items.
4. In the Select where to place the folder list, click Calendar, and then click OK.
5. In Calendar, in the Navigation Pane under the My Calendars section, select the check box for the calendar you created.
6. On the File menu, click Print.
7. In the Print dialog box, under Print this calendar, click the calendar you created.
8. Select the print style options you want, and then click OK.

Make an Appointment or Meeting Private
1.  Create or open the appointment or meeting that you want to make private.
2. On the Appointment tab, in the Options group, click Private.

Important: You should not rely on the Private feature to prevent other people from accessing the details of your appointments, contacts, or tasks. To ensure that other people cannot read the items that you mark as private, do not grant them Read permission to your Calendar, Contacts, or Tasks folders. A person with Read permission to access your folders could use programmatic methods or other e-mail applications to view the details of your private items. Use Private only when you share folders with people whom you trust.

Propose a New Time for a Meeting

1. In the open meeting request, on the Message tab, in the Respond group, click “Propose New Time”.
*Note: If you open the meeting from your calendar, on the Appointment tab, in the Respond group, click Propose New Time.
2. Click either Tentative and Propose New Time or Decline and Propose New Time.
3. Click a time when all invitees are available.
4. Click Propose Time.
5. Click Send.
Microsoft Office Outlook 2007 sends a default message saying that you want to propose a new time but you have tentatively accepted the meeting. You can change this default message to say that you want to propose a new time, and that you are declining the meeting:

1. On the Tools menu, click Options, and then click Calendar Options.
2. In the Use this response when you propose new meeting times list, click the setting that you want.

*Note: You can also change this setting for individual meetings. In the open meeting request, on the Message tab, in the Respond group, click either Tentative and Propose New Time or Decline and Propose New Time. If you open the meeting on your calendar, on the Appointment tab, in the Respond group, click either Tentative and Propose New Time or Decline and Propose New Time.

Change all of the Slide Transitions in your Presentation

1. In the pane that contains the Outline and Slides tabs, click the Slides tab.
2. On the Home tab, click a slide thumbnail.
3. On the Animations tab, in the Transition To This Slide group, click a different slide transition effect.
To see more transition effects on the Quick Styles list, click the More button.
4. To re-set the slide transition speed, in the Transition To This Slide group, click the arrow next to Transition Speed, and then select the speed that you want.
5. In the Transition To This Slide group, click Apply to All.