Latest Blog Posts

How to Change Date Format in Excel Using Formula

To change date format using a formula in Excel: Select a cell. Insert the formula: =TEXT(Reference Cell,"Date Format") Press Enter. For ...

Excel VBA: Filter Date before Today (With Quick Steps)

In Microsoft Excel, working with dates is a pretty common thing. And filtering those dates is also a day-to-day task for a lot of Excel users. Now, ...

Excel VBA: Count Rows in Named Range (4 Methods)

We can count rows in a named range by using workbook functions or conditional formatting but if we work with a large amount of data then using VBA ...

[Fixed!] Arrow Keys Not Moving Between Cells in Excel (2 Ways)

A typical problem with arrow keys is that they move the spreadsheet but not the pointer. In this tutorial, we will illustrate how to fix arrow keys ...

How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel

Method 1 - Change the Default Date & Time Format to dd/mm/yyyy hh:mm:ss in Excel When we add a date in a cell of an Excel worksheet, it stores ...

How to Use Named Range for Data Validation List with VBA in Excel

If you are looking for the easiest ways to use named range for data validation list in Excel VBA, then you will find this article useful. Named ...

How to Get First Day of Month from Month Name in Excel (3 Ways)

During our work with Excel, sometimes we need to know the first day of the given month or date. But there is no direct function or formula in Excel ...

How to Get Last Day of Previous Month in Excel (3 Methods)

  The sample dataset contains a list of dates in column B. We'll find the last day of the previous month in column C. Method 1 - ...

How to Convert 7 Digit Julian Date to Calendar Date in Excel (3 Ways)

The date format which uses the combination of a year and the number of days since the start of that year is known as Julian Date format. In the 7 ...

How to Remove Blank Cells from a Range in Excel (9 Methods)

We have a data range (B4:E12) that contains sales data for several electronic products (Date-wise). You can delete blank cells manually by selecting ...

How to Stop Excel from Auto Formatting Dates in CSV: 3 Methods

Method 1 - Save the CSV File as Text Document to Stop Excel from Auto Formatting Dates STEPS: Open the CSV file. Click on the File tab. A ...

How to Use Excel VBA to Create Data a Validation List from Array

  The salespersons' dataset has their working region and selling products. We will create a data validation list for the Region and Product ...

How to Use a Data Validation List from Another Sheet (6 Methods)

The below dataset has two columns: The Product purchased by a customer will be inserted using the Data Validation drop-down list from another sheet. ...

How to Use Data Validation in Excel with Color (4 Ways)

We have a dataset containing five columns: Serial Number, Candidate Name, Acquired Number, DoB, and Candidate’s Code. We will use different Columns ...

How to Find Column Index Number in Excel (2 Methods)

In this tutorial, we will explain some ways to find the Column Index Number in Excel. We'll use the following dataset containing the Painting ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo