Category Archives: Excel 365 English

How To Recover Unsaved Microsoft Office Files?

Let’s say that we have put a lot of effort typing in our Word Document or creating an Excel Workbook or even finalizing our PowerPoint Presentation. Suddenly they are gone! We haven’t even saved them. What happens next? How do we Recover them? Thankfully, it is not that hard to Recover our Word Documents, Excel Workbooks and PowerPoint Presentations in the recent versions of Microsoft Office. This is where the Recover Unsaved Files Feature appears in Microsoft Office and will be described in the post below.

Recover Unsaved Office Files

Read the rest of this entry

Advertisements

How To Change The Page Numbering Order In An Excel Spreadsheet?

Many times, and Excel Spreadsheet doesn’t fit on one page because it is too large. Cells are pushed to another page, and depending how we have organized our data, we sometimes need to change the order of the pages manually so it could be easier for the viewer. Sometimes additional Columns will be printed at the end of the Sheet, after all the Rows have been printed and many other issues also occur. If you want to change the order of our Pages in our Excel Spreadsheet just keep on reading.

How To Change The Page Order in Excel

Read the rest of this entry

How To View, Insert or Edit Page Breaks in Excel

Page Breaks are dividers that separate our Worksheet into different pages for printing. In Excel, automatic Page Breaks are inserted depending on the Paper Size, Margin Settings, Scale Options and the positions of the Manual Page Breaks that we have inserted. If we want to Print a Worksheet with the exact number of Pages that we want, we must adjust the Page Breaks in our Worksheet before we print it. To find out, how it is done, just keep on reading the post below.

Insert - Delete - Review Page Breaks in Excel

Read the rest of this entry

How To Copy or Move A Worksheet in Excel?

In Excel, we can Move or Copy a Worksheet in the same Workbook so we can organize the Workbook the way we want to, or we can even Move or Copy a Worksheet to other location, such as an existing open Workbook or to a New Workbook. All you need to do, so you can find out how, is to continue reading this post below.

How To Move Or Copy A Spreadsheet in Excel

Read the rest of this entry

How To Delete Cells, Rows, Columns and Spreadsheets in an Excel Workbook?

In a previous post of mine, I had mentioned How To Insert Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook. What happens though, when we come to a point that we want to Delete Cell, Cells, Row, Rows, Column, Columns and Sheet, Sheets in a Excel Workbook. All you need to do is to continue reading this post.

How To Delete Cells, Rows, Columns & Sheets in Excel

Read the rest of this entry

How To Insert Cells, Rows, Columns and Spreadsheets in an Excel Workbook?

We have all come to a point when we are working in an Excel Workbook, where we need to Insert a Cell or Cells, or we need to Insert a Row, Rows or Column, Columns or even to Insert an entire Worksheet. How is it done? The procedure is quite simple and very handy, so we don’t need to worry if we have forgotten to insert some data and there is not enough space for us. Just keep on reading the post below.

How To Insert Cells, Rows, Columns & Sheets in Excel

Read the rest of this entry

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

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

%d bloggers like this: