Category Archives: Microsoft Office 365 ProPlus English
As we already know, we can use an Excel Chart or Excel Table Data that we created in a PowerPoint Slide. We just simply copy it from Excel and then use the Paste Options to paste into the PowerPoint Slide. This way, the Data is linked between the Excel Worksheet and the PowerPoint Slide. When we want to change or edit the Data or the Chart from the PowerPoint Slide we have several options available in order for us to use. All you need to do is to continue reading the post below.
Sometimes when we work in an Excel Spreadsheet, we want some data to be hidden for our own reasons. Sometimes we hide Columns, sometimes we hide Rows, sometimes we hide Sheets. What happens when we want to hide individual Cells in our Spreadsheet? In order to find out, just keep on reading the post below.
True or False, this is the question?
When it comes in Excel, it is certainly the question, and this is where the IF Statement and the brand new IFS Statement appears. What do they do?
The IF Function checks whether a condition is met, returns one value If True and another value If False. In other words, it is an instruction that checks any condition, and if that condition is to found to be TRUE then it returns a predefined value however, and if the condition is FALSE, it returns a different predefined value.
The IFS Function checks whether on or more conditions are met and returns a value that corresponds to the first TRUE condition. The IFS Function can take the place of multiple nested IF statements, and it is much easier to read with multiple conditions.
A new feature that is available now in Excel 365 is that we can get Stock And Geographical Data. All needed is to type what we want in a Cell and convert it to the Stocks Data Type or the Geography Data Type. The Stocks and Geography Data Types are considered linked Data Types because they have a connection to an online Data Source. This connection allows us to bring back to us interesting information that we can work with. All you need to do is to continue reading the post below.
Suddenly, we all have Ideas in what to do with our Data in an Excel Spreadsheet. We think hard, waste a lot of time and put in general, a lot of effort on how to represent visually our Data in our Spreadsheet perfectly. Well we don’t have to worry anymore, because Excel 365 has had the exact thought on how to help us understand our Data through high-level visual summaries, trends and patterns. All we need to do is to simply click on a cell in a data range, or select the whole data range, and with the use of the Ideas command, Excel will analyze our data and return interesting values about it. If you want to learn more just continue reading the post below
Kerning in Microsoft Word! I bet most of us doesn’t know what Kerning means or does! Well, Kerning is a feature in Microsoft Word, where it adjusts the space between two individual letters for a better visual look. Say that when we are designing a Document, each Typeface font requires its own specific Kerning. This feature is very important and necessary when we are designing in a Word Document with large Fonts. In order to use this feature just keep on reading this post below.