Word 365 ProPlus English

How To Save Your Presentation as an Outline in PowerPoint?

Posted on

Microsoft PowerPoint Blog Banner

An Outline View in PowerPoint displays our Presentation as an Outline that contains all the Titles and the Main Text of each Slide. When we work in Outline view it is quite handy if we make a lot of edits in the Presentation. For example, we can rearrange the Headings, the sequence of the Slides, the sequence of the Bulleting or even apply Formatting changes in our Slides. If someone is not quite comfortable working in Outline View in PowerPoint, we can always save our Presentation as an Outline and then do all the editing in Microsoft Word. The procedure of saving our Presentation as an Outline is quite easy and will be described below.

How To Save Your Presentation as an Outline in PowerPoint

Read the rest of this entry »

How To Export A Presentation Slide As Animated Gif in Microsoft PowerPoint?

Posted on

Microsoft PowerPoint Blog Banner

Imagine that we have created a PowerPoint Presentation with animations, with Slide Transitions, with media, text and many other elements, and we want to Export it as a GIF and not a Video. Well, now it can be done in PowerPoint. We can easily create looping GIFS in Microsoft PowerPoint. Just follow the steps below to find out how.

How To Export A Presentation Slide As Animated Gif in Microsoft PowerPoint

Read the rest of this entry »

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet?

Posted on

Microsoft Excel Blog Banner

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.

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet

In the image below I have selected the Data that begins from the Cell A1 until the Cell D100 (which cannot be seen in the screenshot). I selected the first Cell and then by simply dragging my mouse I reached at the end of what I wanted to select. The range of Cells is from A1 until D100.

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet

Now let’s say, that by accident I didn’t want some Cells to be selected. How can I deselect them and not by selecting them again from the beginning? As all the Cells are selected as shown below, I move my mouse over the first Cell that I want to be deselected and for my example is the Cell A2. I press the Ctrl button on my keyboard and then with my mouse I do a left click on the Cell A2. That is it. We follow the same procedure for the rest of the Cells that we want to be deselected, and all this just by holding the Ctrl button at the same time we do the left click on our mouse.

In the image below, while holding down the Ctrl key of my keyboard, I have deselected the Cells, B4, B11, B15, C10, C18, D5, D8 and D14. If we click with our mouse anywhere in the Spreadsheet without holding down the Ctrl key, all the Selections will be lost.

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet

Below you can check out the video describing How To Deselect A Selection in a Spreadsheet in Microsoft Excel?

Don’t Forget To Subscribe To My YouTube Channel.

YouTube Channel

How To Use The XLOOKUP Function in a Microsoft Excel Spreadsheet?

Posted on

Microsoft Excel Blog Banner

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

How To Use The XLOOKUP Function in a Microsoft Excel Spreadsheet

Read the rest of this entry »

How To Use The VLOOKUP Function in a Microsoft Excel Spreadsheet?

Posted on

Microsoft Excel Blog Banner

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.

How To Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

In the image below, I have entered Data into a Table. This Table contains information about TV Shows. I have the Rank number of the TV Show among with the Network that has created the TV Show and the percentage of Viewers watching the TV Shows. The Rank of each TV Show depends on the percentage of Viewers. Say, now that we want to find out the Title of the Show ranked in the 55th Rank in our Table. Below, with the help of the VLOOKUP Function the procedure is quite simple and will be described thoroughly.

Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

In the image below, I have selected the Formulas tab, and then from the Function Library area of the ribbon, I have selected the Lookup & Reference Category as shown. Once the Lookup & Reference category is selected the drop-down menu appears with all the available Functions, where I select for my example the Function VLOOKUP.

What does the VLOOKUP Function do? It Looks For A Value In The Leftmost Column Of A Table, And Then Returns A Value In The Same Row From A Column We Specify. By Default, The Table Must Be Sorted In An Ascending Order.

Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

Once the VLOOKUP Function is selected, the Function Arguments dialog box appears as shown in the image below:

The VLOOKUP Function is separated in the following arguments:

  • Lookup_value: Is the value to be found in the first column of the table, and can be a value, a reference, or a text string. In other words, What We Are Looking For.
  • Table_array: Is a table of text, numbers or logical values, in which data is retrieved. Table_array can be a reference to a range or a range name. In other words, Where To Find It.
  • Col_index_num: Is the column number in the table_array from which the matching value should be returned. The first column of values in the table is the column 1. In other words, What To Return.
  • Range_lookup: Is a logical value: to find the closest match in the first column (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE

Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

In the next image in the VLOOKUP Functions Argument dialog box, my arguments are the following:

  • Lookup_value: I am looking for the data in the Cell G1, in this case the number 55 in the Rank category.
  • Table_array: I am looking in the whole Table which is named TOP_100_SHOWS_OF_2018_2019__TOTAL_VIEWERS, for the data to be retrieved.
  • Col_index_num: I want the result to be drawn from Column 2, which in this case is the Title of the Show.
  • Range_lookup: TRUE To find the closest match.

Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

Once we have filled in all the Arguments, we just press the Ok button, located at the bottom right corner of the Function Arguments and see the results. In the image, according to our Arguments, the result is that the Title of the Show is Life in Pieces, which is in the 55th place of Viewers and it is drawn from Column 2. If we double click on the Function in the actual Cell, we can see the whole Function in the Formula Bar as shown in the image below.

Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

In the next image in the VLOOKUP Functions Argument dialog box, my arguments are the following:

  • Lookup_value: I am looking for the data in the Cell G4, in this case the number 10300 in the Viewers Category.
  • Table_array: I am looking in the whole Table which is named TOP_100_SHOWS_OF_2018_2019__TOTAL_VIEWERS, for the data to be retrieved.
  • Col_index_num: I want the result to be drawn from Column 3, which in this case is the Network of the Show.
  • Range_lookup: Ommited To find the closest match.

Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

Once we have filled in all the Arguments, we just press the Ok button, located at the bottom right corner of the Function Arguments and see the results. In the image, according to our Arguments, the result is that the Network of the Show is Fox, which the Viewers are 10300 and it is drawn from Column 3. If we double click on the Function in the actual Cell, we can see the whole Function in the Formula Bar as shown in the image below.

Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

Below you can check out the video describing How To Use The VLOOKUP Function in Microsoft Excel?

Don’t Forget To Subscribe To My YouTube Channel!!!

YouTube Channel

How To Create A Data Validation Rule in Microsoft Excel?

Posted on

Microsoft Excel Blog Banner

Data Validation is a feature in Microsoft Excel that is used to control what a user can or cannot enter in a Cell of the Spreadsheet. It means that we can check the accuracy and quality of the Source Data before using it, importing it or otherwise processing the Data. We can use different types of Validation depending on what we want to accomplish. In this post, I have created something simple enough for everyone to understand what Data Validation is about.

How To Create A Data Validation Rule in Microsoft Excel

Read the rest of this entry »