Latest Blog Posts

How to Make a Clock Chart in Excel (with Easy Steps)

What Is a Clock Chart? There is no direct way to make a clock chart in Excel. However, you can make one using the bubble chart from the charts group ...

How to Create Test Cases for an E-Commerce Website in Excel (2 Scenarios)

Step-by-Step Process Step 1 - Set Up the Test Case Format In this step, we’ll create a structured format for test cases related to an e-commerce ...

How to Disable Alerts in Excel VBA: 3 Methods

Method 1 - Open Visual Basic Editor Go to the Developer tab >> click the Visual Basic button. This opens the Visual Basic Editor in ...

How to Overline Text in Excel (4 Method)

Method 1 - Using the Accent Option Click the Insert tab. Click on Symbols followed by Equation. Choose Accent and select Bar. ...

How to Create an Excel Data Connection to Another Excel File – 3 Methods

This is the sample dataset. Method 1 - Using the Connections Function to Create an Excel Data Connection to Another Excel File   ...

How to Calculate Coefficient of Skewness in Excel: 3 Methods

Method 1 - Calculate Pearson’s Skewness in Excel by Using Descriptive Statistics 1.1 Use AVERAGE, MODE.SNGL, STDEV.P Functions Steps: Select ...

Create an Excel Data Entry Form That Includes Checkboxes

In this article, we will demonstrate how to create an Excel data entry form that includes checkboxes, such as a To-Do list or checklist. We'll also ...

How to Create a Burndown Chart in Excel – 6 Steps

  Step 1 - Preparing Dataset to Create a Burndown Chart in Excel The sample dataset contains 2 tables. The first table showcases: ...

How to Do a Multi-Product Break-Even Analysis in Excel (Step-by-Step Guide)

  The following dataset contains information on per-unit sales, per-unit variable expenses, and the expected sale ratio of 3 products, along ...

How to Create a Project Roadmap in Excel (4 Methods)

Method 1 - Using Shapes In the following sheet, we will create a Roadmap for ExcelDemy using different shapes in Excel. Step 1 - Insert Shapes ...

How to Create a Calculator Using Macros in Excel (with Easy Steps)

Step 1 - Record Macro Steps: Create a basic outline as shown in the following image. We constructed two Input cells in cells C4 and C5. You ...

How to Export Test Cases from ALM to Excel: with 8 Exercises

Steps to Export Test Cases from ALM to Excel Select Test Grid from the View Select a single test case and right click. Select Export All ...

How to Create Graph of Skewness and Kurtosis in Excel

Introduction to Skewness and Kurtosis Skewness Skewness is a measure of the level of asymmetry in the distribution of a dataset. When a dataset ...

How to Make a Running Clock in Excel (2 Easy Ways)

The screenshot below represents a digital running clock in Excel. In the following sections, we’ll explore the process of preparing this and another ...

How to Use the COUNTIF Function with an Array Criteria in Excel

In the dataset below, we have Employee Names, Working Days and employee Status according to performance. We will apply the COUNTIF function with an ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo