In a spreadsheet program it is all about designing and building an appropriate calculation model: what is the purpose of it, what should it calculate, what do we want to find out, analyse or even predict, and so on? In this workbook we discuss various (advanced) model designs in Excel 2021, such as outlines, consolidations, data tables, pivot tables, and forecasts. We also discuss searching and filtering in models.
About the Author
Peter Scharpff originates from the scientific computer-linguistic field focussing on the interaction between man and machine, especially on speech and language engineering. After that he started to develop training material for office automation. In the last few decades he has also produced many publications on topics such as digital security, privacy, hardware, programming, web design, teleworking, social networks, drawing, audio, video and photo editing and the like.