Management Spreadsheets with Microsoft Excel: ICDL Professional

Management Spreadsheets with Microsoft Excel: ICDL Professional provides readers with the skills and knowledge required to use advanced features in Microsoft Excel. Filled with practical advice, step-by-step instructions, and revision exercises after each section, this book gives ...Management Spreadsheets with Microsoft Excel: ICDL Professional provides readers with the skills and knowledge required to use advanced features in Microsoft Excel. Filled with practical advice, step-by-step instructions, and revision exercises after each section, this book gives learners a useful overview of the advanced spreadsheet techniques needed to use Excel effectively.

Topics covered include: Apply complex formulas and functions to calculations - Create, edit, and format worksheet tables - Create, modify, and summarise information using PivotTablesDevelop macros to perform automated tasks - Use scenarios to predict future financial outcomes - Represent data using charts with advanced features - Apply conditional formatting to tables - Data validation and auditing in worksheets - Perform calculations using data tables - Trace formula elements using precedents and dependants Apply names to groups and formulas - Collaboration and reviewing spreadsheets with other users Readers can develop their existing skills and build on previously learned spreadsheet knowledge with this useful guide. Illustrated with step-by-step instructions and revision exercises after each section, readers will be able to advance their understanding of Microsoft Excel. Accompanying resources are available to download from the author's website.