A workspace is multiple files. Instead of opening the excel files, you can create a workspace the opens them all for you. Open all the files for the workspace, Save the Workspace. To change it by adding other books, or removing one, then open the files, save over the Workspace.
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.
Recent Comments