menu
{ "item_title" : "Management Spreadsheets with Microsoft Excel", "item_author" : [" Conor Jordan "], "item_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 calculationsCreate, edit, and format worksheet tablesCreate, modify, and summarise information using PivotTablesDevelop macros to perform automated tasksUse scenarios to predict future financial outcomesRepresent data using charts with advanced featuresApply conditional formatting to tablesData validation and auditing in worksheetsPerform calculations using data tablesTrace formula elements using precedents and dependantsApply names to groups and formulasCollaboration and reviewing spreadsheets with other usersReaders 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.", "item_img_path" : "https://covers2.booksamillion.com/covers/bam/1/73/965/473/1739654730_b.jpg", "price_data" : { "retail_price" : "21.99", "online_price" : "21.99", "our_price" : "21.99", "club_price" : "21.99", "savings_pct" : "0", "savings_amt" : "0.00", "club_savings_pct" : "0", "club_savings_amt" : "0.00", "discount_pct" : "10", "store_price" : "" } }
Management Spreadsheets with Microsoft Excel|Conor Jordan

Management Spreadsheets with Microsoft Excel : ICDL Professional

local_shippingShip to Me
In Stock.
FREE Shipping for Club Members help

Overview

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.

Details

  • ISBN-13: 9781739654733
  • ISBN-10: 1739654730
  • Publisher: Conor Jordan
  • Publish Date: May 2022
  • Dimensions: 11 x 8.5 x 0.35 inches
  • Shipping Weight: 0.88 pounds
  • Page Count: 166

Related Categories

You May Also Like...

    1

BAM Customer Reviews