Latest Blog Posts - ExcelDemy

Excel VBA Offset Column (5 Suitable Cases)

Jun 1, 2023

Often we need to move the active cell to the next cell without explicitly specifying its row and column coordinates. The Offset function provides a ...

Excel VBA Offset Column (5 Suitable Cases)

How to Create a Database in Excel with Pictures (with Easy Steps)

May 29, 2023

In this article, I am going to show how to create a database in Excel with pictures. Even though MS Excel is not an ideal application to build a ...

How to Create a Database in Excel with Pictures (with Easy Steps)

How to Make a Roster in Excel (with Detailed Steps)

May 25, 2023 2

A roster usually indicates a schedule that divides the turn of duties (or even leave) in an organization for an individual or a group. From ...

How to Make a Roster in Excel (with Detailed Steps)

Excel VBA to Copy Without Clipboard (3 Easy Ways)

May 23, 2023

In this article, we will learn how to use Excel VBA to copy without a clipboard. Often, users need to copy data from one sheet to another or from one ...

Excel VBA to Copy Without Clipboard (3 Easy Ways)

Excel VBA to Show Message on Status Bar

May 23, 2023

Customizing the Excel Status Bar message using VBA allows users to personalize their experience and gain valuable insights during the execution of ...

[Fixed!] VBA Loop Without Do Error (3 Possible Reasons)

May 23, 2023

Loop without Do is a common error in Excel VBA Macro. Most of us often face this problem continuously. Predominantly this is a compile error and ...

[Fixed!] VBA Loop Without Do Error (3 Possible Reasons)

How to Format Slicer in Excel (7 Common Options)

May 25, 2023

Excel Slicer allows you to present your data visually appealing and easy to understand. Slicer is a powerful feature in Excel that only filters data ...

How to Format Slicer in Excel (7 Common Options)

Types of Sparklines in Excel

May 29, 2023

Excel's Sparklines feature is a helpful tool for identifying data trends. Sparklines are tiny charts that can fit into a single cell and give quick ...

How to Remove Sparklines in Excel (2 Quick Ways)

May 22, 2023

Sparklines are a powerful feature in Excel that allows you to display miniature charts within a single cell, making it easier to visualize trends and ...

How to Remove Sparklines in Excel (2 Quick Ways)

How to Create Timeline Slicer with Date Range in Excel

May 22, 2023

Nowadays using Excel is quite common in day-to-day life. Specially, we need to work on large datasets in corporate life. But there is a bit of a ...

How to Create Timeline Slicer with Date Range in Excel

How to Sum If Cell Contains Number in Excel (6 Examples)

May 22, 2023

Sometimes, we need to sum if a cell contains a number in Excel. We need to do this very often in data analysis and financial modeling. Sometimes the ...

How to Sum If Cell Contains Number in Excel (6 Examples)

[Fixed!] Excel Date Filter Is Not Grouping by Month (3 Solutions)

May 22, 2023

Filtering data according to particular criteria, like filtering dates by month, is one of the most popular Excel tasks. Excel's date filter ...

[Fixed!] Excel Date Filter Is Not Grouping by Month (3 Solutions)

Excel VBA DoEvents and Wait Properties

May 22, 2023

In this article, we are going to discuss Excel VBA DoEvents and Wait property. These two property allows users to interact with the Excel GUI while ...

Excel VBA Text to Columns (4 Easy Examples)

May 22, 2023

In this article, we are going to discuss the Excel VBA Text to Columns method (TextToColumns). The TextToColumns method works the same way as the ...

Excel VBA Text to Columns (4 Easy Examples)

[Fixed!] Excel EXACT Function Not Working (3 Suitable Solutions)

May 23, 2023

One of the many functions available in Excel is the EXACT function, which allows users to compare two text strings and determine if they are ...