Category Archives: Excel 365 English

How To Hide Cell or Cells in Plain Sight in Excel

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

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

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

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

Read the rest of this entry

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

%d bloggers like this: