You have just built the perfect Excel model. It contains a wealth of data and analysis that can be used to help support critical decisions. You have added charts, summaries, and pivot tables to help tell a story and illustrate trends. Now all that is left is to get this great information into the hands of stakeholders and decision makers, and quickly! There are a lot of options when it comes to presenting your Excel analysis, and each of them comes with its pros and cons.
Option 1: Email the Excel file
Perhaps the fastest way to share your Excel analysis is to simply email it to the consumer. Excel even has a share feature built-in to facilitate this activity.
Using this approach, you can either share the file as an attachment or send a link to the latest version of the file located in OneDrive, Teams, or SharePoint. However, there are several drawbacks to sending around Excel files:
Because of the limitations of sharing Excel files directly, most companies convert the Excel analysis to a more formal presentation before sharing with stakeholders.
Option 2: Create a PowerPoint Presentation
PowerPoint is Microsoft’s marquee solution for business presentations. It allows you to rapidly create a professional presentation with text, graphics, and of course your Excel analysis. You can even add animations, smart art, and media to help tell the story and create a “wow” factor.
While PowerPoint is a powerful presentation medium, there are a number paint points associated with sharing Excel analysis in a PowerPoint file:
Option 3: Power BI Dashboards & Reports
Over the past decade, business Intelligence and analytics capabilities have evolved tremendously and are transforming the way companies are able to store, analyze, and present data. One emerging trend is real-time dashboards to provide executives and decision makers a live view into the health and performance of their business. Enter Microsoft’s solution, Power BI.
Power BI an incredibly powerful collection of services, apps, and connectors and has seen a huge uptick in adoption over the past several years. Using Power BI is a no-brainer when you are working with large, structured datasets and want to provide powerful analytics and visualizations to your stakeholders. However, we often use Excel to create content that is not structured enough for Power BI to easily consume, such as financial models, making it difficult to rely on Power BI’s native functionality as the only way to present your work.
Power BI tries to solve this by allowing users to import Excel data to use as a data source and/or directly embed an Excel chart in a Power BI dashboard. You can also publish an Excel file to Power BI and use the data as a data source or pin a range to a dashboard. While these features can be useful, there are several limitations:
Option 4: Sway
One of the newest additions to the Microsoft suite of business tools is Sway. Sway is an online tool that lets you create slick, highly responsive presentations that look great on any device. It also enables collaboration and sharing across the organization.
Trying to embed Excel analysis into Sway is a bit tricky. It can be achieved by copying and pasting “Embed” HTML code from Excel into the Sway document. It is pretty a rigid process and not a great user experience.
While Sway has a high cool factor, we do not currently see significant adoption of Sway for Excel-based business presentations.
Option 5: TackleBox
We developed TackleBox to solve many of the pain points and limitations that people experience every day when trying to present their Excel analysis. TackleBox enhances your current process by allowing you to:
Contact us to learn more about how TackleBox can save you time, reduce errors, and transform the way you are able to present your Excel analysis. View our plans to find the best option for your organization.