file Archives | Page 36 of 45

Change Date Format in Excel

There are many different date formats you can use to display a particular date. You can use short or long formats. Excel can…

Normally, when you use VLOOKUP, you are going to check a single condition. VLOOKUP can’t use more than one condition until you modify…

Pivot tables are useful to summarize data and quickly change the structure of the table. In this lesson, I’ll show you how you…

Calculating the number of days between two days is easy and pretty straightforward. You have to subtract an older date from the newer…

Filters in Excel are used to reduce the amount of data displayed inside a worksheet. Depending on whether you filter text, numbers, or…

When you work with Excel, you probably have to deal with data separated into multiple rows. For example name, city, age, etc. But…

You can use the MATCH function to get the column number and the INDEX function to get the column name. Get column index…

In Excel, if you create a table, dates or times will be displayed on the X-axis. But there are situations where the data…

In Power Query, you can merge multiple columns into a single one. This is what we are going to do in this lesson….

Excel contains over one million rows – 1,048,576 to be exact. If your file is larger than that and you will try to…