Graphics

Leave a Comment
Graphics

Adding a Picture
To add a picture:

§     Click the Insert tab
§     Click the Picture button
§     Browse to the picture from your files
§     Click the name of the picture
§     Click Insert
  §     To move the graphic, click it and drag it to where you want it

Adding Clip Art
To add Clip Art:

§     Click the Insert tab
§     Click the Clip Art button
§     Search for the clip art using the search Clip Art dialog box
§     Click the clip art
§     To move the graphic, click it and drag it to where you want it

Editing Pictures and Clip Art
When you add a graphic to the worksheet, an additional tab appears on the
Ribbon. The Format tab allows you to format the pictures and graphics.  This tab has four groups:

Adjust: Controls the picture brightness, contrast, and colors
Picture Style:  Allows you to place a frame or border around the picture and add effects
Arrange: Controls the alignment and rotation of the picture
Size: Cropping and size of graphic
 Adding Shapes
To add Shape:

§     Click the Insert tab
§     Click the Shapes button
§     Click the shape you choose


§     Click the Worksheet
§     Drag the cursor to expand the Shape

To format the shapes:

§     Click the Shape
§     Click the Format tab

Adding SmarArt

Smart Art is a feature in Office 2007 that allows you to choose from a variety of graphics, including flow charts, lists, cycles, and processes.  To add Smart Art:

§     Click the Insert tab
§     Click the SmarArt button
§     Click the SmarArt you choose

§     Select the Smart Art
§     Drag it to the desired location in the worksheet

To format the Smart Art:

§     Select the SmarArt
§     Click either the Design or the Format tab
§     Click the SmarArt to add text and pictures.


Read More

Filtering

Leave a Comment
Filtering
Filtering allows you to display only data that meets certain criteria. To filter:

§     Click the column or columns that contain the data you wish to filter
§     On the Home tab, click on Sort & Filter
§     Click Filter button
§     Click the Arrow at the bottom of the first cell
§     Click the Text Filter
§     Click the Words you wish to Filter
§     To clear the filter click the Sort & Filter button
§     Click Clear

Read More

Sort and Filter

Leave a Comment
Sort and Filter
Sorting and Filtering allow you to manipulate data in a worksheet based on given set of criteria.

Basic Sorts
To execute a basic descending or ascending sort based on one column:

§     Highlight the cells that will be sorted
§     Click the Sort & Filter button on the Home tab
§     Click the Sort Ascending (A-Z) button or Sort Descending (Z-A)               button
 Custom Sorts

To sort on the basis of more than one column:

§     Click the Sort & Filter button on the Home tab
§     Choose which column you want to sort by first
§     Click Add Level
§     Choose the next column you want to sort
§     Click OK
Read More

Macros

Leave a Comment
Macros
Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet. They record sequences of menu selections that you choose so that a series of actions can be completed in one step.

Recording a Macro
To record a Macro:

§     Click the View tab on the Ribbon
§     Click Macros
§     Click Record Macro
§     Enter a name (without spaces)
§     Enter a Shortcut Key
§     Enter a Description

§     Perform the Macro
§     Click Marcos
§     Click Stop Recording
Running a Macro

To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the Macro. Or you can view all macros and run by:

§     Click Macros
§     Click View Macros
§     Choose the Macro and click Run
Read More