How to Calculate SUM of Every Other (Alternate) Column or Row in Excel
This article covers the guideline on how to calculate SUM of numbers from every other or alternative columns or rows […]
macro and vba
Auto Shuffle or Randomize Data in Excel
If you are looking for how to auto shuffle or randomize the data in Excel sheet, here we will guide
Guideline to Download and Use Excel VBA Templates
Download Microsoft Excel templates for your small business at free of cost.
Spellnumber Function in Excel
Learn how to create and use Spell Number in Excel. This Converts the numeric values to word or spelling format.
VBA Tutorial for Beginners
Learn Microsoft Visual Basic for Applications (VBA). This is the beginner’s tutorial, where you will learn the basics of VBA to start the journey of Excel automation.
How to Lock VBA Project from Viewing
If you’ve spent time developing a Visual Basic for Applications (VBA) project, you likely want to protect your code from
Spellnumber VBA Code for Qatari Riyal and Dirham
Get the VBA code required for converting the numeric value of Qatari Riyal and Dirhams to spelling in Microsoft Excel.
VBA Code for Converting Numeric Indian Rupees and Paise to Words
Get the VBA code required to create spellnumber function for Indian Rupees and Paise.
Spellnumber Code for Omani Riyal and Baisa | Convert Omani Riyal to Spelling in Excel
Learn how to convert Omani Riyal and Baisa to Spelling format in Microsoft Excel and get the VBA code.
How to Get Detailed List of Files from a Folder in PC
Learn how to get the details of files from a folder in PC to an Excel sheet.
How to SUM Numbers by Cell Background Color in Excel
Learn how to calculate the SUM of numbers based on cell background color in Excel.
Automatically Extract Entire Row Data to New Sheet When Clicked in Excel
Learn how to auto extract the entire row data to a new sheet based on cell click event.
Find Out Which Numbers Add Up to a Total in Excel
Find out which numbers adds up to a specific total in Microsoft Excel. We will use here two methods, solver and VBA.
Convert Currency Numbers to Word in Excel: Step by Step Guide
Learn how to convert the numeric value of currency to spelling format in Microsoft Excel.