File Properties Tool is an MS Excel based tool which helps you to get File Name, File Path, Date Created, Date Last Accessed, Date Last Modified, Size (MB) and File Type properties of the files. You just need to browse the folder where your files are and click on ‘Get File Properties’ button.
Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.
SMALL function is used to get the Smallest k-th value from the range.
SMALL Function has two required arguments i.e. array, and k
In this tutorial, you’ll learn what an Excel array formula is, how to enter it properly, and how to use array constants and array functions.
Array formulas are a very powerful tool in Excel, allowing you to do multiple calculations with a single formula. One array formula can replace many regular formulas. However, most users—around 90%—have never used them because they seem intimidating to learn.
Array formulas are known to be one of the trickiest Excel features to understand. The goal of this tutorial is to make learning them as easy and simple as possible
While starting Excelsirji.Com, it is always been critical for me to find the best to amaze the viewer experience. So I spent many hours on web to read, explore amazing excel content which I really…
Introduction Welcome to this comprehensive guide on using Power Query in Excel to split data efficiently. In this tutorial, we’ll walk you through the step-by-step process of splitting columns, specifically focusing on splitting the name…
Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.