Category Archives: Excel 365 English
Now, in Microsoft Excel we have a available a Visio Data Visualizer Add-in for us to create high quality Visio Flowcharts, Organizational Charts from the Data that we have in our Excel Spreadsheet. We just choose a diagram, modify the Data that is linked with the Chart and then Refresh the Add-in to see the changes take place. We don’t need a Visio license to use this Add-in, but if we want to edit, or print and among other things we will need a Subscription. To find out more about the Visio Data Visualizer Add-in just keep on reading the post below.
Many times, I believe, when we are selecting multiple Cells or Ranges of Cells in a Microsoft Excel Spreadsheet, we accidentally select on or more that we didn’t mean to do. What did we usually do? We started all over again, wishing that we would be more accurate and luckier this time. Well, we do not have to worry any more. We can Deselect any Cells within the Selected Range by simply pressing the Ctrl Key button on our keyboard. We just press the Ctrl Key, and click, or click and drag to deselect Cells or Ranges of Cells. Just on keep on reading the post below to find out, how it can be done.
There are many Functions available in Microsoft Excel. There are Functions, combination of Functions, more than what we can think of. Remember when we were looking for a Function to lookup and retrieve data within a Table, and we used to use the VLOOKUP function. VLOOKUP Function that I described in a previous post of mine and you can find here. Well now the successor of the VLOOKUP Function is the XLOOKUP Function. It is named like this because it can search bother vertically and horizontally. It allows us to search for an item in a Range or Table and return the matching result.
The XLOOKUP Function has Five Arguments, where the first three are required and the last two are optional. The first three necessary arguments are the following:
lookup_value: What we are looking for.
lookup_array: Where to find it.
return_array: What to return
There are many Functions available in Microsoft Excel. There are Functions, combination of Functions, more than what we can think of. When we are looking for a Function to lookup and retrieve data within a Table, this is where the VLOOKUP function appears. The V, stands for vertical, meaning that the Data in the Table must be arranged vertically, with Data in Rows. We use the VLOOKUP Functions when we are in need to find things in a Table or a Range by Row. We can use the VLOOKUP Function when we have a well- organized Table, with all the information arranged Vertically and a Column on the left, which we can use to match a Row. To find out more and to learn how to use the VLOOKUP Function in an Excel Spreadsheet, just keep on reading the post below.
Sometimes we know the result we want from a Formula and we need to find out the input value that produces the Formula result, then we must use the Goal Seek feature in Microsoft Excel. The Goal Seek feature calculates a value by performing What-If Analysis on a given set of Values. The Goal Seek feature lets us adjust a Value that is used in a Formula so we can achieve a specific Goal. It allows us to see how one Data item in a Formula impacts on another. It is a very useful feature, because we can adjust one Cell Entry to see the Result that we needed. To find out how to use the Goal Seek Feature in Microsoft Excel just keep on reading the post below.
Keep in mind, that for the Goal Seek feature, we need to have the following:
The Cell To Change In Order To Achieve The Target
In Microsoft Excel, we can set a Picture as a Sheet Background. This Sheet Background will be used only for display purposes and cannot be printed. Because a Sheet Background cannot be printed, therefore cannot be used as a Watermark. In a next post of mine I will describe how to insert a Watermark in an Excel Spreadsheet. For now, I will be describing How To Insert A Sheet Background in An Excel Spreadsheet. Just keep on reading the post below.