1

Excel Lesson 6Enhancing a Worksheet

2

Sorting Dataascending sort—letters (A to Z) and #s lowest to highestDescending—letters (Z to A) and #s highest to lowest To sort data, you first click a cell in the column by which

you want to sort a range of data. Data tab>Sort & Filter group>click ascending or

descendingYou can sort by more than one column of data. You set up a

sort with multiple levels in the Sort dialog box.

3

Filtering Data

Filtering—displays data that meets certain criteria and temporarily hides the rows that do not

Data>Sort & Filter>Filter buttonFilter arrows appear in the lower-right

corners of the column heading cells. AutoFilter--displays a list of all the

values that appear in that column along with additional criteria and color filtering options.

4

Applying Conditional FormattingConditional formatting—changes look of cells

that meet a specified conditionHome>Styles>Conditional Formatting buttonThe Highlight Cells Rules format cells based on

comparison operators. The Top/Bottom Rules format cells based on their

rank.

5

Hiding Columns and RowsHiding—temporarily removes a row or

column from viewSelect how many rows or columns you

want to hide, and then right-click the selection.

On the shortcut menu that appears, click Hide to remove the selection from view in the worksheet.

6

Adding Shapes to a Worksheet

Insert tab>Illustrations group>Shapes button

To delete a shape, select it and press the Delete key.

7

Adding SmartArt Graphics to a Worksheet

SmartArt graphics enhance worksheets by providing a visual representation of information and ideas.

SmartArt graphics are often used for organizational charts, flowcharts, and decision trees.

Insert>Illustrations>SmartArt

8

Adding Pictures to a Worksheet

Insert>Illustrations>Picture

Insert>Illustrations>Clip Art

9

Using TemplatesTemplates–predesigned workbook files The template includes all the parts of a workbook

that will not change, such as text labels, formulas, and formatting.

You save a copy of the template as a workbook and enter the variable data. You can use a template again and again, entering different data each time.

Excel comes with a variety of templates, which you access from the New Workbook dialog box.

10

Inserting Hyperlinks

Hyperlink—cell that opens another file or page when you click it

Insert>Links>Hyperlink button or right-click the cell

11

Saving a Workbook in a Different Format

Excel workbooks can be saved in different file formats so that they can be opened in other programs.

For example, if you want to share data with a coworker or friend who uses an earlier version of Excel, you can save your Excel file in a format that is readable by Excel 2003.

You can also save the file in a format that can be viewed as a Web page on the Internet.

12

Working with CommentsComment--notes used to explain or identify infoReview>CommentsThe New Comment button inserts a comment in

the active cell. To edit a comment, click the cell that contains

the comment. Review>Comments>Edit Comment button

To delete a comment, click the cell that contains the comment. Review>Comments>Delete