(Click image to enlarge.) New features in Excel 2019Įxcel 2019 has a few new features you’ll want to check out, notably two new chart types. With 3D Maps you can plot geospatial data in an interactive 3D map. When you’ve downloaded the workbook, open it up, select Insert > 3D Map > Open 3D Maps and click the map to launch it. The screenshot shown here is from Microsoft’s Dallas Utilities Seasonal Electricity Consumption Simulation demo. If you don’t have data for mapping but just want to see firsthand what a 3D map is like, you can download sample data created by Microsoft. For details on how to work with your data and customize your map, head to the Microsoft tutorial “ Get started with 3D Maps.” Then click Enable from the box that appears. Once you have properly prepared data, open the spreadsheet and select Insert > 3D Map > Open 3D Maps. Those steps are beyond the scope of this article, but here’s advice from Microsoft about how to get and prepare data for 3D Maps. You’ll need to first have data suitable for mapping, and then prepare that data for 3D Maps. With it, you can plot geographic and other information on a 3D globe or map. Now it’s free, built into Excel 20, and has been renamed 3D Maps. For more about using these tools, see Microsoft’s “ Getting Started with Get & Transform in Excel.” 3D Mapsīefore Excel 2016, Power Map was a popular free 3D geospatial visualization add-in for Excel. You’ll find the Get & Transform tools together in a group on the Data tab in the Ribbon. Get & Transform lets you pull in and shape data from a wide variety of sources. You can also use data from public sources including Wikipedia. These include Excel workbooks, CSV files, SQL Server and other databases, Azure, Active Directory and many others. Now called Get & Transform, it’s a business intelligence tool that lets you pull in, combine and shape data from wide variety of local and cloud sources. Microsoft’s Power BI business intelligence software offers similar functionality. Formerly known as Power Query, it was made available as a free add-in to Excel 2013 and worked only with the PowerPivot features in Excel Professional Plus. This feature is not entirely new to Excel. (Click image to enlarge.) Get & Transform The Forecast Sheet feature can predict future results based on historical data. (Your original worksheet will be unchanged.) IDG Click the Create button, and a new worksheet will appear showing your historical and predicted data and the forecast chart. On the screen that appears, you can select various options such as whether to create a line or bar chart and what date the forecast should end. Put your cursor in one of the data cells, go to the Data tab on the Ribbon and select Forecast Sheet from the Forecast group toward the right. To use the feature, you must be working in a worksheet that has time-based historical data. If, for example, you have a worksheet showing past book sales by date, Forecast Sheet can predict future sales based on past ones. (Click image to enlarge.) Forecast SheetĪlso new is that you can generate forecasts built on historical data, using the Forecast Sheet function. The Quick Analysis feature gives you a variety of tools for analyzing your data instantly. For example, you can use the tool to highlight the cells with a value greater than a specific number, get the numerical average for the selected cells, or create a chart on the fly. Click it and you’ll get a variety of tools for performing instant analysis of your data. A small icon of a spreadsheet with a lightning bolt on it appears. Highlight the cells you want to analyze, then move your cursor to the lower right-hand corner of what you’ve highlighted. If you’re looking to analyze data in a spreadsheet, the new Quick Analysis tool will help. Spreadsheet pros will be pleased with four new features built into Excel 20 - Quick Analysis, Forecast Sheet, Get & Transform and 3D Maps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |