We can spend a lot of time looking for information surrounding formula. Formula Auditing tools help us streamline this process. See topic: HP10066253 Trace Precedents Shows what cells are supplying data to the cell selected. Trace Dependents Shows what cells the formula is depending on. Watch Window I love the watch window. It allows you […]
Navigate to the Excel Options (use the Office Button). Why? It gives you additional statistical analysis options. You may or may not need them. Once added you can access the tools on the Data tab of the ribbon.
I had a great time presenting the options of the Formula Tab in Excel 2007. We covered things like: Show Formulas in Excel Formula Auditing Vlookup, IFs and ISNA Here is the session content with Help Codes: View Full Album
Recent Comments