E-Quals Level 2 Unit 023 Spreadsheets Using Excel 2003

Section 1: Fundamentals - Includes creating, opening, closing and saving a spreadsheet. Section 2: Formulas - Includes using formulas and operators, simple functions and using fill. Section 3: Editing Cells - Includes finding, replacing, moving and copying data. Section 4: Printing - Includes options on page setup and printing selections. Section 5: Formatting Cells - Includes formatting numbers and dates, and applying borders and lines. Section 6: Formatting Worksheets - Includes changing column width and row height, inserting rows and columns, freezing and splitting panes. Section 7: Cell Referencing - Including relative and absolute addressing. Section 8: Functions - Includes using a variety of in-built functions. Section 9: Names - Includes defining and using names in formulas. Section 10: Linking - Includes creating and updating links to other sheets. Section 11: Charts - Includes creating and formatting a variety of charts. Section 12: Importing and Exporting Data - Includes saving in different formats and converting to Access. Section 13: Designing Solutions - Includes data entry forms.