|
![]() |
|||
|
||||
OverviewManagement 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. Full Product DetailsAuthor: Conor JordanPublisher: Conor Jordan Imprint: Conor Jordan Edition: 2nd Management Spreadsheets with Microsoft Excel ed. Dimensions: Width: 21.60cm , Height: 0.90cm , Length: 27.90cm Weight: 0.399kg ISBN: 9781739654733ISBN 10: 1739654730 Pages: 166 Publication Date: 02 May 2022 Audience: General/trade , General Format: Paperback Publisher's Status: Active Availability: Available To Order ![]() We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately. Table of ContentsReviewsAuthor InformationTab Content 6Author Website:Countries AvailableAll regions |