Latest Blog Posts

Mixed Cell Reference in Excel (4 Examples)

In this article, we will let you know what mixed cell reference is in Excel and describe it with 4 examples. What is Mixed Cell Reference in ...

How to Use VBA to Remove Duplicates in Excel – 6 Examples

VBA Syntax to Remove Duplicates in Excel Generic Syntax Range.RemoveDuplicates(Columns, Header) Parameter Description ...

Using an Excel Shortcut to Merge Cells – 3 Methods

Download Practice Workbook Download the practice workbook. Merge Cells Shortcuts.xlsm The title of the dataset below doesn't fit in B2. ...

How to Use DCOUNT Function in Excel (5 Suitable Examples)

The DCOUNT function is a built-in function in Excel that is categorized as a Database Function. The DCOUNT function of Microsoft Excel is one of the ...

Cell Reference in Excel VBA (8 Examples)

We'll use a data set with the Book Name, Book Types, and Price of some books of a bookshop called Martin Bookstore. The data set lies in the range ...

How to Calculate Exponential Moving Average in Excel

Exponential Moving Average is widely used for forecasting future data and smoothening stock price movement. If you want to know what an exponential ...

How to Apply AutoFill Shortcut in Excel (7 Methods)

This tutorial will help you to use Autofill shortcut in Excel of various types to conveniently autofill or populate the cells in Excel without any ...

How to Use the Excel Cell Format Formula (4 Methods)

What is Cell Formatting in Excel? Cell formatting involves adjusting or changing the appearance of a cell without altering its original value. In ...

SUM Not Working with Time Values in Excel: 5 Methods

Method 1 - Get the SUM of Time Value Inserting Individual Cells Step 1: Go to Cell E5. Find the sum of the Cells C5 and D5 using the ...

How to Delete Rows Using Excel Shortcuts

While working with Microsoft Excel, you will face a lot of situations where you need to delete rows. Some people love to work with the mouse and the ...

How to Use the Format Painter Shortcut in Excel

What is Format Painter? In Microsoft Excel, the Format Painter is a powerful tool that allows you to copy the formatting from one cell or range of ...

How to Hide Duplicates in Excel (4 Methods)

Dataset Overview To explain this process clearly, let’s use a sample dataset from an online fruit store. The dataset contains 5 columns representing ...

How to Delete Hidden Rows in Excel: 3 Methods

Method 1 - Utilizing the ‘Inspect Document’ Option to Delete Hidden Rows in Excel Hide the highlighted rows, select the rows. Right-click on ...

How to Use Year Function in Excel VBA (5 Suitable Examples)

The Year function in Excel VBA is under the Date and Time category functions. If we use it in a VBA code, it extracts the year from the date which we ...

How to Use VBA MONTH Function in Excel (7 Suitable Examples)

The MONTH function falls under the Date or Time category. The MONTH function works both in worksheet and VBA Macros. It takes only one argument. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo