Open Learning Guide for Excel 2003 Intermediate

Open Learning Guide for Excel 2003 Intermediate

  • Mixed media product

List price: US$24.52

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 more 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 | 196 pages
  • 150 x 300 x 12mm | 600g
  • CiA Training Ltd
  • Sunderland, United Kingdom
  • 1860051979
  • 9781860051975
  • 2,563,815

Table of contents

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