Publisher's Synopsis
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.
