Al Arafat Siddique, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, has worked on the ExcelDemy project for two years. He has written over 85+ articles for ExcelDemy. Currently, he is working as a software developer. He is leading a team of six members to develop Microsoft Office Add-ins, extending Office applications to interact with office documents. Other assigned projects to his team include creating AI-based products and online conversion tools using the latest web technologies.
Method 1 - Calculate the Centered Moving Average for Odd No. of Periods Calculate this dataset's centered moving average for odd no periods. The dataset shows ...
Step 1. Check the Status Bar in Excel The status bar in Excel provides useful information about the active worksheet. We can customize the status bar to set ...
Dataset Overview Let’s delve into various solutions to address the issue of being unable to unhide rows in Excel. For our demonstration, we’ll work with a ...
Below, we have the population percentages by major ethnic groups in Southern California. We have created a pie chart using this data and added percentages. ...
The following dataset will be used. The dataset contains prices of three different products during 3 quarters of the year 2021. From this dataset, we ...
Method 1 - Unmerge First to Sort Merged Cells in Excel 1.1 Single Column Steps: Part-1 Select the cells that we need to sort. Click on the Merge ...
We’ll use a bunch of URLs from the Exceldemy website to show how you can extract them. Method 1 - Create a User-Defined Function to Extract a ...
Knowing how to sort range using VBA in Excel saves time and effort in our daily calculations. Although Excel provides a sorting facility by default, using the ...
Method 1 - Remove the Negative Sign in Excel Using the ABS Function We have a list of numbers in cells B4:B10 with both positive and negative. In cell ...
The sample dataset contains sales data for 8 products that fall into 3 different categories. We will discuss 3 suitable methods to filter this dataset based on ...
We’ll first discuss how to write code in the Visual Basic Editor. Follow the simple steps to create the setup for writing your code. Steps: Go to the ...
To illustrate how to refresh an Excel pivot table, we created two pivot tables for a dataset. The dataset shows a list of sale data with all required details ...
Method 1 - Using Excel Formula Excel lacks a built-in function to directly retrieve the sheet name, but we can create a formula using the MID, CELL, and ...
In this article, we’ll demonstrate how to count filtered data using the COUNTIF function together with the SUBTOTAL function. Download the Practice ...
Method 1 - Use of Relative Cell Reference in Formila in Excel Steps: In cell F5, write the following formula to calculate the Price as a product of the ...