Category Archives: Excel 365 English
There is an area in Excel 365 named Get & Transform, where we can search for data sources, make connections and then modify the data. In the area Get & Transform, we now have the power to create New Queries from multiple data sources that are now available.
As Microsoft says: We Connect, We Transform, We Combine and then Share.
In this post I will show all the available Data Sources in Excel, that are sitting in the Cloud, in a Service or stored Locally in order to create a New Query.
A new chart has arrived in Microsoft Excel 365 which is the Funnel Chart. What does the Funnel Chart represents? It shows values across multiple stages in a process. We use this Chart Type to show progressively smaller stages in a process. We can also use this Chart Type when Data Values show progressively decreasing proportions. We can use a Funnel Chart to show the number of sales at each stage in a sales pipeline. Usually the values decrease slowly, allowing the bars to look like a Funnel. In order to create a Funnel Chart in Microsoft Excel 365, all you have to do is to continue reading.
Now in Excel 365 we can use a Map Chart to compare values and show categories across Geographical Regions. We use a Map Chart when we have Geographical Regions in our spreadsheet such as Countries – Regions – States – Counties or Postal Codes. To find out how to create a Map Chart in Excel 365 just keep reading.
We should have one column for our geographic location (country/region, state or province, county or postal code), then our numeric or categorical values in the second column. We might also need to add another level of geographic detail.
Imagine that we have created an Excel Workbook which contains Formulas which we need to distribute to others. The only problem is that we don’t want to reveal the Formulas that our Workbook contains. In the post described below, you can learn how to copy a Worksheet to a different Workbook with only the Results to be shown and not the actual Formulas.
In the image below we can see our Worksheet with all the necessary information, and we also notice that it contains Formulas. At the Formula Bar we can see the actual Formula.