Microsoft Excel

Rounding off decimals helps to improve the readability of your information. It is also simpler to work with numbers where the decimals have been rounded off. It is also very helpful when exact values are not required.

4 Methods to round off decimals in Microsoft Excel:

• The ROUND function
• The ROUNDUP function
• The ROUNDDOWN function
• The MROUND function

Let us begin by looking at each of these methods.

Read more

A CSV file is a very basic file that stores data in a simple format, separated by commas. That is why it is called CSV – comma-separated values.

In contrast, MS Excel saves data in spreadsheets with formatting and formulas. It is best to convert a CSV file into Excel to make use of the information.

2 Methods to convert a CSV file to Microsoft Excel:

• Save As option
• Data Import option

Let us begin.

Read more

Adding days to a date helps determine deadlines. It can simplify various tasks at hand. For example, completing a task 10 days after the previous task. It is also ‌helpful in stock management, to make sure you don’t sit with old stock. 

4 Methods to add days to a date in Microsoft Excel:

• Add the quantity directly (If the number of days to be added are the same)
• Use a separate column (When the number of days to be added differs)
• Use the Paste Special option
• Use the End of Month formula

Let us begin.

Read more

5 Methods of getting the number of months between two dates:

• Use the YEAR and MONTH function
• Use the MONTH function and subtract the dates
• Use the DATEDIF function
• Use the YEARFRAC and ROUNDUP function
• Use Microsoft VBA code

Let us begin by getting a closer look at these methods.

Read more

Adding months to dates could be very useful.

For example, you have the manufacturing date of multiple products with the number of months they are viable.

You can calculate the expiry date of the product by adding the number of months from the manufacturing date.

This can be done quickly, using MS Excel.

4 Methods to add months to a date using Microsoft Excel:

• Use the EDATE function
• Use the MONTH function
• Use Microsoft VBA code
• Use the Fill Series option

Let us begin by looking at each of these methods in detail.

---

Read more

For calculation and data analysis, you may need to add years to a date in MS Excel. For example, to calculate the date of expiration of goods, to analyze the sales of a company after a period of time or to determine your policy’s payout date.

To do this, MS Excel provides several formulas to make this task easy to execute.

3 Methods to add years to a date in Microsoft Excel:

• Use the YEAR & DATE function
• Use the EDATE function
• Use a generic formula

Let us begin.

---

Read more

If you have a list of people with their dates of birth, it is possible to calculate their age using a few tricks in MS Excel. While there are no specific functions to calculate age in MS Excel, these methods will work just as good.

4 Methods of calculating age from date of birth using Microsoft Excel:

• Use the DATEDIF function
• Use the YEARFRAC function
• Use Microsoft VBA code
• Use the logical formula

Let us begin by looking at how to use these methods to get the age from a person’s date of birth.

Read more

Unlike MS Word, an MS Excel printout seldom looks the same as it is on the screen in front of you. 

For one, you may have a large dataset, and need to know whether everything will fit onto one page, or not, and if so, where the print margins are.

Print Preview helps you understand the layout of your printout, by providing a visual presentation of how your printed copy will look like.

Using this feature, you can customize your printout as per your requirements. You may need to scale the data, shrink the width, or hide a particular row or column to get the desired results.

2 Methods to preview a worksheet before printing in Microsoft Excel:

• Use the Print Preview option
• Use the Page Break Preview option

Let us begin.

Read more

If you have a spreadsheet with a large number of rows, it might extend to the next page when you print it. You would’ve noticed that the header row or title gets printed only on the first page.

This is the default behavior in excel.

It is also possible to print the title row on every page while printing your worksheet. IN this tutorial will share the exact steps to achieve the same.

Easy Method for printing the title row on every page in Microsoft Excel:

Read more

Gridlines are not printed on a Microsoft Excel worksheet or workbook by default. But you might want to print them to improve the readability of the data. In this tutorial, we’ll show you how you can achieve this in a few easy steps.

2 Methods for printing gridlines in Microsoft Excel:

• Use the Page Layout menu
• Use the keyboard shortcut

Let us begin.

---

Read more