Reviews and recommendations are unbiased and products are independently selected. Postmedia may earn an affiliate commission from purchases made through links on this page. You think you know Excel.

The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and columns using the TRANSPOSE function, transform large datasets using ...

Excel is incredibly powerful when your data is complete, but what happens when you need to solve for unknown variables? Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy ...