Category Archives: Excel 365 English

Turn On The Legacy Wizards In Microsoft Excel 365

Now in Excel 365, we have the Get & Transform area available, which has been described in an older post of mine. The Get & Transform area of the Data tab on the ribbon is superior in terms of Data Connectors and Transformational capabilities. However though, sometimes we just want to use one of the old wizards to import our data such as the Legacy Wizards.

10. Turn On The Legacy Wizards In Microsoft Excel 365

Read the rest of this entry

Modify The Data Options in Excel 365

Are you looking for options on how to Import Data and Analysis in Excel 365 and cannot find them anywhere? The reason is that they have moved them in the latest version of Excel. They have their own location in the Data section of the Excel Options dialog box. In order to find out How To Modify The Data Options in Excel 365, just keep on reading this post.

Data Options View In Microsoft Excel 365

Read the rest of this entry

Upload Export Workbook To Microsoft Power BI

I have mentioned and described in a previous post of mine about Microsoft Power BI. Well now, we have two new commands for us available to use so we can Export or Publish our Workbooks to Microsoft Power BI. Let’s just refresh our memory about Microsoft Power BI.

What is it? It is a data visualization and business analytics platform that is suitable for business. It is a collection of online services and features that enable us to find and visualize data, share discoveries, and collaborate in intuitive new ways.

What does it do? Monitors organizational data that is important.

We have tools, so we can quickly Analyze, Transform and Visualize data, and also
Share Reports.  Just keep on reading to find out about the new commands available, or follow the above link to find out what Microsoft Power BI actually does.

Upload - Export Workbook To Power BI

Read the rest of this entry

Display Options For Worksheet in Excel

As mentioned in the previous post of mine Display Options for Workbooks in Excel, the same thing might happen when we are working in a Worksheet. Elements might be missing, or the elements that we are not used to, might appear. Elements such as, Column and Row Headings, Formulas might appear in Cells instead of the calculated result, Page Breaks might appear and many more. What do we do? Everything is explained in the post described below.

Display Options for Worksheet

Read the rest of this entry

Display Options For Workbook in Excel

Sometimes it may occur to us, when we are working in an Excel Workbook for the Horizontal or Vertical Scroll bar not to be displayed. We may even cannot see the Sheet Tabs, or even nor the Objects that we know exist in our Workbook. What has happened? All will be explained in the post described below.

Display Options for Workbook

Read the rest of this entry

Insert A Funnel Chart In Excel 365

Insert Funnel Chart

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.

Read the rest of this entry

Create A Map Chart In Excel 365

Insert Maps in Excel 365

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 CountriesRegionsStatesCounties 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.

Read the rest of this entry

%d bloggers like this: