Connect with us

MS Excel

How to Calculate Date Difference in Microsoft Excel

Published

on

How to Calculate Date Difference in Microsoft Excel

You can also calculate the difference in dates in Microsoft Excel with the help of formulas. The method is no less easy.

Although there is some code that you have to add, it’s still relatively easy, really. And this is usually needed for certain needs.

What is the full tutorial-like? Come on, continue to follow until the end Guys!

HOW TO CALCULATE DATE DIFFERENCE IN EXCEL

The formula to find out the difference is DATEDIF and you can write it down immediately.

But, specifically for writing the DATEDIF formula, you have to add certain code which we will discuss later.

The correct writing is DATEDIF(StartDate;EndDate;UnitCode) and as an example like this.

Well, in that example there are several different codes added and the results are also different. Although the start and end dates of all numbers are the same.

Then what is the code? The code indicates the unit according to the formula.

DATEDIF code

The following is a table list of DATEDIF codes that you will need when using the DATEDIF formula. There are several codes with different functions.

By adding the code, it means that all the differences related to the date can be calculated very easily and quickly.

Even though the formula is correct, but the code is wrong, the results will not appear.

Don’t forget to always prioritize the = sign in all Excel formulas. In the picture of writing the formula above is only an example to facilitate learning.

MS Excel

How to Create Automatic Serial Numbers in Excel

Published

on

How to Create Automatic Serial Numbers in Excel

There are several ways to create automatic serial numbers in Microsoft Excel that you can use to help with any given job.

Starting from the manual method, there are various ways, really.

And for you beginners who may just be getting to know Microsoft Excel, we will explain how to do it.

Go ahead, here’s the complete tutorial.

HOW TO CREATE SEQUENTIAL NUMBERS IN EXCEL

Creating a serial number is very easy, and you don’t need to do it manually.

How to Create Automatic Serial Numbers in Excel

For the automatic method, you can write only two numbers, then select both, and a dot will appear on the bottom right side.

Press and hold the dot then drag downwards.

By doing this, you no longer need to use the very old manual method.

Using Excel Fills

In addition to this method, you can use another method, namely Excel Fill.

First, write only one number, then select it and go to the Home menu – Fill – Series as below.

How to Create Automatic Serial Numbers in Excel

A new menu will appear, and fill in as needed. Because you want to make the number downward, we choose Columns, Linear, and in the stop value fill in the last number you want.

How to Create Automatic Serial Numbers in Excel

Well, that’s easy, isn’t it? You can use all methods according to your needs.

That’s all and good luck!

Continue Reading

MS Excel

How To Find & Replace Feature in Microsoft Excel

Published

on

How To Find & Replace Feature in Microsoft-Excel

Excel has a feature called Find & Replace, this feature will help you when searching for data according to its name.

So you no longer need to search manually one by one. Because this feature will find words or data according to what you input.

But it’s not only limited to searching for data or words, but you can also use it to replace data.

How to? Here’s the full tutorial.

EXCEL’S FIND & REPLACE FEATURE

To use the Find feature, you can click the Home menu – Find & Select Find like this,

How To Find & Replace Feature in Microsoft-Excel

A pop-up menu will appear and you can simply type the word or data you want to search for and then press Find Next.

How To Find & Replace Feature in Microsoft-Excel

Excel will automatically display the data quickly.

Or, if you want an even faster way, you can use the Ctrl+F shortcut to open the menu.

Change Words or Data Quickly

In addition to searching, you can also use this feature to replace data or words very quickly.

The trick is to press Ctrl + F and the same menu will appear as before. But here select Replace like this.

How To Find & Replace Feature in Microsoft-Excel

On the menu, when the word you want to change is in the Find what and Replace with a column for replacement words or data.

Then Replace All to replace all these words or you can select Replace to replace only one data.

How, after knowing this, the use of Microsoft Excel becomes easier, dong.

Of course, this feature makes it very easy for you to process your data, especially if you experience a lot of data input errors.

Continue Reading

MS Excel

How to Set Column and Row Size in Microsoft Excel

Published

on

How to Set Column and Row Size in Microsoft Excel

The easiest way to adjust the size of columns and rows in Microsoft Excel is this way. Guys, curious, right?

Before We tell you how usually you will need to set the column and row sizes when you are inputting data but the number of characters exceeds the thickness or height of the cell.

In other words, the data you input only appears partially.

Then how to solve it? Here’s the full tutorial.

HOW TO SET COLUMN AND ROW WIDTH

This is very easy for you to do, even those who are just learning will immediately be able to. You can directly use the mouse to expand or adjust the size.

The trick is to press, hold and drag the mouse on the boundary of each column or row like this.

How to Set Column and Row Size in Microsoft Excel

Easy, right? The same goes for when you want to resize rows, yes. The difference is, you need to hover your mouse over the row of lifts on the left.

Column Width Features

In addition to this method, there is one other method that requires several steps.

First, select all or the area you want then go to the Home menu – Format – Column Width like this.

How to Set Column and Row Size in Microsoft Excel

After the pop-up menu appears again, you just enter the desired value, then the column will automatically have the same size.

This second method is perfect for those of you who want to set the same column and row sizes in Excel without any difference.

But if you want a fast one, you can use the first method, both are the same depending on your needs.

Continue Reading
Advertisement

Latest

How To Use Dummy Text Lorem Ipsum in Microsoft Word How To Use Dummy Text Lorem Ipsum in Microsoft Word
MS Word13 hours ago

How To Use Dummy Text Lorem Ipsum in Microsoft Word

SHARE How To Use Dummy Text Lorem Ipsum in Microsoft Word How to quickly make Dummy Text Lorem Ipsum in...

How to Quickly Enlarge and Reduce Fonts in Word How to Quickly Enlarge and Reduce Fonts in Word
MS Word13 hours ago

How to Quickly Enlarge and Reduce Fonts in Word

SHARE You can increase and decrease fonts in Microsoft Word very quickly, you don’t even need to change your font...

How to Create Automatic Serial Numbers in Excel How to Create Automatic Serial Numbers in Excel
MS Excel13 hours ago

How to Create Automatic Serial Numbers in Excel

SHARE There are several ways to create automatic serial numbers in Microsoft Excel that you can use to help with...

How To Find & Replace Feature in Microsoft-Excel How To Find & Replace Feature in Microsoft-Excel
MS Excel13 hours ago

How To Find & Replace Feature in Microsoft Excel

SHARE Excel has a feature called Find & Replace, this feature will help you when searching for data according to...

How to Set Column and Row Size in Microsoft Excel How to Set Column and Row Size in Microsoft Excel
MS Excel13 hours ago

How to Set Column and Row Size in Microsoft Excel

SHARE The easiest way to adjust the size of columns and rows in Microsoft Excel is this way. Guys, curious,...

How to Delete Columns and Rows in Microsoft Excel How to Delete Columns and Rows in Microsoft Excel
MS Excel14 hours ago

How to Delete Columns and Rows in Microsoft Excel

SHARE You can delete Excel columns and rows to tidy up the data or worksheets that you are managing. By...

How to Copy Writing Format in Microsoft Word How to Copy Writing Format in Microsoft Word
MS Word2 days ago

How to Copy Writing Format in Microsoft Word

SHARE This time, how to copy the writing format in Microsoft Word into tutorial material that you will enjoy on...

How to Show Calculator Features in Microsoft Word How to Show Calculator Features in Microsoft Word
MS Word2 days ago

How to Show Calculator Features in Microsoft Word

SHARE How to display the calculator feature in Microsoft Word is really easy for you to try! For those of...

How to Add Columns and Rows in Excel How to Add Columns and Rows in Excel
MS Excel2 days ago

How to Add Columns and Rows in Excel

SHARE How to add columns and rows in Excel is an important and mandatory thing for you to know, especially...

How to Create a Table in Microsoft Excel How to Create a Table in Microsoft Excel
MS Excel2 days ago

How to Create a Table in Microsoft Excel

SHARE How to create a table in Excel is very easy because basically, Microsoft Excel consists of a table and...

Advertisement

Categories

Trending

Copy link
Powered by Social Snap