Much of the power really lies behind the formulas and rules that you can write to manipulate data and information automatically, regardless of what data you insert into the spreadsheet.
Digging Into Excel
With the right information, you can create a system that automatically calculates and recalculates results and reports from that raw data. Today, I’d like to dig a little further under the surface and show you how you can use some of the underlying formulas and other tools to make better use of Excel.
Cool Conditional Formatting With Formulas
One of the tools that I think people just don’t use often enough is Conditional Formatting. With the use of formulas, rules, or just a few really simple settings, you can transform a spreadsheet into an automated dashboard that shows you a lot about the information in the spreadsheet at just a glance.
To get to Conditional Formatting, you just click on the Home tab, and click on the “Conditional Formatting” toolbar icon.
To Read More Double Click On The Below Button
>
If the above link does'nt work then copy paste this link in your browser -
http://www.technoration.com/p/3-crazy-formulas-that-do-amazing-things.html
0 Comment to "3 Crazy Excel Formulas That Do Amazing Things"
Post a Comment