Open Learning Guide for Excel 2003 Advanced

Section 34: Advanced Functions - Includes using logical, date & time, statistical, financial & nested function. Section 35: Advanced Charts - Includes using chart options, moving average, 3D chart view and stacked bar charts. Section 36: Outlines - Includes creating & working with an outline. Section 37: Objects - Includes using drawing tools, inserting, deleting & manipulating objects and using WordArt. Section 38: Data Tables - Includes one & two input tables. Section 39: Data Analysis - Includes descriptive statistics, correlation, histograms and sampling. Section 40: Styles - Includes using & deleting styles. Section 41: Data Consolidation - Includes by position and category. Section 42: Customising Toolbars - Includes moving, displaying, hiding & adding toolbars as well as customising those on view. Section 43: Macros - Includes recording, running, assigning to a button and editing macros & buttons. Section 44: Auditing - Includes tracing precedents, dependents & errors. Section 45: Forms - Includes creating on-line forms. Section 46: Web Pages - Includes publishing & updating web pages and using hyperlinks. Section 47: Sharing Workbooks - Includes tracking changes. Section 48: Importing Data - Includes importing from & to a variety of sources. Section 49: Designing Solutions - Includes data entry forms, testing formulas & spreadsheets.