Excel Peer Learning Community. UBI700. peer learning. communities. Overview.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
3 Simple Ways:
By the end of this session, you will be able to…
Today’s Date: CTRL&+ &; is a shortcut for entering the current date (hold down all 3 keys and release.
Note: Putting extra spaces into formulas can cause an error message!
Source: Excel for Dummies, http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html
To Trace Formula, we have the following steps.
Select the cell that contains the formula result to be traced..
On the Formula tab, click in the
Formula Auditing group.
Then, click on the Trace
Then, the Formula Precedents will be displayed.
To remove the formula precedents,
Click on Remove
Precedent and dependent lines are always inserted from or to the active cell. From the active cell:
Admin & Finance IT
Univ. Tax Compliance Manager
Adjunct Faculty, Dept. of Accounting