Excel Basics

How to Insert the Current Date in Excel – 4 Examples

This is an overview. The date format- MM/DD/YYYY was used. Example 1 - Insert the Current Static Date Using a Keyboard Shortcut in ...

How to Use Excel Date Shortcut

This article illustrates how using Excel date shortcut makes dealing with dates in Excel easier. While making reports, budgets, calendars, and ...

How to Calculate Hours and Minutes for Payroll Excel (7 Easy Ways)

Why Formatting Is Important For Measuring Time in Excel? Excel stores Date and Time as numbers. An integer represents a complete day with a starting ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo