Lesson 3 PowerPoint

Slide 1: 

Lesson 3 Using Editing and Style Tools

Lesson Objectives : 

Lesson Objectives Use AutoCorrect and Error Checking. Check spelling. Use Find and Replace. Use series and AutoFill. Apply table and cell styles. Prepare headers and footers.

Using AutoCorrect : 

Using AutoCorrect AutoCorrect makes some spelling corrections as you type. For example, it corrects “teh” to “the.” It automatically capitalizes the days of the week and the months. AutoCorrect corrects capitalization errors such as THis. It aids in efficient data entry.

Setting AutoCorrect Options : 

Setting AutoCorrect Options Excel Options dialog box, Proofing pane

Error Checking : 

Error Checking Excel displays a small green triangle in the top-left corner of a cell with a potential error. The Error Checking Options button appears at the left and displays options for fixing the error. You can review an error, fix it, or ignore it. You can also click the Error Checking button on the Formulas tab to see options for the error.

Error Checking : 

Error Checking

Checking Spelling : 

Checking Spelling Excel’s spelling feature works like spellers in most programs. The Spelling button is on the Review command tab.

Spelling Dialog Box Options : 

Spelling Dialog Box Options

Using Find and Replace : 

Using Find and Replace The Find command locates a character sequence of letters, numbers, or symbols. It can also find formats. The Replace command locates character strings and substitutes them with replacement strings. You can use wildcard characters in the Find what box in either command.

Wildcard Characters : 

Wildcard Characters * Represents any number of characters ? Represents any single character

Finding a Character String : 

Finding a Character String

Replacing a Character String : 

Replacing a Character String

Finding and Replacing Formats : 

Finding and Replacing Formats Excel can find and replace formats, such as replacing bold with italic. Don’t forget, though, to reset this dialog box after completing the task.

Using Series and AutoFill : 

Using Series and AutoFill A series is a list of labels, numbers, dates, or times that follows a pattern. You can create your own series by keying two values or labels that set an identifiable interval. A series is extended using the Fill handle.

Creating a Month Series : 

Creating a Month Series

Copying with the Fill Handle : 

Copying with the Fill Handle The Fill handle copies data when there is no pattern. The Fill handle can be used to copy formulas, too.

Applying Table and Cell Styles : 

Applying Table and Cell Styles A table is an arrangement of data in a list. Each row represents one entity. A header row identifies the data in each column. The Table Styles gallery provides many options for formatting a table.

An Excel Table : 

An Excel Table

Apply a Cell Style : 

Apply a Cell Style A cell style is a preset format option for labels and values. A cell style uses colors, fonts, and effects from the document theme. Cell styles can be used within any data on a worksheet, including tables.

Cell Styles Gallery : 

Cell Styles Gallery

Preparing Headers and Footers : 

Preparing Headers and Footers A header prints at the top of each page in a worksheet. A footer prints at the bottom of each page in a worksheet. Headers/footers can have up to three sections. From the Insert command tab, you choose from several preset header/footer arrangements.

Choosing a Preset Header : 

Choosing a Preset Header

Printing Gridlines and Headings : 

Printing Gridlines and Headings You can print a worksheet with visible gridlines as well as the column and row headings. The Sheet Options group is on the Page Layout tab.

Using Page Layout View : 

Using Page Layout View Page Layout View has margin and column markers that you can drag to quickly adjust settings before printing a worksheet.

Summary : 

Summary AutoCorrect corrects common typing errors as you work. You can add your own entries or delete existing ones. The Spelling command spell-checks a worksheet by comparing labels to dictionary entries. Options let you decide if and how to make the correction. The Find command locates and lists all occurrences of data that match your Find what character string. You can use wildcards in the character string. The Replace command locates and substitutes new data for existing data. You can complete the changes one at a time or all at once.

Summary : 

Summary Excel displays options buttons for some commands and formula errors. You can look at the message for the button, make a change, or ignore it. All cells have a Fill handle that can be used for filling in a series or for copying data. Excel recognizes common series for the days of the week, the months, and patterns such as “Week 1,” “Week 2,” and so on. You can create your own series with any interval by keying at least two cells that define the pattern.

Summary : 

Summary A table is a consistent pattern of data rows with a header row. Tables can be formatted with a style from the gallery. Cell styles apply colors, fonts, and other formatting options to a cell or range. Headers and footers print at the top or bottom of every page. There are preset headers and footers, or you can create your own. You can view and print a worksheet with or without the gridlines and row and column headings. You can change margins and column widths in Page Layout View and immediately see the results.