Minimize costs? Create a conference schedule with fewest early-morning sessions? In this excerpt from the book Data Smart, find out how to use Excel's free Solver add-in to do some data science ...

Use Solver Add-in to solve equations in Excel. Based on your criteria solve equations easily and quickly using Excel with help of Solver Add-in.

Excel's MOD function doesn't have to be used to return a value—it can also be used to determine which cells should be formatted through conditional formatting.

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.