Session 3

Microsoft Excel: Using Natural Language Formulas, Formula AutoCorrect, and Range Finder

Intuitively create formulas with Natural Language Formulas. These formulas are easier to understand, and easier for other people using the spreadsheet to figure out, without complex programming or cryptic cell references.

Formula AutoCorrect identifies 15 of the most common errors in creating formulas and recommends corrections for them. A dialog box appears, lets you know the correction has been made, and gives you the option of accepting or rejecting the change.

Learn how to use Range Finder to audit and correct formulas and ensure that you are charting the correct ranges. The Range Finder was designed to make it easier for users to visually identify what cells make up a formula or a chart. In addition, Range Finder frames are flexible and can be moved or dragged to change the formula or chart series.

Session 3	Hands-On Exercises with Excel 98		1:27
		Estimated completion time
		Effortless Analysis	0:19
	Objectives
	*	Exercise 1: Apply Natural Language Formulas
	*	Exercise 2: Use Formula AutoCorrect
	*	Exercise 3: Use Range Finder
	*	Exercise 4: Apply Conditional Formatting
	*	Exercise 5: Use Data Validation

		Richer Reporting	0:53
	Objectives
	*	Exercise 1: Work with Improved Chart Wizard
	*	Exercise 2: Apply Custom Cell Formatting
	*	Exercise 3: Save as HTML

		Increased Connectivity	0:15
	Objectives
	*	Exercise 1: Create Hyperlink from Microsoft Excel Word
	*	Exercise 2: View Web Toolbar