Latest Blog Posts

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 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 Format Slicer in Excel (7 Common Options)

In this article, we will explain how to format the Slicer in Excel, for example by editing the size, shape, color, font, and styles, as in the image ...

How to Create Timeline Slicer with Date Range in Excel: 4 Methods

Method 1 - Insert a Pivot Table Select the data range B4:E13 to build the pivot table Select Insert >> PivotTable from the Toolbox as ...

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

Here we can see that the price of the Google Pixel 6 is in text format. We have calculated the total price including the price of the Google Pixel 6. ...

The Excel Date Filter Is Not Grouping by Month – 3 Solutions

This is an overview. The dataset showcases product code, selling date, and sales amount.   Solution 1 - If Dates Are Not in ...

Excel VBA DoEvents and Wait Properties

Here's an overview that shows code that uses DoEvents and Wait properties. What Are VBA DoEvents and Application.Wait Properties? When a ...

Text to Columns in Excel VBA (4 Easy Examples)

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

Excel VBA Digital Clock on UserForm: A Comprehensive Guide

Using Excel VBA, we can create a Digital Clock on a UserForm. This can be used as a visual reference for the current time, and to track the duration ...

Excel VBA to Customize Ribbon: 5 Easy Steps

Method 1 - Save Excel File as Zip File Change the extension of the Excel file. We have a sample Excel file with the extension xlsm. We want to ...

Excel VBA to Split String by Delimiter: 9 Examples

Method 1 - Use Split Function to Split String by Delimiter Use the Split function to split strings using a delimiter. We have a string with Sales ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo