Category Archives: Excel 365 English

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

Create a Copy of an Excel Worksheet Without Formulas

Formula

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.

Formula

Read the rest of this entry

How To Show Formulas Instead Of Values in Excel

Show Formula

In Excel 2016 and in previous version of Excel, we have the option to display the Formulas in the Cells instead of the Calculated Results. This comes handy, if we are working in a Worksheet with a lot of Formulas in it and we want to understand how all these Formulas relate to each other. This way we can track the data that is used in each calculation so we can quickly check our Formulas for errors. The procedure to quickly display Formulas in Cells is described in this post.

As we can see in the following image the Cell F7 is activated. In this Cell, we see the Calculated Result instead of the Formula. The Formula can be seen in the Formula Bar, where in this example the Formula is =sum(B7:E7).

Calculated Results

Read the rest of this entry

Browser View Options In Excel 2016

In Excel 2016, we have the option to specify how we want a Workbook to be displayed in a browser window. This way we can choose what we want to be viewed in our Workbook, when other people view it in a browser window. This is where the Browser View Options command appears in Excel. All you need to do is to follow the steps below:

First of all, we must select the File tab in order to move to backstage view. Once in backstage view, we make sure the Info category is selected from the left and then from the middle of the drop down menu we navigate and locate the area named Browser View Options as shown in the image below. Here we are notified that we can Pick What Users Can See When This Workbook Is Viewed On The Web.

Browser View Options

Read the rest of this entry

How To Protect An Excel 2016 Workbook

We can easily protect a sensitive or a confidential Workbook, either by assigning a password, either restricting access to it avoiding unwanted editing. We can also protect a document from being opened. As mentioned in a previous post of mine Protect A Word 2016 Document, the same procedure stands here, with the difference that some commands might be not available or some more will be available. All we have to do is to follow the steps below.

Fist we must select the File tab in order to move to backstage view as shown in the image below. Once in backstage view we make sure that the Info category from the left is selected. Then from the middle of the drop down menu we notice three different categories which are the following:

  • Protect Document: Control What Types Of Change People Can Make To This Workbook.
  • Inspect Document: Before Publishing This File Be Aware Of Its Contents: Author’s Name and Absolute Path
  • Manage Document: Check Out Document Or Recover Unsaved Changes.
  • Browser View Options: We Can Pick What Viewers Can See When This Workbook Is Viewed On The Web

Backstage View - Info

Read the rest of this entry

Calculate Sheet In Excel 2016

When we work in a Worksheet, Excel automatically recalculates all the formulas when we change the values in the Workbook. However, we have the option to recalculate whatever we want, whenever we want. All you have to do is to continue reading.

First, we must select the Formulas tab and from the end right corner of the ribbon named Calculation we notice the commands available to choose from which are as shown in the image below:

  • Calculation Options
  • Calculate Now
  • Calculate Sheet

Calculation Options

Read the rest of this entry

Insert 3D Maps in Excel 2016

3D Maps in Excel 2016

As mentioned in my previous post Power Map in Excel 13, the 3-D geospatial visualization add-in is fully integrated into Excel 2016. The new name of this feature is 3D Maps, and is available on the Insert tab and under the area named Tours.

Read the rest of this entry

%d bloggers like this: