People on the basis of a formula, in large and complex spreadsheets in Microsoft Excel

If Microsoft Excel is used to create large and complex spreadsheets with multiple worksheets, can be very difficult for someone to move, not to mention the track or trace numbers on the table with all values and formulas that are in them. This is because in a large table, as the financial model, which may not always, if not hundreds of thousands of different formulas, and on each side, including the calculations, and numerous links to other pages in this book. The difficulty of navigating through a large and complex tables, even if you are the person who designed and built a table.

Microsoft Excel with basic functionality for users in the formulas in the spreadsheet. Some common methods are:

- With "Go to [Ctrl + G] in the box and enter the address

- Adding edit mode [F2], in which the background paper in various colors

- Using this formula, the test to use the arrow precedent and dependent cells or double-click on the back and forth between sources and the same sheet of "Come to the window to the back and forth between the links for the list.

All of this functionality and efficiency of double-clicking is not a sign for many users, large, complex tables, such as the financial model with formulas, which represent a set of cells or multiple cells or all cells of a variety of other work sheets, and even books. The conclusion is that when it comes to the formula of the navigation functionality of existing Microsoft Excel is difficult to use effectively, but not in functionality.

The biggest problem is that when it comes to verification, or a formula to understand, first of the preceding or ranges of cells, and then in a position to the other cells above and, finally, back to the original formula, initially for lookout. Browse these precedents, and then again in Microsoft Excel for the existing functionality of a long time at least, as many of them have felt the frustration editing, testing, debugging, improving expertise, or formula, or even worse, someone is on your table, where There are several background and leaves.

The overall complaint with Microsoft Excel are always on the engineers, accountants, management consultants, bankers and financial professionals working with Excel spreadsheets on a daily basis. Many users, including financial modelers table (which appears to be leading the charge) go to the Excel Add-ins and software tools that connect to Microsoft Excel, to help them navigate in the complex formulas and tables easier.

Perhaps the most popular and widely used in addition Excel for this purpose is "Formula Navigator. Supplement to the company's" Guys table. A module with a new large floating window and system for users to understand the Excel formula and effective transition for all occasions and family members and a range of cells, whether they are in a spreadsheet or other open book. Another story window products in the 2-nd version also allows the user clicks on any cell investigated (track), with this tool during the current session opens.

If the table for you or anyone else, "Formula-Navigator" must be respected, and has already healed the disappointment of many users of the spreadsheet Excel, which helps them quickly the logic in the formula, as well as the relationship between the leaves, which reduce the errors in the table and to facilitate the cleaning of the table with the test.