In our previous article, we have seen how to create a new notebook in OneNote? As we all know that Microsoft OneNote is a digital notebook which helps you to organize your notes, your information. It allows you to create multiple notebooks and multiple sections in each notebook. But what if you do not require any of the created notebook. You can delete notebook in OneNote. In this section, we … [Read more...]

## How to Create an Outlook Account?

Do you have an outlook account or you want to create one? The outlook is a web-based email service that was earlier known by the name Hotmail. Microsoft has acquired Hotmail in the year 1997 and in the year 2012, it has relaunched Hotmail with a new name Outlook. Outlook provides email, contact, task and calendar services to its users. Though the users with old Hotmail id haven’t changed their … [Read more...]

## How to Calculate Average in Excel?

Excel has provided some particular functions to calculate average. Like it has AVERAGE, AVERAGEA, AVERAGEIF functions which returns the average of the numbers fed to the functions in the argument. The average is the arithmetic mean of the considered numbers. In this section, we will discuss different methods to calculate the average. We will also discuss the different average functions provided … [Read more...]

## How to Subtract in Excel?

We all are aware of the basic arithmetic operations which are addition, subtraction, multiplication & division. We use subtraction to minus a number from another number. Subtract in excel allow us to minus numbers, cell values, numbers in columns, date, time and many more. In this section, we will study subtraction in excel with the different type of values as described below: Subtract … [Read more...]

## How to Calculate Age in Excel?

Excel doesn’t have any specific function to calculate age. However, we can still calculate age with the help of certain functions present in Excel. We can calculate the age of any person incorporating his birth date and the current date in certain excel functions. In this section, we will consider different methods or formulas to calculate age, we will also discuss their consequences. So, let … [Read more...]

## How to Group in Excel?

Earlier we have seen several methods to deal with a large scale of data. In addition to this, the Group in Excel can group data at different levels. Grouping also helps you to organize your data in a better way. It helps you to create a more compact version of your large scale data. In this section, we will discuss the method of grouping the data in columns or rows. We will also discuss the … [Read more...]

## How to SUMIF in Excel?

SUMIF is one of the useful function in excel. This function returns the total sum of the specified range when the specified criteria is met by the specified range. SUMIF function ease our work if we are in search of the sum, based on the criteria. The syntax of the SUMIF function is as follow: = SUMIF(range, criteria,[sum_range]) The range is the range of cells which has to be evaluated … [Read more...]

## How to Filter Data in Excel?

Dealing with the large scale of data sometimes, it becomes very challenging for us to focus on some specific set of data or the data you are interested in. Well, Excel provides us with the facility to Filter data to narrow down the large scale of data which eases us to study the data of our interest. In this section, we will discuss the method of adding the filter to the data. Further, we will … [Read more...]

## How Create a Pie Chart in Excel?

A pie chart is a circular chart which is a collection of multiple slices that joins together form a circular graph. In a pie chart, each slice represents an individual fragment of the whole pie chart and the complete pie chart represents 100% of the whole. Excel provides us with an easy way to create a pie chart. In this section, we will discuss the method of creating a pie chart, we will also … [Read more...]

## How to Highlight Duplicates in Excel?

We use Excel to save or accumulate information. Working with large Excel sheet, we may duplicate records or information and further, it becomes difficult for us to identify duplicates. Well, Excel provides a facility to highlight duplicates. Analyzing the highlighted duplicates, you can determine whether you have to keep that record or you have to delete it. In this section, we will discuss the … [Read more...]

- 1
- 2
- 3
- …
- 12
- Next Page »