Excel 2019 Model Design

Excel 2019 Model Design
English | 2019 | ISBN: 978-87-403-3100-4 | 121 pages | EPUB | 4.83 MB
In a spreadsheet program it is all about designing and building an appropriate model: what is the purpose of it, what should it calculate, what do we want to find out, analyse of even predict, and so on? In this ebook we discuss various (advanced) model designs in Excel such as outlines, consolidations, data tables, pivot tables, and forecasts. Also, we cover some topics on searching and filtering in models, and elaborate formatting and printing in more detail.