Advantage Series: Microsoft® Excel 2002 Sarah Hutchinson-Clifford Glen Coulthard
Developing Applications Using Excel
Learning ObjectivesAfter reading this chapter, you will be able to:
1.Explain the features and limitations of working with shared workbooks |
| | | 2.Validate and format data that is input by the user |
| | | 3.Identify common cell indicators and use smart tags |
| | | 4.Audit a worksheet for cell references and incorrect or non-conforming values and formulas |
| | | 5.Automate everyday procedures by recording and running macros |
| | | 6.Use the Visual Basic Editor to modify and print recorded macros |
| | | 7.Streamline the Menu bar and toolbars to your specific work habits and patterns |
|