We need to generate visual graphs for those numbers so that we can share financial data in an executive-friendly format. We also heavily work with numbers, whether it’s when planning out the project budget or for benchmarking our projects against others. We need to track dates and tasks on a detailed level. And keep visiting Tech Community for all the latest Planner news and to engage directly with the Microsoft Planner team.A major part of our job as Project Managers is to organize information: We need to break down large complex activities into smaller achievable steps. Send us ideas for future integration capabilities or enhancements to current ones, like adding the ability to import items from Excel back into Planner, through our UserVoice site. We’re constantly looking for ways to improve features like this one and your input for doing that is crucial. These are just a few of our ideas of how Export to Excel can help you get more out of Planner-but we want to hear how you’re using it! Leave us a comment below on your experiences so far. This can be particularly useful for giving a high-level plan summary to executives without bogging them down with unnecessarily details (or adding them to yet another plan). By bringing your plan into Excel, you can easily delete the columns of information you don’t want to disseminate. Export to Excel can help you do just that. This works fine in most cases, but there may be times when you want to share a plan’s status without also sharing all its minute details. Sharing: There’s currently no way to give access to only some parts of your Planner plan-someone either has access to all of it or they don’t have access at all. Printing: Excel gives you a tabular view of your plan details that may be easier to consume for some as a printed document than a Planner plan board. By exporting each plan to Excel individually, and then manually merging those files into a single spreadsheet, you can surface new insights about related plans. There’s no way to analyze these plans together in Planner-but you can in Excel. Merging plans: There are almost certainly plans in your hub that are somehow related maybe they share the same executive team or are part of a multi-year strategic initiative. Plus, connecting Excel data to Power BI is easier than ever today, giving you yet another option for visualizing critical plan details. Choosing from a host of Excel’s analysis tools, you can quickly find outliers in your plan take inventory of completed tasks, which are hidden by default in Planner sort and filter based on elements not available with Planner chart filters, like who created the task and the task checklist items build PivotTables and helpful graphs, like Burndown Charts and, much, much more. Export all your plan details to Excel, store that Excel file somewhere safe (like OneDrive for Business), and purge that plan from Planner to keep your hub clean and organized.Īnalysis: The use cases here are nearly endless. Below are just few scenarios to help you get started with this newest Microsoft 365 integration.Īrchiving: Excel can provide a simple method for archiving your completed plans. There are countless use cases for Export to Excel. The top of the sheet includes all-up plan information, including plan name, plan ID, and date of export to ensure you’re looking at the latest information. The downloaded file includes just about all the details from your plan (e.g., assigned to, start and due dates, description, labels, and more), with each task getting its own row in the spreadsheet. Your plan will automatically download as an Excel file to your machine. Within the Planner web app, click the “…” at the top of the screen, then select “Export plan to Excel.” And you’re done. From conducting more detailed analysis to sharing your plan’s status, Export to Excel gives you a broad range of additional capabilities for keeping your plan on schedule and your plan’s stakeholders up to date.Įxporting your plan to Excel is just a couple clicks away-literally. For more robust plan options, you can now export your entire plan to Microsoft Excel. There’s also the Charts view, which gives you different visual representations of progress, especially now with charts filtering.īut there may be times when the simplicity of these tools-and simplicity is our goal with Planner-isn’t quite enough. In-app features like red highlights for late tasks and color-coded labels provide visual cues for quickly finding tasks that need attention. Planner comes with some pretty cool out-of-the-box tools for keeping your team on track. (Please note - this feature is only currently available in the Planner web app ( ) and not when using Planner via the SharePoint web part or within Teams)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |