Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Management Spreadsheets, Paperback / softback Book

Management Spreadsheets Paperback / softback

Paperback / softback

Only a few left - usually despatched within 24 hours

Description

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.

 

 

 

Information

Save 8%

£16.99

£15.49

Only a few left - usually despatched within 24 hours
Add to Basket
Sign in to add to wishlist
 
Free Home Delivery

on all orders

 
Pick up orders

from local bookshops

Information