Excel Peer Learning Community. UBI700. peer learning. communities. Overview.
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