Precedents and Dependents in Spreadsheets

LibreOffice Calc has a Detective menu to trace precedents and dependents. Similar to Excel's formula auditing tools, the tracings are limited to one cell at a time, and each click goes one level further. This new book,  Easily understand your spreadsheet model and detect errors with influence charts (For LibreOffice Calc), improves the detective tracing ability with LibreOffice Basic programming. Calc users can now trace precedents and dependents over many cells, or many levels at once. There are more functions described in the book. This unique spreadsheet book shows you how you can quickly and easily gain an overview of your spreadsheet model, with just a few clicks. The automatically generated overview, with the specialized software (VisualCheck, tested with LibreOffice 5.3) that comes with the book, allows easy understanding and error detection, as illustrated in the book. This book is meant for all types of spreadsheet users. It is meant for both novice and exp...

Influence charts: How to easily gain a powerful overview of your Excel spreadsheet model   Books about Excel don’t tell you how to gain an overview of the model in a spreadsheet. They talk about how to cut and paste, how to write formulas, and how to use special formulas. But do you know how all these formulas are organized in a spreadsheet model? Normally, people will have a very hard time doing this, as they have to look at formulas one at a time.  This unique Excel book shows you how you can quickly and easily gain an overview of an Excel model, with just a few clicks. The automatically generated overview, from the specialized software (VisualCheck) that comes with the book, has many powerful uses, as illustrated in the book. This book is meant for all types of Excel users. It is meant for both novice and expert users. Whether you create spreadsheets or you work with other people’s spreadsheets, this book will be very useful for you. T...