Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager?

When you decide to build interactive dashboards in Excel, you are stepping into a world where data tells a story. These dashboards are powerful tools for summarizing, analyzing, and presenting data in ...