Rank Function in Excel
Learn how to use Rank Function in Excel. Also learn combination of Rank + Countif to ignore the tie values.
Uncategorized
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.
Learn 10 Essential Excel Formulas for Beginners
In this article, you will learn 10 very useful Excel functions specially for the beginners in learning Excel.
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
Top 50 Most Useful Excel Shortcut Keys to Boost Your Productivity
Learn to use Top 50 most useful Keyboard Shortcut keys for Microsoft Excel. Using these will boost your productivity at work by saving lots of time.
How to Sort Data in Excel Using Custom List
Learn how to sort data in Excel using custom list. This allows you to sort or arrange data according to your specific criteria.
How to Display Numbers in Thousand(K), Million (M) or Billion(B) Format in Excel
How to display numbers in Thousand(K), Million(M) or Billion(B) format in MS Excel.
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.
Useful VBA code collection for Microsoft Excel
Get the useful VBA codes to increase your productivity in Microsoft Excel.
How to Calculate Percentage of Total Sales in Excel
Learn How to Calculate the Percentage of Total Sales in Microsoft Excel.
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 Make Search Bar in Excel for All Column Search
Learn how to make advanced search bar in Excel. By using this search bar, you can find out the information across every column.
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 Freeze Top Row or Any Other N Number of Rows in Excel
Learn how to freeze the top row or any other number of rows in Excel.
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.