Latest Blog Posts

Excel VBA ComboBoxes – 4 Examples

How to Add a ComboBox in Excel This is the sample dataset. Steps: Go to the Developer tab >> Insert >> Combo Box (ActiveX ...

How to Perform Left Outer Join in Excel (2 Easy Methods)

This tutorial will demonstrate how to perform left outer join to merge data tables in Excel. We’ll use the sample dataset below, which contains ...

Excel VBA Projects for Practice: 7 Exercises

Problem Overview Seven exercises related to the Excel VBA projects are provided for practice. Each has a distinct dataset. The exercises are ...

How to Use EDATE Formula for Days: 3 Ideal Examples

Method 1 - Returning Date After Specific Months Using EDATE Formula We will show the basic use of the EDATE function. Our dataset includes the Date, ...

How to Find the Slope of a Regression Line in Excel (3 Easy Ways)

What Is the Slope of a Regression Line? A regression line generally shows the connection between some scatter data points from a dataset. The ...

How to Make Smooth Area Chart in Excel (With Easy Steps)

Excel is a very useful tool for plotting different kinds of charts. Excel offers various options to format the plotted charts to make it look more ...

How to Create an Analog Clock in Excel (with Easy Steps)

  Step 1: Setting up Hours, Minutes, and Seconds Click on cell C5 and enter the following formula: ...

How to Create Monthly Duty Roster Format in Excel

To create a monthly duty roster in Excel, first we'll create a roster template, then fill the roster for a specific month into this remplate as an ...

How to Make an Effort Estimation Sheet in Excel: 4 Easy Methods

Method 1 - Using Parametric Estimation Steps: Enter the following formula in cell G5. =C5/(D5*E5*F5) Drag the Fill Handle tool ...

How to Use Conditional Formatting with the IFERROR Function in Excel – 4 Examples

The dataset showcases Name, Salary, Week, and Per Week Salary. To determine per week salary by dividing Salary by Week: Use the following ...

How to Calculate Historical Volatility in Excel (with Easy Steps)

What Is Historical Volatility? In business aspects, the monetary value of different financial factors (i.e., stocks and currency) keeps fluctuating ...

How to Create an Approval Workflow in Excel (with Easy Steps)

Below is our dataset called “Running Project of DPR Construction”. Step 1: Open a Dataset from OneDrive Using Desktop App Go to your ...

How to Perform Drawing of Objects with VBA in Excel (2 Examples)

Example 1 - Drawing Simple Shapes with VBA Code We will design a rectangle, a cell-sized rectangle, and a cube. Steps: Open your worksheet. ...

How to Create an Attendance Roster in Excel (with Easy Steps)

In this article, I will show you how to create an attendance roster in Excel. As we know, Excel is a very handy tool for keeping track of employees’ ...

How to Create Weekly Duty Roster Format in Excel

Let's take a sample dataset that represents the roster format of a company. Step 1 - Insert Staff Details Insert 3 sub-headers ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo