ExecuTrain Houston

Monthly Tip | Excel 2010 Modify Chart Options

Modifying Microsoft® Excel® Chart Options

Adding/Modifying Titles, Labels, and the Legend

1. 1. Activate the chart.
2. 2. On the Chart Tools Layout tab, in the Labels group, click the button of the label to modify.
3. 3. In the gallery grid, select the appropriate option.

Modifying Gridlines and Axes

1. 1. Activate the chart.
2. 2. On the Chart Tools Layout tab, in the Axes group, click the button of the axes to modify.
3. 3. In the gallery grid, select the appropriate option.

Adding a Background to 3D Charts

1. 1. Activate the chart.
2. 2. On the Chart Tools Layout tab, in the Background group, click the button of the background to modify.
3. 3. In the gallery grid, select the appropriate option.

Modifying Objects Within a Chart

1. 1. Activate the chart.
2. 2. Select the item you wish to modify.
3. 3. On the Chart Tools Layout tab, in the Current Selection group, click the Format Selection button.
4. 
5. 4. In the dialog box, click the item to modify. 
6. 5. Modify the appropriate options for the related item.
7. 6. Click the Close button.

Note: Options vary based on the formatting option selected.

Tags: Office 2010, weekly tip
Posted in Monthly Tip | Comments Off

Monthly Tip | Excel 2010 Format a Chart

Formatting a Microsoft® Excel ® Chart

Format Chart Elements

---

1. 1. Click the chart element. On the Chart Tools Design, Layout, and Format tabs, make the appropriate changes.
2. Note: To select a single data point, click on the series data point, then click the data point again.

Format Text Using the Mini Toolbar

---

1. 1. Right click the chart element.
2. 2. On the Mini toolbar, click the appropriate buttons.  Click outside the Mini toolbar.

Format the Chart Elements using the Format Dialog Box

1. 1. Right click on the chart element.
2. 2. Select the Format choice from the shortcut menu.
3. 3. In the Format Selection dialog box, make the appropriate changes.

Tags: Office 2010, weekly tip
Posted in Monthly Tip | Comments Off

Monthly Tip | Excel 2010 Creating a Chart

Microsoft^® Excel 2010 Creating a Chart

Tags: Office 2010, weekly tip
Posted in Monthly Tip | Comments Off

Monthly Tip | Execl 2010 Consolidating Data

Microsoft^® Excel 2010 Consolidating Data

You may find that you frequently have related lists of data in multiple sheets or workbooks. Display a summary of the data by consolidating it onto one sheet.

1. 1. Click the destination cell.
2. 2. On the Data tab, in the Data Tools group, click the Consolidate button.
3. 3. In the Consolidate dialog box, in the Function list, select the appropriate function.
4. 4. In the Reference box, specify the first source area you want to consolidate.
5. 5. Click the Add button.
6. 6. Repeat steps 4 and 5 until all source areas are specified then click the OK button.

Tags: Excel 2010, Office 2010, weekly tip
Posted in Monthly Tip | Comments Off

Montly Tip | The Access 2010 Expression Builder

Microsoft^® Access 2010 Expression Builder Feature

The Access 2010 Expression Builder includes two new tools: IntelliSense and Quick Tips, to simplify and help improve accuracy when creating and
modifying expressions within Access objects.

Use IntelliSence in the Expression Builder

On the Query Tools Design tab, in the Query Setup group, click the Builder button. The Expression Builder opens.

1. Begin entering an expression function. The IntelliSense drop-down displays.

2. Double-click or use the scroll and press the Tab+Enter keys to select a value from the list.

Note: Quick Tips appear when a value in the IntelliSense drop-down has focus.

Note: The Esc key disables the IntelliSense drop-down and the Ctrl+Spacebar keys enable the IntelliSense drop-down.

Tags: Office 2010, weekly tip
Posted in Monthly Tip | Comments Off

Monthly Tip | Outlook 2010 Meeting Request Reply

Reply to a Meeting Request in Microsoft^® Outlook^® 2010

A meeting request e-mail contains buttons which an invitee can use for responding to the invitation. According to the response, Outlook® performs the following Actions:

Tags: Office 2010, Outlook 2010, weekly tip
Posted in Monthly Tip | Comments Off

Monthly Tip | Calendar Groups and Schedule Viewing

Calendar Groups and the Schedule Viewing Microsoft^® Outlook^® 2010

Calendar groups allow easy viewing of team or department calendars.

1. 1. In calendar view, on the Home tab, in the Manage Calendars group, select the Calendar Groups button, and click Create New Calendar Group.
2. 2. Type a group name and click OK.
3. 3. Select a name from an Address Listand click Group Members to add it to the list (repeat to add additional names) and click OK.
4. 4. The new group appears in the Calendar Navigation bar.
5. 5. Select the check box for each target calendar to view.
6. 6. On the Home tab, in the Arrange group, select Schedule View.

Tags: Office 2010, weekly tip
Posted in Monthly Tip | Comments Off

Monthly Tip | Appointments and Calendar Entries

Appointments and Calendar Entries in Microsoft^® Outlook^® 2010

Appointments can be customized in many ways to be useful and easy to find. These settings are often found in the Appointment form dialog box.

1. In the Navigation Pane, click the Calendar button. 2. On the Home tab, in the New group, click the New Appointment button.

3. In the Subject box, enter a subject for the appointment. 4. Select start and end date and times for the appointment.

1. 5. Click the Save and Close button.

Edit and delete calendar entries such as appointments, meetings, and events as needed.

Edit Calendar Entries

1. 1. Double-click the calendar entry.
2. 2. Make the appropriate changes in the dialog box.
3. 3. Click the Save and Close button.

Delete Calendar Entries

Locate and select the calendar entry, and then click the Delete button.

Tags: Office 2010, weekly tip
Posted in Monthly Tip | Comments Off

Monthly Tip | Copy Filtered or Subtotal

Copy Filtered or Subtotal Data in Microsoft^® Excel^® 2010

Use the Paste Special feature of Microsoft Excel simplify routine tasks.

Copy Filtered or Subtotal Data

1. 1. Create a subtotal or a filtered list. Select the data to copy to a new location.
2. 2. On the Home tab, in the Editing group, click the Find & Select button.
3. 3. In the drop down gallery grid, click Go To Special.



4. 4. In the Go To Special, click the Visible cells only radio button.



5. 5. Click the OK button.
6. 6. On the Home tab, in the Clipboard group, click the Copy button.



7. 7. Click the new location for the data and click the Paste button.

Notes:

Quickly convert your data into a graphical illustration by using the default chart style feature.

• You can use other methods for Copy and Paste.
• After pasting, you can chart this data.

Tags: Excel 2010, Office 2010, weekly tip
Posted in Monthly Tip | Comments Off

The Chart Feature in Microsoft^® Excel^®

Use the chart feature of Microsoft® Excel® to turn data into a graphical illustration.

Create a Chart Using the Insert Tab

1. 1. Select the data cells to chart.
2. 2. On the Insert tab, in the Charts group, click the button for the chart type.
3. 3. In the drop down gallery grid, click the appropriate choice.

Create a Default Chart

Quickly convert your data into a graphical illustration by using the default chart style feature.

1. 1. Select the data cells to chart.
2. 2. Press the F11 key.
3. 3. The chart displays on a new worksheet.

Note: Use the Chart Tools tabs to modify the chart.

Tags: Office 2010, weekly tip
Posted in Monthly Tip | Comments Off