Loading in 3 Seconds
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.
Excel Peer Learning Community
UBI700
peer learning
communities
Today’s Topic:
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.
Step 1
Select the cell that contains the formula result to be traced..
Auditing for Formula Errors
On the Formula tab, click in the
Formula Auditing group.
Then, click on the Trace
Precedents.
Auditing for Formula Errors
Then, the Formula Precedents will be displayed.
To remove the formula precedents,
Click on Remove
Precedents
Button.
Source: http://www.dotnetheaven.com/article/tracing-formula-in-excel-2010
Precedent and dependent lines are always inserted from or to the active cell. From the active cell:
Business Analyst
Financial Services
657.278.5298
Business Analyst
Admin & Finance IT
657.278.8265
Univ. Tax Compliance Manager
Financial Services
Adjunct Faculty, Dept. of Accounting
657.278.5671
Thank You
Happy Holidays!