There can be two reasons to compare two columns in excel either we have to find the matches or to find the differences. Matches are the data points that are present in both the compared columns. Differences are the data points that are in one column but not present in other column being compared. There are several ways to compare two columns in an excel sheet. In this section, we will discuss … [Read more...]
How to COUNTIF in MS Excel 2016?
Have you ever operated the function COUNTIF in Excel? COUNTIF is a statistical function which counts all the cells that match the criteria we describe in the function. This function always returns you a count number that has met the criteria specified in the function. Let us discuss the syntax of the COUNTIF function: COUNTIF(range, criteria) range: Here, the range denotes the range of … [Read more...]
How to Count Unique Values in Excel 2016?
It becomes messy to sort out the unique values in a large range of cells if it contains duplicate values. Let’s say if you want to identify or count unique values in excel, then you can build up your own formula for it. There are various functions available in Excel using a combination of which you can implement the formula to count the unique values in Excel. In this section we will discuss … [Read more...]
How to Change the Date Format in Excel?
Excel provides various formats to display a date. It even allows you to change date format in a way you are comfortable with. Excel has defined the code for displaying the days, months and years using a combination of which you can format or customize your dates as you wish. In this section we will see how the dates are stored in excel, how can you change its format? How you can customize the … [Read more...]
How to Calculate Percentage in MS Excel 2016?
We know various methods to calculate the percentage. Even the excel provides us with several ways to calculate the percentage. Percentage is a value that is a proportion, in relation to the whole data. We can calculate the percentage for certain marks in examination, or calculating % discount for various prices, the percentage change between two numbers and so on. For calculating percentage … [Read more...]
How to Enable Macros in Excel 2016?
When you open an excel file that have macro or macros, a warning appears to enable macros in excel file. The macros are used to automate the tasks that the user needs to perform repeatedly. The macros are created by recording a sequence of commands over a cell in a file. The macro once created, can be run over any cell/cells when you have to perform the desired task. Most of the macros are … [Read more...]
How to Add or Sum in MS Excel 2016?
Adding is a basic mathematical operation, and is often used during the mathematical calculations. You have a variety of method to add or sum in Excel. One of the popular method to add in excel is AutoSum. It generates the sum of two or more cells in a sheet quickly. In this section, we will discuss the other options which can also be used to add the cells in excel 2016. We will discuss how we … [Read more...]
How to Embed a YouTube Video in MS PowerPoint 2016?
Have you ever embed a YouTube video in MS PowerPoint. Adding videos to the PowerPoint presentation engages your audience and grab their attention towards the presentation until the end. As it is human nature, we learn things more precisely if we have watched them instead of hearing. So, seeing related videos during presentation gives us a more detailed explanation regarding the topic. Instead … [Read more...]
How to Convert Text to Number in MS Excel 2016?
In this section, we will see how you can convert text to number in Excel. Excel allows you to choose the format for your cells such as you can keep the format of your cell as Date, Time, % Percentage, Fraction, Text, Number etc. If your cell is in Text format it generates an unexpected result for mathematical formulas. Like, look at the picture below, in a cell, I have written a formula =12+4 … [Read more...]
How to Insert a YouTube Video in MS PowerPoint 2016?
Do you know the method to insert a YouTube video in MS PowerPoint? While creating a PowerPoint presentation, sometimes we insert a video clip for making the presentation more explanatory. Adding video also grabs the attention of our audience. As the videos have moving pictures and everything can be seen in a sequence, it holds the attention of the audience for a long time. If you have a lack of … [Read more...]
- « Previous Page
- Next Page »