The key to building advanced formulas for Excel is the use of functions. Functions are pre-generated formulas that can manipulate the data in cells. Combining traditional math operations with functions can create sophisticated formulas.
Functions for Advanced Excel Formulas
Powerful Ways To Modify Formulas
All of this can get a bit tricky, which is why Microsoft Excel Classes are available for those new to advanced formula functions. When you're looking for Microsoft Excel training, be sure to find out if the specific areas you need are covered; many classes simply cover the basics.
Spreadsheet software, a useful tool for financial and other types of calculations, is offered by a number of different software manufacturers, both as a part of application "suites" and as stand-alone programs.