Inscrit le: 01 Avr 2016
|Posté le: Ven 7 Juil - 00:49 (2017) Sujet du message: Power Detective Easily Trace Precedents And Dependents Fo
Knowing how cells are connected is a basic requirement to understanding a spreadsheet. This knowledge is hidden in all the cell formulas. What can we do?
LibreOffice Calc has this very useful ability (called Detective) to trace precedents and dependents, which draws arrows to connect cells. These arrows are very useful for understanding how a cell used values from other cells. Cell connections have other powerful uses. For example, cell connections for an entire spreadsheet can show us how the spreadsheet is structured. Often, cell connection arrows can reveal potential errors.
LibreOffice Calc’s Detective is, however, tedious to use as it is limited to tracing one cell at a time. We also have to know which cell to begin the tracing process.
This unique spreadsheet book shows how you can easily enhanced the tracing ability of LibreOffice, by downloading Power Detective. Power Detective allows tracing over a block of cells, or even over an entire spreadsheet.
This book goes beyond simple tracing of precedents and dependents. It shows you how you can quickly and easily gain an overview of your spreadsheet model, with just a few clicks of Power Detective. The automatically generated cell connections 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 expert users. Whether you create spreadsheets or you work with other people’s spreadsheets, this book will be very useful for you.
This book is especially useful for people who check other people’s spreadsheets. If you are a spreadsheet teacher, a spreadsheet auditor or a manager who gets spreadsheet reports, this book is a must read.
Even if you read only your own spreadsheets, this book gives you better and more efficient methods to look through your own spreadsheets.