Other new templates include Stock Analysis and My Calendar. Once you get the hang of it, just replace Excel’s sample data with some real data of your own and Excel does the rest. If you click the Go button, you can add some new data to the Sample Data spreadsheet, then watch the charts change based on your new input. Click the buttons 2013, 2014, or 2015 to see the chart data change by year. Click the Let’s Get Startedbutton, and Excel displays the My Cashflow charts. 08 New template Cashflow-click the Let’s Get Started button.įor example, in the My Cashflow template, Excel encourages you to try the Excel Data Model to manage your cash flow. New templatesĮxcel’s new templates come with sample data and charts, plus hands-on exercises that teach you how to use each template. Because the bars seem to hover between the start and end columns, it looks sort of like a waterfall, hence the name. Waterfall (aka ‘flying brick’ chart) provides a visual method for viewing a series of positive and negative data, such as monthly cash flows. Use this chart data to decide where to assign your resources. Pareto sorts the bars by highest first and shows which bars have the biggest impact or highest return. We’ll delve deeper into the new charts in an upcoming column, but here are two to whet your appetite: Or, if you’re not inclined to use one of the recommendations, click the All Charts tab, choose a category from the list, then select one of the designs from the pictured charts in that category. It’s still an easy process to create them, too: Just highlight the database table, select Insert > Recommended Charts, then choose one from the pictured samples. New chartsĮxcel has six new charts to show off to your clients and colleagues. Note that each icon is a button/link to a sub menu that provides more options (the selected icon turns dark green and bold). Note the lightning worksheet icon at the bottom right corner of the range: Click this icon, and a popup menu appears that displays a half-dozen options for what to do with this data. After you’ve completed your spreadsheet or table, select the entire range. Quick analysis tools are a real timesaver, nudging you in the right direction with your data. You’ll find options for Power Queries Data Models Reports Pivot Tables One-Click Forecasting and some new, one-button workbook sharing through Power BI for creating and using interactive reports and dashboards. The database enhancements alone-which include merging some of the previous Add-On programs such as Power Pivot and Power Query-more than justify the upgrade.
0 kommentar(er)
