Learn how to use Advanced Microsoft Excel features with this step by step guide. With clear instructions, detailed illustrations and reviews after each section, prepare for the Advanced ICDL exam with this useful handbook. Learn how to:*Create, edit and format charts*Link cells, worksheets and workbooks*Use complex functions and formulas*Apply auditing techniques and data validation*Create and use templates*Create and use automated features such as macrosFilled with helpful advice, this guide will show you how to use the advanced features of Microsoft Excel with confidence.

Covering various aspects of the ECDL/ICDL Advanced AM4 syllabus, this step-by-step, exercise based manual helps readers gain the required knowledge for the successful completion of the ECDL Foundation test. Useful data files are available to download, which allows the practise of different software features. It is approved by the ECDL Foundation.

As well as comprehensively covering the ECDL/ICDL Advanced AM4 syllabus, this manual is useful for those wishing to increase their spreadsheet knowledge. Designed to gradually build up your knowledge the syllabus includes advanced Functions, Scenarios and Pivot Tables. Data files are supplied on CD which allow you to practise the different features.Approved by the ECDL Foundation.

Digidiscover offers a range of resources drawing on the currently available ICDL Excel syllabus. With comprehensive coverage and in-depth descriptions, exercises, instruction and reviews, explore this cutting-edge tour of Microsoft Office. From Word processing and database to text production, explore the full spectrum of Microsoft Office in this well researched introduction to digital office skills. Discover the dialogue behind digital skills from the learner's perspective. Acquire the underlying skills necessary to perform in any digital scenario.Learn how to:*Use the basic functions of Microsoft Excel*Save spreadsheets in different formats*Use help facilitiies, shortcuts and the go to tool*Enter and format data in spreadsheets*Edit columns and rows*Use worksheets effectively*Perform a range of calculations and functions*Apply formatting to tables*Create appropriate charts to represent data*Prepare spreadsheets for printingFilled with helpful advice, this guide will show you how to use Microsoft Excel with confidence.

using Excel 97. As well as comprehensively covering the ECDL/ICDL Advanced AM4 syllabus, this manual is useful for those wishing to increase their spreadsheet knowledge. Designed to gradually build up your knowledge the syllabus includes advanced Functions, Scenarios and Pivot Tables. Data files are supplied on CD which allow you to practise the different features.Approved by the ECDL Foundation.

Tests can be daunting, especially ECDL Advanced tests. Are you about to do the ECDL Advanced AM6 test? Is your knowledge up to scratch? This guide gives everyday examples, and tests how your new found knowledge can be utilised.