Open Learning Guide for Excel 2003 Intermediate

Publisher:: CIA Training Ltd
Format:: Mixed-media pack

Now:	R281.95
eBucks:	eB2820

United Kingdom

Delivery:: Usually within 16 working days.
Seller:: kalahari.com

E-mail

Email this product to a friend

Friend's email address

Your email address

Your name

Message (optional)

Cancel

Short 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.

Product details

ISBN:: 9781860051975
Publication date:: June 2004
Additional format:: Contains Spiral bound and CD-ROM
Length:: 300mm
Width:: 150mm
Pages:: 196
Readership:: General

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.

Other products to consider

Microsoft Office Excel 2003: A Professional Approach, Comprehensive Student Edition W/ CD-ROM

Author: Deborah Hinkle; Kathleen Stewart
Now R750.95
(eB 7510)