The Modeling Tools option gives you a dedicated set of features to build, audit, and maintain complex Excel models directly from the UpSlide ribbon. It covers constructing models, auditing and navigating and keeping workbooks clean and reliable. This tutorial guides you through all the different features included in the Modeling Tools.
What is covered in this tutorial
This tutorial is available in different languages. To change the default language, click the Translation button in the bottom-left corner of the tutorial window.
This tutorial guides you through the following functionalities:
- Navigating open workbooks and sheets with the Workbook Explorer.
- Inserting a hyperlinked Table of Contents for your workbook.
- Tracing formula precedents and dependents with Smart Track.
- Identifying formula discrepancies across large datasets with Formula Audit.
- Colour-coding cell types automatically with Autocolor.
- Applying IfError to large ranges in one action.
- Adding CAGR functions directly from the ribbon.
- Removing corrupted name ranges with the Clean feature.
- Optimising your workbook before sharing with Prepare.