The go to resource for how to use Excel dashboards and reports to better conceptualize data Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an “Excel Report. ” What they don’t offer is the most effective ways to present and report data.