Abu Saleh Arman is a Marine engineer and Excel & VBA expert. He loves programming with VBA. He finds VBA programming a time-saving tool to manipulate data, handle files, and interact with the internet. He is very interested in Python, MATLAB, PHP, Deep Neural Networks, and Machine Learning, showcasing his diverse skill set. Arman holds a B.Sc in Naval Architecture & Marine Engineering from BUET, Bangladesh. However, he switched to a content developer, where he writes technical content about Excel and VBA.
Weighted moving average is one form of moving average that is used to smooth out time-series data with an aim to decrease the effects of random, short-term ...
The Excel N function is used to check whether a value is a number or not. It returns a Boolean value of either "TRUE" or "FALSE" based on the evaluation of the ...
The following dataset has Periods, Cash Flow, and Date columns. Using this dataset, we will show 3 methods for using the XIRR function in Excel. ...
While working with numbers that have decimal parts in Excel we need to round down those numbers for ease of calculation or decimal parts of the numbers are not ...
In this article, we'll reveal how to move around an Excel workbook using the arrow keys on the keyboard only, no mouse required. To demonstrate, we'll use ...
We have an Excel worksheet with information about a company. We'll freeze the column header and the employee names so they stay on the screen while scrolling. ...
