Latest Blog Posts - Page 58 of 412

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

May 22, 2024

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 Create an Approval Workflow in Excel (with Easy Steps)

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

Jul 30, 2024

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 Perform Drawing of Objects with VBA in Excel (2 Examples)

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

Apr 29, 2024

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 an Attendance Roster in Excel (with Easy Steps)

How to Create Weekly Duty Roster Format in Excel

Jun 16, 2024

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

How to Create Weekly Duty Roster Format in Excel

How to Find the Distance Between Zip Codes Using a Formula in Excel – 2 Methods

Aug 4, 2024

The sample dataset has 2 types of columns (Location 1 and Location 2). Method 1 - Using a Geometric Formula to Find the Distance Between ...

How to Find the Distance Between Zip Codes Using a Formula in Excel – 2 Methods

How to Use IF and IFERROR Combined in Excel (3 Examples)

Jul 29, 2024

Example 1 - Calculate the Sales Bonus We have two columns containing Sales Target and Sales Achieved for some products. We’ll check in Column E if ...

How to Use IF and IFERROR Combined in Excel (3 Examples)

Top 100 MCQ of Excel: Test Your Skills

Aug 10, 2024

In this article, you will find the top 100 MCQ of Excel to test your skills. Most of the questions are very basic. As a result, anyone with a basic ...

How to Create a Lottery Prediction Algorithm in Excel – Easy Steps

Aug 4, 2024

The sample dataset contains 2 columns. The 1st one with a series of lottery numbers and a 2nd column, in which the probability of selecting a serial ...

How to Create a Lottery Prediction Algorithm in Excel – Easy Steps

How to Clear Pivot Cache in Excel (3 Effective Ways)

Jun 21, 2024

Method 1 - Using PivotTable Options In this method, we will apply the PivotTable Options to clear the Pivot Cache. We will delete some of the data ...

How to Clear Pivot Cache in Excel (3 Effective Ways)

How to Create Betting Algorithm in Excel: 3 Methods

Jul 3, 2024

Method 1 - Create Dataset with Proper Parameters HTHG: Half-Time Home Goals. Further, add the total home goals as values in the dataset. ...

How to Create Betting Algorithm in Excel: 3 Methods

How to Calculate Volatility in Excel (2 Suitable Ways)

Jul 5, 2024

What Is Volatility? Volatility is the measure of the fluctuations of return of any stock or security over a time period. It is calculated based on ...

How to Calculate Volatility in Excel (2 Suitable Ways)

50 Advanced Excel Exam Questions and Answers

Jun 26, 2024

In this article, you will find advanced Excel questions and answers to test your skills. You should know the following: introduction to Excel ...

50 Advanced Excel Exam Questions and Answers

How to Create Dynamic Chart with Multiple Series in Excel

Jun 14, 2024

Method 1 - Insert Table to Create Dynamic Chart with Multiple Series Steps: Select the complete dataset. Go to the Insert tab and select ...

How to Create Dynamic Chart with Multiple Series in Excel

How to Convert Old Excel Files to New Format: 2 Quick Methods

Jul 5, 2024

Method 1 - Using Convert Option Steps: Go to the File tab from Ribbon. The following window will open in your worksheet. Select ...

How to Convert Old Excel Files to New Format: 2 Quick Methods

How to Create a Catalogue in Excel (with Easy Steps)

Aug 6, 2024

Step 1: Giving a Suitable Title to the Catalogue Open an Excel file and give a suitable title to the workbook. On the 2nd row of the ...