Open Learning Guide for Excel 2003 Intermediate

Section 14: Options - Includes view, edit & general options and creating custom lists. Section 15: Setting Chart Parameters - Includes adding titles, labels and legends, setting limits & intervals on axes and using trendlines. Section 16: Formatting Charts - Includes using house styles with various effects including colour. Section 17: Worksheet Views - Includes zoom, freeze panes, split & full screen. Section 18: Advanced Cell Formatting - Includes wrap text, text orientation, conditional formatting and a variety of Auto features. Section 19: Protection - Includes cell & workbook protection, hiding information and using read-only. Section 20: Cell Comments - Includes creating, editing, displaying, deleting & formatting comments. Section 21: Names - Includes using, creating, pasting & applying names in formulas. Section 22: Advanced Cell Editing - Includes finding & replacing text, spell checking and transposing data. Section 23: Templates - Includes creating & using templates. Section 24: Advanced Printing - Includes scaling, compiling print areas and manipulating page breaks. Section 25: Advanced Formulas - Includes percentages, cumulative totals, data series, iteration and arrays. Section 26: Solver - Includes goal seek and using solver. Section 27: Scenarios - Includes creating, using, editing & deleting scenarios. Section 28: Views - Includes creating, displaying & deleting views. Section 29: Linking - Includes creating & updating links. Section 30: Lists - Includes creating lists & data forms and using database functions. Section 31: Filter Lists - Includes using AutoFilter, advanced filter and filtering using complex criteria. Section 32: Sorting - Includes sorting lists. Section 33: PivotTables - Includes using & creating charts from PivotTables and creating from external sources.