Excel Basics

How to Use COUNTIF Between Two Numbers (4 Methods)

The COUNTIF Function in Excel: Syntax ➤ Description Count cells within specific criteria. ➤ Generic Syntax COUNTIF(range,criteria) ➤ ...

How to Change Time Format in Excel (4 Ways)

Method 1 - Alter the Cell Format to Change Time Format in Excel Step 1: Select the cells in an Excel sheet where you wish to apply or alter the ...

How to Copy Formula to Entire Column in Excel (7 Ways)

Let’s say there's a dataset where different types of Fruits and their prices in January are given in Column B and Column C, respectively. You need to ...

How to Add Minutes to Time Quickly In Excel: 5 Easy Ways

Method 1 - Use Formula to Add Minutes to Time in Excel In the following dataset, column B contains the time, and column C contains the decimal value ...

How to Sum Time in Excel (9 Suitable Methods)

  Method 1 - Using Excel Formula to Sum Time in Excel We will use the following dataset which contains the working hours of staff for Thursday ...

How to Calculate Hours Between Two Times in Excel (6 Methods)

  Method 1 - Calculating Hours Between Two Times by Subtracting Them in Excel We’ve created the following data table to calculate the hours ...

How to Convert Date to Text YYYYMMDD (3 Quick Ways)

In Excel, the date and time are stored as numbers. This allows the user to perform calculations with these dates and times. However, you might want ...

How to Calculate Percentage of Total in Excel? (2 Methods)

Suppose you have a list of your daily or monthly transactions. You want to know in which transaction category you are spending the most. You can get ...

How to Switch Rows and Columns in Excel (5 Methods)

The dataset below shows the market share of smartphone companies. Method 1 – Using the Paste Special (Transpose) Steps: Select the ...

How to Perform If Zero Leave Blank Formula in Excel (3 Methods)

There are several ways to make zero values into blank cells. Here's a GIF overview of how you can do that. 3 Easy Ways to Perform If Zero ...

How to Generate Moving Average in Excel Chart: 4 Methods

Method 1 - Generating Moving Average in Excel Chart Select data. Click Insert tabs>Charts ribbon. Click Recommended Charts or any chart ...

How to Convert Date to Number in Excel (4 Methods)

Method 1 - Converting the Date to a Serial Number in Excel with the DATEVALUE Function  We will convert a date to a number in Excel. Here is an ...

How to Hide Columns in Excel (6 Easy Ways)

Method 1 - Using the Home Tab from the Ribbon Select the column(s) you want to hide. Navigate to the Home tab on the ribbon. Go to the ...

Different Types of Lookup to Apply in Excel (8 Types)

Here's an overview of the functions and formulas for different types of lookups in Excel. What Is a Lookup in Excel? A lookup means ...

How to Select Row in Excel If Cell Contains Specific Data (4 Ways)

Sometimes you may need to select an entire row based on any specific data in a cell of that row. In this article, we’ll show you 4 easy and simple ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo