Word 365 ProPlus English

How To Hide Cell or Cells in Plain Sight in Excel

Posted on

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.

How To Hide Cells in Plain Sight in Excel 365

Read the rest of this entry »

Advertisements

Logical Functions IF and new IfS Function in Microsoft Excel 365

Posted on

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?

IFS Formula in Excel 365

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.

Read the rest of this entry »

New Feature in Excel 365: Stock Quotes and Geographic Data

Posted on

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.

Stock Quotes & Geographic Data in Microsoft Excel 365

Read the rest of this entry »

New Ideas Function in Excel 365

Posted on

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

New Ideas Command in Excel 365

In the image below, I have opened a Spreadsheet that contains data, where it is possible to use the Ideas command. I have selected the area needed, which contains the data needed for the Ideas command.

Selected Cells

The Home tab of the ribbon must be activated where at the far right is located the Ideas area, where we select the Ideas command as shown below. The Idea command looks for patterns in our data that it can use to create intelligent and personalized suggestions.

Ideas Command

Once the Ideas command is selected, the Ideas task pane appears at the right of our Spreadsheet as shown in the image below. The Ideas task pane appears showing us the different Graphical representations that it has created according to the Data that we had selected.

Ideas Task Pane

We can scroll down in the Ideas task pane in order to view all the other Graphical representations that it has created.

Ideas Task Pane

Once we have located on the Graphical representations or Chart in other words that it has created for us, at the bottom left corner of each Chart is located the command Insert Chart. Once we select the command Insert Chart, the Chart will be inserted in our Spreadsheet immediately as shown in the image below.

Ideas - Inserted Chart

The Ideas command works much better with well organized data, that doesn’t contain any blank Rows or Columns. It also works better if the Data that we have in our Spreadsheet is formatted as an Excel Table. We should also make sure that we have good Headers for our Columns, where they should be in a single Row with non-blank labels for each Column. We should also avoid double Rows of Headers and Merged Cells.

Below you can check out the video describing the Ideas command in Microsoft Excel 365.

Don’t Forget To Subscribe To My YouTube Channel.

  YouTube Channel

Modifying the Printing Options in Word 365

Posted on

In Word, we can print all sorts of Drawing Objects. We can print Background Color or Background Image or even Hidden text. We can also print Document Properties or Summary Information of our Word Document. We can also set it, so before we print our Document, the Fields or Table of Contents to be updated automatically before printed. How is this done? Just keep on reading the post below.

Display Printing Options in Microsoft Word

Read the rest of this entry »

What is the Kerning Feature in Microsoft Word?

Posted on

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.

What Is Kerning in Microsoft Word 365

Read the rest of this entry »