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.