Abstract
Excel is a remarkable tool for business intelligence, office jobs, and many other applications. Its greatness comes from many features it has, including formula and functions, autofill, automatic workbook calculation, add-in, and so on. Via automatic workbook calculation, any modifications on the formula or the value inside a cell can trigger recalculations of all other cells that are directly or indirectly related to this cell, even if they are on a different worksheet. The recalculation can also reshape charts that are dependent on these cells. The value of a cell can also be linked to a form control, which renders visual control of data values and charts.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Hong Zhou
About this chapter
Cite this chapter
Zhou, H. (2020). After Excel. In: Learn Data Mining Through Excel. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5982-5_13
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5982-5_13
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5981-8
Online ISBN: 978-1-4842-5982-5
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)