Create a new Workbook in Excel

A workbook in Excel is a group of worksheets that are used to organize, calculate & analyze various kind of related information. Open an Existing Workbook To open a workbook that you previously have been saved, follow these steps: 1– Go to the file tab, click open. 2– In the Recent section, your recent file will […]

Basics of Microsoft Excel [For beginners]

This section is for beginners with no knowledge of Excel. A workbook is a group of worksheets that are used to organize, calculate & analyze various kind of related information. Status Bar provides a quicker way to see the average, count, numerical count, minimum, maximum or sum of selected cells. Percentage Formula is used to get the relationship between two […]

Round a number

To round a number with a specified number of digits, use the ROUND function. For example, we can round the 2.123456 number to 2.12 by using the ROUND function with two digits. Example Formula: Result: Copy and paste the formula into other cells after changing num_digits. How the formula work The formula used in our example […]

Merge and unmerge cells in Excel

When two or more adjacent cells are merged, one greater cell is displayed across multiple column and rows. To merge adjacent cells do the following steps: 1– Select more than one adjacent cell e.g. cell A1 and B1 below. 2– Go to the Home tab, select Merge & Center from the Alignment window. Both cells A1 […]

Days in month

By using both the Day function and the EOMONTH function, we can find the number of days in a given month e.g. to find how many days are in the month of Oct. Example Formula: Result: How the formula works The formula used above is: =DAY(EOMONTH(A4,0)) where the DAY function is used to find days […]

How to get nth largest value in Excel

Use the LARGE function to get the nth largest value from a set of values e.g. 2nd largest, 3rd largest, and, so on. In our example, we will largest and second largest values. How the formula works The formula used to find the largest value in the example is: =LARGE(A5:D5,1)  where, array (A5:D5) – The range […]

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved