Latest Blog Posts

Excel VBA Text to Columns for Fixed Width

In this article, we will demonstrate the use of Excel VBA to perform text to columns operations on fixed-width data types using the TextToColumns ...

How to Change Number Format in Excel

Change Number Format in Excel: Knowledge Hub How to Convert European Number Format to US in Excel How to Convert Percentage to Decimal in ...

Excel VBA Offset Column (5 Suitable Cases)

The Offset column property is very useful in copying cell entries from a column. In this article, we will discuss the use of the Offset function in ...

Dynamic List Excel (Complete Guideline)

Download Practice Workbook Dynamic List.xlsx Method 1 - Using FILTER and OFFSET Functions Based on Single Criteria: We will combine ...

Excel Add to a Cell Value (Complete Guideline)

In this article, we will explain how to add numbers, text, times, dates, and special characters to a cell value in Excel. We'll use the SUM, ...

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

Step 1 - Create a Header Row in a Worksheet Open a new Excel workbook. Create a new worksheet (you can name it Employee Database or something ...

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

Here's a roster template that we will be making throughout this article. You can follow along and make changes if you want a modified version, or ...

How to Calculate Running Total in Excel? (Complete Guide)

In the following overview image, we used the SUM function to calculate the running total of sales values, with the formulas showing how the function ...

How to Remove Text in Excel? (3 Suitable Methods)

We'll use the following simple dataset to showcase how you can remove text. Download the Practice Workbook Text Remove.xlsx ...

How to Get Excel Row Number? (8 Practical Examples)

Row numbers act as reference points for conducting calculations in Excel. They help users to identify and locate particular rows in a worksheet. Row ...

How to Make a List in Excel (All Things You Need to Know)

In the following overview image, we selected a range as the source in the Data Validation dialog to create a drop-down list. ⏷Ways of ...

How to Add, Change or Remove Header and Footer in Excel

In this Excel tutorial, you will learn how to: - Insert headers and footers - Use preset styles of headers and footers - Use custom styles for ...

How to Speed Up Excel? (18 Effective Tips)

In this Excel tutorial, we will review some of the best strategies to make Excel faster with lots of data by avoiding the use of volatile functions, ...

Excel VBA to Copy Without Clipboard (3 Easy Ways)

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 Show Message on Status Bar 

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo