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 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 PivotTables
• Develop 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.