How to Calculate Fluctuations in Excel. Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.