Open Learning Guide for Excel 2003 Advanced

Open Learning Guide for Excel 2003 Advanced

  • Mixed media product

List price: US$19.98

Currently unavailable

We can notify you when this item is back in stock

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

This A4 spiral bound manual has been specifically designed to provide the necessary knowledge and techniques for the successful creation and manipulation of a complex Excel spreadsheet. The accompanying data files on disk are designed to help demonstrate the features you are learning as you work through the manual step by step approach.show more

Product details

  • Mixed media product | 163 pages
  • 150 x 300 x 18mm | 502g
  • CiA Training Ltd
  • Sunderland, United Kingdom
  • 1860052002
  • 9781860052002

Table of contents

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.show more